The pgx_stat_walwriter view displays statistics related to WAL writing, in a single line.
Table D.4 pgx_stat_walwriter viewColumn | Type | Description |
|---|
dirty_writes | bigint | Number of times old WAL buffers were written to the disk because the WAL buffer was full when WAL records were added |
writes | bigint | Number of WAL writes |
write_blocks | bigint | Number of WAL write blocks |
total_write_time | double precision | Number of milliseconds spent on WAL writing |
stats_reset | timestamp with timezone | Last time at which this statistic was reset |
