SYSTEM CATALOGS / STATISTICS VIEWS
pg_stat_recovery_prefetch
Read PG 18 manual ↗The pg_stat_recovery_prefetch view will contain only one row.
- Kind
- Statistics views
- Columns in this snapshot
- 10
- Definition source
- English manual
Columns 10
| 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
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
stats_reset | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
prefetch | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
hit | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
skip_init | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
skip_new | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
skip_fpw | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
skip_rep | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
wal_distance | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
block_distance | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
io_depth | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● |
Version history 1
- PG 14 → 15added
Definition snapshot: english-manuals:e8de90f7444057522fdb5203bd3… · English manual source