broken tables on hot standby after migration on PostgreSQL 16 (3x times last month)

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: broken tables on hot standby after migration on PostgreSQL 16 (3x times last month)
Date: 2024-05-17 13:12:31
Message-ID: CAFj8pRBpprGHZTwBaNQ7GRgokwB-vJT9s7aDWY6OFPDQNXSA=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2024-05-17 13:15:20 Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs
Previous Message jian he 2024-05-17 13:12:25 remove Todo item: Allow infinite intervals just like infinite timestamps