Hologres:View active queries

Procedure

1. Log on to the Hologres console.

2. In the navigation pane on the left, click Go to HoloWeb.

3. In the top navigation bar of the HoloWeb page, click Diagnostics and Optimization.

4. In the left-side navigation pane, choose Management for Information About Active Queries > Active Query Tasks.

5. On the Active Query Tasks page, filter the queries by Instance Name, Database, or Status, and then click Search.

   Parameter	Description
   Instance Name	The name of the instance.
   Database	The name of the database.
   Status	The process status. idle: The process is waiting for a new client command. active: The process is executing a query. idle in transaction: The process is in a transaction but is not currently executing a query. idle in transaction (aborted): The process is in a transaction that contains an errored statement, and the process is not currently executing a query. fastpath function call: The process is executing a fast-path function. disabled: The activity tracking feature (track activities) is disabled for the process.

6. Click Search.

   The search results are displayed in a table. For example, you can view queries with the idle status. The table includes columns such as pid, database, username, query_start, state, client_addr, and query.

   You can click Details in the Actions column of a query to view its details.

   On the Details page, you can also click Copy to copy the query's SQL statement.