↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Statistics & Metrics

pg_stat_recovery_prefetch.block_distance

How many blocks ahead the prefetcher is looking

Reading PG 18·Select a recorded version

View
pg_stat_recovery_prefetch
Field
block_distance
SQL type
int
Units named in the field definition
blocks
Reset observation
Time at which these statistics were last reset
documented
true
field
block_distance
manual path
/docs/18/monitoring-stats.html
signature
SELECT block_distance FROM pg_catalog.pg_stat_recovery_prefetch;
source only
false
sql type
int
units mentioned
blocks
view
pg_stat_recovery_prefetch

Definition PG 18

How many blocks ahead the prefetcher is looking

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f