52.2. Viewing Total Wait Event Time #
Go to the active session history in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Active sessions history.
From the drop-down list in the top-right corner of the page, select an instance.
Using the corresponding section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Active sessions history.
The line graph with the total event wait time and the table with details about SQL queries and sessions will be displayed.
If the line graph contains no data, try the following actions:
Adjust the data visible on the graph, if necessary:
In the top-right corner of the line graph, select or specify a time period from the drop-down list.
In the bottom of the graph, click the legend checkboxes to show or hide certain event types.
Switch the graph display mode:
The graph is in the all-in-one display mode by default, when the wait time for all event types is displayed.
To switch to the detailed display mode for an event type, click on the colored part of the graph that relates to the event type.
When the graph is in the detailed display mode, it displays detailed wait time information for the selected event type.
You can select the different event type from the drop-down list at the top of the graph.
To switch back to the all-in-one display mode, in the top-left corner of the graph, click Back.
To view summary of wait event statistics at a specific point of time, hover over the graph to this point.
To explore wait event statistics in detail, select a time interval and view the displayed data as described below.
52.2.1. Viewing Detailed Wait Event Statistics #
Explore detailed wait event statistics using the line graph with the total event wait time and the table with details about SQL queries and sessions:
In the top-right corner of the graph, click
. Inside the graph, press the left mouse button and drag the cursor to select a horizontal area that represents a time period of interest.
To clear the selection, in the top-right corner of the graph, click
. Alternatively, click 
next to the time period below the graph.
The tables with detailed information about the selected time period will be displayed:
The SQL queries table has the following columns:
Activity: The colored horizontal indicator that represents the query wait time compared to the other queries within the selected time period.
To view details about the activity, hover over the indicator.
Query ID.
Query, Duration.
To view the query details, click the query (for example,
SELECT). The window with detailed information about the query will open. The following parameters are displayed:Execution count and Total execution time.
These parameters are displayed only if the pg_stat_statements module is installed on the instance.
Query: The query text.
Query plan: The query plan, if available.
The query plan is displayed only if the pgpro_stats extension is installed on the instance.
Even with the extension installed, the query plan may be unavailable.
Execution count, Total execution time.
The Sessions table has the following columns:
Activity: The colored horizontal indicator that represents the session duration compared to other sessions within the selected time period.
To view details about the activity, hover over the indicator.
PID: The backend ID.
Username: The name of the DBMS user on behalf of which the session is initiated.
Database: The name of the database associated with the user session.
Application: The name of the source application of the user session.