[APM][OTEL][Java] Add JVM Garbage Collection Visualizations for OTEL Java Agent

[herrBez]

Describe the feature:

With the introduction of #161970, Kibana now offers distinct visualizations for applications instrumented using the "classic" APM Java agent and those using either the Elastic Distribution or the vanilla OpenTelemetry (OTEL) Java agent.

Currently, under the Metrics tab, the "classic" APM Java agent provides the following visualizations:

• Garbage Collection count per minute
• Garbage collection time spent per minute

However, these visualizations are not yet available for applications instrumented with the OTEL Java agent.

The OTEL agent, though, already collects relevant metrics under the jvm.gc.duration field, represented as a histogram. This feature request aims to implement similar visualizations based on this field for OTEL-instrumented applications, ensuring a consistent monitoring experience across both agent types.

Describe a specific use case for the feature:

• Have a better visibility of applications instrumented with the (Elastic Distribution of or the vanilla) OTEL Java agent.
• Make the OTEL Java Agent more integrated in the Stack

[elasticmachine]

Pinging @elastic/obs-ux-infra_services-team (Team:obs-ux-infra_services)

[SylvainJuge]

While not being an expert on Kibana, I did a quick search that returned apparently related issues

• [Lens] Support for Histogram data type with sum, average #74581
• Allow histogram aggregation on histogram field type #112390
• [Lens] Allow histograms on histogram fields #112391

Those issues were closed as duplicates and apparently using ES|QL could bring a solution, however the issue is still open:

• ES|QL: Support aggregation commands on histogram fields elasticsearch#103060

So this brings another concrete example use-case where implementing this would be beneficial.

Also maybe there could be a work-around just for this particular use-case, and the ES|QL issue mentioned above refers to a generic and broader solution. In this case I'd be happy as well as we could add those missing charts.