query2_waldump.txt

text/plain

Filename: query2_waldump.txt
Type: text/plain
Part: 0
Message: Re: WAL usage calculation patch
rmgr: Standby     len (rec/tot):     50/    50, tx:          0, lsn: 0/016B6288, prev 0/016B6210, desc: RUNNING_XACTS nextXid 494 latestCompletedXid 493 oldestRunningXid 494
rmgr: Storage     len (rec/tot):     42/    42, tx:          0, lsn: 0/016B62C0, prev 0/016B6288, desc: CREATE base/13580/16405
rmgr: Standby     len (rec/tot):     42/    42, tx:        494, lsn: 0/016B62F0, prev 0/016B62C0, desc: LOCK xid 494 db 13580 rel 16405 
rmgr: Heap2       len (rec/tot):     60/    60, tx:        494, lsn: 0/016B6320, prev 0/016B62F0, desc: NEW_CID rel 1663/13580/1259; tid 0/2; cmin: 0, cmax: 4294967295, combo: 4294967295
rmgr: Heap        len (rec/tot):     54/  1322, tx:        494, lsn: 0/016B6360, prev 0/016B6320, desc: INSERT off 2 flags 0x01, blkref #0: rel 1663/13580/1259 blk 0 FPW
rmgr: Btree       len (rec/tot):     53/  2253, tx:        494, lsn: 0/016B6890, prev 0/016B6360, desc: INSERT_LEAF off 108, blkref #0: rel 1663/13580/2662 blk 2 FPW
rmgr: Btree       len (rec/tot):     53/  3881, tx:        494, lsn: 0/016B7160, prev 0/016B6890, desc: INSERT_LEAF off 88, blkref #0: rel 1663/13580/2663 blk 2 FPW
rmgr: Btree       len (rec/tot):     53/  1033, tx:        494, lsn: 0/016B80A8, prev 0/016B7160, desc: INSERT_LEAF off 47, blkref #0: rel 1663/13580/3455 blk 4 FPW
rmgr: Heap2       len (rec/tot):     60/    60, tx:        494, lsn: 0/016B84B8, prev 0/016B80A8, desc: NEW_CID rel 1663/13580/1249; tid 16/30; cmin: 0, cmax: 4294967295, combo: 4294967295
rmgr: Heap        len (rec/tot):     54/  8218, tx:        494, lsn: 0/016B84F8, prev 0/016B84B8, desc: INSERT off 30 flags 0x01, blkref #0: rel 1663/13580/1249 blk 16 FPW
rmgr: Btree       len (rec/tot):     53/  1373, tx:        494, lsn: 0/016BA530, prev 0/016B84F8, desc: INSERT_LEAF off 40, blkref #0: rel 1663/13580/2658 blk 14 FPW
rmgr: Btree       len (rec/tot):     53/  6753, tx:        494, lsn: 0/016BAA90, prev 0/016BA530, desc: INSERT_LEAF off 333, blkref #0: rel 1663/13580/2659 blk 9 FPW
rmgr: Heap2       len (rec/tot):     60/    60, tx:        494, lsn: 0/016BC510, prev 0/016BAA90, desc: NEW_CID rel 1663/13580/2610; tid 3/20; cmin: 0, cmax: 4294967295, combo: 4294967295
rmgr: Heap        len (rec/tot):     54/  3582, tx:        494, lsn: 0/016BC550, prev 0/016BC510, desc: INSERT off 20 flags 0x01, blkref #0: rel 1663/13580/2610 blk 3 FPW
rmgr: Btree       len (rec/tot):     53/  3193, tx:        494, lsn: 0/016BD350, prev 0/016BC550, desc: INSERT_LEAF off 155, blkref #0: rel 1663/13580/2678 blk 1 FPW
rmgr: Btree       len (rec/tot):     53/  3193, tx:        494, lsn: 0/016BDFD0, prev 0/016BD350, desc: INSERT_LEAF off 155, blkref #0: rel 1663/13580/2679 blk 1 FPW
rmgr: Heap2       len (rec/tot):     60/    60, tx:        494, lsn: 0/016BEC68, prev 0/016BDFD0, desc: NEW_CID rel 1663/13580/2608; tid 56/64; cmin: 0, cmax: 4294967295, combo: 4294967295
rmgr: Heap        len (rec/tot):     54/  4798, tx:        494, lsn: 0/016BECA8, prev 0/016BEC68, desc: INSERT off 64 flags 0x01, blkref #0: rel 1663/13580/2608 blk 56 FPW
rmgr: Btree       len (rec/tot):     53/  1149, tx:        494, lsn: 0/016BFF68, prev 0/016BECA8, desc: INSERT_LEAF off 32, blkref #0: rel 1663/13580/2673 blk 32 FPW
rmgr: Btree       len (rec/tot):     53/  8121, tx:        494, lsn: 0/016C0400, prev 0/016BFF68, desc: INSERT_LEAF off 287, blkref #0: rel 1663/13580/2674 blk 39 FPW
rmgr: XLOG        len (rec/tot):     49/   289, tx:        494, lsn: 0/016C23D8, prev 0/016C0400, desc: FPI , blkref #0: rel 1663/13580/16405 blk 1 FPW
rmgr: XLOG        len (rec/tot):     49/   137, tx:        494, lsn: 0/016C2500, prev 0/016C23D8, desc: FPI , blkref #0: rel 1663/13580/16405 blk 0 FPW
rmgr: Heap        len (rec/tot):    233/   233, tx:        494, lsn: 0/016C2590, prev 0/016C2500, desc: INPLACE off 4, blkref #0: rel 1663/13580/1259 blk 0
rmgr: Heap        len (rec/tot):    188/   188, tx:        494, lsn: 0/016C2680, prev 0/016C2590, desc: INPLACE off 2, blkref #0: rel 1663/13580/1259 blk 0
rmgr: Transaction len (rec/tot):    274/   274, tx:        494, lsn: 0/016C2740, prev 0/016C2680, desc: COMMIT 2020-04-02 20:41:00.529118 IST; inval msgs: catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 7 catcache 6 catcache 32 relcache 16402 relcache 16405 relcache 16405 relcache 16402 snapshot 2608