{"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":"476690b07a10ace1d6357a236efeb04c9aba77c239ca22d816cd298da3a7b8d7","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":"english-manuals:4cfd4642a426e22669c4916bcbba372cd54c841247112d0b6fc025a08e70cade","summary":"PostgreSQL accesses certain on-disk information via SLRU (simple least-recently-used) caches.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_slru","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_slru","SourceRevision":"english-manuals:4cfd4642a426e22669c4916bcbba372cd54c841247112d0b6fc025a08e70cade","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of the SLRU","description_zh":"","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"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},{"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":"","documented":true,"documented_name":"blks_hit","hidden":false,"name":"blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"description":"Number of disk blocks read for this SLRU","description_zh":"","documented":true,"documented_name":"blks_read","hidden":false,"name":"blks_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":5,"description":"Number of disk blocks written for this SLRU","description_zh":"","documented":true,"documented_name":"blks_written","hidden":false,"name":"blks_written","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":6,"description":"Number of blocks checked for existence for this SLRU","description_zh":"","documented":true,"documented_name":"blks_exists","hidden":false,"name":"blks_exists","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":7,"description":"Number of flushes of dirty data for this SLRU","description_zh":"","documented":true,"documented_name":"flushes","hidden":false,"name":"flushes","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":8,"description":"Number of truncates for this SLRU","description_zh":"","documented":true,"documented_name":"truncates","hidden":false,"name":"truncates","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"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}],"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":"","doc":{"anchor":"PG-STAT-SLRU-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"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"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-SLRU-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_slru","Summary":"PostgreSQL通过SLRU（simple least-recently-used，简单最近最少使用）缓存访问某些磁盘上的信息。pg_stat_slru视图将为每个被跟踪的SLRU缓存包含一行，显示关于访问缓存页面的统计信息。\n\n对于核心服务器中的每个SLRU缓存，都有一个以_buffers为后缀的配置参数来控制其大小。","BodyHTML":"\u003cp\u003ePostgreSQL通过SLRU（simple least-recently-used，简单最近最少使用）缓存访问某些磁盘上的信息。pg_stat_slru视图将为每个被跟踪的SLRU缓存包含一行，显示关于访问缓存页面的统计信息。\n\n对于核心服务器中的每个SLRU缓存，都有一个以_buffers为后缀的配置参数来控制其大小。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"d8f85c60df640a9a019614e0489f579cc3709f2216df4965887ca60ab6860c1f","Payload":{"columns":[{"description_zh":"SLRU的名称","name":"name","type":"text","zh_from":"doc"},{"description_zh":"初始化期间被置零的块数","name":"blks_zeroed","type":"bigint","zh_from":"doc"},{"description_zh":"已经在SLRU中的磁盘块被发现的次数，因此不需要读取（这只包括SLRU中的命中，不包括操作系统的文件系统缓存中的命中）","name":"blks_hit","type":"bigint","zh_from":"doc"},{"description_zh":"为这个SLRU读取的磁盘块数","name":"blks_read","type":"bigint","zh_from":"doc"},{"description_zh":"为这个SLRU写入的磁盘块数","name":"blks_written","type":"bigint","zh_from":"doc"},{"description_zh":"为这个SLRU检查是否存在的块数","name":"blks_exists","type":"bigint","zh_from":"doc"},{"description_zh":"此SLRU的脏数据刷盘次数","name":"flushes","type":"bigint","zh_from":"doc"},{"description_zh":"这个SLRU的截断次数","name":"truncates","type":"bigint","zh_from":"doc"},{"description_zh":"这些统计信息上次被重置的时间","name":"stats_reset","type":"timestamp with time zone","zh_from":"doc"}],"description_zh":"PostgreSQL通过SLRU（simple least-recently-used，简单最近最少使用）缓存访问某些磁盘上的信息。pg_stat_slru视图将为每个被跟踪的SLRU缓存包含一行，显示关于访问缓存页面的统计信息。\n\n对于核心服务器中的每个SLRU缓存，都有一个以_buffers为后缀的配置参数来控制其大小。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}