diff options
| author | Fujii Masao <fujii@postgresql.org> | 2020-10-02 10:17:11 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2020-10-02 10:17:11 +0900 |
| commit | 8d9a935965f01b7759a8c23ff6291000b670a2bf (patch) | |
| tree | 087be8ff79f83042fe0c84771c7987bb389a25bf /src/backend/access/transam/xlog.c | |
| parent | 9d0bd95fa90a7243047a74e29f265296a9fc556d (diff) | |
| download | postgresql-8d9a935965f01b7759a8c23ff6291000b670a2bf.tar.gz postgresql-8d9a935965f01b7759a8c23ff6291000b670a2bf.zip | |
Add pg_stat_wal statistics view.
This view shows the statistics about WAL activity. Currently it has only
two columns: wal_buffers_full and stats_reset. wal_buffers_full column
indicates the number of times WAL data was written to the disk because
WAL buffers got full. This information is useful when tuning wal_buffers.
stats_reset column indicates the time at which these statistics were
last reset.
pg_stat_wal view is also the basic infrastructure to expose other
various statistics about WAL activity later.
Bump PGSTAT_FILE_FORMAT_ID due to the change in pgstat format.
Bump catalog version.
Author: Masahiro Ikeda
Reviewed-by: Takayuki Tsunakawa, Kyotaro Horiguchi, Amit Kapila, Fujii Masao
Discussion: https://postgr.es/m/188bd3f2d2233cf97753b5ced02bb050@oss.nttdata.com
Diffstat (limited to 'src/backend/access/transam/xlog.c')
| -rw-r--r-- | src/backend/access/transam/xlog.c | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.c index 03c089b9a96..8f11b1b9de1 100644 --- a/src/backend/access/transam/xlog.c +++ b/src/backend/access/transam/xlog.c @@ -2196,6 +2196,7 @@ AdvanceXLInsertBuffer(XLogRecPtr upto, bool opportunistic) WriteRqst.Flush = 0; XLogWrite(WriteRqst, false); LWLockRelease(WALWriteLock); + WalStats.m_wal_buffers_full++; TRACE_POSTGRESQL_WAL_BUFFER_WRITE_DIRTY_DONE(); } /* Re-acquire WALBufMappingLock and retry */ |