Skip to content

This is the multi-page printable view of this section. .

Return to the regular view of this page.

Related metrics

Signals used to decide whether a wait is expected or harmful.

Signals used to decide whether a wait is expected or harmful. This index contains 22 entries.

1 - [[metric:active_backends]]

Backends currently executing a query.

Backends currently executing a query.

Referenced by wait events

2 - [[metric:blocked_sessions]]

Sessions with one or more blocking PIDs.

Sessions with one or more blocking PIDs.

Referenced by wait events

3 - [[metric:blocks_read]]

Relation blocks read by database or statement.

Relation blocks read by database or statement.

Referenced by wait events

4 - [[metric:buffer_hit_ratio]]

Blocks served from shared buffers versus blocks read.

Blocks served from shared buffers versus blocks read.

Referenced by wait events

5 - [[metric:checkpoint_time]]

Checkpoint write and synchronization duration.

Checkpoint write and synchronization duration.

Referenced by wait events

6 - [[metric:commit_latency]]

End-to-end transaction commit latency.

End-to-end transaction commit latency.

Referenced by wait events

7 - [[metric:io_read_time]]

Timed read latency from pg_stat_io or operating-system telemetry.

Timed read latency from pg_stat_io or operating-system telemetry.

Referenced by wait events

8 - [[metric:io_write_time]]

Timed write latency from pg_stat_io or operating-system telemetry.

Timed write latency from pg_stat_io or operating-system telemetry.

Referenced by wait events

9 - [[metric:locks_per_backend]]

Rows in pg_locks grouped by backend.

Rows in pg_locks grouped by backend.

Referenced by wait events

10 - [[metric:multixact_member_io]]

Reads and writes for multixact member storage.

Reads and writes for multixact member storage.

Referenced by wait events

11 - [[metric:oldest_multixact_age]]

Oldest multixact age that still requires preservation.

Oldest multixact age that still requires preservation.

Referenced by wait events

12 - [[metric:oldest_transaction_age]]

Age of the oldest open transaction or visibility horizon.

Age of the oldest open transaction or visibility horizon.

Referenced by wait events

13 - [[metric:replication_flush_lag]]

Distance or time between primary WAL and standby flush position.

Distance or time between primary WAL and standby flush position.

Referenced by wait events

14 - [[metric:statement_latency]]

Latency distribution for statements associated with the wait.

Latency distribution for statements associated with the wait.

Referenced by wait events

15 - [[metric:statement_wal_bytes]]

WAL bytes attributed to statements when pg_stat_statements tracks WAL.

WAL bytes attributed to statements when pg_stat_statements tracks WAL.

Referenced by wait events

16 - [[metric:wait_event_share]]

Share of repeated active-session samples attributed to one event.

Share of repeated active-session samples attributed to one event.

Referenced by wait events

17 - [[metric:waiting_sessions]]

Current sessions grouped by wait type and event.

Current sessions grouped by wait type and event.

Referenced by wait events

18 - [[metric:wal_bytes]]

WAL bytes generated over the observation interval.

WAL bytes generated over the observation interval.

Referenced by wait events

19 - [[metric:wal_fpi]]

Full-page images generated in WAL.

Full-page images generated in WAL.

Referenced by wait events

20 - [[metric:wal_sync_time]]

Time spent synchronizing WAL to durable storage.

Time spent synchronizing WAL to durable storage.

Referenced by wait events

21 - [[metric:wal_write_time]]

Time spent writing WAL.

Time spent writing WAL.

Referenced by wait events

22 - [[metric:xact_slru_io]]

Reads and writes for the transaction-status SLRU.

Reads and writes for the transaction-status SLRU.

Referenced by wait events