Skip to main content

Load By Waits (Host)

  1. The third chart in the top section, shows the load produced by each host that connected to the PostgreSQL system, by wait events.
  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 host.
  5. Hover over the bar for more information.
  6. Higher the peak of the bar, higher the load on the system at that point in time.
  7. In a high load scenario and higher the load number, 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.