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)