search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.97k stars 3.79k forks source link

monitoring: Support performance metrics per app_name #54175

Open piyush-singh opened 4 years ago

piyush-singh commented 4 years ago

A customer requested that CockroachDB expose sql_exec_latency and round_trip_latency on a per application basis. With recent work to decouple prometheus from our internal timeseries system, it may be possible to label metrics with fields like app_name. We should explore what would be necessary to enable this and any other metrics that users would like to group this way.

Jira issue: CRDB-3790

piyush-singh commented 4 years ago

Related to #33203

BramGruneir commented 3 years ago

Here is the customer request: https://cockroachdb.zendesk.com/agent/tickets/6155

jjathman commented 3 years ago

As another data point, this is the exact feature our company would like as well. I think many of the metrics under sql_* would benefit from some tag which ties them back to the application which generated the data. For a shared CockroachDB it makes it difficult to tie a metrics like number of select statements back to the application which is generating them.