Prometheus metrics for queries latency, TPS by sql type

[HL]

Hello,

According to https://proxysql.com/documentation/stats-statistics/#stats_mysql_query_digest, we know that ProxySQL stores query-level metrics to stats_mysql_query_digest table with very helpful information like count_star, sum_time, min_time, max_time.

The default port for exporting metrics is 6070 so that we can connect to it from a Prometheus instance and visualized in dashboard.

Actually we successfully setup a ProxySQL point to the MySQL database and also Prometheus for pulling metrics from that ProxySQL container at port 6070, we can monitor metrics like connection's latency, status or throughput and others but we found no metrics provide the data relate to the latency of queries by type like: processing time of SELECT or INSERT, UPDATE, or TPS for each of them, even though it has very precious data stored in table stats_mysql_query_digest.

Environment:

•  ProxySQL version: latest
•  Prometheus version: v2.37.1

Is there anyone know how to do so or can we have a metric for pulling query latency, TPS by type for Prometheus?

Thanks a lot.