Note: The Performance Diagnostic feature is available only on EDB Postgres Advanced Server 11.
In the performance diagnostic window, you will be able to see some activity in the graph. Select a smaller interval and it will expand the interval in more detail under # wait events type.
When you select a specific time frame (Sample time), you will be able to find what queries are running and what queries are in a wait state.
In my example, you can see two SQL statements running (queries executed in Step vi), user details of wait events in the bottom section called Wait Event Details.
For more detailed analysis of a particular query, you can click on the “eye” icon and it will open a new window where you can see how many times this query has been executed, session details, and wait events which helps to determine if the query has to wait for IO or was getting blocked by any other queries for a timely execution.
For a more realistic test, I have a series of SQL running. It gives me insight as a DBA to find out when the IO was high on the system, which queries are getting blocked or waiting for IO’s. It also helps to understand what is happening in the database overall statistics, find out queries that may need tuning or frequently getting blocked or in a waiting state.
I hope this is helpful. If you have any questions or comments, please feel free to send an email to email@example.com.