Search
The Queries page in Pulse provides an overview of all executed ClickHouse queries, displaying their status, performance metrics, resource usage, etc.
This capability enables you to:
- Track query activity across users and nodes.
- Identify failed or long-running queries for further analysis.
- Monitor resource-intensive queries that may impact system performance.
- Drill down into specific queries by clicking a Query ID to open the Query Details view for deeper insight.
Steps
- In the Pulse UI, go to ClickHouse > Queries.
- On the Queries page, a list of executed ClickHouse queries appears.
- Set a time range and data refresh interval (for example, 10 s, 20 m, 2 h, 4 d, or 1 w) to view up-to-date query data.
Pulse displays all executed queries with their summarized metrics.
Query-Level Summary
Query Identification
- Query ID: Unique identifier for each executed query, used for tracing and debugging.
- User: The ClickHouse user account that executed the query.
- Query Type: Specifies the query type, such as SELECT, INSERT, ALTER, or DROP.
- ClickHouse Server: Identifies the ClickHouse node or host where the query was processed.
- Client: Displays the client or application that initiated the query.
Query Execution Details
- Status: Displays the current query state — for example, RUNNING, FINISHED, or FAILED.
- Duration (ms): The total time taken to complete the query, measured in milliseconds.
- Start Time: The timestamp indicating when the query execution began.
Resource Utilization
- Memory Usage: The total memory consumed during query execution. High values may indicate heavy workloads.
- Rows Read: The number of rows scanned from tables to process the query.
- Bytes Read: The total amount of data read from storage or memory.
- Result Rows: The number of rows returned by the query.
- Result Bytes: The total size of the query’s output data.
Error Handling
- Exception Code: Displays an error or exception code if the query fails, helping identify and troubleshoot issues.
Key Features
- Search: Filter and search queries by user, type, status, etc.
- Save Search: Click + to save a query filter and reuse it later. Access saved searches using the Search button.
- Group By: Group queries by User Type, User Status, User, Client, or Host for targeted analysis.
- Download: Click Download to export the list of queries for reporting or review.
Query Details
For deeper analysis of a query, click its Query ID to open the Query Details view. For details, see Analyze ClickHouse Query Details.
Was this page helpful?