{"Entry":{"collection":"catalog","key":"pg_stat_slru","name":"pg_stat_slru","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"12","order":false,"removed":[],"status":"added","to":"13","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]}],"column_count":9,"content_hash":"9cbfec06f811d7c337ddbab47349512a4f7fb2ee054bcbaba81fc82a998f8251","derived_content_hash":"b7d5d2086af394e87b4288cd917440d397ed84bef04269d57ca6a5dd54ac3df1","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:d62feba0e37f39fda03d486dd2f4f669fab4ff4834dd54986a26c6fcda8be608","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"13","imported_at":"2026-09-30T00:40:55.982214+08:00","kind":"statistics","last_version":"20","name":"pg_stat_slru","position":106,"present_in":["13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:d62feba0e37f39fda03d486dd2f4f669fab4ff4834dd54986a26c6fcda8be608","summary":"PostgreSQL accesses certain on-disk information via SLRU (simple least-recently-used) caches.","summary_zh":"PostgreSQL 通过 SLRU（simple least-recently-used，简单最近最少使用）缓存访问某些磁盘上的信息。pg_stat_slru 视图将为每个被跟踪的 SLRU 缓存包含一行，显示关于访问缓存页面的统计信息。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_slru","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_slru","SourceRevision":"catalog-bilingual-repair:d62feba0e37f39fda03d486dd2f4f669fab4ff4834dd54986a26c6fcda8be608","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of the SLRU","description_zh":"SLRU 的名称","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Number of blocks zeroed during initializations","description_zh":"初始化期间被置零的块数","documented":true,"documented_name":"blks_zeroed","hidden":false,"name":"blks_zeroed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Number of times disk blocks were found already in the SLRU, so that a read was not necessary (this only includes hits in the SLRU, not the operating system's file system cache)","description_zh":"已经在 SLRU 中的磁盘块被发现的次数，因此不需要读取（这只包括 SLRU 中的命中，不包括操作系统的文件系统缓存中的命中）","documented":true,"documented_name":"blks_hit","hidden":false,"name":"blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Number of disk blocks read for this SLRU","description_zh":"为这个 SLRU 读取的磁盘块数","documented":true,"documented_name":"blks_read","hidden":false,"name":"blks_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Number of disk blocks written for this SLRU","description_zh":"为这个 SLRU 写入的磁盘块数","documented":true,"documented_name":"blks_written","hidden":false,"name":"blks_written","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of blocks checked for existence for this SLRU","description_zh":"为这个 SLRU 检查是否存在的块数","documented":true,"documented_name":"blks_exists","hidden":false,"name":"blks_exists","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Number of flushes of dirty data for this SLRU","description_zh":"此 SLRU 的脏数据刷盘次数","documented":true,"documented_name":"flushes","hidden":false,"name":"flushes","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Number of truncates for this SLRU","description_zh":"这个 SLRU 的截断次数","documented":true,"documented_name":"truncates","hidden":false,"name":"truncates","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"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":"PostgreSQL accesses certain on-disk information via SLRU (simple least-recently-used) caches. The pg_stat_slru view will contain one row for each tracked SLRU cache, showing statistics about access to cached pages.\n\nFor each SLRU cache that's part of the core server, there is a configuration parameter that controls its size, with the suffix _buffers appended.","description_zh":"PostgreSQL 通过 SLRU（simple least-recently-used，简单最近最少使用）缓存访问某些磁盘上的信息。pg_stat_slru 视图将为每个被跟踪的 SLRU 缓存包含一行，显示关于访问缓存页面的统计信息。\n\n对于核心服务器中的每个 SLRU 缓存，都有一个以_buffers 为后缀的配置参数来控制其大小。","description_zh_html":"\u003cp\u003ePostgreSQL 通过 SLRU（simple least-recently-used，简单最近最少使用）缓存访问某些磁盘上的信息。pg_stat_slru 视图将为每个被跟踪的 SLRU 缓存包含一行，显示关于访问缓存页面的统计信息。\n\n对于核心服务器中的每个 SLRU 缓存，都有一个以_buffers 为后缀的配置参数来控制其大小。\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-SLRU-VIEW\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.35. \u003ccode class=\"structname\"\u003epg_stat_slru\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_slru 视图\"\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\"\u003ename\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       SLRU 的名称\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\"\u003eblks_zeroed\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       初始化期间被置零的块数\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\"\u003eblks_hit\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       已经在 SLRU 中的磁盘块被发现的次数，因此不需要读取（这只包括 SLRU 中的命中，不包括操作系统的文件系统缓存中的命中）\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\"\u003eblks_read\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       为这个 SLRU 读取的磁盘块数\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\"\u003eblks_written\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       为这个 SLRU 写入的磁盘块数\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\"\u003eblks_exists\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       为这个 SLRU 检查是否存在的块数\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\"\u003eflushes\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       此 SLRU 的脏数据刷盘次数\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\"\u003etruncates\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       这个 SLRU 的截断次数\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-SLRU-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":["name","blks_zeroed","blks_hit","blks_read","blks_written","blks_exists","flushes","truncates","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:4cfd4642a426e22669c4916bcbba372cd54c841247112d0b6fc025a08e70cade","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-SLRU-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:4cfd4642a426e22669c4916bcbba372cd54c841247112d0b6fc025a08e70cade","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","blks_zeroed","blks_hit","blks_read","blks_written","blks_exists","flushes","truncates","stats_reset"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_slru","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_slru","Summary":"PostgreSQL accesses certain on-disk information via SLRU (simple least-recently-used) caches. The pg_stat_slru view will contain one row for each tracked SLRU cache, showing statistics about access to cached pages.\n\nFor each SLRU cache that's part of the core server, there is a configuration parameter that controls its size, with the suffix _buffers appended.","BodyHTML":"\u003cp\u003ePostgreSQL accesses certain on-disk information via SLRU (simple least-recently-used) caches. The pg_stat_slru view will contain one row for each tracked SLRU cache, showing statistics about access to cached pages.\n\nFor each SLRU cache that\u0026#39;s part of the core server, there is a configuration parameter that controls its size, with the suffix _buffers appended.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:d62feba0e37f39fda03d486dd2f4f669fab4ff4834dd54986a26c6fcda8be608","ContentHash":"e690e41ac5916df9d025d4f8f44e5161c15fa2d615b1dad2b52a056693ee9467","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of the SLRU","description_zh":"SLRU 的名称","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Number of blocks zeroed during initializations","description_zh":"初始化期间被置零的块数","documented":true,"documented_name":"blks_zeroed","hidden":false,"name":"blks_zeroed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Number of times disk blocks were found already in the SLRU, so that a read was not necessary (this only includes hits in the SLRU, not the operating system's file system cache)","description_zh":"已经在 SLRU 中的磁盘块被发现的次数，因此不需要读取（这只包括 SLRU 中的命中，不包括操作系统的文件系统缓存中的命中）","documented":true,"documented_name":"blks_hit","hidden":false,"name":"blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Number of disk blocks read for this SLRU","description_zh":"为这个 SLRU 读取的磁盘块数","documented":true,"documented_name":"blks_read","hidden":false,"name":"blks_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Number of disk blocks written for this SLRU","description_zh":"为这个 SLRU 写入的磁盘块数","documented":true,"documented_name":"blks_written","hidden":false,"name":"blks_written","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of blocks checked for existence for this SLRU","description_zh":"为这个 SLRU 检查是否存在的块数","documented":true,"documented_name":"blks_exists","hidden":false,"name":"blks_exists","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Number of flushes of dirty data for this SLRU","description_zh":"此 SLRU 的脏数据刷盘次数","documented":true,"documented_name":"flushes","hidden":false,"name":"flushes","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Number of truncates for this SLRU","description_zh":"这个 SLRU 的截断次数","documented":true,"documented_name":"truncates","hidden":false,"name":"truncates","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"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":"PostgreSQL accesses certain on-disk information via SLRU (simple least-recently-used) caches. The pg_stat_slru view will contain one row for each tracked SLRU cache, showing statistics about access to cached pages.\n\nFor each SLRU cache that's part of the core server, there is a configuration parameter that controls its size, with the suffix _buffers appended."}},"RequestedLocale":"en","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}