Hologres:View active queries

Procedure

1. Log on to the Hologres console.

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

3. On the HoloWeb developer page, in the top menu bar, click Diagnostics and Optimization.

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

5. On the Active Query Tasks page, configure the parameters.

   Parameter	Description
   Instance name	The name of the instance to which you are logged on.
   Database	The name of a database that is created in the selected connection.
   State	The activity state of a process in the database. 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 a statement with an error, and the process is not currently executing a query. fastpath function call: The process is executing a fast-path function. disabled: The track_activities parameter is disabled for the process.

6. Click Search.

   The following figure shows an example of viewing queries that are in the idle state.

   In the Actions column of a query, click Details to view its details.

   On the Details page, click Copy to copy the SQL statement that the query executed.