Skip to main content

Load By Waits (BackendType)

  1. The fourth chart in the top section, shows the load produced by each backend type 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 backend type.
  5. Hover over the bar for more information.
  6. Higher 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.