track_wal_io_timing

A parameter determining whether to track timing of WAL I/O

track_wal_io_timing is a configuration parameter timing of WAL I/O calls.

track_wal_io_timing was added in PostgreSQL 14.

Default value

The default value for track_wal_io_timing is: off.

Usage

If set to on, track_wal_io_timing will track statistics for WAL input/output operations. The accumulated statistics can be retrieved via the following columns of pg_stat_wal:

wal_write_time
wal_sync_time

Note that if enabled, track_wal_io_timing will cause PostgreSQL to query the operating system for the current time whenever WAL is written or synced, which may cause significant overhead on some platforms.

Change history

PostgreSQL 14
- added (commit ff99918c)

Examples

Sample contents of pg_stat_wal with track_wal_io_timing set to on:

postgres=# SELECT * FROM pg_stat_wal\gx
-[ RECORD 1 ]----+------------------------------
wal_records      | 301882
wal_fpi          | 135
wal_bytes        | 18544842
wal_buffers_full | 603
wal_write        | 633
wal_sync         | 5
wal_write_time   | 4.13
wal_sync_time    | 219.9
stats_reset      | 2021-03-09 11:06:01.842869+01

References

PostgreSQL documentation: track_wal_io_timing

Version charts

Useful overviews

Useful links

Contents