[Databend Query] Metrics databend_session_queued_queries Not Found

[Electronic-Waste]

We couldn't find databend_session_running_acquired_queries in databend-query instances.

Yesterday, I conducted TPC-H benchmark test and opened 4 terminals to run sql injections in parallel, in which the max running queries was 2 and therefore there were 2 queries pending in queue. However, we couldn't find this metric in the Prometheus. Could you please help me figure out this?

Also cc👀 @flaneur2020 @Chasen-Zhang @hantmac

databend-docs/docs/en/guides/10-deploy/03-monitor/10-metasrv-metrics.md

Line 212 in 2e94b49

| databend_session_queued_queries | Gauge | Number of SQL queries currently in the query queue. | |

[BohuTANG]

Hi @Electronic-Waste

The metric databend_session_queued_queries is work and utilized in Databend Cloud. You can find its implementation here:
https://github.com/databendlabs/databend/blob/29fcd98e648b9915d9ba9886b7556382c98f4fb2/src/common/metrics/src/metrics/session.rs#L58

Below is an example of Databend Cloud's running queue metrics:

If the databend_session_queued_queries metric is not visible in system.metrics, it indicates that there are no queued queries currently in the system.

Note: It can be challenging to manually simulate query queuing for testing purposes.