{"Entry":{"collection":"func","key":"pg-xlog-location-diff","name":"pg_xlog_location_diff","aliases":[],"metadata":{"changed_in":["9.4"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.1","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.2"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.3","group_changed":null,"signatures":{"added":["pg_xlog_location_diff ( location pg_lsn, location pg_lsn ) → numeric"],"removed":["pg_xlog_location_diff ( location text, location text ) → numeric"]},"status":"changed","to":"9.4"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.6","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"removed","to":"10"}],"content_hash":"20df1189d45a8914e4dd7a62f1c34a879bde901d1d298f8de1c94331c0b484ca","first_version":"9.2","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.71795+08:00","last_version":"9.6","name":"pg_xlog_location_diff","name_key":"pg_xlog_location_diff","position":29118,"present_in":["9.2","9.3","9.4","9.5","9.6"],"signature":"pg_xlog_location_diff ( location pg_lsn, location pg_lsn ) → numeric","signature_count":1,"slug":"pg-xlog-location-diff","source_rev":"b7bd9cda","summary":"Calculate the difference between two transaction log locations","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-xlog-location-diff","SourceDatabase":"center","Version":"9.6","SourceTable":"func","SourceKey":"pg-xlog-location-diff","SourceRevision":"b7bd9cda","Facts":{"description":"Calculate the difference between two transaction log locations","description_html":"Calculate the difference between two transaction log locations","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ADMIN-BACKUP-TABLE","file":"functions-admin.html","slug":"9.6"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-old","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Calculate the difference between two transaction log locations","description_html":"Calculate the difference between two transaction log locations","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_xlog_location_diff\u003c/code\u003e ( location pg_lsn, location pg_lsn ) → \u003ccode class=\"returnvalue\"\u003enumeric\u003c/code\u003e","returns":"numeric","text":"pg_xlog_location_diff ( location pg_lsn, location pg_lsn ) → numeric","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-BACKUP-TABLE","file":"functions-admin.html","slug":"9.6"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-xlog-location-diff","SourceDatabase":"pgweb","Version":"9.6","Locale":"zh-Hans","Title":"pg_xlog_location_diff","Summary":"计算两个事务日志位置之差","BodyHTML":"计算两个事务日志位置之差\u003cpre\u003epg_xlog_location_diff ( location pg_lsn, location pg_lsn ) → numeric\u003c/pre\u003e计算两个事务日志位置之差","SourceRevision":"ca936764","ContentHash":"22e48e71ef3ede2619dfba894d1b4a3aad36f2633fbd2ff71cff4c12b9e1d02c","Payload":{"description_zh":"计算两个事务日志位置之差","description_zh_html":"计算两个事务日志位置之差","signatures":[{"description_zh":"计算两个事务日志位置之差","description_zh_html":"计算两个事务日志位置之差","returns":"numeric","text":"pg_xlog_location_diff ( location pg_lsn, location pg_lsn ) → numeric","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"9.6","Ordinal":0,"Hash":"838f955d2e76366701e877a2381d1ef21da48da094e502a9888402550e44da3d","Text":"pg_xlog_location_diff ( location pg_lsn, location pg_lsn ) → numeric","Returns":"numeric","Payload":{"description":"Calculate the difference between two transaction log locations","description_html":"Calculate the difference between two transaction log locations","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_xlog_location_diff\u003c/code\u003e ( location pg_lsn, location pg_lsn ) → \u003ccode class=\"returnvalue\"\u003enumeric\u003c/code\u003e","returns":"numeric","text":"pg_xlog_location_diff ( location pg_lsn, location pg_lsn ) → numeric","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}