Wait analysis

Home > 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.

Note

• This function is supported in DBX agent 1.9.0 or later.

• The collected wait data includes wait_event and wait_event_type in the pg_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.

The center time-series chart visually displays the distribution of wait classes and number of sessions by time zone. This allows you to identify patterns of increased waiting events in a specific time zone. You can select analysis categories such as Wait (time), Wait (count), Latch, Enqueue, Stat, Cpu, Memory, and Session Count.

If you select the detailed time in the time-series chart, you can view the active sessions in the time and check the SQL statements in which the wait events occurred.

Wait Class

It visualizes wait events for each wait class with a pie chart. This allows you to quickly identify the causes of major wait events. If the wait class is abnormally high, focus on checking the resources related to the class.

Wait Event Top 5

It displays the top 5 frequent wait events. The percentage of each wait event can help you determine which events have the greatest impact on system performance, which is useful for identifying bottlenecks in the system.

Stat Top 5

The top 5 key stat data are displayed in percentage (%). You can quickly find the resource usage status and which operation is having the greatest impact on the database.

Tip

• The wait analysis results are used as a tool to help diagnose their causes, and problem resolution must be performed at the DBA's discretion.

• You need to adjust the time range to accurately find the time zone when the problem occurs.

• If you become familiar with the characteristics of the wait classes and events in advance, it can speed up the analysis.

Note

• When you select the instance column in the Active Session section list, the Monitoring a Database Instance menu appears. For more information about Monitoring a Database Instance, see the following.

• In the Active Session list, if you select a session, the Session detail window appears. For more information about the Session detail windows, see the following.

• When you select the query column in the Active Session list, the SQL details window appears. For more information about the SQL details windows, see the following.

Filtering the table data

1. Select on the upper right of the table.

2. Select a column header and a condition in the table.

3. Enter a desired value in the Enter conditions field.

4. Select Save.

Setting the table columns

You can hide the table header columns or add any of them. You can also change the column order. Select .

Note

• After configuration, select Confirm 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.

• Images may differ depending on the product, project, or menu.

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 Initialized.