questdb/questdb
Ability to monitor behavior and statistics of queries
Offen
#2.221 geöffnet am 14.06.2022
Help wantedNew featureSQLintegration
Repository-Metriken
- Stars
- (13.403 Sterne)
- PR-Merge-Metriken
- (Durchschn. Merge 5T 13h) (108 gemergte PRs in 30 T)
Beschreibung
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