System Catalogs / Statistics views
pg_stat_slru
Read the PG 18 manualPostgreSQL accesses certain on-disk information via SLRU (simple least-recently-used) caches.
Reading PG 18current·documented in 8 of 24 versions, 13 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 9
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 9
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
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 |
Column history across versions
Definition snapshot: english-manuals:4cfd4642a426e22669c4916bcbb… · English manual source