query1_waldump.txt
text/plain
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: 0/01679740, prev 0/016796C8, desc: RUNNING_XACTS nextXid 489 latestCompletedXid 488 oldestRunningXid 489 rmgr: Storage len (rec/tot): 42/ 42, tx: 0, lsn: 0/01679778, prev 0/01679740, desc: CREATE base/13580/16401 rmgr: Standby len (rec/tot): 42/ 42, tx: 489, lsn: 0/016797A8, prev 0/01679778, desc: LOCK xid 489 db 13580 rel 16401 rmgr: Heap2 len (rec/tot): 60/ 60, tx: 489, lsn: 0/016797D8, prev 0/016797A8, desc: NEW_CID rel 1663/13580/1259; tid 0/2; cmin: 0, cmax: 4294967295, combo: 4294967295 rmgr: Heap len (rec/tot): 54/ 1322, tx: 489, lsn: 0/01679818, prev 0/016797D8, desc: INSERT off 2 flags 0x01, blkref #0: rel 1663/13580/1259 blk 0 FPW rmgr: Btree len (rec/tot): 53/ 2253, tx: 489, lsn: 0/01679D48, prev 0/01679818, desc: INSERT_LEAF off 108, blkref #0: rel 1663/13580/2662 blk 2 FPW rmgr: Btree len (rec/tot): 53/ 3881, tx: 489, lsn: 0/0167A630, prev 0/01679D48, desc: INSERT_LEAF off 88, blkref #0: rel 1663/13580/2663 blk 2 FPW rmgr: Btree len (rec/tot): 53/ 1033, tx: 489, lsn: 0/0167B560, prev 0/0167A630, desc: INSERT_LEAF off 47, blkref #0: rel 1663/13580/3455 blk 4 FPW rmgr: Heap2 len (rec/tot): 60/ 60, tx: 489, lsn: 0/0167B970, prev 0/0167B560, desc: NEW_CID rel 1663/13580/1249; tid 16/30; cmin: 0, cmax: 4294967295, combo: 4294967295 rmgr: Heap len (rec/tot): 54/ 7498, tx: 489, lsn: 0/0167B9B0, prev 0/0167B970, desc: INSERT off 30 flags 0x01, blkref #0: rel 1663/13580/1249 blk 16 FPW rmgr: Btree len (rec/tot): 53/ 1373, tx: 489, lsn: 0/0167D718, prev 0/0167B9B0, desc: INSERT_LEAF off 40, blkref #0: rel 1663/13580/2658 blk 14 FPW rmgr: Btree len (rec/tot): 53/ 6753, tx: 489, lsn: 0/0167DC78, prev 0/0167D718, desc: INSERT_LEAF off 333, blkref #0: rel 1663/13580/2659 blk 9 FPW rmgr: Heap2 len (rec/tot): 60/ 60, tx: 489, lsn: 0/0167F6F8, prev 0/0167DC78, desc: NEW_CID rel 1663/13580/2610; tid 3/20; cmin: 0, cmax: 4294967295, combo: 4294967295 rmgr: Heap len (rec/tot): 54/ 3582, tx: 489, lsn: 0/0167F738, prev 0/0167F6F8, desc: INSERT off 20 flags 0x01, blkref #0: rel 1663/13580/2610 blk 3 FPW rmgr: Btree len (rec/tot): 53/ 3193, tx: 489, lsn: 0/01680550, prev 0/0167F738, desc: INSERT_LEAF off 155, blkref #0: rel 1663/13580/2678 blk 1 FPW rmgr: Btree len (rec/tot): 53/ 3193, tx: 489, lsn: 0/016811D0, prev 0/01680550, desc: INSERT_LEAF off 155, blkref #0: rel 1663/13580/2679 blk 1 FPW rmgr: Heap2 len (rec/tot): 60/ 60, tx: 489, lsn: 0/01681E50, prev 0/016811D0, desc: NEW_CID rel 1663/13580/2608; tid 56/64; cmin: 0, cmax: 4294967295, combo: 4294967295 rmgr: Heap len (rec/tot): 54/ 4798, tx: 489, lsn: 0/01681E90, prev 0/01681E50, desc: INSERT off 64 flags 0x01, blkref #0: rel 1663/13580/2608 blk 56 FPW rmgr: Btree len (rec/tot): 53/ 1149, tx: 489, lsn: 0/01683168, prev 0/01681E90, desc: INSERT_LEAF off 32, blkref #0: rel 1663/13580/2673 blk 32 FPW rmgr: Btree len (rec/tot): 53/ 8121, tx: 489, lsn: 0/016835E8, prev 0/01683168, desc: INSERT_LEAF off 287, blkref #0: rel 1663/13580/2674 blk 39 FPW rmgr: XLOG len (rec/tot): 49/ 289, tx: 489, lsn: 0/016855C0, prev 0/016835E8, desc: FPI , blkref #0: rel 1663/13580/16401 blk 1 FPW rmgr: XLOG len (rec/tot): 49/ 137, tx: 489, lsn: 0/016856E8, prev 0/016855C0, desc: FPI , blkref #0: rel 1663/13580/16401 blk 0 FPW rmgr: Heap len (rec/tot): 233/ 233, tx: 489, lsn: 0/01685778, prev 0/016856E8, desc: INPLACE off 9, blkref #0: rel 1663/13580/1259 blk 0 rmgr: Heap len (rec/tot): 188/ 188, tx: 489, lsn: 0/01685868, prev 0/01685778, desc: INPLACE off 2, blkref #0: rel 1663/13580/1259 blk 0 rmgr: Transaction len (rec/tot): 274/ 274, tx: 489, lsn: 0/01685928, prev 0/01685868, desc: COMMIT 2020-04-02 20:39:36.189621 IST; inval msgs: catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 7 catcache 6 catcache 32 relcache 16398 relcache 16401 relcache 16401 relcache 16398 snapshot 2608