{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_recovery-last_replayed_read_lsn", "name": "pg_stat_recovery.last_replayed_read_lsn", "name_zh": "", "category": "pg_stat_recovery", "summary": "Not recorded in the selected version.", "aliases": ["last_replayed_read_lsn", "pg_stat_recovery"], "content_hash": "775ef014bce3add3975579eab808ffde17987f01f39f77ad252bb6910f2b6fa4", "versions": {"19": {"view": "pg_stat_recovery", "facts": [{"label": "View", "value": "pg_stat_recovery"}, {"label": "Field", "value": "last_replayed_read_lsn"}, {"label": "SQL type", "value": "pg_lsn"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "No stats_reset field is documented for this view"}], "field": "last_replayed_read_lsn", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_recovery/?v=19", "label": "pg_stat_recovery columns"}, {"url": "/docs/19/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "/docs/19/monitoring-stats.html#PG-STAT-RECOVERY-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 19 English manual", "sha256": "26e1b6632bdf05ebe081987cb60ab4ded526eec7db73e41316fbd69466c494fe"}], "sections": [{"title": "View semantics", "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": "Collection and reset context", "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."]}, {"code": "SELECT last_replayed_read_lsn FROM pg_catalog.pg_stat_recovery;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "pg_lsn", "signature": "SELECT last_replayed_read_lsn FROM pg_catalog.pg_stat_recovery;", "documented": true, "description": ["Start write-ahead log location of the last successfully replayed WAL record."], "manual_html": "", "manual_path": "/docs/19/monitoring-stats.html", "source_only": false, "comparison_data": {"view": "pg_stat_recovery", "field": "last_replayed_read_lsn", "sql_type": "pg_lsn", "units_mentioned": []}, "comparison_hash": "d02abb12588d23b5e52f14cb13fc0aec9eef12eb9f740a0d6cbb6d736dee0b97", "units_mentioned": []}, "20": {"view": "pg_stat_recovery", "facts": [{"label": "View", "value": "pg_stat_recovery"}, {"label": "Field", "value": "last_replayed_read_lsn"}, {"label": "SQL type", "value": "pg_lsn"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "No stats_reset field is documented for this view"}], "field": "last_replayed_read_lsn", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_recovery/?v=20", "label": "pg_stat_recovery columns"}, {"url": "/docs/devel/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "/docs/devel/monitoring-stats.html#PG-STAT-RECOVERY-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 20 English manual", "sha256": "dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251"}], "sections": [{"title": "View semantics", "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": "Collection and reset context", "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."]}, {"code": "SELECT last_replayed_read_lsn FROM pg_catalog.pg_stat_recovery;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "pg_lsn", "signature": "SELECT last_replayed_read_lsn FROM pg_catalog.pg_stat_recovery;", "documented": true, "description": ["Start write-ahead log location of the last successfully replayed WAL record."], "manual_html": "", "manual_path": "/docs/devel/monitoring-stats.html", "source_only": false, "comparison_data": {"view": "pg_stat_recovery", "field": "last_replayed_read_lsn", "sql_type": "pg_lsn", "units_mentioned": []}, "comparison_hash": "d02abb12588d23b5e52f14cb13fc0aec9eef12eb9f740a0d6cbb6d736dee0b97", "units_mentioned": []}}}, "snapshot": null, "comparison": {"left": "18", "right": "19", "status": "added", "diff": "--- PostgreSQL 18\n+++ PostgreSQL 19\n@@ -1 +1,6 @@\n-Not recorded in this version\n+{\n+  \"field\": \"last_replayed_read_lsn\",\n+  \"sql_type\": \"pg_lsn\",\n+  \"units_mentioned\": [],\n+  \"view\": \"pg_stat_recovery\"\n+}"}}