Re: crash while decoding INSERT ON CONFLICT - Mailing list pgsql-bugs

2018-05-21 14:59 GMT-03:00 Peter Geoghegan <pg@bowt.ie>:
> On Mon, May 21, 2018 at 8:52 AM, Euler Taveira <euler@timbira.com.br> wrote:
>> If my math is correct the lsn 6211559254952 is 5A6/3DC86BA8. The transaction is:
>
> Are you sure you're not missing some earlier records for this xact? I
> see a HEAP_CONFIRM record without any preceding HEAP_INSERT. This
> doesn't make any sense, though I half-suspect that that's the actual
> problem: we have a HEAP_CONFIRM without anything to confirm. (I
> actually doubt that you omitted WAL records, but I must still ask if
> it's a simple mistake, just to be sure.)
>
Yep. I forgot to send the first part of the transaction because I
searched by lsn and then forgot to search by that transaction. Here is
the complete output:

rmgr: Heap        len (rec/tot):    335/   335, tx:  144441221, lsn:
5A6/3DC1A478, prev 5A6/3DC1A448, desc: INSERT off 22, blkref #0: rel
1663/355309/382889 blk 1786937
rmgr: Btree       len (rec/tot):     53/  7353, tx:  144441221, lsn:
5A6/3DC1A5C8, prev 5A6/3DC1A478, desc: INSERT_LEAF off 232, blkref #0:
rel 1663/355309/46488102 blk 138223 FPW
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC1C2A0, prev 5A6/3DC1A5C8, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/48166457 blk 1
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC1C2E0, prev 5A6/3DC1C2A0, desc: INSERT_LEAF off 157, blkref #0:
rel 1663/355309/48166458 blk 62259
rmgr: Btree       len (rec/tot):     53/  4513, tx:  144441221, lsn:
5A6/3DC1C320, prev 5A6/3DC1C2E0, desc: INSERT_LEAF off 15, blkref #0:
rel 1663/355309/48166459 blk 362995 FPW
rmgr: Btree       len (rec/tot):     53/  7893, tx:  144441221, lsn:
5A6/3DC1D4C8, prev 5A6/3DC1C320, desc: INSERT_LEAF off 105, blkref #0:
rel 1663/355309/48166460 blk 37962 FPW
rmgr: Btree       len (rec/tot):     53/  7913, tx:  144441221, lsn:
5A6/3DC1F3B8, prev 5A6/3DC1D4C8, desc: INSERT_LEAF off 60, blkref #0:
rel 1663/355309/48166463 blk 43766 FPW
rmgr: Btree       len (rec/tot):     53/  5413, tx:  144441221, lsn:
5A6/3DC212C0, prev 5A6/3DC1F3B8, desc: INSERT_LEAF off 68, blkref #0:
rel 1663/355309/48171844 blk 6292 FPW
rmgr: Btree       len (rec/tot):     53/  7473, tx:  144441221, lsn:
5A6/3DC22800, prev 5A6/3DC212C0, desc: INSERT_LEAF off 192, blkref #0:
rel 1663/355309/48176501 blk 53409 FPW
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC24550, prev 5A6/3DC22800, desc: INSERT_LEAF off 38, blkref #0:
rel 1663/355309/48222806 blk 134616
rmgr: Btree       len (rec/tot):     53/  7661, tx:  144441221, lsn:
5A6/3DC24590, prev 5A6/3DC24550, desc: INSERT_LEAF off 123, blkref #0:
rel 1663/355309/48255609 blk 221282 FPW
rmgr: Btree       len (rec/tot):     53/  5217, tx:  144441221, lsn:
5A6/3DC26398, prev 5A6/3DC24590, desc: INSERT_LEAF off 94, blkref #0:
rel 1663/355309/48262197 blk 44534 FPW
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC27800, prev 5A6/3DC26398, desc: INSERT_LEAF off 88, blkref #0:
rel 1663/355309/48275659 blk 134614
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC27840, prev 5A6/3DC27800, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/48286181 blk 1
rmgr: Btree       len (rec/tot):     53/  7457, tx:  144441221, lsn:
5A6/3DC27988, prev 5A6/3DC27958, desc: INSERT_LEAF off 98, blkref #0:
rel 1663/355309/48292403 blk 44553 FPW
rmgr: Btree       len (rec/tot):     53/  7457, tx:  144441221, lsn:
5A6/3DC29B90, prev 5A6/3DC29B60, desc: INSERT_LEAF off 33, blkref #0:
rel 1663/355309/48319209 blk 42505 FPW
rmgr: Btree       len (rec/tot):     53/  7457, tx:  144441221, lsn:
5A6/3DC2B8D0, prev 5A6/3DC29B90, desc: INSERT_LEAF off 99, blkref #0:
rel 1663/355309/48326655 blk 44553 FPW
rmgr: Btree       len (rec/tot):     53/  7541, tx:  144441221, lsn:
5A6/3DC2D610, prev 5A6/3DC2B8D0, desc: INSERT_LEAF off 71, blkref #0:
rel 1663/355309/48364917 blk 134855 FPW
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC2F3D8, prev 5A6/3DC2F3A0, desc: INSERT_LEAF off 128, blkref #0:
rel 1663/355309/48366893 blk 8939
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC2F418, prev 5A6/3DC2F3D8, desc: INSERT_LEAF off 105, blkref #0:
rel 1663/355309/48375917 blk 9710
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC2F458, prev 5A6/3DC2F418, desc: INSERT_LEAF off 151, blkref #0:
rel 1663/355309/48392267 blk 9009
rmgr: Btree       len (rec/tot):     53/  4653, tx:  144441221, lsn:
5A6/3DC2F498, prev 5A6/3DC2F458, desc: INSERT_LEAF off 21, blkref #0:
rel 1663/355309/48393908 blk 148070 FPW
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC306E0, prev 5A6/3DC2F498, desc: INSERT_LEAF off 3, blkref #0:
rel 1663/355309/48398929 blk 153013
rmgr: Btree       len (rec/tot):     53/  5613, tx:  144441221, lsn:
5A6/3DC30720, prev 5A6/3DC306E0, desc: INSERT_LEAF off 140, blkref #0:
rel 1663/355309/48422100 blk 141177 FPW
rmgr: Btree       len (rec/tot):     53/  7453, tx:  144441221, lsn:
5A6/3DC31D10, prev 5A6/3DC30720, desc: INSERT_LEAF off 308, blkref #0:
rel 1663/355309/48458258 blk 94582 FPW
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC33A48, prev 5A6/3DC31D10, desc: INSERT_LEAF off 7, blkref #0:
rel 1663/355309/48463333 blk 145616
rmgr: Btree       len (rec/tot):     53/  7633, tx:  144441221, lsn:
5A6/3DC33A88, prev 5A6/3DC33A48, desc: INSERT_LEAF off 180, blkref #0:
rel 1663/355309/48687881 blk 33026 FPW
rmgr: Btree       len (rec/tot):     53/  7549, tx:  144441221, lsn:
5A6/3DC3F120, prev 5A6/3DC3E100, desc: INSERT_LEAF off 93, blkref #0:
rel 1663/355309/72204267 blk 26594 FPW
rmgr: Heap        len (rec/tot):     48/    48, tx:  144441221, lsn:
5A6/3DC40EB8, prev 5A6/3DC3F120, desc: HEAP_CONFIRM off 22, blkref #0:
rel 1663/355309/382889 blk 1786937
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC40EE8, prev 5A6/3DC40EB8, desc: LOCK off 5: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/41910223
blk 230
rmgr: Heap        len (rec/tot):     59/  7971, tx:  144441221, lsn:
5A6/3DC40F20, prev 5A6/3DC40EE8, desc: LOCK off 34: xid 144441221:
flags 1 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/5094899 blk
44069 FPW
rmgr: Heap        len (rec/tot):     59/  7619, tx:  144441221, lsn:
5A6/3DC42E60, prev 5A6/3DC40F20, desc: LOCK off 19: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/5094899 blk
79637 FPW
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44C40, prev 5A6/3DC42E60, desc: LOCK off 72: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42211759
blk 1
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44C78, prev 5A6/3DC44C40, desc: LOCK off 91: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42211925
blk 5
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44CB0, prev 5A6/3DC44C78, desc: LOCK off 80: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42211925
blk 13
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44CE8, prev 5A6/3DC44CB0, desc: LOCK off 5: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42240984
blk 13
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44D20, prev 5A6/3DC44CE8, desc: LOCK off 13: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42272788
blk 0
rmgr: MultiXact   len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44D58, prev 5A6/3DC44D20, desc: CREATE_ID 8141708 offset
26509253 nmembers 2: 144439567 (keysh) 144441221 (keysh)
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44D90, prev 5A6/3DC44D58, desc: LOCK off 25: xid 8141708: flags
0 IS_MULTI LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42290062
blk 0
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44DC8, prev 5A6/3DC44D90, desc: LOCK off 20: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42290296
blk 0
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44E00, prev 5A6/3DC44DC8, desc: LOCK off 1: xid 8141708: flags
0 IS_MULTI LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42324282
blk 0
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC44E38, prev 5A6/3DC44E00, desc: LOCK off 1: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42330935
blk 0
rmgr: Heap        len (rec/tot):    125/   125, tx:  144441221, lsn:
5A6/3DC44E70, prev 5A6/3DC44E38, desc: INSERT off 16, blkref #0: rel
1663/355309/382895 blk 1432184
rmgr: Btree       len (rec/tot):     53/  5261, tx:  144441221, lsn:
5A6/3DC44EF0, prev 5A6/3DC44E70, desc: INSERT_LEAF off 136, blkref #0:
rel 1663/355309/46466754 blk 602565 FPW
rmgr: Btree       len (rec/tot):     53/  6393, tx:  144441221, lsn:
5A6/3DC46398, prev 5A6/3DC44EF0, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/48992112 blk 365102 FPW
rmgr: Btree       len (rec/tot):     53/  8033, tx:  144441221, lsn:
5A6/3DC47C98, prev 5A6/3DC46398, desc: INSERT_LEAF off 291, blkref #0:
rel 1663/355309/48992114 blk 367495 FPW
rmgr: Btree       len (rec/tot):   3558/  3558, tx:  144441221, lsn:
5A6/3DC49C18, prev 5A6/3DC47C98, desc: SPLIT_L level 0, firstright
192, blkref #0: rel 1663/355309/48992115 blk 1, blkref #1: rel
1663/355309/48992115 blk 365776, blkref #2: rel 1663/355309/48992115
blk 365773
rmgr: Btree       len (rec/tot):     61/  7393, tx:  144441221, lsn:
5A6/3DC4AA18, prev 5A6/3DC49C18, desc: INSERT_UPPER off 3, blkref #0:
rel 1663/355309/48992115 blk 3 FPW, blkref #1: rel
1663/355309/48992115 blk 1
rmgr: Heap        len (rec/tot):     48/    48, tx:  144441221, lsn:
5A6/3DC4C718, prev 5A6/3DC4AA18, desc: HEAP_CONFIRM off 16, blkref #0:
rel 1663/355309/382895 blk 1432184
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC4C748, prev 5A6/3DC4C718, desc: LOCK off 14: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42246107
blk 2
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC4C780, prev 5A6/3DC4C748, desc: LOCK off 1: xid 8141708: flags
0 IS_MULTI LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42329427
blk 0
rmgr: Heap2       len (rec/tot):     70/    70, tx:  144441221, lsn:
5A6/3DC4C7B8, prev 5A6/3DC4C780, desc: CLEAN remxid 144435657, blkref
#0: rel 1663/355309/382889 blk 1786937
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC4C800, prev 5A6/3DC4C7B8, desc: LOCK off 22: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/382889 blk
1786937
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC4C838, prev 5A6/3DC4C800, desc: LOCK off 22: xid 144441221:
flags 0 LOCK_ONLY EXCL_LOCK , blkref #0: rel 1663/355309/382889 blk
1786937
rmgr: Heap        len (rec/tot):    346/   346, tx:  144441221, lsn:
5A6/3DC4C870, prev 5A6/3DC4C838, desc: UPDATE off 22 xmax 144441221 ;
new off 23 xmax 144441221, blkref #0: rel 1663/355309/382889 blk
1786937
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4C9D0, prev 5A6/3DC4C870, desc: INSERT_LEAF off 232, blkref #0:
rel 1663/355309/46488102 blk 138223
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CA10, prev 5A6/3DC4C9D0, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/48166457 blk 1
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CA50, prev 5A6/3DC4CA10, desc: INSERT_LEAF off 157, blkref #0:
rel 1663/355309/48166458 blk 62259
rmgr: Btree       len (rec/tot):    112/   112, tx:  144441221, lsn:
5A6/3DC4CA90, prev 5A6/3DC4CA50, desc: INSERT_LEAF off 15, blkref #0:
rel 1663/355309/48166459 blk 362995
rmgr: Btree       len (rec/tot):    104/   104, tx:  144441221, lsn:
5A6/3DC4CB00, prev 5A6/3DC4CA90, desc: INSERT_LEAF off 105, blkref #0:
rel 1663/355309/48166460 blk 37962
rmgr: Btree       len (rec/tot):    112/   112, tx:  144441221, lsn:
5A6/3DC4CB68, prev 5A6/3DC4CB00, desc: INSERT_LEAF off 60, blkref #0:
rel 1663/355309/48166463 blk 43766
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CBD8, prev 5A6/3DC4CB68, desc: INSERT_LEAF off 68, blkref #0:
rel 1663/355309/48171844 blk 6292
rmgr: Btree       len (rec/tot):     80/    80, tx:  144441221, lsn:
5A6/3DC4CC18, prev 5A6/3DC4CBD8, desc: INSERT_LEAF off 192, blkref #0:
rel 1663/355309/48176501 blk 53409
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CC68, prev 5A6/3DC4CC18, desc: INSERT_LEAF off 38, blkref #0:
rel 1663/355309/48222806 blk 134616
rmgr: Btree       len (rec/tot):     80/    80, tx:  144441221, lsn:
5A6/3DC4CCA8, prev 5A6/3DC4CC68, desc: INSERT_LEAF off 123, blkref #0:
rel 1663/355309/48255609 blk 221282
rmgr: Btree       len (rec/tot):     72/    72, tx:  144441221, lsn:
5A6/3DC4CCF8, prev 5A6/3DC4CCA8, desc: INSERT_LEAF off 94, blkref #0:
rel 1663/355309/48262197 blk 44534
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CD40, prev 5A6/3DC4CCF8, desc: INSERT_LEAF off 88, blkref #0:
rel 1663/355309/48275659 blk 134614
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CD80, prev 5A6/3DC4CD40, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/48286181 blk 1
rmgr: Btree       len (rec/tot):     72/    72, tx:  144441221, lsn:
5A6/3DC4CDC0, prev 5A6/3DC4CD80, desc: INSERT_LEAF off 98, blkref #0:
rel 1663/355309/48292403 blk 44553
rmgr: Btree       len (rec/tot):     72/    72, tx:  144441221, lsn:
5A6/3DC4CE08, prev 5A6/3DC4CDC0, desc: INSERT_LEAF off 33, blkref #0:
rel 1663/355309/48319209 blk 42505
rmgr: Btree       len (rec/tot):     72/    72, tx:  144441221, lsn:
5A6/3DC4CE50, prev 5A6/3DC4CE08, desc: INSERT_LEAF off 99, blkref #0:
rel 1663/355309/48326655 blk 44553
rmgr: Btree       len (rec/tot):     72/    72, tx:  144441221, lsn:
5A6/3DC4CE98, prev 5A6/3DC4CE50, desc: INSERT_LEAF off 71, blkref #0:
rel 1663/355309/48364917 blk 134855
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CEE0, prev 5A6/3DC4CE98, desc: INSERT_LEAF off 128, blkref #0:
rel 1663/355309/48366893 blk 8939
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CF20, prev 5A6/3DC4CEE0, desc: INSERT_LEAF off 105, blkref #0:
rel 1663/355309/48375917 blk 9710
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CF60, prev 5A6/3DC4CF20, desc: INSERT_LEAF off 151, blkref #0:
rel 1663/355309/48392267 blk 9009
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CFA0, prev 5A6/3DC4CF60, desc: INSERT_LEAF off 21, blkref #0:
rel 1663/355309/48393908 blk 148070
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4CFE0, prev 5A6/3DC4CFA0, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/48398929 blk 146957
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4D020, prev 5A6/3DC4CFE0, desc: INSERT_LEAF off 140, blkref #0:
rel 1663/355309/48422100 blk 141177
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4D060, prev 5A6/3DC4D020, desc: INSERT_LEAF off 308, blkref #0:
rel 1663/355309/48458258 blk 94582
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4D0A0, prev 5A6/3DC4D060, desc: INSERT_LEAF off 7, blkref #0:
rel 1663/355309/48463333 blk 145616
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC4D0E0, prev 5A6/3DC4D0A0, desc: INSERT_LEAF off 180, blkref #0:
rel 1663/355309/48687881 blk 33026
rmgr: Btree       len (rec/tot):     72/    72, tx:  144441221, lsn:
5A6/3DC4D120, prev 5A6/3DC4D0E0, desc: INSERT_LEAF off 93, blkref #0:
rel 1663/355309/72204267 blk 26594
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC4D4D8, prev 5A6/3DC4D498, desc: LOCK off 16: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42324281
blk 0
rmgr: Heap        len (rec/tot):    112/   112, tx:  144441221, lsn:
5A6/3DC51F20, prev 5A6/3DC51EE0, desc: INSERT off 39, blkref #0: rel
1663/355309/25332667 blk 53769
rmgr: Btree       len (rec/tot):     53/  4433, tx:  144441221, lsn:
5A6/3DC51FD0, prev 5A6/3DC51F90, desc: INSERT_LEAF off 146, blkref #0:
rel 1663/355309/45934917 blk 3486 FPW
rmgr: Btree       len (rec/tot):     53/  8129, tx:  144441221, lsn:
5A6/3DC54CC8, prev 5A6/3DC54C98, desc: INSERT_LEAF off 244, blkref #0:
rel 1663/355309/46159842 blk 12634 FPW
rmgr: Btree       len (rec/tot):     53/  8213, tx:  144441221, lsn:
5A6/3DC57CB8, prev 5A6/3DC57C88, desc: INSERT_LEAF off 280, blkref #0:
rel 1663/355309/46160285 blk 3952 FPW
rmgr: Btree       len (rec/tot):     53/  5641, tx:  144441221, lsn:
5A6/3DC59CE8, prev 5A6/3DC57CB8, desc: INSERT_LEAF off 96, blkref #0:
rel 1663/355309/46160286 blk 16005 FPW
rmgr: Btree       len (rec/tot):     53/  7509, tx:  144441221, lsn:
5A6/3DC62158, prev 5A6/3DC62120, desc: INSERT_LEAF off 126, blkref #0:
rel 1663/355309/46160288 blk 4404 FPW
rmgr: Btree       len (rec/tot):     53/  7673, tx:  144441221, lsn:
5A6/3DC78A80, prev 5A6/3DC78A40, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/46160677 blk 5668 FPW
rmgr: Btree       len (rec/tot):     53/  7453, tx:  144441221, lsn:
5A6/3DC7A898, prev 5A6/3DC78A80, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/46160774 blk 3441 FPW
rmgr: Btree       len (rec/tot):     53/  4593, tx:  144441221, lsn:
5A6/3DC7C5D0, prev 5A6/3DC7A898, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/46162416 blk 11910 FPW
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC7D7C8, prev 5A6/3DC7C5D0, desc: INSERT_LEAF off 164, blkref #0:
rel 1663/355309/46164900 blk 482
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC7D908, prev 5A6/3DC7D8D8, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/46164920 blk 11916
rmgr: Btree       len (rec/tot):     53/  7633, tx:  144441221, lsn:
5A6/3DC7D948, prev 5A6/3DC7D908, desc: INSERT_LEAF off 203, blkref #0:
rel 1663/355309/46168215 blk 4008 FPW
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC7F738, prev 5A6/3DC7D948, desc: INSERT_LEAF off 13, blkref #0:
rel 1663/355309/46168862 blk 11710
rmgr: Heap        len (rec/tot):     48/    48, tx:  144441221, lsn:
5A6/3DC7F778, prev 5A6/3DC7F738, desc: HEAP_CONFIRM off 39, blkref #0:
rel 1663/355309/25332667 blk 53769
rmgr: Heap        len (rec/tot):    610/   610, tx:  144441221, lsn:
5A6/3DC807C0, prev 5A6/3DC80780, desc: INSERT off 5, blkref #0: rel
1663/355309/382872 blk 5520503
rmgr: Btree       len (rec/tot):   3795/ 11731, tx:  144441221, lsn:
5A6/3DC80B58, prev 5A6/3DC80B28, desc: SPLIT_R level 0, firstright
139, blkref #0: rel 1663/355309/54931968 blk 176078, blkref #1: rel
1663/355309/54931968 blk 223615, blkref #2: rel 1663/355309/54931968
blk 176079 FPW
rmgr: Btree       len (rec/tot):     61/  4481, tx:  144441221, lsn:
5A6/3DC83948, prev 5A6/3DC80B58, desc: INSERT_UPPER off 39, blkref #0:
rel 1663/355309/54931968 blk 176062 FPW, blkref #1: rel
1663/355309/54931968 blk 176078
rmgr: Btree       len (rec/tot):     72/    72, tx:  144441221, lsn:
5A6/3DC84AE8, prev 5A6/3DC83948, desc: INSERT_LEAF off 2, blkref #0:
rel 1663/355309/57252673 blk 218754
rmgr: Btree       len (rec/tot):     53/  7613, tx:  144441221, lsn:
5A6/3DC84B30, prev 5A6/3DC84AE8, desc: INSERT_LEAF off 129, blkref #0:
rel 1663/355309/57252674 blk 23008 FPW
rmgr: Btree       len (rec/tot):     64/    64, tx:  144441221, lsn:
5A6/3DC86908, prev 5A6/3DC84B30, desc: INSERT_LEAF off 71, blkref #0:
rel 1663/355309/57252998 blk 156099
rmgr: Btree       len (rec/tot):     72/    72, tx:  144441221, lsn:
5A6/3DC86948, prev 5A6/3DC86908, desc: INSERT_LEAF off 210, blkref #0:
rel 1663/355309/57253000 blk 219630
rmgr: Heap        len (rec/tot):     48/    48, tx:  144441221, lsn:
5A6/3DC86990, prev 5A6/3DC86948, desc: HEAP_CONFIRM off 5, blkref #0:
rel 1663/355309/382872 blk 5520503
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC869C0, prev 5A6/3DC86990, desc: LOCK off 8: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42286702
blk 0
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC869F8, prev 5A6/3DC869C0, desc: LOCK off 1: xid 144441221:
flags 0 LOCK_ONLY KEYSHR_LOCK , blkref #0: rel 1663/355309/42323652
blk 0
rmgr: Heap        len (rec/tot):     54/    54, tx:  144441221, lsn:
5A6/3DC86A30, prev 5A6/3DC869F8, desc: LOCK off 23: xid 144441221:
flags 0 LOCK_ONLY EXCL_LOCK , blkref #0: rel 1663/355309/382874 blk
4688787
rmgr: Heap        len (rec/tot):    211/   211, tx:  144441221, lsn:
5A6/3DC86A68, prev 5A6/3DC86A30, desc: HOT_UPDATE off 23 xmax
144441221 ; new off 24 xmax 144441221, blkref #0: rel
1663/355309/382874 blk 4688787
rmgr: Heap        len (rec/tot):     98/    98, tx:  144441221, lsn:
5A6/3DC86B40, prev 5A6/3DC86A68, desc: HOT_UPDATE off 32 xmax
144441221 ; new off 34 xmax 0, blkref #0: rel 1663/355309/39370447 blk
6284
rmgr: Transaction len (rec/tot):     46/    46, tx:  144441221, lsn:
5A6/3DC86BA8, prev 5A6/3DC86B40, desc: COMMIT 2018-05-21
10:26:05.830168 -03


-- 
   Euler Taveira                                   Timbira -
http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento