{"Entry":{"collection":"catalog","key":"pg_stat_recovery","name":"pg_stat_recovery","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","order":false,"removed":[],"status":"added","to":"19","types":[]}],"column_count":9,"content_hash":"3778704e6ac4eece68601f790954fbcb21d45f274d51f74cbe6d87e895614da8","first_version":"19","imported_at":"2026-09-30T00:40:55.960122+08:00","kind":"statistics","last_version":"20","name":"pg_stat_recovery","position":102,"present_in":["19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:aaa8fa3b2bbd0ec5f88d62cc16915a4032abb5f860b066f1e5b0e00782486c62","summary":"The pg_stat_recovery view will contain at most one row, showing statistics about the recovery state of the startup process.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_recovery","SourceDatabase":"center","Version":"20","SourceTable":"catalog","SourceKey":"pg_stat_recovery","SourceRevision":"english-manuals:aaa8fa3b2bbd0ec5f88d62cc16915a4032abb5f860b066f1e5b0e00782486c62","Facts":{"columns":[{"description":"True if a promotion has been triggered.","description_zh":"","documented":true,"documented_name":"promote_triggered","hidden":false,"name":"promote_triggered","references":"","type":"boolean"},{"description":"Start write-ahead log location of the last successfully replayed WAL record.","description_zh":"","documented":true,"documented_name":"last_replayed_read_lsn","hidden":false,"name":"last_replayed_read_lsn","references":"","type":"pg_lsn"},{"description":"End write-ahead log location, plus one, of the last successfully replayed WAL record.","description_zh":"","documented":true,"documented_name":"last_replayed_end_lsn","hidden":false,"name":"last_replayed_end_lsn","references":"","type":"pg_lsn"},{"description":"Timeline of the last successfully replayed WAL record.","description_zh":"","documented":true,"documented_name":"last_replayed_tli","hidden":false,"name":"last_replayed_tli","references":"","type":"integer"},{"description":"Write-ahead log location of the record currently being replayed (end position plus one). When no record is being actively replayed, equals last_replayed_end_lsn.","description_zh":"","documented":true,"documented_name":"replay_end_lsn","hidden":false,"name":"replay_end_lsn","references":"","type":"pg_lsn"},{"description":"Timeline of the WAL record currently being replayed. When no record is being actively replayed, equals last_replayed_tli.","description_zh":"","documented":true,"documented_name":"replay_end_tli","hidden":false,"name":"replay_end_tli","references":"","type":"integer"},{"description":"Timestamp of the last transaction commit or abort record replayed during recovery. This is the time at which the commit or abort WAL record for that transaction was generated on the primary.","description_zh":"","documented":true,"documented_name":"recovery_last_xact_time","hidden":false,"name":"recovery_last_xact_time","references":"","type":"timestamp with time zone"},{"description":"Time when the startup process observed that replay had caught up with the latest WAL chunk received from streaming replication. Used in recovery-conflict timing and replay/apply-lag diagnostics. NULL if streaming WAL has not yet been received or the time is not available.","description_zh":"","documented":true,"documented_name":"current_chunk_start_time","hidden":false,"name":"current_chunk_start_time","references":"","type":"timestamp with time zone"},{"description":"Recovery pause state. Possible values are:\n\nnot paused: Recovery is proceeding normally. pause requested: A pause has been requested but recovery has not yet paused. paused: Recovery is paused.","description_zh":"","documented":true,"documented_name":"pause_state","hidden":false,"name":"pause_state","references":"","type":"text"}],"description":"The pg_stat_recovery view will contain at most one row, showing statistics about the recovery state of the startup process. This view returns no rows when the server is not in recovery or the user does not have privileges of the pg_read_all_stats role.","description_zh":"","doc":{"anchor":"PG-STAT-RECOVERY-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","slug":"devel"},"kind":"statistics","lang":"en","measured_attributes":false,"metadata_release":"","runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-RECOVERY-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","slug":"devel"}},"MeasuredEvidence":{"measured_attributes":false,"metadata_release":"","runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_recovery","SourceDatabase":"pgweb","Version":"20","Locale":"zh-Hans","Title":"pg_stat_recovery","Summary":"pg_stat_recovery视图至多包含一行，用来显示启动进程的恢复状态统计信息。当服务器不处于恢复状态，或者用户没有 pg_read_all_stats 角色的权限时，这个视图不返回任何行。","BodyHTML":"\u003cp\u003epg_stat_recovery视图至多包含一行，用来显示启动进程的恢复状态统计信息。当服务器不处于恢复状态，或者用户没有 pg_read_all_stats 角色的权限时，这个视图不返回任何行。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"232dc859552a9bf0bc78b5ff0f8a9d68e4d13042f900151ce9924019a1d2d81e","Payload":{"columns":[{"description_zh":"如果已经触发提升，则为真。","name":"promote_triggered","type":"boolean","zh_from":"doc"},{"description_zh":"最近一次成功重放的 WAL 记录在预写式日志中的起始位置。","name":"last_replayed_read_lsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"最近一次成功重放的 WAL 记录在预写式日志中的结束位置加一。","name":"last_replayed_end_lsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"最近一次成功重放的 WAL 记录所在的时间线。","name":"last_replayed_tli","type":"integer","zh_from":"doc"},{"description_zh":"当前正在重放的记录的预写式日志位置（结束位置加一）。如果当前没有正在重放的记录，则等于 last_replayed_end_lsn。","name":"replay_end_lsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"当前正在重放的 WAL 记录所在的时间线。如果当前没有正在重放的记录，则等于last_replayed_tli。","name":"replay_end_tli","type":"integer","zh_from":"doc"},{"description_zh":"恢复期间最近重放的事务提交或中止记录的时间戳。这个时间是该事务的提交或中止 WAL 记录在主库上生成的时间。","name":"recovery_last_xact_time","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"启动进程观察到重放已经追上从流复制接收的最新 WAL 块的时间。用于恢复冲突计时和重放/应用延迟诊断。如果尚未接收到流式 WAL，或无法获得该时间，则为空值。","name":"current_chunk_start_time","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"恢复暂停状态。可能的值有：","name":"pause_state","type":"text","zh_from":"doc"}],"description_zh":"pg_stat_recovery视图至多包含一行，用来显示启动进程的恢复状态统计信息。当服务器不处于恢复状态，或者用户没有 pg_read_all_stats 角色的权限时，这个视图不返回任何行。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}