查询给定时间点的历史数据
更新时间 2025-02-05 09:37:13
最近更新时间: 2025-02-05 09:37:13
本页为您介绍查询给定时间点的历史数据的方法。
teledb=# SELECT pg_xact_commit_timestamp(xmin) as xmin_time, pg_xact_commit_timestamp(case xmax when 0 then null else xmax end) as xmax_time,*
FROM pg_dirtyread('foo') AS t(tableoid oid, ctid tid, xmin xid, xmax xid, cmin cid, cmax cid, dead boolean,bar bigint, baz text)
where (pg_xact_commit_timestamp(xmin) <= ' 2023-11-02 16:43:02' and
(pg_xact_commit_timestamp(case xmax when 0 then null else xmax end) < '2023-11-02 16:43:02') is distinct from true
) ;
xmin_time | xmax_time | tableoid | ctid | xmin | xmax | cmin | cmax | dead | bar | baz
-------------------------------+-----------+----------+-------+------+------+------+------+------+-----+----------
2023-11-02 16:42:47.230036+08 | | 16432 | (0,3) | 680 | 0 | 0 | 0 | f | 5 | eee
2023-11-02 16:42:41.46109+08 | | 16432 | (0,3) | 659 | 0 | 0 | 0 | f | 3 | ccc_new2
(2 rows)
