{"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":"a16879e3e4113a886a38546f09ec89f4d81bcf49d8da5e3dd9ad194c59e37994","derived_content_hash":"a0eabc7e3bac7ac1c9c7361026b63b95216eccd8bfb014b79b6114920982b0b7","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:ef4e07cbbdc9a0b311100615df88af0d888469047cf1093ed40f01f17d9aabad","versions":{"15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"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":"catalog-bilingual-repair:ef4e07cbbdc9a0b311100615df88af0d888469047cf1093ed40f01f17d9aabad","summary":"The pg_stat_recovery_prefetch view will contain only one row.","summary_zh":"pg_stat_recovery_prefetch 视图将只包含一行。wal_distance、block_distance 和 io_depth 列显示当前值，其他列显示可以使用 pg_stat_reset_shared 函数重置的累积计数器。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_recovery_prefetch","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_recovery_prefetch","SourceRevision":"catalog-bilingual-repair:ef4e07cbbdc9a0b311100615df88af0d888469047cf1093ed40f01f17d9aabad","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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of blocks not prefetched because a full page image was included in the WAL","description_zh":"由于 WAL 中包含整页镜像而未预取的块数","documented":true,"documented_name":"skip_fpw","hidden":false,"name":"skip_fpw","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"}],"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":"pg_stat_recovery_prefetch 视图将只包含一行。wal_distance、block_distance 和 io_depth 列显示当前值，其他列显示可以使用 pg_stat_reset_shared 函数重置的累积计数器。","description_zh_html":"\u003cp\u003epg_stat_recovery_prefetch 视图将只包含一行。wal_distance、block_distance 和 io_depth 列显示当前值，其他列显示可以使用 pg_stat_reset_shared 函数重置的累积计数器。\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-RECOVERY-PREFETCH-VIEW\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.17. \u003ccode class=\"structname\"\u003epg_stat_recovery_prefetch\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_recovery_prefetch 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003estats_reset\u003c/code\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e这些统计信息上次被重置的时间\u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eprefetch\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n        因不在缓冲池中而预取的块数\n       \u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ehit\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n        因已在缓冲池中而未预取的块数\n       \u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eskip_init\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n        未预取的块数，因为它们将被初始化为零\n       \u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eskip_new\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n        未预取的块数，因为它们尚不存在\n       \u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eskip_fpw\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n        由于 WAL 中包含整页镜像而未预取的块数\n       \u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eskip_rep\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n        由于最近已经预取过而未预取的块数\n       \u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ewal_distance\u003c/code\u003e \u003ccode class=\"type\"\u003eint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e预取器向前查看的字节数\u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eblock_distance\u003c/code\u003e \u003ccode class=\"type\"\u003eint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e预取器向前查看的块数\u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\n\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eio_depth\u003c/code\u003e \u003ccode class=\"type\"\u003eint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e已启动但尚未确认完成的预取数量\u003c/p\u003e\n\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","doc":{"anchor":"PG-STAT-RECOVERY-PREFETCH-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"documentation_revision":{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:4743f1c8c10a03746e9386e0559e6c5c272db6c573fe9ca83612dd6a8736df38","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-RECOVERY-PREFETCH-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:4743f1c8c10a03746e9386e0559e6c5c272db6c573fe9ca83612dd6a8736df38","version":"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":"center","Version":"18","Locale":"en","Title":"pg_stat_recovery_prefetch","Summary":"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.","BodyHTML":"\u003cp\u003eThe 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:ef4e07cbbdc9a0b311100615df88af0d888469047cf1093ed40f01f17d9aabad","ContentHash":"2bcf099b3181f3042258bb0a8e3b237c957173fa65239b2bb56259d9675586e9","Payload":{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of blocks not prefetched because a full page image was included in the WAL","description_zh":"由于 WAL 中包含整页镜像而未预取的块数","documented":true,"documented_name":"skip_fpw","hidden":false,"name":"skip_fpw","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"}],"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."}},"RequestedLocale":"en","Fallback":false,"Versions":["15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}