Hydrolix has an active table where we store query information for the last 5 minutes.
It is available to query like any other table and is deployed in the project hdx.
SELECT query_start, query_end, query, active, admin_comment, comment, (query_end - query_start) as query_duration FROM hdx.active_queries ORDER BY query_start DESC
We store multiple information in that table:
We provide a query performance monitoring page in our Grafana deployment which uses Active Queries, this allow you to verify and monitor performance in real time for each query and by leveraging comment you can add some business logic in your monitoring.
For example the user running the query, or if it's a scheduled query for XYZ reason.
Updated about 2 months ago