跳转到主要内容
← 目录图谱 / pg_stat_slru

STATISTICS VIEW · 统计视图

pg_stat_slru

PostgreSQL 官方文档 ↗源码定义 ↗

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. For each SLRU cache that's part of the core server, there is a configuration parameter that controls its size, with the suffix _buffers appended.

首次收录 PG 13最近收录 PG 19当前字段 9
9.09.19.29.39.49.59.610111213141516171819β3

已与 PostgreSQL 18.6 实例逐字段核对 · 原始实测记录 ↗

字段结构 PostgreSQL 18

pg_stat_slru
字段 / COLUMN类型 / TYPE说明 / DESCRIPTION
name text Name of the SLRU
blks_zeroed bigint Number of blocks zeroed during initializations
blks_hit bigint 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)
blks_read bigint Number of disk blocks read for this SLRU
blks_written bigint Number of disk blocks written for this SLRU
blks_exists bigint Number of blocks checked for existence for this SLRU
flushes bigint Number of flushes of dirty data for this SLRU
truncates bigint Number of truncates for this SLRU
stats_reset timestamp with time zone Time at which these statistics were last reset

标记“隐式列”的字段不包含在 SELECT * 中；部分早期统计视图由同版本源码补全，额外来源会显示在字段说明中。

字段演化矩阵

悬停查看字段类型
存在新增 / 类型或属性变化移除
字段 / COLUMN9.09.19.29.39.49.59.610111213141516171819
name – – – – – – – – – –
blks_zeroed – – – – – – – – – –
blks_hit – – – – – – – – – –
blks_read – – – – – – – – – –
blks_written – – – – – – – – – –
blks_exists – – – – – – – – – –
flushes – – – – – – – – – –
truncates – – – – – – – – – –
stats_reset – – – – – – – – – –

9.0 是收录基线；基线中已存在的字段不标记为新增。矩阵按字段名称对齐，重命名显示为旧字段移除与新字段新增。

演化时间线

相邻大版本的变化

PostgreSQL 17 ← 16

目录说明更新

PostgreSQL 13 ← 12新增目录

+ name+ blks_zeroed+ blks_hit+ blks_read+ blks_written+ blks_exists+ flushes+ truncates+ stats_reset

比较任意两个版本

选择两个版本，查看字段的新增、移除与类型变化。交互比较需要 JavaScript；演化时间线可直接阅读。