{"Entry":{"collection":"func","key":"pg-last-xact-replay-timestamp","name":"pg_last_xact_replay_timestamp","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.0","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.1"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"29469a72d11cd46ea992913766b0d035d42b70e081aaa874e42a0e605fde25e9","first_version":"9.1","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.541523+08:00","last_version":"20","name":"pg_last_xact_replay_timestamp","name_key":"pg_last_xact_replay_timestamp","position":29051,"present_in":["9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_last_xact_replay_timestamp () → timestamp with time zone","signature_count":1,"slug":"pg-last-xact-replay-timestamp","source_rev":"b7bd9cda","summary":"Returns the time stamp of the last transaction replayed during recovery.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-last-xact-replay-timestamp","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-last-xact-replay-timestamp","SourceRevision":"b7bd9cda","Facts":{"description":"Returns the time stamp of the last transaction replayed during recovery. This is the time at which the commit or abort WAL record for that transaction was generated on the primary. If no transactions have been replayed during recovery, the function returns NULL. Otherwise, if recovery is still in progress this will increase monotonically. If recovery has completed then this will remain static at the time of the last transaction applied during recovery. When the server has been started normally without recovery, the function returns NULL.","description_html":"Returns the time stamp of the last transaction replayed during recovery. This is the time at which the commit or abort WAL record for that transaction was generated on the primary. If no transactions have been replayed during recovery, the function returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e. Otherwise, if recovery is still in progress this will increase monotonically. If recovery has completed then this will remain static at the time of the last transaction applied during recovery. When the server has been started normally without recovery, the function returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-RECOVERY-INFO-TABLE","file":"functions-admin.html","slug":"18"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Returns the time stamp of the last transaction replayed during recovery. This is the time at which the commit or abort WAL record for that transaction was generated on the primary. If no transactions have been replayed during recovery, the function returns NULL. Otherwise, if recovery is still in progress this will increase monotonically. If recovery has completed then this will remain static at the time of the last transaction applied during recovery. When the server has been started normally without recovery, the function returns NULL.","description_html":"Returns the time stamp of the last transaction replayed during recovery. This is the time at which the commit or abort WAL record for that transaction was generated on the primary. If no transactions have been replayed during recovery, the function returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e. Otherwise, if recovery is still in progress this will increase monotonically. If recovery has completed then this will remain static at the time of the last transaction applied during recovery. When the server has been started normally without recovery, the function returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_last_xact_replay_timestamp\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003etimestamp with time zone\u003c/code\u003e","returns":"timestamp with time zone","text":"pg_last_xact_replay_timestamp () → timestamp with time zone","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-RECOVERY-INFO-TABLE","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-last-xact-replay-timestamp","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_last_xact_replay_timestamp","Summary":"返回恢复期间最近重放事务的时间戳，即该事务的提交或中止 WAL 记录在主库上生成的时间。如果恢复期间尚未重放任何事务，此函数返回 NULL。否则，如果恢复仍在进行，该值单调增加。如果恢复已完成，该值将保持为该次恢复期间最后应用的事务的时间戳。如果服务器未经恢复而正常启动，此函数返回 NULL。","BodyHTML":"返回恢复期间最近重放事务的时间戳，即该事务的提交或中止 WAL 记录在主库上生成的时间。如果恢复期间尚未重放任何事务，此函数返回 \u003ccode\u003eNULL\u003c/code\u003e。否则，如果恢复仍在进行，该值单调增加。如果恢复已完成，该值将保持为该次恢复期间最后应用的事务的时间戳。如果服务器未经恢复而正常启动，此函数返回 \u003ccode\u003eNULL\u003c/code\u003e。\u003cpre\u003epg_last_xact_replay_timestamp () → timestamp with time zone\u003c/pre\u003e返回恢复期间最近重放事务的时间戳，即该事务的提交或中止 WAL 记录在主库上生成的时间。如果恢复期间尚未重放任何事务，此函数返回 \u003ccode\u003eNULL\u003c/code\u003e。否则，如果恢复仍在进行，该值单调增加。如果恢复已完成，该值将保持为该次恢复期间最后应用的事务的时间戳。如果服务器未经恢复而正常启动，此函数返回 \u003ccode\u003eNULL\u003c/code\u003e。","SourceRevision":"ca936764","ContentHash":"1bc19101f0567acd286e62cfa320e74bca985038a39c69491f49356e4f634e99","Payload":{"description_zh":"返回恢复期间最近重放事务的时间戳，即该事务的提交或中止 WAL 记录在主库上生成的时间。如果恢复期间尚未重放任何事务，此函数返回 NULL。否则，如果恢复仍在进行，该值单调增加。如果恢复已完成，该值将保持为该次恢复期间最后应用的事务的时间戳。如果服务器未经恢复而正常启动，此函数返回 NULL。","description_zh_html":"返回恢复期间最近重放事务的时间戳，即该事务的提交或中止 WAL 记录在主库上生成的时间。如果恢复期间尚未重放任何事务，此函数返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。否则，如果恢复仍在进行，该值单调增加。如果恢复已完成，该值将保持为该次恢复期间最后应用的事务的时间戳。如果服务器未经恢复而正常启动，此函数返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","signatures":[{"description_zh":"返回恢复期间最近重放事务的时间戳，即该事务的提交或中止 WAL 记录在主库上生成的时间。如果恢复期间尚未重放任何事务，此函数返回 NULL。否则，如果恢复仍在进行，该值单调增加。如果恢复已完成，该值将保持为该次恢复期间最后应用的事务的时间戳。如果服务器未经恢复而正常启动，此函数返回 NULL。","description_zh_html":"返回恢复期间最近重放事务的时间戳，即该事务的提交或中止 WAL 记录在主库上生成的时间。如果恢复期间尚未重放任何事务，此函数返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。否则，如果恢复仍在进行，该值单调增加。如果恢复已完成，该值将保持为该次恢复期间最后应用的事务的时间戳。如果服务器未经恢复而正常启动，此函数返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","returns":"timestamp with time zone","text":"pg_last_xact_replay_timestamp () → timestamp with time zone","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"642f6508d6414a6947f62afebb6a82153691d4541ea501182fb55ef08042c994","Text":"pg_last_xact_replay_timestamp () → timestamp with time zone","Returns":"timestamp with time zone","Payload":{"description":"Returns the time stamp of the last transaction replayed during recovery. This is the time at which the commit or abort WAL record for that transaction was generated on the primary. If no transactions have been replayed during recovery, the function returns NULL. Otherwise, if recovery is still in progress this will increase monotonically. If recovery has completed then this will remain static at the time of the last transaction applied during recovery. When the server has been started normally without recovery, the function returns NULL.","description_html":"Returns the time stamp of the last transaction replayed during recovery. This is the time at which the commit or abort WAL record for that transaction was generated on the primary. If no transactions have been replayed during recovery, the function returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e. Otherwise, if recovery is still in progress this will increase monotonically. If recovery has completed then this will remain static at the time of the last transaction applied during recovery. When the server has been started normally without recovery, the function returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_last_xact_replay_timestamp\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003etimestamp with time zone\u003c/code\u003e","returns":"timestamp with time zone","text":"pg_last_xact_replay_timestamp () → timestamp with time zone","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}