SYSTEM CATALOGS / STATISTICS VIEWS
pg_stat_slru
Read PG 18 manual ↗PostgreSQL accesses certain on-disk information via SLRU (simple least-recently-used) caches.
- Kind
- Statistics views
- Columns in this snapshot
- 9
- Definition source
- English manual
Columns 9
| 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
Version history 2
- PG 16 → 17changed
- PG 12 → 13added
Definition snapshot: english-manuals:c48c255bb00fa960c1b7f41bce4… · English manual source