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
Columns available in hdx.active_queries:
|timestamp query received|
|timestamp query responded|
|body of the query|
|user placing the query request|
|text provided by the hdx_comment setting|
|text provided by the hdx_admin_comment setting|
|boolean for if the query running or not|
|Hydrolix version active when query was received|
|Turbine revision active when query was received|
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 3 months ago