Missing db.client.operation.duration Metric for DB and NoSQL Calls duration

[SiddhantShr2005]

In the OpenTelemetry Java Agent, we have observed that metrics for database call durations—specifically db.client.operation.duration metric—are not being generated for most SQL and NoSQL operations.

Upon reviewing the code for the JDBC instrumentation module, we did not find any implementation that emits this metric. It appears that db.client.operation.duration is not currently supported in the JDBC plugin or similar instrumentation modules for NoSQL clients like mongo db, redis etc.

Could you please clarify why this metric is not generated for JDBC etc? Is there any plan to add support for db.client.operation.duration in future releases of the OpenTelemetry Java Agent for JDBC and other db libraries?

[jaydeluca]

Hey @SiddhantShr2005, have you tried setting the property -Dotel.semconv-stability.opt-in=database ? For many of our instrumentations, setting this property will result in that metric being emitted