Postgres Pro
Downloads
Home   >   mailing lists

broken tables on hot standby after migration on PostgreSQL 16 (3x times last month) - Mailing list pgsql-hackers

From Pavel Stehule
Subject broken tables on hot standby after migration on PostgreSQL 16 (3x times last month)
Date
Msg-id CAFj8pRBpprGHZTwBaNQ7GRgokwB-vJT9s7aDWY6OFPDQNXSA=g@mail.gmail.com
Whole thread Raw
Responses Re: broken tables on hot standby after migration on PostgreSQL 16 (3x times last month)
Re: broken tables on hot standby after migration on PostgreSQL 16 (3x times last month)
List pgsql-hackers
Tree view
Hi

after migration on PostgreSQL 16 I seen 3x times (about every week) broken tables on replica nodes. The query fails with error

ERROR:  could not access status of transaction 1442871302
DETAIL:  Could not open file "pg_xact/0560": No such file or directory

verify_heapam reports

^[[Aprd=# select * from verify_heapam('account_login_history') where blkno = 179036;
 blkno  | offnum | attnum |                                msg                                
--------+--------+--------+-------------------------------------------------------------------
 179036 |     30 |        | xmin 1393743382 precedes oldest valid transaction ID 3:1687012112
 179036 |     31 |        | xmin 1393748413 precedes oldest valid transaction ID 3:1687012112
 179036 |     32 |        | xmin 1393751312 precedes oldest valid transaction ID 3:1687012112
 179036 |     33 |        | xmin 1393763601 precedes oldest valid transaction ID 3:1687012112
 179036 |     34 |        | xmin 1393795606 precedes oldest valid transaction ID 3:1687012112
 179036 |     35 |        | xmin 1393817722 precedes oldest valid transaction ID 3:1687012112
 179036 |     36 |        | xmin 1393821359 precedes oldest valid transaction ID 3:1687012112
 179036 |     37 |        | xmin 1393821373 precedes oldest valid transaction ID 3:1687012112
 179036 |     38 |        | xmin 1393821523 precedes oldest valid transaction ID 3:1687012112
 179036 |     39 |        | xmin 1410429961 precedes oldest valid transaction ID 3:1687012112
 179036 |     40 |        | xmin 1410433593 precedes oldest valid transaction ID 3:1687012112
 179036 |     41 |        | xmin 1410501438 precedes oldest valid transaction ID 3:1687012112
 179036 |     42 |        | xmin 1410511950 precedes oldest valid transaction ID 3:1687012112
 179036 |     43 |        | xmin 1410516400 precedes oldest valid transaction ID 3:1687012112
 179036 |     44 |        | xmin 1410527685 precedes oldest valid transaction ID 3:1687012112
 179036 |     45 |        | xmin 1421269000 precedes oldest valid transaction ID 3:1687012112
 179036 |     46 |        | xmin 1421304247 precedes oldest valid transaction ID 3:1687012112
 179036 |     47 |        | xmin 1421333991 precedes oldest valid transaction ID 3:1687012112
 179036 |     48 |        | xmin 1421365062 precedes oldest valid transaction ID 3:1687012112
 179036 |     49 |        | xmin 1421427152 precedes oldest valid transaction ID 3:1687012112
 179036 |     50 |        | xmin 1421442074 precedes oldest valid transaction ID 3:1687012112
 179036 |     51 |        | xmin 1421462607 precedes oldest valid transaction ID 3:1687012112
 179036 |     52 |        | xmin 1421464665 precedes oldest valid transaction ID 3:1687012112
 179036 |     53 |        | xmin 1421472360 precedes oldest valid transaction ID 3:1687012112
 179036 |     54 |        | xmin 1421479152 precedes oldest valid transaction ID 3:1687012112
 179036 |     55 |        | xmin 1424811032 precedes oldest valid transaction ID 3:1687012112
 179036 |     56 |        | xmin 1432758173 precedes oldest valid transaction ID 3:1687012112
 179036 |     57 |        | xmin 1437607659 precedes oldest valid transaction ID 3:1687012112
 179036 |     58 |        | xmin 1437618864 precedes oldest valid transaction ID 3:1687012112
 179036 |     59 |        | xmin 1437621879 precedes oldest valid transaction ID 3:1687012112
 179036 |     60 |        | xmin 1440619832 precedes oldest valid transaction ID 3:1687012112
 179036 |     61 |        | xmin 1440619912 precedes oldest valid transaction ID 3:1687012112
 179036 |     62 |        | xmin 1442052720 precedes oldest valid transaction ID 3:1687012112
 179036 |     63 |        | xmin 1442052739 precedes oldest valid transaction ID 3:1687012112
 179036 |     64 |        | xmin 1442052794 precedes oldest valid transaction ID 3:1687012112
 179036 |     65 |        | xmin 1442052935 precedes oldest valid transaction ID 3:1687012112
 179036 |     66 |        | xmin 1442052962 precedes oldest valid transaction ID 3:1687012112
 179036 |     67 |        | xmin 1442052967 precedes oldest valid transaction ID 3:1687012112
 179036 |     68 |        | xmin 1442871302 precedes oldest valid transaction ID 3:1687012112
(39 rows)

but only last tuple with (179036,68) is really broken. I can read others.

master

(2024-05-17 14:36:57) prd=# SELECT * FROM page_header(get_raw_page('account_login_history', 179036));
      lsn      │ checksum │ flags │ lower │ upper │ special │ pagesize │ version │ prune_xid
───────────────┼──────────┼───────┼───────┼───────┼─────────┼──────────┼─────────┼───────────
 A576/810F4CE0 │        0 │     4 │   296 │   296 │    8192 │     8192 │       4 │         0
(1 row)


replica
prd_aukro=# SELECT * FROM page_header(get_raw_page('account_login_history', 179036));
      lsn      | checksum | flags | lower | upper | special | pagesize | version | prune_xid
---------------+----------+-------+-------+-------+---------+----------+---------+-----------
 A56C/63979DA0 |        0 |     0 |   296 |   296 |    8192 |     8192 |       4 |         0
(1 row)

master

2024-05-17 14:38:48) prd_aukro=# SELECT * FROM page_checksum(get_raw_page('account_login_history', 179036), 179036);
 page_checksum
───────────────
         17148
(1 row)

replica

prd_aukro=# SELECT * FROM page_checksum(get_raw_page('account_login_history', 179036), 179036);
 page_checksum
---------------
        -17522
(1 row)

The server was under load - but the related tuples was not changed

master

(2024-05-17 14:41:35) prd=# SELECT * FROM heap_page_items(get_raw_page('account_login_history', 179036)) where lp = 68;
─[ RECORD 1 ]───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
lp          │ 68
lp_off      │ 296
lp_flags    │ 1
lp_len      │ 92
t_xmin      │ 1442871302
t_xmax      │ 0
t_field3    │ 0
t_ctid      │ (179036,68)
t_infomask2 │ 9
t_infomask  │ 2819
t_hoff      │ 32
t_bits      │ 1111110100000000
t_oid       │ ∅


replica

prd=# SELECT * FROM heap_page_items(get_raw_page('account_login_history', 179036)) where lp = 68;
-[ RECORD 1 ]---------------------------------------------------------------------------------------------------------------------------
lp          | 68
lp_off      | 296
lp_flags    | 1
lp_len      | 92
t_xmin      | 1442871302
t_xmax      | 0
t_field3    | 0
t_ctid      | (179036,68)
t_infomask2 | 9
t_infomask  | 2051
t_hoff      | 32
t_bits      | 1111110100000000
t_oid       |

master

(2024-05-17 14:45:30) prd=# SELECT t_ctid, raw_flags, combined_flags
         FROM heap_page_items(get_raw_page('account_login_history', 179036)),
           LATERAL heap_tuple_infomask_flags(t_infomask, t_infomask2)
         WHERE t_infomask IS NOT NULL OR t_infomask2 IS NOT NULL;
─[ RECORD 1 ]──┬────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,1)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 2 ]──┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,2)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 3 ]──┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,3)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 4 ]──┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,4)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 5 ]──┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,5)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 6 ]──┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,6)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 7 ]──┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,7)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 8 ]──┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,8)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 9 ]──┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,9)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 10 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,10)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 11 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,11)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 12 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,12)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 13 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,13)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 14 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,14)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 15 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,15)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 16 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,16)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 17 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,17)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 18 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,18)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 19 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,19)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 20 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,20)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 21 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,21)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 22 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,22)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 23 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,23)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 24 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,24)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 25 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,25)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 26 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,26)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 27 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,27)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 28 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,28)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 29 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,29)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 30 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,30)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 31 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,31)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 32 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,32)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 33 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,33)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 34 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,34)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 35 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,35)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 36 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,36)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 37 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,37)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 38 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,38)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 39 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,39)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 40 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,40)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 41 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,41)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 42 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,42)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 43 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,43)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 44 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,44)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 45 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,45)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 46 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,46)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 47 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,47)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 48 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,48)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 49 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,49)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 50 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,50)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 51 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,51)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 52 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,52)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 53 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,53)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 54 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,54)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 55 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,55)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 56 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,56)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 57 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,57)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 58 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,58)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 59 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,59)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 60 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,60)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 61 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,61)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 62 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,62)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 63 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,63)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 64 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,64)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 65 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,65)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 66 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,66)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 67 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,67)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}
─[ RECORD 68 ]─┼────────────────────────────────────────────────────────────────────────────────────────
t_ctid         │ (179036,68)
raw_flags      │ {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags │ {HEAP_XMIN_FROZEN}

replica

prd=# SELECT t_ctid, raw_flags, combined_flags
prd-#          FROM heap_page_items(get_raw_page('account_login_history', 179036)),
prd-#            LATERAL heap_tuple_infomask_flags(t_infomask, t_infomask2)
prd-#          WHERE t_infomask IS NOT NULL OR t_infomask2 IS NOT NULL;
-[ RECORD 1 ]--+----------------------------------------------------------------------------------------
t_ctid         | (179036,1)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 2 ]--+----------------------------------------------------------------------------------------
t_ctid         | (179036,2)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 3 ]--+----------------------------------------------------------------------------------------
t_ctid         | (179036,3)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 4 ]--+----------------------------------------------------------------------------------------
t_ctid         | (179036,4)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 5 ]--+----------------------------------------------------------------------------------------
t_ctid         | (179036,5)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 6 ]--+----------------------------------------------------------------------------------------
t_ctid         | (179036,6)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 7 ]--+----------------------------------------------------------------------------------------
t_ctid         | (179036,7)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 8 ]--+----------------------------------------------------------------------------------------
t_ctid         | (179036,8)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 9 ]--+----------------------------------------------------------------------------------------
t_ctid         | (179036,9)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 10 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,10)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 11 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,11)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 12 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,12)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 13 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,13)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 14 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,14)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 15 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,15)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 16 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,16)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 17 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,17)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 18 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,18)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 19 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,19)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 20 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,20)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 21 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,21)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 22 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,22)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 23 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,23)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 24 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,24)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 25 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,25)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 26 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,26)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 27 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,27)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 28 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,28)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 29 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,29)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID}
combined_flags | {HEAP_XMIN_FROZEN}
-[ RECORD 30 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,30)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 31 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,31)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 32 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,32)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 33 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,33)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 34 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,34)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 35 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,35)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 36 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,36)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 37 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,37)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 38 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,38)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 39 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,39)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 40 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,40)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 41 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,41)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 42 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,42)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 43 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,43)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 44 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,44)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 45 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,45)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 46 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,46)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 47 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,47)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 48 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,48)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 49 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,49)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 50 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,50)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 51 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,51)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 52 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,52)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 53 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,53)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 54 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,54)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 55 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,55)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 56 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,56)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 57 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,57)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 58 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,58)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 59 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,59)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 60 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,60)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 61 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,61)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 62 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,62)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 63 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,63)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 64 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,64)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 65 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,65)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 66 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,66)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 67 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,67)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMIN_COMMITTED,HEAP_XMAX_INVALID}
combined_flags | {}
-[ RECORD 68 ]-+----------------------------------------------------------------------------------------
t_ctid         | (179036,68)
raw_flags      | {HEAP_HASNULL,HEAP_HASVARWIDTH,HEAP_XMAX_INVALID}
combined_flags | {}

regards

prd=# select version();
-[ RECORD 1 ]----------------------------------------------------------------------------------------------------
version | PostgreSQL 16.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit

Pavel

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: remove Todo item: Allow infinite intervals just like infinite timestamps
Next
From: Robert Haas
Date:
Subject: Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs