{"Entry":{"collection":"metric","key":"pg_stat_recovery-current_chunk_start_time","name":"pg_stat_recovery.current_chunk_start_time","aliases":["current_chunk_start_time","pg_stat_recovery"],"metadata":{"aliases":["current_chunk_start_time","pg_stat_recovery"],"category":"pg_stat_recovery","content_hash":"3883c28851b4f4dc9e6b58b50fafd403eba8a5f755d1df4e9c2f563940e75401","imported_at":"2026-09-30T00:40:46.011688+08:00","name":"pg_stat_recovery.current_chunk_start_time","name_zh":"","slug":"pg_stat_recovery-current_chunk_start_time","summary":"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."}},"Definition":{"Collection":"metric","Key":"pg_stat_recovery-current_chunk_start_time","SourceDatabase":"center","Version":"20","SourceTable":"statistics_metric","SourceKey":"pg_stat_recovery-current_chunk_start_time","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","Facts":{"comparison_data":{"field":"current_chunk_start_time","sql_type":"timestamp with time zone","units_mentioned":[],"view":"pg_stat_recovery"},"comparison_hash":"dc5e9e53572c11a72df73fe6e2be84254f57781789d04c3fe7a40d70b089eb28","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."],"documented":true,"facts":[{"label":"View","value":"pg_stat_recovery"},{"label":"Field","value":"current_chunk_start_time"},{"label":"SQL type","value":"timestamp with time zone"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"No stats_reset field is documented for this view"}],"field":"current_chunk_start_time","manual_html":"","manual_path":"/docs/devel/monitoring-stats.html","related":[{"label":"pg_stat_recovery columns","url":"/wiki/catalog/pg_stat_recovery/?v=20"},{"label":"Statistics collection and reset functions","url":"/docs/devel/monitoring-stats.html"}],"release":{"channel":"devel","label":"20devel","major":"20","ref":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2","revision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"},"sections":[{"paragraphs":["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."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT current_chunk_start_time FROM pg_catalog.pg_stat_recovery;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"signature":"SELECT current_chunk_start_time FROM pg_catalog.pg_stat_recovery;","source_only":false,"sources":[{"label":"PostgreSQL 20 English manual","path":"monitoring-stats.html","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","url":"/docs/devel/monitoring-stats.html#PG-STAT-RECOVERY-VIEW"}],"sql_type":"timestamp with time zone","tables":[],"units_mentioned":[],"view":"pg_stat_recovery"},"ManualEvidence":{"manual_path":"/docs/devel/monitoring-stats.html","release":{"channel":"devel","label":"20devel","major":"20","ref":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2","revision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"},"sources":[{"label":"PostgreSQL 20 English manual","path":"monitoring-stats.html","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","url":"/docs/devel/monitoring-stats.html#PG-STAT-RECOVERY-VIEW"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_recovery-current_chunk_start_time","SourceDatabase":"center","Version":"20","Locale":"en","Title":"pg_stat_recovery.current_chunk_start_time","Summary":"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.","BodyHTML":"\u003cp\u003eTime 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.\u003c/p\u003e","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","ContentHash":"f5227d1ed88644ebf72053bb3e0e7da5b938bf68b4056613f9cd9b7df29b6b1a","Payload":{"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."],"manual_html":"","related":[{"label":"pg_stat_recovery columns","url":"/wiki/catalog/pg_stat_recovery/?v=20"},{"label":"Statistics collection and reset functions","url":"/docs/devel/monitoring-stats.html"}],"sections":[{"paragraphs":["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."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT current_chunk_start_time FROM pg_catalog.pg_stat_recovery;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"tables":[]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}