{"Entry":{"collection":"catalog","key":"pg_stat_recovery_prefetch","name":"pg_stat_recovery_prefetch","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"14","order":false,"removed":[],"status":"added","to":"15","types":[]}],"column_count":10,"content_hash":"ffc63de5c7f1072a8a218b16466642b012760d7e1b8233039bb5edf23a8fd7e5","first_version":"15","imported_at":"2026-09-30T00:40:55.962573+08:00","kind":"statistics","last_version":"20","name":"pg_stat_recovery_prefetch","position":103,"present_in":["15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:4743f1c8c10a03746e9386e0559e6c5c272db6c573fe9ca83612dd6a8736df38","summary":"The pg_stat_recovery_prefetch view will contain only one row.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_recovery_prefetch","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_recovery_prefetch","SourceRevision":"english-manuals:4743f1c8c10a03746e9386e0559e6c5c272db6c573fe9ca83612dd6a8736df38","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Time at which these statistics were last reset","description_zh":"","documented":true,"documented_name":"stats_reset","hidden":false,"name":"stats_reset","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184},{"array_dimensions":0,"attnum":2,"description":"Number of blocks prefetched because they were not in the buffer pool","description_zh":"","documented":true,"documented_name":"prefetch","hidden":false,"name":"prefetch","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":3,"description":"Number of blocks not prefetched because they were already in the buffer pool","description_zh":"","documented":true,"documented_name":"hit","hidden":false,"name":"hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"description":"Number of blocks not prefetched because they would be zero-initialized","description_zh":"","documented":true,"documented_name":"skip_init","hidden":false,"name":"skip_init","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":5,"description":"Number of blocks not prefetched because they didn't exist yet","description_zh":"","documented":true,"documented_name":"skip_new","hidden":false,"name":"skip_new","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":6,"description":"Number of blocks not prefetched because a full page image was included in the WAL","description_zh":"","documented":true,"documented_name":"skip_fpw","hidden":false,"name":"skip_fpw","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":7,"description":"Number of blocks not prefetched because they were already recently prefetched","description_zh":"","documented":true,"documented_name":"skip_rep","hidden":false,"name":"skip_rep","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":8,"description":"How many bytes ahead the prefetcher is looking","description_zh":"","documented":true,"documented_name":"wal_distance","hidden":false,"name":"wal_distance","not_null":false,"references":"","type":"int","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":9,"description":"How many blocks ahead the prefetcher is looking","description_zh":"","documented":true,"documented_name":"block_distance","hidden":false,"name":"block_distance","not_null":false,"references":"","type":"int","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":10,"description":"How many prefetches have been initiated but are not yet known to have completed","description_zh":"","documented":true,"documented_name":"io_depth","hidden":false,"name":"io_depth","not_null":false,"references":"","type":"int","type_modifier":-1,"type_oid":23}],"description":"The pg_stat_recovery_prefetch view will contain only one row. The columns wal_distance, block_distance and io_depth show current values, and the other columns show cumulative counters that can be reset with the pg_stat_reset_shared function.","description_zh":"","doc":{"anchor":"PG-STAT-RECOVERY-PREFETCH-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["stats_reset","prefetch","hit","skip_init","skip_new","skip_fpw","skip_rep","wal_distance","block_distance","io_depth"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-RECOVERY-PREFETCH-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["stats_reset","prefetch","hit","skip_init","skip_new","skip_fpw","skip_rep","wal_distance","block_distance","io_depth"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_recovery_prefetch","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_recovery_prefetch","Summary":"pg_stat_recovery_prefetch视图将只包含一行。wal_distance、block_distance和 io_depth列显示当前值，其他列显示可以使用 pg_stat_reset_shared函数重置的累积计数器。","BodyHTML":"\u003cp\u003epg_stat_recovery_prefetch视图将只包含一行。wal_distance、block_distance和 io_depth列显示当前值，其他列显示可以使用 pg_stat_reset_shared函数重置的累积计数器。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"056ed564e27627fec9db0de3a1179697507ccd23a0627db305c48c14e9b1670a","Payload":{"columns":[{"description_zh":"这些统计信息上次被重置的时间","name":"stats_reset","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"因不在缓冲池中而预取的块数","name":"prefetch","type":"bigint","zh_from":"doc"},{"description_zh":"因已在缓冲池中而未预取的块数","name":"hit","type":"bigint","zh_from":"doc"},{"description_zh":"未预取的块数，因为它们将被初始化为零","name":"skip_init","type":"bigint","zh_from":"doc"},{"description_zh":"未预取的块数，因为它们尚不存在","name":"skip_new","type":"bigint","zh_from":"doc"},{"description_zh":"由于WAL中包含整页镜像而未预取的块数","name":"skip_fpw","type":"bigint","zh_from":"doc"},{"description_zh":"由于最近已经预取过而未预取的块数","name":"skip_rep","type":"bigint","zh_from":"doc"},{"description_zh":"预取器向前查看的字节数","name":"wal_distance","type":"integer","zh_from":"doc"},{"description_zh":"预取器向前查看的块数","name":"block_distance","type":"integer","zh_from":"doc"},{"description_zh":"已启动但尚未确认完成的预取数量","name":"io_depth","type":"integer","zh_from":"doc"}],"description_zh":"pg_stat_recovery_prefetch视图将只包含一行。wal_distance、block_distance和 io_depth列显示当前值，其他列显示可以使用 pg_stat_reset_shared函数重置的累积计数器。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}