54.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.
If no line graph is displayed, it means that profiling is disabled for the selected instance.
In this case, either enable profiling for the selected instance, or select another instance with enabled profiling from the top-right corner of the page.
If the line graph is displayed but contains no data, try the following actions:
If profiling is paused, resume it.
Wait for the historical data to be collected.
In the top-right corner of the line graph, specify or select a different time period from the drop-down list.
(Optional) In the top-right corner of the page, configure auto-refreshing of the graph data:
Click
to enable auto-refreshing. Click
to disable auto-refreshing. If auto-refreshing is disabled, the data can be refreshed manually by clicking
.
Adjust the data visible on the graph, if necessary:
In the top-right corner of the line graph, specify or select a different 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.
If a time period is selected on the graph, the area inside the period is not clickable. To switch to the detailed display mode, click the part of the graph outside this area.
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.
54.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.
You can resize or move the selection with the mouse.
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.