Guest User

Untitled

a guest
May 23rd, 2025
46
0
302 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.65 KB | None | 0 0
  1. # /usr/lib/postgresql/16/bin/pg_waldump -n 31 -s 298B/CB420000 -p /var/lib/postgresql/16/main/pg_wal/
  2. first record is after 298B/CB420000, at 298B/CB420030, skipping over 48 bytes
  3. rmgr: Btree len (rec/tot): 72/ 72, tx: 2650000456, lsn: 298B/CB420030, prev 298B/CB41FFC0, desc: INSERT_LEAF off: 188, blkref #0: rel 1663/16399/3716314465 blk 25
  4. rmgr: Btree len (rec/tot): 74/ 74, tx: 2650000456, lsn: 298B/CB420078, prev 298B/CB420030, desc: INSERT_POST off: 12, blkref #0: rel 1663/16399/3716314466 blk 70
  5. rmgr: Transaction len (rec/tot): 465/ 465, tx: 2650000456, lsn: 298B/CB4200C8, prev 298B/CB420078, desc: INVALIDATION ; inval msgs: catcache 80 catcache 79 catcache 80 catcache 79 catcache 55 catcache 54 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 snapshot 2608 relcache 312704382 snapshot 1214
  6. rmgr: Heap len (rec/tot): 102/ 102, tx: 2650000457, lsn: 298B/CB4202A0, prev 298B/CB4200C8, desc: HOT_UPDATE old_xmax: 2650000457, old_off: 62, old_infobits: [], flags: 0x10, new_xmax: 0, new_off: 91, blkref #0: rel 1663/16399/28562528 blk 11962
  7. rmgr: Transaction len (rec/tot): 46/ 46, tx: 2650000457, lsn: 298B/CB420308, prev 298B/CB4202A0, desc: COMMIT 2025-05-23 13:58:47.363179 UTC
  8. rmgr: Standby len (rec/tot): 42/ 42, tx: 2650000458, lsn: 298B/CB420338, prev 298B/CB420308, desc: LOCK xid 2650000458 db 16399 rel 312704385
  9. rmgr: Heap2 len (rec/tot): 60/ 60, tx: 2650000458, lsn: 298B/CB420368, prev 298B/CB420338, desc: NEW_CID rel: 1663/16399/3716318521, tid: 133/56, cmin: 0, cmax: 4294967295, combo: 4294967295
  10. rmgr: Heap len (rec/tot): 211/ 211, tx: 2650000458, lsn: 298B/CB4203A8, prev 298B/CB420368, desc: INSERT off: 56, flags: 0x00, blkref #0: rel 1663/16399/3716318521 blk 133
  11. rmgr: Btree len (rec/tot): 64/ 64, tx: 2650000458, lsn: 298B/CB420480, prev 298B/CB4203A8, desc: INSERT_LEAF off: 326, blkref #0: rel 1663/16399/3716318526 blk 11
  12. rmgr: Btree len (rec/tot): 128/ 128, tx: 2650000458, lsn: 298B/CB4204C0, prev 298B/CB420480, desc: INSERT_LEAF off: 3, blkref #0: rel 1663/16399/3716318527 blk 108
  13. rmgr: Heap2 len (rec/tot): 60/ 60, tx: 2650000458, lsn: 298B/CB420540, prev 298B/CB4204C0, desc: NEW_CID rel: 1663/16399/3716314459, tid: 104/75, cmin: 0, cmax: 4294967295, combo: 4294967295
  14. rmgr: Heap2 len (rec/tot): 85/ 85, tx: 2650000458, lsn: 298B/CB420580, prev 298B/CB420540, desc: MULTI_INSERT ntuples: 1, flags: 0x02, offsets: [75], blkref #0: rel 1663/16399/3716314459 blk 104
  15.  
Advertisement
Add Comment
Please, Sign In to add comment