System Catalogs / Statistics views
pg_stat_recovery_prefetch
Read the PG 18 manualThe pg_stat_recovery_prefetch view will contain only one row.
Reading PG 18current·documented in 6 of 24 versions, 15 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 10
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 10
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
stats_reset | timestamp with time zone | Time at which these statistics were last reset |
prefetch | bigint | Number of blocks prefetched because they were not in the buffer pool |
hit | bigint | Number of blocks not prefetched because they were already in the buffer pool |
skip_init | bigint | Number of blocks not prefetched because they would be zero-initialized |
skip_new | bigint | Number of blocks not prefetched because they didn't exist yet |
skip_fpw | bigint | Number of blocks not prefetched because a full page image was included in the WAL |
skip_rep | bigint | Number of blocks not prefetched because they were already recently prefetched |
wal_distance | int | How many bytes ahead the prefetcher is looking |
block_distance | int | How many blocks ahead the prefetcher is looking |
io_depth | int | How many prefetches have been initiated but are not yet known to have completed |
Column history across versions
Version history 1
- 14 → 15 added
Definition snapshot: english-manuals:4743f1c8c10a03746e9386e0559… · English manual source