{"Entry":{"collection":"catalog","key":"pg_stat_wal","name":"pg_stat_wal","aliases":[],"metadata":{"changed_in":["18","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"13","order":false,"removed":[],"status":"added","to":"14","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Number of times WAL files were synced to disk via issue_xlog_fsync request (if fsync is on and wal_sync_method is either fdatasync, fsync or fsync_writethrough, otherwise zero). See Section 30.5 for more information about the internal WAL function issue_xlog_fsync.","name":"wal_sync","to":"Number of times WAL files were synced to disk via issue_xlog_fsync request (if fsync is on and wal_sync_method is either fdatasync, fsync or fsync_writethrough, otherwise zero). See Section 28.5 for more information about the internal WAL function issue_xlog_fsync."},{"from":"Number of times WAL buffers were written out to disk via XLogWrite request. See Section 30.5 for more information about the internal WAL function XLogWrite.","name":"wal_write","to":"Number of times WAL buffers were written out to disk via XLogWrite request. See Section 28.5 for more information about the internal WAL function XLogWrite."}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"17","listing":[],"order":false,"removed":["wal_write","wal_sync","wal_write_time","wal_sync_time"],"status":"changed","to":"18","types":[],"unlisted":[]},{"added":["wal_fpi_bytes"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":6,"content_hash":"d45ef7a5502870c862b9f938b31e6ad0bea49696110e49d31a3928c9673e7f4a","derived_content_hash":"5e15560b162d0702cc83d540dba4abb6e5515b9bd3508279c516738cd7d7176a","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:b8d3902ed9b30f7f62dc6e3a44b29d1cb092554487c52eeadcb84463c457c95f","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"14","imported_at":"2026-09-30T00:40:56.04167+08:00","kind":"statistics","last_version":"20","name":"pg_stat_wal","position":115,"present_in":["14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:b8d3902ed9b30f7f62dc6e3a44b29d1cb092554487c52eeadcb84463c457c95f","summary":"The pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster.","summary_zh":"pg_stat_wal 视图一直有一行，包含关于集簇的 WAL 活动的数据。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_wal","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_wal","SourceRevision":"catalog-bilingual-repair:b8d3902ed9b30f7f62dc6e3a44b29d1cb092554487c52eeadcb84463c457c95f","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Total number of WAL records generated","description_zh":"生成的 WAL 记录的总数","documented":true,"documented_name":"wal_records","hidden":false,"name":"wal_records","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Total number of WAL full page images generated","description_zh":"生成的 WAL 整页镜像的总数","documented":true,"documented_name":"wal_fpi","hidden":false,"name":"wal_fpi","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Total amount of WAL generated in bytes","description_zh":"生成的 WAL 总量，以字节计","documented":true,"documented_name":"wal_bytes","hidden":false,"name":"wal_bytes","not_null":false,"references":"","type":"numeric","type_modifier":-1,"type_oid":1700,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Number of times WAL data was written to disk because WAL buffers became full","description_zh":"因为 WAL 缓冲区已满，WAL 数据被写入磁盘的次数","documented":true,"documented_name":"wal_buffers_full","hidden":false,"name":"wal_buffers_full","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Time at which these statistics were last reset","description_zh":"这些统计信息上次被重置的时间","documented":true,"documented_name":"stats_reset","hidden":false,"name":"stats_reset","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"}],"description":"The pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster.","description_zh":"pg_stat_wal 视图一直有一行，包含关于集簇的 WAL 活动的数据。","description_zh_html":"\u003cp\u003epg_stat_wal 视图一直有一行，包含关于集簇的 WAL 活动的数据。\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-WAL-VIEW\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.26. \u003ccode class=\"structname\"\u003epg_stat_wal\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_wal 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ewal_records\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       生成的 WAL 记录的总数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ewal_fpi\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       生成的 WAL 整页镜像的总数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ewal_bytes\u003c/code\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       生成的 WAL 总量，以字节计\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ewal_buffers_full\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       因为 WAL 缓冲区已满，WAL 数据被写入磁盘的次数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003estats_reset\u003c/code\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e这些统计信息上次被重置的时间\u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","doc":{"anchor":"PG-STAT-WAL-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"documentation_revision":{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["wal_records","wal_fpi","wal_bytes","wal_buffers_full","stats_reset"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:9e12acc0a30ab462ba2ca1ac3267b32093d7666c95f53c66200e1fe690d7afd1","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-WAL-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:9e12acc0a30ab462ba2ca1ac3267b32093d7666c95f53c66200e1fe690d7afd1","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["wal_records","wal_fpi","wal_bytes","wal_buffers_full","stats_reset"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_wal","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_wal","Summary":"The pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster.","BodyHTML":"\u003cp\u003eThe pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:b8d3902ed9b30f7f62dc6e3a44b29d1cb092554487c52eeadcb84463c457c95f","ContentHash":"e5ed75cc7f14a7cf296a6e8e4a3294cb0aebf3356dc72a4b09552dea2236c191","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Total number of WAL records generated","description_zh":"生成的 WAL 记录的总数","documented":true,"documented_name":"wal_records","hidden":false,"name":"wal_records","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Total number of WAL full page images generated","description_zh":"生成的 WAL 整页镜像的总数","documented":true,"documented_name":"wal_fpi","hidden":false,"name":"wal_fpi","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Total amount of WAL generated in bytes","description_zh":"生成的 WAL 总量，以字节计","documented":true,"documented_name":"wal_bytes","hidden":false,"name":"wal_bytes","not_null":false,"references":"","type":"numeric","type_modifier":-1,"type_oid":1700,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Number of times WAL data was written to disk because WAL buffers became full","description_zh":"因为 WAL 缓冲区已满，WAL 数据被写入磁盘的次数","documented":true,"documented_name":"wal_buffers_full","hidden":false,"name":"wal_buffers_full","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Time at which these statistics were last reset","description_zh":"这些统计信息上次被重置的时间","documented":true,"documented_name":"stats_reset","hidden":false,"name":"stats_reset","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"}],"description":"The pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster."}},"RequestedLocale":"en","Fallback":false,"Versions":["14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}