Active Queries

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.
Example:

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:

query_start

query_end

query

active

admin_comment

comment

timestamp query received

timestamp query responded

body of the query

boolean is the query running or not

text provided by the hdx_admin_comment setting

text provided by the hdx_comment setting

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.

31843184

Did this page help you?