Wait analysis
Home screen > Select Project > Analysis > Wait analysis
You can check in which wait event the active session is waiting and which wait events occur frequently. Active sessions collected every 5 seconds can be analyzed from the wait perspective.
-
This function is supported in DBX agent 1.6.10 or later.
-
The collected wait data includes
wait_event
andwait_event_type
in thepg_stat_activity
view. For more information about the metric, see the following.
Basic screen guide
Select the time and instance to view. You can see the wait data corresponding to the set time and instance. If there are active sessions that frequently wait (delay) during the query period, it can be used to analyze what types of wait events occurred.
In Wait Event Top 5, you can see which wait events occurred most frequently. Using the above image as an example, the most frequently occurred type of wait event is Lock. If you select the detailed time in the graph chart, you can view the active sessions in the time and check the SQL statements in which the wait events occurred.
Filtering the table data
-
Select on the upper right of the table.
-
Select a column header and a condition in the table.
-
Enter a desired value in the Enter conditions field.
-
Select Save.
Configuring the table columns
You can hide the table header columns or add any of them. You can also change the column order. Select .
-
After configuration, select OK to apply the settings in the table.
-
In the search bar, enter text to search the desired columns. Only the columns that meet the entered text are displayed.
Adding columns
From the list, select the items to add as table header columns. To select all items, select Select All.
Deleting columns
From the list, unselect the columns to delete. Alternatively, select on the right of the item to delete from the list.
Changing the column order
Drag an item to reposition from the list, and then move it to the desired position.
Initializing the configuration
To cancel all changes and reset them, select Reset.