questdb/questdb
Ability to monitor behavior and statistics of queries
Aperta
#2221 aperta il 14 giu 2022
Help wantedNew featureSQLintegration
Metriche repository
- Star
- (13.403 stelle)
- Metriche merge PR
- (Merge medio 5g 13h) (108 PR mergiate in 30 g)
Descrizione
Is your feature request related to a problem?
We are seeing performance degradation of quest but without visibility to query statistics it is a bit difficult to find out what is causing the performance issues. It seems it is not ingestion side based on currently exposed metrics.
Describe the solution you'd like.
Currently the database expose quite a few very helpful metrics related to writes like number of committed rows, O3 amplification etc. It would be nice to expose also metrics for queries ... like number of queries executed over the time, execution times for queries, ideally the list of the most time consuming queries etc.
This will allow to better understand the performance degradation of database and optimize the usage based on the findings.
Describe alternatives you've considered.
No response
Additional context.
No response