Skip to main content

Load By Waits (Query)

  1. The first chart in the bottom section, shows the load on the PostgreSQL database system, by wait events caused by a query's execution.
  2. Each bar represents load at a specific point in time.
  3. The load is measured in terms of average active sessions.
  4. The X-axis represents time and the Y-axis represents the average active sessions.
  5. Hover over the bar for more information.
  6. Longer the peak of the bar and higher the load number, higher the load on the system at that point in time.
  7. In a high load scenario, some of the load events that you may see are:
    • CPU
    • Disk I/O
    • Transactions
    • IPC
    • Network I/O
    • WAL (Write Ahead Log)
    • Locks
  8. A high load scenario is most likely caused by a query.
  9. Identify the query and fine tune it to reduce the load on the system.

Peeking into the query​

  • Click on the query identifier under the Query ID column in any row.
  • A new view opens up with the complete query text, under the Query Text tab.
  • To view the execution plan of the query, click on the Query Plans tab.