{"Entry":{"collection":"catalog","key":"pg_stat_bgwriter","name":"pg_stat_bgwriter","aliases":[],"metadata":{"changed_in":["9.1","9.2","17"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.2","order":false,"removed":[],"status":"added","to":"8.3","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.4","order":false,"removed":[],"status":"coverage","to":"9.0","types":[]},{"added":["buffers_backend_fsync","stats_reset"],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.0","listing":[],"order":false,"removed":[],"status":"changed","to":"9.1","types":[],"unlisted":[]},{"added":["checkpoint_write_time","checkpoint_sync_time"],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.1","listing":[],"order":false,"removed":[],"status":"changed","to":"9.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"16","listing":[],"order":false,"removed":["checkpoints_timed","checkpoints_req","checkpoint_write_time","checkpoint_sync_time","buffers_checkpoint","buffers_backend","buffers_backend_fsync"],"status":"changed","to":"17","types":[],"unlisted":[]}],"column_count":4,"content_hash":"7c1990ff663162322fd2d80f74b6efceb055fa00c6803e549d84bfabdc982ab2","first_version":"8.3","imported_at":"2026-09-30T00:40:55.888767+08:00","kind":"statistics","last_version":"20","name":"pg_stat_bgwriter","position":86,"present_in":["8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:02741e530d66fd3b89a43c8d8d40f84d1c23950fee9ab47a3ba82ef5fe847991","summary":"The pg_stat_bgwriter view will always have a single row, containing data about the background writer of the cluster.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_bgwriter","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_bgwriter","SourceRevision":"english-manuals:02741e530d66fd3b89a43c8d8d40f84d1c23950fee9ab47a3ba82ef5fe847991","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Number of buffers written by the background writer","description_zh":"","documented":true,"documented_name":"buffers_clean","hidden":false,"name":"buffers_clean","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":2,"description":"Number of times the background writer stopped a cleaning scan because it had written too many buffers","description_zh":"","documented":true,"documented_name":"maxwritten_clean","hidden":false,"name":"maxwritten_clean","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":3,"description":"Number of buffers allocated","description_zh":"","documented":true,"documented_name":"buffers_alloc","hidden":false,"name":"buffers_alloc","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"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}],"description":"The pg_stat_bgwriter view will always have a single row, containing data about the background writer of the cluster.","description_zh":"","doc":{"anchor":"PG-STAT-BGWRITER-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["buffers_clean","maxwritten_clean","buffers_alloc","stats_reset"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-BGWRITER-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["buffers_clean","maxwritten_clean","buffers_alloc","stats_reset"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_bgwriter","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_bgwriter","Summary":"pg_stat_bgwriter 视图始终只有一行，包含有关集簇后台写入器的数据。","BodyHTML":"\u003cp\u003epg_stat_bgwriter 视图始终只有一行，包含有关集簇后台写入器的数据。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"2234417185ca630d8aba683c14d93820ddf30aa6a8533e52e7f9a9aa1d57b339","Payload":{"columns":[{"description_zh":"后台写入器写入的缓冲区数量","name":"buffers_clean","type":"bigint","zh_from":"doc"},{"description_zh":"后台写入器因写入了过多缓冲区而停止清理扫描的次数","name":"maxwritten_clean","type":"bigint","zh_from":"doc"},{"description_zh":"分配的缓冲区数量","name":"buffers_alloc","type":"bigint","zh_from":"doc"},{"description_zh":"这些统计信息上次被重置的时间","name":"stats_reset","type":"timestamp with time zone","zh_from":"doc"}],"description_zh":"pg_stat_bgwriter 视图始终只有一行，包含有关集簇后台写入器的数据。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}