[19:54:50.895] src/tools/ci/cores_backtrace.sh linux /tmp/cores [19:54:51.111] dumping /tmp/cores/postgres-6-31352.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:54:51.363] [New LWP 31352] [19:54:51.363] [19:54:51.363] This GDB supports auto-downloading debuginfo from the following URLs: [19:54:51.363] [19:54:51.363] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [19:54:51.363] Debuginfod has been disabled. [19:54:51.363] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [19:54:51.489] [Thread debugging using libthread_db enabled] [19:54:51.489] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [19:54:51.489] Core was generated by `postgres: primary: postgres regression [local] DELETE '. [19:54:51.489] Program terminated with signal SIGABRT, Aborted. [19:54:51.489] #0 0x00007f71632a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:51.684] [19:54:51.684] Thread 1 (Thread 0x7f716122af00 (LWP 31352)): [19:54:51.684] #0 0x00007f71632a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:51.684] No symbol table info available. [19:54:51.684] #1 0x00007f716325afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:51.684] No symbol table info available. [19:54:51.684] #2 0x00007f7163245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:51.684] No symbol table info available. [19:54:51.684] #3 0x00005599f73dfa3c in ExceptionalCondition (conditionName=conditionName@entry=0x5599f7608f48 "!BTScanPosIsPinned(so->currPos)", fileName=fileName@entry=0x5599f7608dc8 "../src/backend/access/nbtree/nbtsearch.c", lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [19:54:51.684] No locals. [19:54:51.684] #4 0x00005599f6afe368 in _bt_readnextpage (scan=scan@entry=0x5599fa2dc100, blkno=, expectNext=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [19:54:51.684] so = 0x5599fa384ed8 [19:54:51.684] rel = 0x7f715eac6a18 [19:54:51.684] page = [19:54:51.684] opaque = [19:54:51.684] status = [19:54:51.684] #5 0x00005599f6afec99 in _bt_steppage (scan=scan@entry=0x5599fa2dc100, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [19:54:51.684] so = 0x5599fa384ed8 [19:54:51.684] blkno = 2 [19:54:51.684] expectNext = 4 [19:54:51.684] status = [19:54:51.684] #6 0x00005599f6b020ae in _bt_first (scan=scan@entry=0x5599fa2dc100, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [19:54:51.684] rel = 0x7f715eac6a18 [19:54:51.684] so = 0x5599fa384ed8 [19:54:51.684] buf = 128 [19:54:51.684] stack = [19:54:51.684] offnum = [19:54:51.684] strat = [19:54:51.684] inskey = {heapkeyspace = true, allequalimage = true, anynullkeys = false, nextkey = false, backward = true, scantid = 0x0, keysz = 1, scankeys = {{sk_flags = 65665, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5599f6ae1b43 , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5599fa2dbef0, fn_expr = 0x5599fa358cd8}, sk_argument = 0}, {sk_flags = 2687018, sk_attno = 40, sk_strategy = 39, sk_subtype = 2424870, sk_collation = 2293796, sk_func = {fn_addr = 0x1f002000210022, fn_oid = 1900574, fn_nargs = 28, fn_strict = 27, fn_retset = false, fn_stats = 26 '\032', fn_extra = 0x13001400150016, fn_mcxt = 0xf001000110012, fn_expr = 0xb000c000d000e}, sk_argument = 1970359197302794}, {sk_flags = 327686, sk_attno = 4, sk_strategy = 3, sk_subtype = 65538, sk_collation = 21913, sk_func = {fn_addr = 0x7ffdd468f050, fn_oid = 4197779576, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x700000002, fn_mcxt = 0x5599fa3163b8, fn_expr = 0x5599fa289990}, sk_argument = 94119815897880}, {sk_flags = -97190344, sk_attno = 21913, sk_strategy = 0, sk_subtype = 4197777672, sk_collation = 21913, sk_func = {fn_addr = 0x5599fa350cc8, fn_oid = 4197780680, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 152 '\230', fn_extra = 0x1, fn_mcxt = 0x1, fn_expr = 0x5599f714d191 }, sk_argument = 94119815898568}, {sk_flags = 0, sk_attno = 21913, sk_strategy = 0, sk_subtype = 4196964752, sk_collation = 21913, sk_func = {fn_addr = 0x101000700000003, fn_oid = 4197541464, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x5599fa350cc8, fn_mcxt = 0x100000000000001, fn_expr = 0x5599fa316658}, sk_argument = 94119815901848}, {sk_flags = -97425920, sk_attno = 21913, sk_strategy = 0, sk_subtype = 4197780680, sk_collation = 21913, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 0, fn_nargs = 0, fn_strict = 240, fn_retset = 63, fn_stats = 0 '\000', fn_extra = 0x5599fa350f68, fn_mcxt = 0x101010101000000, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = -150068980, sk_attno = 21913, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5599f70e5106 , fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 0 '\000', fn_extra = 0x1, fn_mcxt = 0x5599f711fccc , fn_expr = 0x56000}, sk_argument = 2305843009213702144}, {sk_flags = 1597824320, sk_attno = 32625, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f715efd8400, fn_oid = 4144898316, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5599f70e5106 , fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = -106839336, sk_attno = 21913, sk_strategy = 0, sk_subtype = 16384, sk_collation = 0, sk_func = {fn_addr = 0x2000, fn_oid = 3563648272, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 19 '\023', fn_extra = 0x56000, fn_mcxt = 0x1, fn_expr = 0x5599fa308308}, sk_argument = 3}, {sk_flags = 1595064320, sk_attno = 32625, sk_strategy = 0, sk_subtype = 8192, sk_collation = 0, sk_func = {fn_addr = 0x67f00000000, fn_oid = 16384, fn_nargs = 2619, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5599f9a1be70, fn_mcxt = 0x56000, fn_expr = 0x1}, sk_argument = 8192}, {sk_flags = -149675060, sk_attno = 21913, sk_strategy = 0, sk_subtype = 23655640, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101, fn_oid = 4142192771, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 48 '0', fn_extra = 0x5599fa294750, fn_mcxt = 0x0, fn_expr = 0x5599f714d191 }, sk_argument = 0}, {sk_flags = -152721079, sk_attno = 21913, sk_strategy = 0, sk_subtype = 4197009232, sk_collation = 16799129, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 282578800148737}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 3563648512, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffdd468f67c, fn_mcxt = 0x270000000, fn_expr = 0x2}, sk_argument = 42}, {sk_flags = 1594722264, sk_attno = 32625, sk_strategy = 0, sk_subtype = 3754727663, sk_collation = 0, sk_func = {fn_addr = 0x7f005efdce00, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xc80000001a, fn_mcxt = 0x2000000100000000, fn_expr = 0x1a}, sk_argument = 94119763172604}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 45, sk_func = {fn_addr = 0x5599f7690be0, fn_oid = 1595088896, fn_nargs = 32625, fn_strict = false, fn_retset = false, fn_stats = 45 '-', fn_extra = 0x0, fn_mcxt = 0x2d, fn_expr = 0x5599f71234fd }, sk_argument = 45}, {sk_flags = -150144336, sk_attno = 21913, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f715f132000, fn_oid = 1588360056, fn_nargs = 32625, fn_strict = false, fn_retset = false, fn_stats = 45 '-', fn_extra = 0x1, fn_mcxt = 0x5599f718a797 , fn_expr = 0x1a0000001a}, sk_argument = 858993459200}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 32513, sk_func = {fn_addr = 0xca00c90000001a, fn_oid = 13369547, fn_nargs = 205, fn_strict = 206, fn_retset = false, fn_stats = 207 '\317', fn_extra = 0xd600d500d400d3, fn_mcxt = 0xda00d900d800d7, fn_expr = 0xde00dd00dc00db}, sk_argument = 63614311118930143}, {sk_flags = -149381689, sk_attno = 21913, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 180 '\264', fn_extra = 0x7f715f0d8880, fn_mcxt = 0x3, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 4145588119, sk_collation = 21913, sk_func = {fn_addr = 0x7ffdd468f730, fn_oid = 1594722305, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 48 '0', fn_extra = 0x7f715f0d8880, fn_mcxt = 0x5599fa308508, fn_expr = 0x5599f718a96e }, sk_argument = 1594722305}, {sk_flags = -150114838, sk_attno = 21913, sk_strategy = 0, sk_subtype = 3563648812, sk_collation = 32765, sk_func = {fn_addr = 0x7ffdd468f72c, fn_oid = 1593686912, fn_nargs = 32625, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xd468f697, fn_mcxt = 0xe63bc2ca00000002, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -144107312, sk_attno = 21913, sk_strategy = 256, sk_subtype = 1, sk_collation = 16777217, sk_func = {fn_addr = 0x40000000067f, fn_oid = 37594, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1f6afc80e, fn_mcxt = 0x3e0, fn_expr = 0x7f715eac7378}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4197483784, sk_collation = 21913, sk_func = {fn_addr = 0x7f71632b6e77, fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x6b0, fn_mcxt = 0x7f71632b6fdd, fn_expr = 0x0}, sk_argument = 94119816221168}, {sk_flags = 1027, sk_attno = 0, sk_strategy = 0, sk_subtype = 114, sk_collation = 4294967295, sk_func = {fn_addr = 0x6ae0, fn_oid = 1665080416, fn_nargs = 32625, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 140124896389656}, {sk_flags = 1663793658, sk_attno = 32625, sk_strategy = 0, sk_subtype = 27416, sk_collation = 0, sk_func = {fn_addr = 0x5599f7422b2d , fn_oid = 4197302000, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x5599f7422b2d , fn_expr = 0x5599fa2dbef0}, sk_argument = 16384}, {sk_flags = -731317520, sk_attno = 32765, sk_strategy = 0, sk_subtype = 4197302200, sk_collation = 21913, sk_func = {fn_addr = 0x0, fn_oid = 4148312255, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x10, fn_mcxt = 0x1, fn_expr = 0x5599fa384ed8}, sk_argument = 94119815659776}}} [19:54:51.684] startKeys = {0x5599fa2dc2a0, 0xd300d400d500d6, 0xcf00d000d100d2, 0xcb00cc00cd00ce, 0xc700c800c900ca, 0xc300c400c500c6, 0xbf00c000c100c2, 0xbb00bc00bd00be, 0xb700b800b900ba, 0xb300b400b500b6, 0xaf00b000b100b2, 0xab00ac00ad00ae, 0xa700a800a900aa, 0xa300a400a500a6, 0x9f00a000a100a2, 0x9b009c009d009e, 0x9700980099009a, 0x93009400950096, 0x8f009000910092, 0x8b008c008d008e, 0x8700880089008a, 0x83008400850086, 0x7f008000810082, 0x7b007c007d007e, 0x7700780079007a, 0x73007400750076, 0x6f007000710072, 0x6b006c006d006e, 0x6700680069006a, 0x63006400650066, 0x5f006000610062, 0x5b005c005d005e} [19:54:51.684] notnullkeys = {{sk_flags = -98001056, sk_attno = 21913, sk_strategy = 0, sk_subtype = 4147319245, sk_collation = 21913, sk_func = {fn_addr = 0x100000070, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x7f715eac61c8, fn_mcxt = 0x5599fa289990, fn_expr = 0x5599fa28a080}, sk_argument = 2}, {sk_flags = -147169914, sk_attno = 21913, sk_strategy = 0, sk_subtype = 1588342048, sk_collation = 0, sk_func = {fn_addr = 0x3f50624dd2f1a9fc, fn_oid = 96, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 87 'W', fn_extra = 0x0, fn_mcxt = 0x5599f73d4a8b , fn_expr = 0x5599fa289990}, sk_argument = 94119765686265}, {sk_flags = -731322576, sk_attno = 32765, sk_strategy = 256, sk_subtype = 4197539944, sk_collation = 21913, sk_func = {fn_addr = 0x5599fa289f60, fn_oid = 4197777672, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x5599f73d4a82 , fn_mcxt = 0x1700000017, fn_expr = 0x101ffffffff}, sk_argument = 3563644496}, {sk_flags = -731322768, sk_attno = 32765, sk_strategy = 0, sk_subtype = 4196964752, sk_collation = 21913, sk_func = {fn_addr = 0x60, fn_oid = 4196966528, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffdd468e670, fn_mcxt = 0x5599f7333941 , fn_expr = 0x7f715ed46548}, sk_argument = 94119766447357}, {sk_flags = -731322768, sk_attno = 32765, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 21760, fn_strict = 4, fn_retset = false, fn_stats = 144 '\220', fn_extra = 0x5599f73ec000 , fn_mcxt = 0x60, fn_expr = 0x5599fa289900}, sk_argument = 94119815323776}, {sk_flags = -98000896, sk_attno = 21913, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x5599f73ec400 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 168 '\250', fn_extra = 0x5599f7333933 , fn_mcxt = 0x1000400000065, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = -98008032, sk_attno = 21913, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 4145336721, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5599f6e5a949 , fn_mcxt = 0x5599fa28a080, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = -98000688, sk_attno = 21913, sk_strategy = 0, sk_subtype = 3563644800, sk_collation = 32765, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 144 '\220', fn_extra = 0x0, fn_mcxt = 0x5599f6e840e1 , fn_expr = 0x0}, sk_argument = 94119756193948}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4147789241, sk_collation = 21913, sk_func = {fn_addr = 0x1600000001, fn_oid = 4147787744, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 232 '\350', fn_extra = 0x7f715eab1de8, fn_mcxt = 0x7f715eab1df0, fn_expr = 0x5599f7fe3258 }, sk_argument = 1406730386}, {sk_flags = -147158638, sk_attno = 21913, sk_strategy = 0, sk_subtype = 4160622376, sk_collation = 0, sk_func = {fn_addr = 0x2, fn_oid = 4188364288, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x10000001c, fn_mcxt = 0x60, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -731321776, sk_attno = 32765, sk_strategy = 0, sk_subtype = 4148399501, sk_collation = 1406730386, sk_func = {fn_addr = 0x17, fn_oid = 4137820775, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 16 '\020', fn_extra = 0x7f715eac6298, fn_mcxt = 0x7ffdd468e8e0, fn_expr = 0x7f715eac6208}, sk_argument = 94119816135896}, {sk_flags = -146868269, sk_attno = 21913, sk_strategy = 0, sk_subtype = 1588355592, sk_collation = 32625, sk_func = {fn_addr = 0x7f715eac61c8, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 216 '\330', fn_extra = 0x1, fn_mcxt = 0x5599f73a5d86 , fn_expr = 0x1}, sk_argument = 94119815318352}, {sk_flags = 37594, sk_attno = 0, sk_strategy = 0, sk_subtype = 4147807575, sk_collation = 21913, sk_func = {fn_addr = 0x7ffdd468e8e0, fn_oid = 4147989131, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 80 'P', fn_extra = 0x5599f73387be , fn_mcxt = 0x5599fa28a080, fn_expr = 0x5599fa315fc8}, sk_argument = 2}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 4197539080, sk_collation = 21913, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 4196964752, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5599fa315a18, fn_mcxt = 0x5599f73a3db9 , fn_expr = 0x7ffdd468ea60}, sk_argument = 94119766144992}, {sk_flags = 1588342024, sk_attno = 32625, sk_strategy = 0, sk_subtype = 1588342024, sk_collation = 32625, sk_func = {fn_addr = 0x7f715eac2ce0, fn_oid = 4188460456, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x5599f73a77ef , fn_mcxt = 0x5599fa3160d0, fn_expr = 0x92da}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x1800000000, fn_oid = 37594, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x7f715eac2d20, fn_mcxt = 0x7f715eac2ce0, fn_expr = 0x2}, sk_argument = 10}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 4147797382, sk_collation = 21913, sk_func = {fn_addr = 0xa, fn_oid = 1588342120, fn_nargs = 32625, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x5599f73a8557 , fn_mcxt = 0x1, fn_expr = 0x5599f73d4a8b }, sk_argument = 140124896374048}, {sk_flags = -155454750, sk_attno = 21913, sk_strategy = 0, sk_subtype = 37594, sk_collation = 0, sk_func = {fn_addr = 0x1, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 185 '\271', fn_extra = 0x7f715eac2d08, fn_mcxt = 0x5599f73a37e0 , fn_expr = 0x7f715eac2d08}, sk_argument = 140124896374024}, {sk_flags = 1588341984, sk_attno = 32625, sk_strategy = 0, sk_subtype = 4188460456, sk_collation = 21913, sk_func = {fn_addr = 0x5599f9a6d080, fn_oid = 4147804143, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5599f6a2609c , fn_mcxt = 0x0, fn_expr = 0x5599f73a3db9 }, sk_argument = 111669149696}, {sk_flags = -146659006, sk_attno = 21913, sk_strategy = 0, sk_subtype = 4196959264, sk_collation = 21913, sk_func = {fn_addr = 0x328, fn_oid = 7, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 131 '\203', fn_extra = 0xf9a75880, fn_mcxt = 0x7, fn_expr = 0x5599f7fe0f28 }, sk_argument = 94119815899512}, {sk_flags = -731321472, sk_attno = 32765, sk_strategy = 0, sk_subtype = 101, sk_collation = 0, sk_func = {fn_addr = 0x7ffdd468eb88, fn_oid = 1592388872, fn_nargs = 32625, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x5599f7438d8d , fn_mcxt = 0x7f715ee9ed08, fn_expr = 0x7f715ee9ecc8}, sk_argument = 140124896387592}, {sk_flags = 1592388944, sk_attno = 32625, sk_strategy = 0, sk_subtype = 1592388872, sk_collation = 32625, sk_func = {fn_addr = 0x5599f73a5d86 , fn_oid = 4197542264, fn_nargs = 21913, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x7ffdd468eb70, fn_mcxt = 0x5599f73a8557 , fn_expr = 0x7f715ee9ed08}, sk_argument = 94119766667781}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4148314111, sk_collation = 21913, sk_func = {fn_addr = 0x5599fa316b88, fn_oid = 1, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x7ffdd468ecd0, fn_mcxt = 0x7ffdd468ec80, fn_expr = 0x7ffdd468ec88}, sk_argument = 0}, {sk_flags = 66, sk_attno = 0, sk_strategy = 0, sk_subtype = 97, sk_collation = 0, sk_func = {fn_addr = 0x5599f7332641 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x17, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 24 '\030', fn_extra = 0x7f715eac65d8, fn_mcxt = 0x7f715eac6208, fn_expr = 0x7f715eac61c8}, sk_argument = 523}, {sk_flags = -731320976, sk_attno = 32765, sk_strategy = 0, sk_subtype = 3563646304, sk_collation = 32765, sk_func = {fn_addr = 0xe2f73a5d86, fn_oid = 14745826, fn_nargs = 224, fn_strict = 223, fn_retset = false, fn_stats = 222 '\336', fn_extra = 0xd700d800d900da, fn_mcxt = 0xd300d400d500d6, fn_expr = 0xcf00d000d100d2}, sk_argument = 57140296459026638}, {sk_flags = 13172938, sk_attno = 200, sk_strategy = 199, sk_subtype = 12910790, sk_collation = 12779716, sk_func = {fn_addr = 0xbf00c000c100c2, fn_oid = 12386494, fn_nargs = 188, fn_strict = 187, fn_retset = false, fn_stats = 186 '\272', fn_extra = 0xb300b400b500b6, fn_mcxt = 0xaf00b000b100b2, fn_expr = 0xab00ac00ad00ae}, sk_argument = 47007042676261034}, {sk_flags = 10813606, sk_attno = 164, sk_strategy = 163, sk_subtype = 10551458, sk_collation = 10420384, sk_func = {fn_addr = 0x9b009c009d009e, fn_oid = 10027162, fn_nargs = 152, fn_strict = 151, fn_retset = false, fn_stats = 150 '\226', fn_extra = 0x8f009000910092, fn_mcxt = 0x8b008c008d008e, fn_expr = 0x8700880089008a}, sk_argument = 36873788893495430}, {sk_flags = 8454274, sk_attno = 128, sk_strategy = 127, sk_subtype = 8192126, sk_collation = 8061052, sk_func = {fn_addr = 0x7700780079007a, fn_oid = 7667830, fn_nargs = 116, fn_strict = 115, fn_retset = false, fn_stats = 114 'r', fn_extra = 0x6b006c006d006e, fn_mcxt = 0x6700680069006a, fn_expr = 0x63006400650066}, sk_argument = 26740535110729826}, {sk_flags = 6094942, sk_attno = 92, sk_strategy = 91, sk_subtype = 5832794, sk_collation = 5701720, sk_func = {fn_addr = 0x53005400550056, fn_oid = 5308498, fn_nargs = 80, fn_strict = 79, fn_retset = false, fn_stats = 78 'N', fn_extra = 0x4700480049004a, fn_mcxt = 0x43004400450046, fn_expr = 0x3f004000410042}, sk_argument = 16607281327964222}, {sk_flags = 3735610, sk_attno = 56, sk_strategy = 55, sk_subtype = 3473462, sk_collation = 3342388, sk_func = {fn_addr = 0x2f003000310032, fn_oid = 2949166, fn_nargs = 44, fn_strict = 43, fn_retset = false, fn_stats = 213 '\325', fn_extra = 0x5599f7422942 , fn_mcxt = 0x5599fa35f1c0, fn_expr = 0x40}, sk_argument = 3}, {sk_flags = -146654589, sk_attno = 21913, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 4197839296, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5, fn_mcxt = 0xe200000001, fn_expr = 0xdf00e000e100e2}, sk_argument = 61643964806922462}} [19:54:51.684] keysz = 1 [19:54:51.684] i = [19:54:51.684] status = [19:54:51.684] strat_total = 1 [19:54:51.684] currItem = [19:54:51.684] blkno = 32765 [19:54:51.684] __func__ = "_bt_first" [19:54:51.684] #7 0x00005599f6af9177 in btgettuple (scan=0x5599fa2dc100, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [19:54:51.684] so = 0x5599fa384ed8 [19:54:51.684] res = [19:54:51.684] #8 0x00005599f6adfd73 in index_getnext_tid (scan=scan@entry=0x5599fa2dc100, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [19:54:51.684] found = [19:54:51.684] __func__ = "index_getnext_tid" [19:54:51.684] #9 0x00005599f7328642 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x7f715eac7378, indexRel=indexRel@entry=0x7f715eac6a18, indexscandir=indexscandir@entry=BackwardScanDirection, scankeys=scankeys@entry=0x7ffdd468faf0, typLen=, typByVal=, tableslot=0x5599fa2dbff0, outercontext=0x5599f99f59e0, endpointDatum=0x5599fa354840) at ../src/backend/utils/adt/selfuncs.c:6349 [19:54:51.684] have_data = false [19:54:51.684] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 21913, xmax = 4147804143, xip = 0x4000, xcnt = 23, subxip = 0x0, subxcnt = 0, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0x5599f7fd7840 , active_count = 23, regd_count = 0, ph_node = {first_child = 0x0, next_sibling = 0x7f715ee9ed08, prev_or_parent = 0x7f715ee9ecc8}, whenTaken = 23, lsn = 94119815659248, snapXactCompletionCount = 140728167103824} [19:54:51.684] index_scan = 0x5599fa2dc100 [19:54:51.684] vmbuffer = 0 [19:54:51.684] last_heap_block = 4294967295 [19:54:51.684] n_visited_heap_pages = 0 [19:54:51.684] tid = [19:54:51.684] values = {68719476752, 9, 94119816267456, 94119816138320, 94119816266304, 94119766754971, 94119816267456, 94119766665538, 94119806327264, 10, 1, 94119766669955, 4197910536, 1, 94119816266304, 94119766490665, 140728167102960, 140124972584992, 4187972352, 0, 0, 94119806713040, 8482937312, 94119806709680, 140728167102960, 0, 0, 94119766146489, 94119806331816, 94119766144992, 140124900420848, 140124900420848} [19:54:51.684] isnull = {false, 2, 55, 250, false, false, false, false, true, false, false, false, 25, 31, 55, 224, 2, false, false, false, false, false, false, false, 64, 2, 55, 250, 153, 85, false, false} [19:54:51.684] oldcontext = [19:54:51.684] __func__ = "get_actual_variable_endpoint" [19:54:51.684] #10 0x00005599f7328e29 in get_actual_variable_range (root=root@entry=0x5599fa352e08, vardata=vardata@entry=0x7ffdd468fd50, sortop=97, collation=collation@entry=0, min=min@entry=0x0, max=0x5599fa354840) at ../src/backend/utils/adt/selfuncs.c:6228 [19:54:51.684] tmpcontext = 0x5599fa2dbef0 [19:54:51.684] oldcontext = 0x5599f99f59e0 [19:54:51.684] heapRel = 0x7f715eac7378 [19:54:51.684] slot = 0x5599fa2dbff0 [19:54:51.684] typLen = 4 [19:54:51.684] indexRel = 0x7f715eac6a18 [19:54:51.684] typByVal = true [19:54:51.684] scankeys = {{sk_flags = 129, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}} [19:54:51.684] index = [19:54:51.684] indexscandir = ForwardScanDirection [19:54:51.684] lc__state = [19:54:51.684] have_data = true [19:54:51.684] rel = [19:54:51.684] rte = [19:54:51.684] lc = [19:54:51.684] #11 0x00005599f7333b93 in ineq_histogram_selectivity (root=root@entry=0x5599fa352e08, vardata=vardata@entry=0x7ffdd468fd50, opoid=opoid@entry=523, opproc=opproc@entry=0x7ffdd468fcb0, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [19:54:51.684] probe = 100 [19:54:51.684] ltcmp = [19:54:51.684] histfrac = [19:54:51.684] lobound = 99 [19:54:51.684] hibound = 101 [19:54:51.684] have_end = false [19:54:51.684] hist_selec = -1 [19:54:51.684] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x5599fa354520, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [19:54:51.684] #12 0x00005599f7334204 in scalarineqsel (root=root@entry=0x5599fa352e08, operator=operator@entry=523, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=collation@entry=0, vardata=vardata@entry=0x7ffdd468fd50, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [19:54:51.684] stats = 0x7f715eac6250 [19:54:51.684] opproc = {fn_addr = 0x5599f722bb5e , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5599f99f59e0, fn_expr = 0x0} [19:54:51.684] mcv_selec = 0 [19:54:51.684] hist_selec = [19:54:51.684] sumcommon = 0 [19:54:51.684] selec = [19:54:51.684] #13 0x00005599f7334723 in scalarineqsel_wrapper (fcinfo=, isgt=isgt@entry=false, iseq=iseq@entry=true) at ../src/backend/utils/adt/selfuncs.c:1459 [19:54:51.684] root = 0x5599fa352e08 [19:54:51.684] operator = 523 [19:54:51.684] args = [19:54:51.684] varRelid = [19:54:51.684] collation = 0 [19:54:51.684] vardata = {var = 0x5599fa3532e8, rel = 0x5599f99f76a0, statsTuple = 0x7f715eac6208, freefunc = 0x5599f73d4a82 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [19:54:51.684] other = 0x5599fa3b3378 [19:54:51.684] varonleft = true [19:54:51.684] constval = 100000010 [19:54:51.684] consttype = 23 [19:54:51.684] selec = [19:54:51.684] #14 0x00005599f7334862 in scalarlesel (fcinfo=) at ../src/backend/utils/adt/selfuncs.c:1482 [19:54:51.684] No locals. [19:54:51.684] #15 0x00005599f73ed4fd in FunctionCall4Coll (flinfo=flinfo@entry=0x7ffdd468fe40, collation=collation@entry=0, arg1=arg1@entry=94119816146440, arg2=arg2@entry=523, arg3=arg3@entry=94119816148168, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [19:54:51.684] fcinfodata = {fcinfo = {flinfo = 0x7ffdd468fe40, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x7ffdd468fdf0}, fcinfo_data = "@\376h\324\375\177", '\000' , "U\004\000\b.5\372\231U\000\000\000\300>\367\231U\000\000\v\002\000\000\000\000\000\000\000.5\372\231U\000\000\31045\372\231U\000\000\00045\372\231U", '\000' , "\304>\367\231U\000"} [19:54:51.684] fcinfo = 0x7ffdd468fdd0 [19:54:51.684] result = [19:54:51.684] __func__ = "FunctionCall4Coll" [19:54:51.684] #16 0x00005599f73edca8 in OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=94119816146440, arg2=arg2@entry=523, arg3=arg3@entry=94119816148168, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [19:54:51.684] flinfo = {fn_addr = 0x5599f733484f , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5599f99f59e0, fn_expr = 0x0} [19:54:51.684] #17 0x00005599f6f4d260 in restriction_selectivity (root=root@entry=0x5599fa352e08, operatorid=operatorid@entry=523, args=0x5599fa3534c8, inputcollid=0, varRelid=varRelid@entry=0) at ../src/include/postgres.h:324 [19:54:51.684] oprrest = [19:54:51.684] result = [19:54:51.684] __func__ = "restriction_selectivity" [19:54:51.684] #18 0x00005599f6e7b5f0 in clause_selectivity_ext (root=root@entry=0x5599fa352e08, clause=0x5599fa353568, clause@entry=0x5599fa3541a0, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=use_extended_stats@entry=true) at ../src/backend/optimizer/path/clausesel.c:848 [19:54:51.684] opclause = 0x5599fa353568 [19:54:51.684] opno = 523 [19:54:51.684] s1 = 0.5 [19:54:51.684] rinfo = 0x5599fa3541a0 [19:54:51.684] cacheable = true [19:54:51.684] #19 0x00005599f6e7bf5f in clauselist_selectivity_ext (root=root@entry=0x5599fa352e08, clauses=0x5599fa354150, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=use_extended_stats@entry=true) at ../src/backend/optimizer/path/clausesel.c:183 [19:54:51.684] clause = 0x5599fa3541a0 [19:54:51.684] rinfo = [19:54:51.684] s2 = [19:54:51.684] l__state = [19:54:51.684] s1 = 1 [19:54:51.684] rel = [19:54:51.684] estimatedclauses = 0x0 [19:54:51.684] rqlist = 0x5599fa3b3328 [19:54:51.684] l = [19:54:51.684] listidx = 1 [19:54:51.684] #20 0x00005599f6e7c242 in clauselist_selectivity (root=root@entry=0x5599fa352e08, clauses=, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [19:54:51.684] No locals. [19:54:51.684] #21 0x00005599f6e8b618 in set_baserel_size_estimates (root=root@entry=0x5599fa352e08, rel=rel@entry=0x5599f99f76a0) at ../src/backend/optimizer/path/costsize.c:5286 [19:54:51.684] nrows = [19:54:51.684] #22 0x00005599f6e7011e in set_plain_rel_size (root=root@entry=0x5599fa352e08, rel=rel@entry=0x5599f99f76a0, rte=rte@entry=0x5599f99f6ba8) at ../src/backend/optimizer/path/allpaths.c:581 [19:54:51.684] No locals. [19:54:51.684] #23 0x00005599f6e7638e in set_rel_size (root=root@entry=0x5599fa352e08, rel=rel@entry=0x5599f99f76a0, rti=rti@entry=1, rte=rte@entry=0x5599f99f6ba8) at ../src/backend/optimizer/path/allpaths.c:411 [19:54:51.684] __func__ = "set_rel_size" [19:54:51.684] #24 0x00005599f6e76577 in set_base_rel_sizes (root=root@entry=0x5599fa352e08) at ../src/backend/optimizer/path/allpaths.c:322 [19:54:51.684] rel = 0x5599f99f76a0 [19:54:51.684] rte = 0x5599f99f6ba8 [19:54:51.684] rti = 1 [19:54:51.684] #25 0x00005599f6e7a57d in make_one_rel (root=root@entry=0x5599fa352e08, joinlist=joinlist@entry=0x5599fa353f50) at ../src/backend/optimizer/path/allpaths.c:183 [19:54:51.684] rel = [19:54:51.684] rti = [19:54:51.684] total_pages = [19:54:51.684] #26 0x00005599f6ede275 in query_planner (root=root@entry=0x5599fa352e08, qp_callback=qp_callback@entry=0x5599f6ee35ce , qp_extra=qp_extra@entry=0x7ffdd46901a0) at ../src/backend/optimizer/plan/planmain.c:280 [19:54:51.684] parse = 0x5599f99f6998 [19:54:51.684] joinlist = 0x5599fa353f50 [19:54:51.684] final_rel = [19:54:51.684] __func__ = "query_planner" [19:54:51.684] #27 0x00005599f6ef0b38 in grouping_planner (root=root@entry=0x5599fa352e08, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [19:54:51.684] sort_input_targets = 0x5599fa3535b8 [19:54:51.684] sort_input_target_parallel_safe = [19:54:51.684] grouping_target = [19:54:51.684] scanjoin_target = [19:54:51.684] activeWindows = 0x0 [19:54:51.684] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [19:54:51.684] sort_input_targets_contain_srfs = 0x2 [19:54:51.684] have_grouping = [19:54:51.684] wflists = 0x0 [19:54:51.684] gset_data = 0x0 [19:54:51.684] sort_input_target = [19:54:51.684] grouping_targets = 0x5599f99f6998 [19:54:51.684] grouping_target_parallel_safe = [19:54:51.684] scanjoin_targets = 0x5599fa352e08 [19:54:51.684] scanjoin_target_parallel_safe = [19:54:51.684] grouping_targets_contain_srfs = 0x5599fa353658 [19:54:51.684] scanjoin_targets_contain_srfs = 0x0 [19:54:51.684] scanjoin_target_same_exprs = [19:54:51.684] parse = 0x5599f99f6998 [19:54:51.684] offset_est = 0 [19:54:51.684] count_est = 0 [19:54:51.684] limit_tuples = -1 [19:54:51.684] have_postponed_srfs = false [19:54:51.684] final_target = [19:54:51.684] final_targets = 0x5599f99f7620 [19:54:51.684] final_targets_contain_srfs = 0x5599f6f26494 [19:54:51.684] final_target_parallel_safe = [19:54:51.684] current_rel = [19:54:51.684] final_rel = [19:54:51.684] extra = {limit_needed = 192, limit_tuples = 4.6501367750850263e-310, count_est = 94119816148568, offset_est = 94119816146440} [19:54:51.684] lc = [19:54:51.684] __func__ = "grouping_planner" [19:54:51.684] #28 0x00005599f6ef396b in subquery_planner (glob=glob@entry=0x5599f99f6888, parse=parse@entry=0x5599f99f6998, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1089 [19:54:51.684] root = 0x5599fa352e08 [19:54:51.684] newWithCheckOptions = [19:54:51.684] newHaving = [19:54:51.684] hasOuterJoins = [19:54:51.684] hasResultRTEs = false [19:54:51.684] final_rel = [19:54:51.684] l = 0x0 [19:54:51.684] #29 0x00005599f6ef45fc in standard_planner (parse=parse@entry=0x5599f99f6998, query_string=query_string@entry=0x5599f99f5ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:415 [19:54:51.684] result = [19:54:51.684] glob = 0x5599f99f6888 [19:54:51.684] tuple_fraction = 0 [19:54:51.684] root = [19:54:51.684] final_rel = [19:54:51.684] best_path = [19:54:51.684] top_plan = [19:54:51.684] lp = [19:54:51.684] lr = [19:54:51.684] #30 0x00007f7160e40551 in pgss_planner (parse=0x5599f99f6998, query_string=0x5599f99f5ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:971 [19:54:51.684] _save_exception_stack = 0x7ffdd4690800 [19:54:51.684] _save_context_stack = 0x0 [19:54:51.684] _local_sigjmp_buf = {{__jmpbuf = {94119806331288, -7179560132130337040, 0, 2048, 0, 94119806327520, -3993197576687939856, -3923718363137798416}, __mask_was_saved = 0, __saved_mask = {__val = {1, 0, 94119806331288, 11298019657422863148, 94119766756749, 0, 94119760550019, 0, 94119806331288, 0, 94119760552638, 0, 0, 94119816146280, 94119763009108, 0}}}} [19:54:51.684] _do_rethrow = false [19:54:51.684] result = 0x5599f73a77ef [19:54:51.684] #31 0x00005599f6ef565c in planner (parse=parse@entry=0x5599f99f6998, query_string=query_string@entry=0x5599f99f5ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [19:54:51.684] result = [19:54:51.684] #32 0x00005599f714efc6 in pg_plan_query (querytree=querytree@entry=0x5599f99f6998, query_string=query_string@entry=0x5599f99f5ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:912 [19:54:51.684] plan = [19:54:51.684] #33 0x00005599f714f3a7 in pg_plan_queries (querytrees=0x5599fa352db8, query_string=query_string@entry=0x5599f99f5ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1006 [19:54:51.684] query = 0x5599f99f6998 [19:54:51.684] stmt = [19:54:51.684] query_list__state = [19:54:51.684] stmt_list = 0x0 [19:54:51.684] query_list = [19:54:51.684] #34 0x00005599f714f954 in exec_simple_query (query_string=query_string@entry=0x5599f99f5ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [19:54:51.684] cmdtaglen = 6 [19:54:51.684] snapshot_set = true [19:54:51.684] per_parsetree_context = 0x0 [19:54:51.684] plantree_list = [19:54:51.684] parsetree = 0x5599f99f6808 [19:54:51.684] commandTag = CMDTAG_DELETE [19:54:51.684] qc = {commandTag = CMDTAG_CREATE_SUBSCRIPTION, nprocessed = 94119806327520} [19:54:51.684] querytree_list = [19:54:51.684] portal = [19:54:51.684] receiver = [19:54:51.684] format = 0 [19:54:51.684] cmdtagname = [19:54:51.684] parsetree_item__state = [19:54:51.684] dest = DestRemote [19:54:51.684] oldcontext = 0x5599f9a89450 [19:54:51.684] parsetree_list = 0x5599f99f6838 [19:54:51.684] parsetree_item = 0x5599f99f6850 [19:54:51.684] save_log_statement_stats = false [19:54:51.684] was_logged = true [19:54:51.684] use_implicit_block = false [19:54:51.684] msec_str = "\260\ti\324\375\177\000\000HW@\367\231U\000\000\340\ai\324\375\177\000\000W\000\000\000\000\000\000" [19:54:51.684] __func__ = "exec_simple_query" [19:54:51.684] #35 0x00005599f7152575 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [19:54:51.684] query_string = 0x5599f99f5ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [19:54:51.684] firstchar = [19:54:51.684] input_message = {data = 0x5599f99f5ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [19:54:51.684] local_sigjmp_buf = {{__jmpbuf = {94119778988568, -7179572491695649040, 4, 140728167106992, 140728167107136, 140728167107140, -3993197576838934800, -7179572276169371920}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94119806577104, 0, 168, 94119766670057, 0, 10, 2, 94119778988576, 94119806058112, 94119778982656, 140728167106992, 140728167107136, 140728167107140}}}} [19:54:51.684] send_ready_for_query = false [19:54:51.684] idle_in_transaction_timeout_enabled = false [19:54:51.684] idle_session_timeout_enabled = false [19:54:51.684] __func__ = "PostgresMain" [19:54:51.684] #36 0x00005599f7148697 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:54:51.684] bsdata = [19:54:51.684] #37 0x00005599f7000dbe in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffdd469095c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdd46909b0) at ../src/backend/postmaster/launch_backend.c:274 [19:54:51.684] pid = [19:54:51.684] #38 0x00005599f700686a in BackendStartup (client_sock=client_sock@entry=0x7ffdd46909b0) at ../src/backend/postmaster/postmaster.c:3414 [19:54:51.684] bn = 0x5599f9a22288 [19:54:51.684] pid = [19:54:51.684] startup_data = {canAcceptConnections = CAC_OK} [19:54:51.684] __func__ = "BackendStartup" [19:54:51.684] #39 0x00005599f7006dcc in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:54:51.684] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\"cq\177\000\000t\ni\324\375\177\000\000\312\020\305dq\177\000\000=\004\000\000\000\000\000\000\220\227#cq\177\000\000\240\237|dq\177\000\000x\ni\324\375\177\000\000t\ni\324\375\177\000\000\000\000\000\000\000\000\000\000\020\ni\324\375\177\000\000\303{\035\366\231U\000\000\020g\031\366\231U\000\000@\vi\324\375\177\000\0008\vi\324\375\177\000\000\225[\362\001\000\000\000", __ss_align = 94119806499584}, salen = 2}} [19:54:51.684] i = 0 [19:54:51.684] now = [19:54:51.684] last_lockfile_recheck_time = 1725047479 [19:54:51.684] last_touch_time = 1725047479 [19:54:51.684] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f7164c7b2e0}, {pos = -731313480, events = 0, fd = 0, user_data = 0x7f7164c7b668}, {pos = -165839933, events = 21913, fd = 1690809960, user_data = 0x7f716408d630}, {pos = 1690809056, events = 32625, fd = 2090263927, user_data = 0x7ffdd4690bc0}, {pos = 1690638920, events = 32625, fd = 15, user_data = 0x7f716408d630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1690809056, events = 32625, fd = -731313352, user_data = 0x7ffdd4690b40}, {pos = 1690809960, events = 32625, fd = 0, user_data = 0x5599f9a21398}, {pos = -106818952, events = 21913, fd = -106800863, user_data = 0x7f7100000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f716322e000}, {pos = 1685888928, events = 32625, fd = -106818664, user_data = 0x7ffdd4690f30}, {pos = -106800696, events = 21913, fd = -106798768, user_data = 0x5599f9a21398}, {pos = 1690809056, events = 32625, fd = 439, user_data = 0x5599f7949db8 }, {pos = 0, events = 0, fd = 1, user_data = 0x5599f99f7920}, {pos = 1690664638, events = 32625, fd = 1, user_data = 0x0}, {pos = 1663229952, events = 32625, fd = 1664036288, user_data = 0x7ffdd4690fa0}, {pos = -731312256, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1690673578, user_data = 0x0}, {pos = 1663757588, events = 32625, fd = 0, user_data = 0x5599f7fd4be0 }, {pos = 2, events = 0, fd = 7, user_data = 0x5599f99b7f20}, {pos = 1952410737, events = 28781, fd = 1663263912, user_data = 0x7f716329c880 }, {pos = 1629662648, events = 32625, fd = 8096, user_data = 0x100007f00000002}, {pos = 1663791069, events = 32625, fd = 2, user_data = 0x5599f9a2a990}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 1665080416, events = 32625, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x5599f99b7f20}, {pos = 1663793658, events = 32625, fd = 1769300525, user_data = 0x5599f99b7f20}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3339352f0a202020}, {pos = 1632135434, events = 1818313290, fd = 0, user_data = 0x0}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 1685235008, user_data = 0x7f716472aa80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x55fdb7f1f7a2a600}, {pos = 1665066464, events = 32625, fd = -328, user_data = 0x0}, {pos = -106819272, events = 21913, fd = 1024, user_data = 0x5599f9a21138}, {pos = -731312072, events = 32765, fd = 1663794831, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 22142, events = 0, fd = -328, user_data = 0x0}, {pos = -106989280, events = 21913, fd = 1664036819, user_data = 0x7ffdd4691038}, {pos = -146575690, events = 21913, fd = -134336048, user_data = 0x5599f7425973 }, {pos = -106819472, events = 21913, fd = -106997280, user_data = 0x5599f9a21070}, {pos = 1663785006, events = 32625, fd = 0, user_data = 0x5599f74375dd }, {pos = -106819472, events = 1, fd = -146573530, user_data = 0x5599f99f59e0}, {pos = -140335616, events = 1442691057, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1663707825, user_data = 0x7f71632a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -140335616, user_data = 0x5599f99cd110}, {pos = -140335616, events = 1442691057, fd = 11, user_data = 0x55fdb7f1f7a2a600}, {pos = 0, events = 0, fd = 1663414841, user_data = 0x1}, {pos = -150992197, events = 21913, fd = 4194304, user_data = 0x5599f7425807 }, {pos = -107163376, events = 21913, fd = -106997280, user_data = 0x5599f99cd110}, {pos = 1, events = 0, fd = 0, user_data = 0x5599f74375dd }, {pos = -107163376, events = 21913, fd = -146573530, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5599f6e39661 }, {pos = 0, events = 0, fd = -152835669, user_data = 0xb}, {pos = -150971048, events = 21913, fd = -137922416, user_data = 0x5599f99f6398}} [19:54:51.684] nevents = 1 [19:54:51.684] __func__ = "ServerLoop" [19:54:51.684] #40 0x00005599f7008542 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5599f99b3d80) at ../src/backend/postmaster/postmaster.c:1346 [19:54:51.684] opt = [19:54:51.684] status = [19:54:51.684] userDoption = [19:54:51.684] listen_addr_saved = false [19:54:51.684] output_config_variable = [19:54:51.684] __func__ = "PostmasterMain" [19:54:51.684] #41 0x00005599f6e49a8c in main (argc=4, argv=0x5599f99b3d80) at ../src/backend/main/main.c:197 [19:54:51.684] do_check_root = [19:54:51.706] -e [19:54:51.706] [19:54:51.706] [19:54:51.769] dumping /tmp/cores/postgres-6-25281.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:54:52.018] [New LWP 25281] [19:54:52.018] [19:54:52.018] This GDB supports auto-downloading debuginfo from the following URLs: [19:54:52.018] [19:54:52.018] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [19:54:52.018] Debuginfod has been disabled. [19:54:52.018] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [19:54:52.123] [Thread debugging using libthread_db enabled] [19:54:52.123] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [19:54:52.123] Core was generated by `postgres: old_node: postgres regression [local] DELETE '. [19:54:52.123] Program terminated with signal SIGABRT, Aborted. [19:54:52.123] #0 0x00007f754c4a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:52.276] [19:54:52.276] Thread 1 (Thread 0x7f754c1d2f00 (LWP 25281)): [19:54:52.276] #0 0x00007f754c4a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:52.276] No symbol table info available. [19:54:52.276] #1 0x00007f754c45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:52.276] No symbol table info available. [19:54:52.276] #2 0x00007f754c445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:52.276] No symbol table info available. [19:54:52.276] #3 0x000055d1bc511a3c in ExceptionalCondition (conditionName=conditionName@entry=0x55d1bc73af48 "!BTScanPosIsPinned(so->currPos)", fileName=fileName@entry=0x55d1bc73adc8 "../src/backend/access/nbtree/nbtsearch.c", lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [19:54:52.276] No locals. [19:54:52.276] #4 0x000055d1bbc30368 in _bt_readnextpage (scan=scan@entry=0x55d1bdb53680, blkno=, expectNext=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [19:54:52.276] so = 0x55d1bdc334a8 [19:54:52.276] rel = 0x7f754096c098 [19:54:52.276] page = [19:54:52.276] opaque = [19:54:52.276] status = [19:54:52.276] #5 0x000055d1bbc30c99 in _bt_steppage (scan=scan@entry=0x55d1bdb53680, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [19:54:52.276] so = 0x55d1bdc334a8 [19:54:52.276] blkno = 2 [19:54:52.276] expectNext = 4 [19:54:52.276] status = [19:54:52.276] #6 0x000055d1bbc340ae in _bt_first (scan=scan@entry=0x55d1bdb53680, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [19:54:52.276] rel = 0x7f754096c098 [19:54:52.276] so = 0x55d1bdc334a8 [19:54:52.276] buf = 4348 [19:54:52.276] stack = [19:54:52.276] offnum = [19:54:52.276] strat = [19:54:52.276] inskey = {heapkeyspace = true, allequalimage = true, anynullkeys = false, nextkey = false, backward = true, scantid = 0x0, keysz = 1, scankeys = {{sk_flags = 65665, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55d1bbc13b43 , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55d1bdb53470, fn_expr = 0x55d1bdc03c08}, sk_argument = 0}, {sk_flags = 2687018, sk_attno = 40, sk_strategy = 39, sk_subtype = 2424870, sk_collation = 2293796, sk_func = {fn_addr = 0x1f002000210022, fn_oid = 1900574, fn_nargs = 28, fn_strict = 27, fn_retset = false, fn_stats = 26 '\032', fn_extra = 0x13001400150016, fn_mcxt = 0xf001000110012, fn_expr = 0xb000c000d000e}, sk_argument = 1970359197302794}, {sk_flags = 327686, sk_attno = 4, sk_strategy = 3, sk_subtype = 65538, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 3162714426, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 16 '\020', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x55d1bdc0a860}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x1, fn_mcxt = 0x5, fn_expr = 0x1}, sk_argument = 0}, {sk_flags = 0, sk_attno = 21969, sk_strategy = 0, sk_subtype = 1024, sk_collation = 1, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 3183661736, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x1, fn_mcxt = 0x55d1bdc2ca78, fn_expr = 0x1}, sk_argument = 94359290105097}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 3183895128, sk_collation = 21969, sk_func = {fn_addr = 0x55d1bdc2c2f8, fn_oid = 3153964485, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 248 '\370', fn_extra = 0x55d1bdc680c8, fn_mcxt = 0x55d1bdc2b948, fn_expr = 0x7ffc08fdeb80}, sk_argument = 94359320183688}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 2, sk_collation = 7, sk_func = {fn_addr = 0x55d1bdc66f68, fn_oid = 3182657712, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 200 '\310', fn_extra = 0x55d1bdc2b948, fn_mcxt = 0x55d1bdc2bc18, fn_expr = 0x55d1bdc2c7d8}, sk_argument = 94359320184792}, {sk_flags = -1111305560, sk_attno = 21969, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x1, fn_oid = 3156734353, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x55d1bbfe0026 , fn_mcxt = 0x55d1bdb380b0, fn_expr = 0x55d1bc27f191 }, sk_argument = 94359320424968}, {sk_flags = -1141323447, sk_attno = 21969, sk_strategy = 0, sk_subtype = 3183658968, sk_collation = 21969, sk_func = {fn_addr = 0x100000000000001, fn_oid = 3183899144, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 104 'h', fn_extra = 0x55d1bdc2bc00, fn_mcxt = 0x7ffc08fdee40, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -1111299008, sk_attno = 21969, sk_strategy = 0, sk_subtype = 3156734353, sk_collation = 21969, sk_func = {fn_addr = 0x0, fn_oid = 3153643849, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 109 'm', fn_extra = 0x7ffc08fdee40, fn_mcxt = 0x0, fn_expr = 0x55d1bdbe3008}, sk_argument = 94359319883864}, {sk_flags = 150859424, sk_attno = 32764, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 3183660144, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 27 '\033', fn_extra = 0x55d1bdc2bc68, fn_mcxt = 0x55d1bdbe3008, fn_expr = 0x55d1bc031e6d }, sk_argument = 140720459345568}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55d1bdc2cc70, fn_oid = 3153647727, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 112 'p', fn_extra = 0x55d1bc23171c , fn_mcxt = 0x7f7547ce3000, fn_expr = 0x55d1bdbe2f50}, sk_argument = 94359319883784}, {sk_flags = 150859424, sk_attno = 32764, sk_strategy = 0, sk_subtype = 16777216, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x550101010101, fn_oid = 3159705922, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 96 '`', fn_extra = 0x40, fn_mcxt = 0x3, fn_expr = 0x55d1bc555a83 }, sk_argument = 3183357200}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 1087495608, sk_collation = 16809845, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 282578800148737}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 150859520, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 16 '\020', fn_extra = 0x55d1bc226775 , fn_mcxt = 0x7f75496f8ac0, fn_expr = 0x55d1bc227172 }, sk_argument = 94359319229832}, {sk_flags = 12536, sk_attno = 21969, sk_strategy = 0, sk_subtype = 150859776, sk_collation = 32764, sk_func = {fn_addr = 0x5500bd109840, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xc80000001a, fn_mcxt = 0x2000000100000000, fn_expr = 0x1a}, sk_argument = 94359292738812}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 13725, sk_func = {fn_addr = 0x55d1bc7c2be0, fn_oid = 1204719616, fn_nargs = 32629, fn_strict = false, fn_retset = false, fn_stats = 157 '\235', fn_extra = 0x0, fn_mcxt = 0x359d, fn_expr = 0x55d1bc2554fd }, sk_argument = 13725}, {sk_flags = -1138746704, sk_attno = 21969, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f7547ce9000, fn_oid = 1083623928, fn_nargs = 32629, fn_strict = false, fn_retset = false, fn_stats = 45 '-', fn_extra = 0x1, fn_mcxt = 0x55d1bc2bc797 , fn_expr = 0x1a0000001a}, sk_argument = 858993459200}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 32513, sk_func = {fn_addr = 0xca00c90000001a, fn_oid = 13369547, fn_nargs = 205, fn_strict = 206, fn_retset = false, fn_stats = 207 '\317', fn_extra = 0xd600d500d400d3, fn_mcxt = 0xda00d900d800d7, fn_expr = 0xde00dd00dc00db}, sk_argument = 63614311118930143}, {sk_flags = -1137984057, sk_attno = 21969, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 180 '\264', fn_extra = 0x7f7541186980, fn_mcxt = 0x3, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 3156985751, sk_collation = 21969, sk_func = {fn_addr = 0x7ffc08fdf160, fn_oid = 1092118785, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 96 '`', fn_extra = 0x7f7541186980, fn_mcxt = 0x55d1bdbb7248, fn_expr = 0x55d1bc2bc96e }, sk_argument = 1092118785}, {sk_flags = -1138717206, sk_attno = 21969, sk_strategy = 0, sk_subtype = 150860124, sk_collation = 32764, sk_func = {fn_addr = 0x7ffc08fdf15c, fn_oid = 1088690816, fn_nargs = 32629, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x8fdf0c7, fn_mcxt = 0x5559024700000002, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 8913008, sk_attno = 0, sk_strategy = 256, sk_subtype = 1, sk_collation = 16777217, sk_func = {fn_addr = 0x40030000067f, fn_oid = 37832, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1bbc2e80e, fn_mcxt = 0x3e0, fn_expr = 0x7f754096c9f8}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3183178312, sk_collation = 21969, sk_func = {fn_addr = 0x7f754c4b6e77, fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x6b0, fn_mcxt = 0x7f754c4b6fdd, fn_expr = 0x0}, sk_argument = 94359320068384}, {sk_flags = 1027, sk_attno = 0, sk_strategy = 0, sk_subtype = 114, sk_collation = 4294967295, sk_func = {fn_addr = 0x6ae0, fn_oid = 1281301600, fn_nargs = 32629, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 140141571522712}, {sk_flags = 1280014842, sk_attno = 32629, sk_strategy = 0, sk_subtype = 27416, sk_collation = 0, sk_func = {fn_addr = 0x55d1bc554b2d , fn_oid = 3182769264, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x55d1bc554b2d , fn_expr = 0x55d1bdb53470}, sk_argument = 16384}, {sk_flags = 150861088, sk_attno = 32764, sk_strategy = 0, sk_subtype = 3182769464, sk_collation = 21969, sk_func = {fn_addr = 0x0, fn_oid = 3159709887, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 112 'p', fn_extra = 0x10, fn_mcxt = 0x1, fn_expr = 0x55d1bdc334a8}, sk_argument = 94359319295616}}} [19:54:52.276] startKeys = {0x55d1bdb53820, 0xd300d400d500d6, 0xcf00d000d100d2, 0xcb00cc00cd00ce, 0xc700c800c900ca, 0xc300c400c500c6, 0xbf00c000c100c2, 0xbb00bc00bd00be, 0xb700b800b900ba, 0xb300b400b500b6, 0xaf00b000b100b2, 0xab00ac00ad00ae, 0xa700a800a900aa, 0xa300a400a500a6, 0x9f00a000a100a2, 0x9b009c009d009e, 0x9700980099009a, 0x93009400950096, 0x8f009000910092, 0x8b008c008d008e, 0x8700880089008a, 0x83008400850086, 0x7f008000810082, 0x7b007c007d007e, 0x7700780079007a, 0x73007400750076, 0x6f007000710072, 0x6b006c006d006e, 0x6700680069006a, 0x63006400650066, 0x5f006000610062, 0x5b005c005d005e} [19:54:52.276] notnullkeys = {{sk_flags = -1112308096, sk_attno = 21969, sk_strategy = 0, sk_subtype = 3182659568, sk_collation = 21969, sk_func = {fn_addr = 0x7ffc08fde0b0, fn_oid = 150855648, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffc08fde0a8, fn_mcxt = 0x55d1bdb38680, fn_expr = 0x55d1bc059051 }, sk_argument = 94359320423016}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x7ffc08fde0a8, fn_oid = 150855728, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 223 '\337', fn_extra = 0x55d1bdb387f0, fn_mcxt = 0x55d1bdb380b0, fn_expr = 0x0}, sk_argument = 94359319295088}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3182659568, sk_collation = 21969, sk_func = {fn_addr = 0x7ffc08fde0b0, fn_oid = 3182657712, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffc08fde0a8, fn_mcxt = 0x55d1bdb38680, fn_expr = 0x55d1bc05e63d }, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 168 '\250', fn_extra = 0x55d1bdb38680, fn_mcxt = 0x55d1bc4631cd , fn_expr = 0x550000000101}, sk_argument = 0}, {sk_flags = 1083619464, sk_attno = 32629, sk_strategy = 0, sk_subtype = 1083619400, sk_collation = 32629, sk_func = {fn_addr = 0x55d1bdb380b0, fn_oid = 3182659488, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x55d1bc4d7d86 , fn_mcxt = 0x409683a0, fn_expr = 0x3f50624dd2f1a9fc}, sk_argument = 96}, {sk_flags = -1135762089, sk_attno = 21969, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55d1bc506a8b , fn_oid = 3182657712, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 249 '\371', fn_extra = 0x1007ffc08fde260, fn_mcxt = 0x55d1bdc66c18, fn_expr = 0x55d1bdb38680}, sk_argument = 94359320181784}, {sk_flags = 1083619464, sk_attno = 32629, sk_strategy = 0, sk_subtype = 3159386754, sk_collation = 21969, sk_func = {fn_addr = 0x1700000017, fn_oid = 4294967295, fn_nargs = 257, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x7ffc08fde1a0, fn_mcxt = 0x55d1bdb380b0, fn_expr = 0x60}, sk_argument = 94359319185312}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 150856096, sk_collation = 32764, sk_func = {fn_addr = 0x55d1bc465941 , fn_oid = 1086109448, fn_nargs = 32629, fn_strict = false, fn_retset = false, fn_stats = 253 '\375', fn_extra = 0x7ffc08fde1a0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 1219358395203584}, {sk_flags = -1112309584, sk_attno = 21969, sk_strategy = 0, sk_subtype = 3159482368, sk_collation = 21969, sk_func = {fn_addr = 0x60, fn_oid = 3182657536, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 160 '\240', fn_extra = 0x55d1bdb38700, fn_mcxt = 0x2, fn_expr = 0x55d1bc51e400 }, sk_argument = 0}, {sk_flags = -1135477592, sk_attno = 21969, sk_strategy = 0, sk_subtype = 3158726963, sk_collation = 21969, sk_func = {fn_addr = 0x1000400000065, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55d1bdb36b40, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 94359293260177}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3153643849, sk_collation = 21969, sk_func = {fn_addr = 0x55d1bdb387a0, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55d1bdb387f0, fn_mcxt = 0x7ffc08fde2b0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -1112309584, sk_attno = 21969, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55d1bbfb60e1 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 156 '\234', fn_extra = 0x1, fn_mcxt = 0x55d1bc4d5db9 , fn_expr = 0x1600000001}, sk_argument = 94359295711200}, {sk_flags = 1083540680, sk_attno = 32629, sk_strategy = 0, sk_subtype = 1083540680, sk_collation = 32629, sk_func = {fn_addr = 0x7f75409584d0, fn_oid = 3172029016, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 146 '\222', fn_extra = 0x55d1bc4da992 , fn_mcxt = 0xbd112f28, fn_expr = 0x2}, sk_argument = 94359310624000}, {sk_flags = 1086046072, sk_attno = 32629, sk_strategy = 0, sk_subtype = 28, sk_collation = 1, sk_func = {fn_addr = 0x60, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x7ffc08fde580, fn_mcxt = 0x53d90092bc56ad8d, fn_expr = 0x17}, sk_argument = 94359285744231}, {sk_flags = 16, sk_attno = 16, sk_strategy = 0, sk_subtype = 1083619608, sk_collation = 32629, sk_func = {fn_addr = 0x7ffc08fde410, fn_oid = 1083619464, fn_nargs = 32629, fn_strict = false, fn_retset = false, fn_stats = 232 '\350', fn_extra = 0x55d1bc5217d3 , fn_mcxt = 0x7f754096b888, fn_expr = 0x7f754096b848}, sk_argument = 1}, {sk_flags = -1111310360, sk_attno = 21969, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x55d1bc4d7d86 , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 112 'p', fn_extra = 0x93c8, fn_mcxt = 0x55d1bc4da557 , fn_expr = 0x7ffc08fde410}, sk_argument = 94359295912587}, {sk_flags = -1112313232, sk_attno = 21969, sk_strategy = 0, sk_subtype = 3158747070, sk_collation = 21969, sk_func = {fn_addr = 0x55d1bdb387a0, fn_oid = 3183897464, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x1, fn_mcxt = 0x55d1bdc668b8, fn_expr = 0x3ff0000000000000}, sk_argument = 94359319183536}, {sk_flags = 1, sk_attno = 260, sk_strategy = 0, sk_subtype = 3183896008, sk_collation = 21969, sk_func = {fn_addr = 0x55d1bc4d5db9 , fn_oid = 150857104, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0x7f7540968388, fn_mcxt = 0x7f7540968388, fn_expr = 0x7f7540968360}, sk_argument = 94359310721560}, {sk_flags = -1120774272, sk_attno = 21969, sk_strategy = 0, sk_subtype = 3159201775, sk_collation = 21969, sk_func = {fn_addr = 0x55d1bdc66c80, fn_oid = 37832, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55d1bc554942 , fn_mcxt = 0x55d1bdb36b40, fn_expr = 0x6}, sk_argument = 0}, {sk_flags = -1135256957, sk_attno = 21969, sk_strategy = 0, sk_subtype = 1083605920, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 85 'U', fn_extra = 0x55d1bdb36c40, fn_mcxt = 0x55d1bdb36d50, fn_expr = 0x5}, sk_argument = 140720459346232}, {sk_flags = -1111756840, sk_attno = 21969, sk_strategy = 0, sk_subtype = 3159705922, sk_collation = 21969, sk_func = {fn_addr = 0x55d1bdb36b40, fn_oid = 64, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x55d1bc555a83 , fn_mcxt = 0xbdb36b40, fn_expr = 0x3}, sk_argument = 1}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 5, sk_collation = 0, sk_func = {fn_addr = 0x55d1bc554942 , fn_oid = 3182652224, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x3, fn_mcxt = 0x55d1bc555a83 , fn_expr = 0x2}, sk_argument = 3}, {sk_flags = -1112315072, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x5, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 5 '\005', fn_extra = 0x55d1bc554942 , fn_mcxt = 0x55d1bdc0a0f0, fn_expr = 0x40}, sk_argument = 3}, {sk_flags = -1135256957, sk_attno = 21969, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 3183517936, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5, fn_mcxt = 0x1, fn_expr = 0x7ffc08fde9d0}, sk_argument = 140720459343528}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 3159797133, sk_collation = 21969, sk_func = {fn_addr = 0x2, fn_oid = 3153590403, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55d1bdc0a990, fn_mcxt = 0x395, fn_expr = 0x55d1bbf7fd79 }, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 150860256, sk_collation = 32764, sk_func = {fn_addr = 0x55d1bc6b2edb , fn_oid = 150859776, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 159 '\237', fn_extra = 0x7ffc08fdf000, fn_mcxt = 0xc8, fn_expr = 0x4fffffffe}, sk_argument = 140720459344320}, {sk_flags = 150857376, sk_attno = 32764, sk_strategy = 0, sk_subtype = 3183518192, sk_collation = 21969, sk_func = {fn_addr = 0x200015f, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55d100000000, fn_mcxt = 0x55d1bdc03c08, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 4, sk_attno = 0, sk_strategy = 0, sk_subtype = 4294967295, sk_collation = 4294967295, sk_func = {fn_addr = 0xffffffffffffffff, fn_oid = 4294967295, fn_nargs = -1, fn_strict = 255, fn_retset = 255, fn_stats = 255 '\377', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x17}, sk_argument = 0}, {sk_flags = 1083620504, sk_attno = 32629, sk_strategy = 0, sk_subtype = 1083620440, sk_collation = 32629, sk_func = {fn_addr = 0x7f754096b888, fn_oid = 1083619400, fn_nargs = 32629, fn_strict = false, fn_retset = false, fn_stats = 11 '\v', fn_extra = 0x7ffc08fde8a0, fn_mcxt = 0x7ffc08fde890, fn_expr = 0x55d1bc4d7d86 }, sk_argument = 140720459344040}, {sk_flags = 97, sk_attno = 0, sk_strategy = 0, sk_subtype = 150857896, sk_collation = 32764, sk_func = {fn_addr = 0x55d1bc4da557 , fn_oid = 150857888, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 139 '\213', fn_extra = 0x7ffc08fde898, fn_mcxt = 0x55d1bc466a8f , fn_expr = 0x7ffc08fde7e0}, sk_argument = 4294967393}, {sk_flags = 0, sk_attno = 97, sk_strategy = 0, sk_subtype = 3153784670, sk_collation = 21969, sk_func = {fn_addr = 0x0, fn_oid = 1202590843, fn_nargs = 31457, fn_strict = 132, fn_retset = 63, fn_stats = 123 '{', fn_extra = 0x408f400000000000, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x7ffc08fde880}, sk_argument = 0}, {sk_flags = 1202590843, sk_attno = 31457, sk_strategy = 16276, sk_subtype = 0, sk_collation = 1072693248, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 3183657720, fn_nargs = 21969, fn_strict = false, fn_retset = false, fn_stats = 43 '+', fn_extra = 0x3f747ae147ae147b, fn_mcxt = 0xe2eb851eba, fn_expr = 0xdf00e000e100e2}, sk_argument = 61643964806922462}} [19:54:52.276] keysz = 1 [19:54:52.276] i = [19:54:52.276] status = [19:54:52.276] strat_total = 1 [19:54:52.276] currItem = [19:54:52.276] blkno = 21969 [19:54:52.276] __func__ = "_bt_first" [19:54:52.276] #7 0x000055d1bbc2b177 in btgettuple (scan=0x55d1bdb53680, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [19:54:52.276] so = 0x55d1bdc334a8 [19:54:52.276] res = [19:54:52.276] #8 0x000055d1bbc11d73 in index_getnext_tid (scan=scan@entry=0x55d1bdb53680, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [19:54:52.276] found = [19:54:52.276] __func__ = "index_getnext_tid" [19:54:52.276] #9 0x000055d1bc45a642 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x7f754096c9f8, indexRel=indexRel@entry=0x7f754096c098, indexscandir=indexscandir@entry=BackwardScanDirection, scankeys=scankeys@entry=0x7ffc08fdf520, typLen=, typByVal=, tableslot=0x55d1bdb53570, outercontext=0x55d1bd2ac9c0, endpointDatum=0x55d1bdbe2160) at ../src/backend/utils/adt/selfuncs.c:6349 [19:54:52.276] have_data = false [19:54:52.276] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 21969, xmax = 3159201775, xip = 0x4003, xcnt = 23, subxip = 0x0, subxcnt = 0, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0x55d1bd109840 , active_count = 23, regd_count = 0, ph_node = {first_child = 0x0, next_sibling = 0x7f7540d23d08, prev_or_parent = 0x7f7540d23cc8}, whenTaken = 23, lsn = 94359319295088, snapXactCompletionCount = 140720459347840} [19:54:52.276] index_scan = 0x55d1bdb53680 [19:54:52.276] vmbuffer = 0 [19:54:52.276] last_heap_block = 4294967295 [19:54:52.276] n_visited_heap_pages = 0 [19:54:52.276] tid = [19:54:52.276] values = {68719476752, 140720459347552, 94359319178304, 0, 94359319178048, 94359289096264, 94359319890056, 140720459347520, 94359319295872, 140141574676397, 140720459346872, 140720459347552, 94359319177984, 140141574669874, 140141574638791, 94359296056873, 140720459346976, 140141768675360, 150861412, 0, 2, 94359310615456, 7478331376, 94359310612128, 140720459346976, 0, 0, 94359295712697, 94359310228360, 94359295711200, 140141575421168, 140141575421168} [19:54:52.276] isnull = {false, false, false, false, false, false, false, false, 84, 102, 232, 187, 25, 31, 55, 224, false, false, false, false, false, false, false, false, false, 61, 181, 189, 209, 85, false, false} [19:54:52.276] oldcontext = [19:54:52.276] __func__ = "get_actual_variable_endpoint" [19:54:52.276] #10 0x000055d1bc45ae29 in get_actual_variable_range (root=root@entry=0x55d1bdbe07d8, vardata=vardata@entry=0x7ffc08fdf780, sortop=97, collation=collation@entry=0, min=min@entry=0x0, max=0x55d1bdbe2160) at ../src/backend/utils/adt/selfuncs.c:6228 [19:54:52.276] tmpcontext = 0x55d1bdb53470 [19:54:52.276] oldcontext = 0x55d1bd2ac9c0 [19:54:52.276] heapRel = 0x7f754096c9f8 [19:54:52.276] slot = 0x55d1bdb53570 [19:54:52.276] typLen = 4 [19:54:52.276] indexRel = 0x7f754096c098 [19:54:52.276] typByVal = true [19:54:52.276] scankeys = {{sk_flags = 129, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}} [19:54:52.276] index = [19:54:52.276] indexscandir = ForwardScanDirection [19:54:52.276] lc__state = [19:54:52.276] have_data = true [19:54:52.276] rel = [19:54:52.276] rte = [19:54:52.276] lc = [19:54:52.276] #11 0x000055d1bc465b93 in ineq_histogram_selectivity (root=root@entry=0x55d1bdbe07d8, vardata=vardata@entry=0x7ffc08fdf780, opoid=opoid@entry=523, opproc=opproc@entry=0x7ffc08fdf6e0, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [19:54:52.276] probe = 100 [19:54:52.276] ltcmp = [19:54:52.276] histfrac = [19:54:52.276] lobound = 99 [19:54:52.276] hibound = 101 [19:54:52.276] have_end = false [19:54:52.276] hist_selec = -1 [19:54:52.276] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x55d1bdbe1e40, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [19:54:52.276] #12 0x000055d1bc466204 in scalarineqsel (root=root@entry=0x55d1bdbe07d8, operator=operator@entry=523, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=collation@entry=0, vardata=vardata@entry=0x7ffc08fdf780, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [19:54:52.276] stats = 0x7f754096b8d0 [19:54:52.276] opproc = {fn_addr = 0x55d1bc35db5e , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55d1bd2ac9c0, fn_expr = 0x0} [19:54:52.276] mcv_selec = 0 [19:54:52.276] hist_selec = [19:54:52.276] sumcommon = 0 [19:54:52.276] selec = [19:54:52.276] #13 0x000055d1bc466723 in scalarineqsel_wrapper (fcinfo=, isgt=isgt@entry=false, iseq=iseq@entry=true) at ../src/backend/utils/adt/selfuncs.c:1459 [19:54:52.276] root = 0x55d1bdbe07d8 [19:54:52.276] operator = 523 [19:54:52.276] args = [19:54:52.276] varRelid = [19:54:52.276] collation = 0 [19:54:52.276] vardata = {var = 0x55d1bdbe0c68, rel = 0x55d1bd2ae6d0, statsTuple = 0x7f754096b888, freefunc = 0x55d1bc506a82 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [19:54:52.276] other = 0x55d1bdbe22a0 [19:54:52.276] varonleft = true [19:54:52.276] constval = 100000010 [19:54:52.276] consttype = 23 [19:54:52.276] selec = [19:54:52.276] #14 0x000055d1bc466862 in scalarlesel (fcinfo=) at ../src/backend/utils/adt/selfuncs.c:1482 [19:54:52.276] No locals. [19:54:52.276] #15 0x000055d1bc51f4fd in FunctionCall4Coll (flinfo=flinfo@entry=0x7ffc08fdf870, collation=collation@entry=0, arg1=arg1@entry=94359319873496, arg2=arg2@entry=523, arg3=arg3@entry=94359319875144, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [19:54:52.276] fcinfodata = {fcinfo = {flinfo = 0x7ffc08fdf870, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x7ffc08fdf820}, fcinfo_data = "p\370\375\b\374\177", '\000' , "U\004\000\330\a\276\275\321U\000\000\000\340Q\274\321U\000\000\v\002\000\000\000\000\000\000\000\a\276\275\321U\000\000H\016\276\275\321U\000\000\000\016\276\275\321U", '\000' , "\344Q\274\321U\000"} [19:54:52.276] fcinfo = 0x7ffc08fdf800 [19:54:52.276] result = [19:54:52.276] __func__ = "FunctionCall4Coll" [19:54:52.276] #16 0x000055d1bc51fca8 in OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=94359319873496, arg2=arg2@entry=523, arg3=arg3@entry=94359319875144, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [19:54:52.276] flinfo = {fn_addr = 0x55d1bc46684f , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55d1bd2ac9c0, fn_expr = 0x0} [19:54:52.276] #17 0x000055d1bc07f260 in restriction_selectivity (root=root@entry=0x55d1bdbe07d8, operatorid=operatorid@entry=523, args=0x55d1bdbe0e48, inputcollid=0, varRelid=varRelid@entry=0) at ../src/include/postgres.h:324 [19:54:52.276] oprrest = [19:54:52.276] result = [19:54:52.276] __func__ = "restriction_selectivity" [19:54:52.276] #18 0x000055d1bbfad5f0 in clause_selectivity_ext (root=root@entry=0x55d1bdbe07d8, clause=0x55d1bdbe0ee8, clause@entry=0x55d1bdbe1ac0, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=use_extended_stats@entry=true) at ../src/backend/optimizer/path/clausesel.c:848 [19:54:52.276] opclause = 0x55d1bdbe0ee8 [19:54:52.276] opno = 523 [19:54:52.276] s1 = 0.5 [19:54:52.276] rinfo = 0x55d1bdbe1ac0 [19:54:52.276] cacheable = true [19:54:52.276] #19 0x000055d1bbfadf5f in clauselist_selectivity_ext (root=root@entry=0x55d1bdbe07d8, clauses=0x55d1bdbe1a70, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=use_extended_stats@entry=true) at ../src/backend/optimizer/path/clausesel.c:183 [19:54:52.276] clause = 0x55d1bdbe1ac0 [19:54:52.276] rinfo = [19:54:52.276] s2 = [19:54:52.276] l__state = [19:54:52.276] s1 = 1 [19:54:52.276] rel = [19:54:52.276] estimatedclauses = 0x0 [19:54:52.276] rqlist = 0x55d1bdbe2250 [19:54:52.276] l = [19:54:52.276] listidx = 1 [19:54:52.276] #20 0x000055d1bbfae242 in clauselist_selectivity (root=root@entry=0x55d1bdbe07d8, clauses=, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [19:54:52.276] No locals. [19:54:52.276] #21 0x000055d1bbfbd618 in set_baserel_size_estimates (root=root@entry=0x55d1bdbe07d8, rel=rel@entry=0x55d1bd2ae6d0) at ../src/backend/optimizer/path/costsize.c:5286 [19:54:52.276] nrows = [19:54:52.276] #22 0x000055d1bbfa211e in set_plain_rel_size (root=root@entry=0x55d1bdbe07d8, rel=rel@entry=0x55d1bd2ae6d0, rte=rte@entry=0x55d1bd2adb88) at ../src/backend/optimizer/path/allpaths.c:581 [19:54:52.276] No locals. [19:54:52.276] #23 0x000055d1bbfa838e in set_rel_size (root=root@entry=0x55d1bdbe07d8, rel=rel@entry=0x55d1bd2ae6d0, rti=rti@entry=1, rte=rte@entry=0x55d1bd2adb88) at ../src/backend/optimizer/path/allpaths.c:411 [19:54:52.276] __func__ = "set_rel_size" [19:54:52.276] #24 0x000055d1bbfa8577 in set_base_rel_sizes (root=root@entry=0x55d1bdbe07d8) at ../src/backend/optimizer/path/allpaths.c:322 [19:54:52.276] rel = 0x55d1bd2ae6d0 [19:54:52.276] rte = 0x55d1bd2adb88 [19:54:52.276] rti = 1 [19:54:52.276] #25 0x000055d1bbfac57d in make_one_rel (root=root@entry=0x55d1bdbe07d8, joinlist=joinlist@entry=0x55d1bdbe1870) at ../src/backend/optimizer/path/allpaths.c:183 [19:54:52.276] rel = [19:54:52.276] rti = [19:54:52.276] total_pages = [19:54:52.276] #26 0x000055d1bc010275 in query_planner (root=root@entry=0x55d1bdbe07d8, qp_callback=qp_callback@entry=0x55d1bc0155ce , qp_extra=qp_extra@entry=0x7ffc08fdfbd0) at ../src/backend/optimizer/plan/planmain.c:280 [19:54:52.276] parse = 0x55d1bd2ad978 [19:54:52.276] joinlist = 0x55d1bdbe1870 [19:54:52.276] final_rel = [19:54:52.276] __func__ = "query_planner" [19:54:52.276] #27 0x000055d1bc022b38 in grouping_planner (root=root@entry=0x55d1bdbe07d8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [19:54:52.276] sort_input_targets = 0x55d1bdbe0f68 [19:54:52.276] sort_input_target_parallel_safe = [19:54:52.276] grouping_target = [19:54:52.276] scanjoin_target = [19:54:52.276] activeWindows = 0x0 [19:54:52.276] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [19:54:52.276] sort_input_targets_contain_srfs = 0x2 [19:54:52.276] have_grouping = [19:54:52.276] wflists = 0x0 [19:54:52.276] gset_data = 0x0 [19:54:52.276] sort_input_target = [19:54:52.276] grouping_targets = 0x55d1bd2ad978 [19:54:52.276] grouping_target_parallel_safe = [19:54:52.276] scanjoin_targets = 0x55d1bdbe07d8 [19:54:52.276] scanjoin_target_parallel_safe = [19:54:52.276] grouping_targets_contain_srfs = 0x55d1bdbe1008 [19:54:52.276] scanjoin_targets_contain_srfs = 0x0 [19:54:52.276] scanjoin_target_same_exprs = [19:54:52.276] parse = 0x55d1bd2ad978 [19:54:52.276] offset_est = 0 [19:54:52.276] count_est = 0 [19:54:52.276] limit_tuples = -1 [19:54:52.276] have_postponed_srfs = false [19:54:52.276] final_target = [19:54:52.276] final_targets = 0x55d1bd2ae600 [19:54:52.276] final_targets_contain_srfs = 0x55d1bc058494 [19:54:52.276] final_target_parallel_safe = [19:54:52.276] current_rel = [19:54:52.276] final_rel = [19:54:52.276] extra = {limit_needed = 56, limit_tuples = 4.6619698314439571e-310, count_est = 94359319875592, offset_est = 94359319873496} [19:54:52.276] lc = [19:54:52.276] __func__ = "grouping_planner" [19:54:52.276] #28 0x000055d1bc02596b in subquery_planner (glob=glob@entry=0x55d1bd2ad868, parse=parse@entry=0x55d1bd2ad978, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1089 [19:54:52.276] root = 0x55d1bdbe07d8 [19:54:52.276] newWithCheckOptions = [19:54:52.276] newHaving = [19:54:52.276] hasOuterJoins = [19:54:52.276] hasResultRTEs = false [19:54:52.276] final_rel = [19:54:52.276] l = 0x0 [19:54:52.276] #29 0x000055d1bc0265fc in standard_planner (parse=0x55d1bd2ad978, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:415 [19:54:52.276] result = [19:54:52.276] glob = 0x55d1bd2ad868 [19:54:52.276] tuple_fraction = 0 [19:54:52.276] root = [19:54:52.276] final_rel = [19:54:52.276] best_path = [19:54:52.276] top_plan = [19:54:52.276] lp = [19:54:52.276] lr = [19:54:52.276] #30 0x000055d1bc027666 in planner (parse=parse@entry=0x55d1bd2ad978, query_string=query_string@entry=0x55d1bd2acac0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:282 [19:54:52.276] result = [19:54:52.276] #31 0x000055d1bc280fc6 in pg_plan_query (querytree=querytree@entry=0x55d1bd2ad978, query_string=query_string@entry=0x55d1bd2acac0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:912 [19:54:52.276] plan = [19:54:52.276] #32 0x000055d1bc2813a7 in pg_plan_queries (querytrees=0x55d1bd2ae680, query_string=query_string@entry=0x55d1bd2acac0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1006 [19:54:52.276] query = 0x55d1bd2ad978 [19:54:52.276] stmt = [19:54:52.276] query_list__state = [19:54:52.276] stmt_list = 0x0 [19:54:52.276] query_list = [19:54:52.276] #33 0x000055d1bc281954 in exec_simple_query (query_string=query_string@entry=0x55d1bd2acac0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [19:54:52.276] cmdtaglen = 6 [19:54:52.276] snapshot_set = true [19:54:52.276] per_parsetree_context = 0x0 [19:54:52.276] plantree_list = [19:54:52.276] parsetree = 0x55d1bd2ad7e8 [19:54:52.276] commandTag = CMDTAG_DELETE [19:54:52.276] qc = {commandTag = CMDTAG_CREATE_SUBSCRIPTION, nprocessed = 94359310224064} [19:54:52.276] querytree_list = [19:54:52.276] portal = [19:54:52.276] receiver = [19:54:52.276] format = 0 [19:54:52.276] cmdtagname = [19:54:52.276] parsetree_item__state = [19:54:52.276] dest = DestRemote [19:54:52.276] oldcontext = 0x55d1bd3406f0 [19:54:52.276] parsetree_list = 0x55d1bd2ad818 [19:54:52.276] parsetree_item = 0x55d1bd2ad830 [19:54:52.276] save_log_statement_stats = false [19:54:52.276] was_logged = true [19:54:52.276] use_implicit_block = false [19:54:52.276] msec_str = "\240\000\376\b\374\177\000\000HwS\274\321U\000\000\320\376\375\b\374\177\000\000W\000\000\000\000\000\000" [19:54:52.276] __func__ = "exec_simple_query" [19:54:52.276] #34 0x000055d1bc284575 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [19:54:52.276] query_string = 0x55d1bd2acac0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [19:54:52.276] firstchar = [19:54:52.276] input_message = {data = 0x55d1bd2acac0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [19:54:52.276] local_sigjmp_buf = {{__jmpbuf = {94359308554776, -1909147866526104315, 4, 140720459350176, 140720459350320, 140720459350324, -5631131243004017403, -1909145451429739259}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94359309954624, 14336, 94359308548864, 94359310481536, 140720459350320, 94359296235711, 0, 9, 2, 94359308554784, 94359309954624, 94359308548864, 140720459350176, 140720459350320, 140720459350324}}}} [19:54:52.276] send_ready_for_query = false [19:54:52.276] idle_in_transaction_timeout_enabled = false [19:54:52.276] idle_session_timeout_enabled = false [19:54:52.276] __func__ = "PostgresMain" [19:54:52.276] #35 0x000055d1bc27a697 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:54:52.276] bsdata = [19:54:52.276] #36 0x000055d1bc132dbe in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc08fe004c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc08fe00a0) at ../src/backend/postmaster/launch_backend.c:274 [19:54:52.276] pid = [19:54:52.276] #37 0x000055d1bc13886a in BackendStartup (client_sock=client_sock@entry=0x7ffc08fe00a0) at ../src/backend/postmaster/postmaster.c:3414 [19:54:52.276] bn = 0x55d1bd2e1888 [19:54:52.276] pid = [19:54:52.276] startup_data = {canAcceptConnections = CAC_OK} [19:54:52.276] __func__ = "BackendStartup" [19:54:52.276] #38 0x000055d1bc138dcc in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:54:52.276] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\376\b\374\177\000\0004\001\376\b\374\177", '\000' , "Û0\273\321U\000\000\020\207,\273\321U\000\000\000\002\376\b\374\177\000\000\370\001\376\b\374\177\000\000\225[\362\001\000\000\000\000\240T(Mu\177\000\000+", '\000' , "ؚ0\273\321U\000\000hv\312Mu\177\000\0000V(Mu\177\000", __ss_align = 140141793014496}, salen = 2}} [19:54:52.276] i = 0 [19:54:52.276] now = [19:54:52.276] last_lockfile_recheck_time = 1725047446 [19:54:52.276] last_touch_time = 1725047446 [19:54:52.276] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1154442301, events = 21969, fd = 1305114216, user_data = 0x7f754d285630}, {pos = 1305113312, events = 32629, fd = 2090263927, user_data = 0x7ffc08fe0280}, {pos = 1304943176, events = 32629, fd = 15, user_data = 0x7f754d285630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1305113312, events = 32629, fd = 150864376, user_data = 0x7ffc08fe0200}, {pos = 1305114216, events = 32629, fd = 0, user_data = 0x55d1bd2acad8}, {pos = 1280014842, events = 32629, fd = -1121269032, user_data = 0x55d100000001}, {pos = 32768, events = 0, fd = -1, user_data = 0x7f754c42e000}, {pos = 1301503904, events = 32629, fd = -1121078280, user_data = 0x55d1bd2db2d8}, {pos = -1121079119, events = 21969, fd = 1304968894, user_data = 0x1}, {pos = 1305113312, events = 32629, fd = 439, user_data = 0x55d1bca7bdb8 }, {pos = 0, events = 0, fd = 1, user_data = 0x55d1bd2acad8}, {pos = 1304968894, events = 32629, fd = 1, user_data = 0x0}, {pos = 1279451136, events = 32629, fd = 1280257472, user_data = 0x10}, {pos = 150865520, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1304977834, user_data = 0x0}, {pos = 1279978772, events = 32629, fd = 0, user_data = 0x55d1bd106be0 }, {pos = 2, events = 0, fd = 7, user_data = 0x55d1bd26eee0}, {pos = -1138669400, events = 21969, fd = -1121060800, user_data = 0x55d1bc21582c }, {pos = -1121060709, events = 21969, fd = 8096, user_data = 0x7367702f65736162}, {pos = 1952410737, events = 28781, fd = 1, user_data = 0x0}, {pos = 1279485096, events = 32629, fd = 1279903872, user_data = 0x41e}, {pos = 1280011895, events = 32629, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 1281301600, events = 32629, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = -1135261374, events = 21969, fd = -1121105200, user_data = 0x7f754c4b56db}, {pos = 1281284576, events = 32629, fd = 1279922542, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xa2e1961f97cdfc00}, {pos = 1281287648, events = 32629, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1121078888, user_data = 0x55d1bc555205 }, {pos = -1121079088, events = 21969, fd = 3, user_data = 0x0}, {pos = 16020, events = 0, fd = -328, user_data = 0x0}, {pos = -1121269032, events = 21969, fd = 1280258003, user_data = 0x7ffc08fe0728}, {pos = -1135178058, events = 21969, fd = -1122938416, user_data = 0x55d1bc557973 }, {pos = -1121079088, events = 21969, fd = -1121269312, user_data = 0x55d1bd2db0d0}, {pos = 1280005851, events = 32629, fd = 0, user_data = 0x55d1bc5695dd }, {pos = -1121079088, events = 1, fd = -1135175898, user_data = 0x55d1bd2ac9c0}, {pos = -1748108288, events = 2732693023, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1279929009, user_data = 0x7f754c4a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1748108288, user_data = 0x55d1bd2840f0}, {pos = -1748108288, events = 2732693023, fd = 11, user_data = 0xa2e1961f97cdfc00}, {pos = 0, events = 0, fd = 1279636025, user_data = 0x1}, {pos = -1139594565, events = 21969, fd = 4194304, user_data = 0x55d1bc557807 }, {pos = -1121435408, events = 21969, fd = -1121269312, user_data = 0x55d1bd2840f0}, {pos = 1, events = 0, fd = 0, user_data = 0x55d1bc5695dd }, {pos = -1121435408, events = 21969, fd = -1135175898, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55d1bbf6b661 }, {pos = 0, events = 0, fd = -1141438037, user_data = 0xb}, {pos = -1139573416, events = 21969, fd = -1126524784, user_data = 0x55d1bd2ad368}} [19:54:52.276] nevents = 1 [19:54:52.276] __func__ = "ServerLoop" [19:54:52.276] #39 0x000055d1bc13a542 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55d1bd26ad50) at ../src/backend/postmaster/postmaster.c:1346 [19:54:52.276] opt = [19:54:52.276] status = [19:54:52.276] userDoption = [19:54:52.276] listen_addr_saved = false [19:54:52.276] output_config_variable = [19:54:52.276] __func__ = "PostmasterMain" [19:54:52.276] #40 0x000055d1bbf7ba8c in main (argc=4, argv=0x55d1bd26ad50) at ../src/backend/main/main.c:197 [19:54:52.276] do_check_root = [19:54:52.297] -e [19:54:52.297] [19:54:52.297] [19:54:52.361] dumping /tmp/cores/postgres-6-24842.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [19:54:52.610] [New LWP 24842] [19:54:52.610] [19:54:52.610] This GDB supports auto-downloading debuginfo from the following URLs: [19:54:52.610] [19:54:52.610] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [19:54:52.610] Debuginfod has been disabled. [19:54:52.610] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [19:54:52.714] [Thread debugging using libthread_db enabled] [19:54:52.714] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [19:54:52.714] Core was generated by `postgres: postgres regression [local] DELETE '. [19:54:52.714] Program terminated with signal SIGABRT, Aborted. [19:54:52.714] #0 0x00007f3b314a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:52.869] [19:54:52.869] Thread 1 (Thread 0x7f3b2f02ff00 (LWP 24842)): [19:54:52.869] #0 0x00007f3b314a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:52.869] No symbol table info available. [19:54:52.869] #1 0x00007f3b3145afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:52.869] No symbol table info available. [19:54:52.869] #2 0x00007f3b31445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [19:54:52.869] No symbol table info available. [19:54:52.869] #3 0x0000564df4c76a3c in ExceptionalCondition (conditionName=conditionName@entry=0x564df4e9ff48 "!BTScanPosIsPinned(so->currPos)", fileName=fileName@entry=0x564df4e9fdc8 "../src/backend/access/nbtree/nbtsearch.c", lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [19:54:52.869] No locals. [19:54:52.869] #4 0x0000564df4395368 in _bt_readnextpage (scan=scan@entry=0x564df6ec6560, blkno=, expectNext=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [19:54:52.869] so = 0x564df6f6e9b8 [19:54:52.869] rel = 0x7f3b2570da68 [19:54:52.869] page = [19:54:52.869] opaque = [19:54:52.869] status = [19:54:52.869] #5 0x0000564df4395c99 in _bt_steppage (scan=scan@entry=0x564df6ec6560, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [19:54:52.869] so = 0x564df6f6e9b8 [19:54:52.869] blkno = 2 [19:54:52.869] expectNext = 4 [19:54:52.869] status = [19:54:52.869] #6 0x0000564df43990ae in _bt_first (scan=scan@entry=0x564df6ec6560, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [19:54:52.869] rel = 0x7f3b2570da68 [19:54:52.869] so = 0x564df6f6e9b8 [19:54:52.869] buf = 11538 [19:54:52.869] stack = [19:54:52.869] offnum = [19:54:52.869] strat = [19:54:52.869] inskey = {heapkeyspace = true, allequalimage = true, anynullkeys = false, nextkey = false, backward = true, scantid = 0x0, keysz = 1, scankeys = {{sk_flags = 65665, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x564df4378b43 , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x564df6ec6350, fn_expr = 0x564df6f3f118}, sk_argument = 0}, {sk_flags = 2687018, sk_attno = 40, sk_strategy = 39, sk_subtype = 2424870, sk_collation = 2293796, sk_func = {fn_addr = 0x1f002000210022, fn_oid = 1900574, fn_nargs = 28, fn_strict = 27, fn_retset = false, fn_stats = 26 '\032', fn_extra = 0x13001400150016, fn_mcxt = 0xf001000110012, fn_expr = 0xb000c000d000e}, sk_argument = 1970359197302794}, {sk_flags = 327686, sk_attno = 4, sk_strategy = 3, sk_subtype = 65538, sk_collation = 16843009, sk_func = {fn_addr = 0x0, fn_oid = 4109992250, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x564df6f45d70}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 0, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101, fn_mcxt = 0x564df6f67f88, fn_expr = 0x1}, sk_argument = 94892813327625}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 4143585128, sk_collation = 22093, sk_func = {fn_addr = 0x564df6f67808, fn_oid = 4101242309, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x7ffc22524101, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -151609008, sk_attno = 22093, sk_strategy = 0, sk_subtype = 4104012177, sk_collation = 22093, sk_func = {fn_addr = 0x0, fn_oid = 4100921673, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 109 'm', fn_extra = 0x7f00225241a0, fn_mcxt = 0x0, fn_expr = 0x564df6f1e518}, sk_argument = 94892855518568}, {sk_flags = 575816192, sk_attno = 32764, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 4143350144, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 27 '\033', fn_extra = 0x564df4f27be0, fn_mcxt = 0x564df6f1e518, fn_expr = 0x564df4796e6d }, sk_argument = 140720884302336}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x564df6f68180, fn_oid = 4100925551, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x7f3b2be3a000, fn_mcxt = 0x7f3b25709e60, fn_expr = 0x564df6f1e460}, sk_argument = 94892855518488}, {sk_flags = 575816192, sk_attno = 32764, sk_strategy = 0, sk_subtype = 16777216, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x560101010101, fn_oid = 4106983746, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 112 'p', fn_extra = 0x40, fn_mcxt = 0x3, fn_expr = 0x564df4cbaa83 }, sk_argument = 4143047200}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 632163768, sk_collation = 16809787, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 257, sk_strategy = 257, sk_subtype = 16843009, sk_collation = 16843009, sk_func = {fn_addr = 0x101010101010101, fn_oid = 16843009, fn_nargs = 257, fn_strict = true, fn_retset = true, fn_stats = 1 '\001', fn_extra = 0x101010101010101, fn_mcxt = 0x101010101010101, fn_expr = 0x101010101010101}, sk_argument = 282578800148737}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 575816192, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 112 'p', fn_extra = 0x564df498b775 , fn_mcxt = 0x7f3b2e7e8dc0, fn_expr = 0x564df498c172 }, sk_argument = 94892854864536}, {sk_flags = 58888, sk_attno = 22093, sk_strategy = 0, sk_subtype = 575816544, sk_collation = 32764, sk_func = {fn_addr = 0x5600f586e840, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xc80000001a, fn_mcxt = 0x2000000100000000, fn_expr = 0x1a}, sk_argument = 94892815961340}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 11735, sk_func = {fn_addr = 0x564df4f27be0, fn_oid = 736370688, fn_nargs = 32571, fn_strict = false, fn_retset = false, fn_stats = 215 '\327', fn_extra = 0x0, fn_mcxt = 0x2dd7, fn_expr = 0x564df49ba4fd }, sk_argument = 11735}, {sk_flags = -191468880, sk_attno = 22093, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f3b2be42000, fn_oid = 628155336, fn_nargs = 32571, fn_strict = false, fn_retset = false, fn_stats = 45 '-', fn_extra = 0x1, fn_mcxt = 0x564df4a21797 , fn_expr = 0x1a0000001a}, sk_argument = 858993459200}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 32513, sk_func = {fn_addr = 0xca00c90000001a, fn_oid = 13369547, fn_nargs = 205, fn_strict = 206, fn_retset = false, fn_stats = 207 '\317', fn_extra = 0xd600d500d400d3, fn_mcxt = 0xda00d900d800d7, fn_expr = 0xde00dd00dc00db}, sk_argument = 63614311118930143}, {sk_flags = -190706233, sk_attno = 22093, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 180 '\264', fn_extra = 0x7f3b2624c900, fn_mcxt = 0x3, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 4104263575, sk_collation = 22093, sk_func = {fn_addr = 0x7ffc225244c0, fn_oid = 639944961, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x7f3b2624c900, fn_mcxt = 0x564df6ef2758, fn_expr = 0x564df4a2196e }, sk_argument = 639944961}, {sk_flags = -191439382, sk_attno = 22093, sk_strategy = 0, sk_subtype = 575816892, sk_collation = 32764, sk_func = {fn_addr = 0x7ffc225244bc, fn_oid = 633497088, fn_nargs = 32571, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x22524427, fn_mcxt = 0x234871d400000002, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 8913008, sk_attno = 0, sk_strategy = 256, sk_subtype = 1, sk_collation = 16777217, sk_func = {fn_addr = 0x40000000067f, fn_oid = 37573, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1f439380e, fn_mcxt = 0x3e0, fn_expr = 0x7f3b2570e3c8}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4142868312, sk_collation = 22093, sk_func = {fn_addr = 0x7f3b314b6e77, fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x6b0, fn_mcxt = 0x7f3b314b6fdd, fn_expr = 0x0}, sk_argument = 94892855703088}, {sk_flags = 1027, sk_attno = 0, sk_strategy = 0, sk_subtype = 114, sk_collation = 4294967295, sk_func = {fn_addr = 0x6ae0, fn_oid = 828316768, fn_nargs = 32571, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 139892007950952}, {sk_flags = 827030010, sk_attno = 32571, sk_strategy = 0, sk_subtype = 27416, sk_collation = 0, sk_func = {fn_addr = 0x564df4cb9b2d , fn_oid = 4142687056, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x564df4cb9b2d , fn_expr = 0x564df6ec6350}, sk_argument = 16384}, {sk_flags = 575817856, sk_attno = 32764, sk_strategy = 0, sk_subtype = 4142687256, sk_collation = 22093, sk_func = {fn_addr = 0x0, fn_oid = 4106987711, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 80 'P', fn_extra = 0x10, fn_mcxt = 0x1, fn_expr = 0x564df6f6e9b8}, sk_argument = 94892855158112}}} [19:54:52.869] startKeys = {0x564df6ec6700, 0xd300d400d500d6, 0xcf00d000d100d2, 0xcb00cc00cd00ce, 0xc700c800c900ca, 0xc300c400c500c6, 0xbf00c000c100c2, 0xbb00bc00bd00be, 0xb700b800b900ba, 0xb300b400b500b6, 0xaf00b000b100b2, 0xab00ac00ad00ae, 0xa700a800a900aa, 0xa300a400a500a6, 0x9f00a000a100a2, 0x9b009c009d009e, 0x9700980099009a, 0x93009400950096, 0x8f009000910092, 0x8b008c008d008e, 0x8700880089008a, 0x83008400850086, 0x7f008000810082, 0x7b007c007d007e, 0x7700780079007a, 0x73007400750076, 0x6f007000710072, 0x6b006c006d006e, 0x6700680069006a, 0x63006400650066, 0x5f006000610062, 0x5b005c005d005e} [19:54:52.869] notnullkeys = {{sk_flags = -152618096, sk_attno = 22093, sk_strategy = 0, sk_subtype = 4142349568, sk_collation = 22093, sk_func = {fn_addr = 0x7ffc22523410, fn_oid = 575812416, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffc22523408, fn_mcxt = 0x564df6e73b90, fn_expr = 0x564df47be051 }, sk_argument = 94892856057720}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x7ffc22523408, fn_oid = 575812496, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 223 '\337', fn_extra = 0x564df6e73d00, fn_mcxt = 0x564df6e735c0, fn_expr = 0x0}, sk_argument = 94892855157584}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4142349568, sk_collation = 22093, sk_func = {fn_addr = 0x7ffc22523410, fn_oid = 4142347712, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffc22523408, fn_mcxt = 0x564df6e73b90, fn_expr = 0x564df47c363d }, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x564df6e73b90, fn_mcxt = 0x564df4bc81cd , fn_expr = 0x560000000101}, sk_argument = 0}, {sk_flags = 628150872, sk_attno = 32571, sk_strategy = 0, sk_subtype = 628150808, sk_collation = 32571, sk_func = {fn_addr = 0x564df6e735c0, fn_oid = 4142349488, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x564df4c3cd86 , fn_mcxt = 0x25709c90, fn_expr = 0x3f50624dd2f1a9fc}, sk_argument = 96}, {sk_flags = -188484265, sk_attno = 22093, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x564df4c6ba8b , fn_oid = 4142347712, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 249 '\371', fn_extra = 0x1007ffc225235c0, fn_mcxt = 0x564df6fa2128, fn_expr = 0x564df6e73b90}, sk_argument = 94892855816488}, {sk_flags = 628150872, sk_attno = 32571, sk_strategy = 0, sk_subtype = 4106664578, sk_collation = 22093, sk_func = {fn_addr = 0x1700000017, fn_oid = 4294967295, fn_nargs = 257, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0x7ffc22523500, fn_mcxt = 0x564df6e735c0, fn_expr = 0x60}, sk_argument = 94892854820016}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 575812864, sk_collation = 32764, sk_func = {fn_addr = 0x564df4bca941 , fn_oid = 630777160, fn_nargs = 32571, fn_strict = false, fn_retset = false, fn_stats = 253 '\375', fn_extra = 0x7ffc22523500, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 1220457906831360}, {sk_flags = -152619584, sk_attno = 22093, sk_strategy = 0, sk_subtype = 4106760192, sk_collation = 22093, sk_func = {fn_addr = 0x60, fn_oid = 4142347520, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 176 '\260', fn_extra = 0x564df6e73c00, fn_mcxt = 0x2, fn_expr = 0x564df4c83400 }, sk_argument = 0}, {sk_flags = -188199768, sk_attno = 22093, sk_strategy = 0, sk_subtype = 4106004787, sk_collation = 22093, sk_func = {fn_addr = 0x1000400000065, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x564df6e72050, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 94892816482705}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4100921673, sk_collation = 22093, sk_func = {fn_addr = 0x564df6e73cb0, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x564df6e73d00, fn_mcxt = 0x7ffc22523610, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -152619584, sk_attno = 22093, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x564df471b0e1 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 156 '\234', fn_extra = 0x1, fn_mcxt = 0x564df4c3adb9 , fn_expr = 0x1600000001}, sk_argument = 94892818933728}, {sk_flags = 628128032, sk_attno = 32571, sk_strategy = 0, sk_subtype = 628128032, sk_collation = 32571, sk_func = {fn_addr = 0x7f3b25707928, fn_oid = 4119306840, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 146 '\222', fn_extra = 0x564df4c3f992 , fn_mcxt = 0xf5877f28, fn_expr = 0x2}, sk_argument = 94892846251776}, {sk_flags = 630714232, sk_attno = 32571, sk_strategy = 0, sk_subtype = 28, sk_collation = 1, sk_func = {fn_addr = 0x60, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x7ffc225238e0, fn_mcxt = 0x53d90092f4ccfd8d, fn_expr = 0x17}, sk_argument = 94892808966759}, {sk_flags = 16, sk_attno = 16, sk_strategy = 0, sk_subtype = 628151016, sk_collation = 32571, sk_func = {fn_addr = 0x7ffc22523770, fn_oid = 628150872, fn_nargs = 32571, fn_strict = false, fn_retset = false, fn_stats = 248 '\370', fn_extra = 0x564df4c867d3 , fn_mcxt = 0x7f3b2570d258, fn_expr = 0x7f3b2570d218}, sk_argument = 1}, {sk_flags = -151620360, sk_attno = 22093, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x564df4c3cd86 , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x92c5, fn_mcxt = 0x564df4c3f557 , fn_expr = 0x7ffc22523770}, sk_argument = 94892819135115}, {sk_flags = -152623232, sk_attno = 22093, sk_strategy = 0, sk_subtype = 4106024894, sk_collation = 22093, sk_func = {fn_addr = 0x564df6e73cb0, fn_oid = 4143587464, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x1, fn_mcxt = 0x564df6fa1dc8, fn_expr = 0x3ff0000000000000}, sk_argument = 94892854818240}, {sk_flags = 1, sk_attno = 260, sk_strategy = 0, sk_subtype = 4143586008, sk_collation = 22093, sk_func = {fn_addr = 0x564df4c3adb9 , fn_oid = 575813872, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0x7f3b25709c78, fn_mcxt = 0x7f3b25709c78, fn_expr = 0x7f3b25709c50}, sk_argument = 94892846349048}, {sk_flags = -161091328, sk_attno = 22093, sk_strategy = 0, sk_subtype = 4106479599, sk_collation = 22093, sk_func = {fn_addr = 0x564df6fa2190, fn_oid = 37573, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x564df4cb9942 , fn_mcxt = 0x564df6e72050, fn_expr = 0x6}, sk_argument = 0}, {sk_flags = -187979133, sk_attno = 22093, sk_strategy = 0, sk_subtype = 628137104, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 101 'e', fn_extra = 0x564df6e72150, fn_mcxt = 0x564df6e72260, fn_expr = 0x5}, sk_argument = 140720884303000}, {sk_flags = -152066840, sk_attno = 22093, sk_strategy = 0, sk_subtype = 4106983746, sk_collation = 22093, sk_func = {fn_addr = 0x564df6e72050, fn_oid = 64, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x564df4cbaa83 , fn_mcxt = 0xf6e72050, fn_expr = 0x3}, sk_argument = 1}, {sk_flags = 1, sk_attno = 226, sk_strategy = 0, sk_subtype = 14745826, sk_collation = 14614752, sk_func = {fn_addr = 0xdb00dc00dd00de, fn_oid = 14221530, fn_nargs = 216, fn_strict = 215, fn_retset = false, fn_stats = 214 '\326', fn_extra = 0xcf00d000d100d2, fn_mcxt = 0xcb00cc00cd00ce, fn_expr = 0xc700c800c900ca}, sk_argument = 54888462285078726}, {sk_flags = 12648642, sk_attno = 192, sk_strategy = 191, sk_subtype = 12386494, sk_collation = 12255420, sk_func = {fn_addr = 0xb700b800b900ba, fn_oid = 11862198, fn_nargs = 180, fn_strict = 179, fn_retset = false, fn_stats = 21 '\025', fn_extra = 0x564df4cb9942 , fn_mcxt = 0x564df6f45600, fn_expr = 0x40}, sk_argument = 3}, {sk_flags = -187979133, sk_attno = 22093, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 4143207936, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5, fn_mcxt = 0x1, fn_expr = 0x7ffc22523d30}, sk_argument = 140720884300296}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 4107074957, sk_collation = 22093, sk_func = {fn_addr = 0x2, fn_oid = 4100868227, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x564df6f45ea0, fn_mcxt = 0x395, fn_expr = 0x564df46e4d79 }, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 575817024, sk_collation = 32764, sk_func = {fn_addr = 0x564df4e17edb , fn_oid = 575816544, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 159 '\237', fn_extra = 0x7ffc22524360, fn_mcxt = 0xc8, fn_expr = 0x4fffffffe}, sk_argument = 140720884301088}, {sk_flags = 575814144, sk_attno = 32764, sk_strategy = 0, sk_subtype = 4143208192, sk_collation = 22093, sk_func = {fn_addr = 0x229002a, fn_oid = 2424870, fn_nargs = 36, fn_strict = 35, fn_retset = false, fn_stats = 34 '"', fn_extra = 0x1b001c00000000, fn_mcxt = 0x1700180019001a, fn_expr = 0x13001400000000}, sk_argument = 0}, {sk_flags = 4, sk_attno = 0, sk_strategy = 0, sk_subtype = 4294967295, sk_collation = 4294967295, sk_func = {fn_addr = 0xffffffffffffffff, fn_oid = 4294967295, fn_nargs = -1, fn_strict = 255, fn_retset = 255, fn_stats = 255 '\377', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x17}, sk_argument = 0}, {sk_flags = 628151912, sk_attno = 32571, sk_strategy = 0, sk_subtype = 628151848, sk_collation = 32571, sk_func = {fn_addr = 0x7f3b2570d258, fn_oid = 628150808, fn_nargs = 32571, fn_strict = false, fn_retset = false, fn_stats = 11 '\v', fn_extra = 0x7ffc22523c00, fn_mcxt = 0x7ffc22523bf0, fn_expr = 0x564df4c3cd86 }, sk_argument = 140720884300808}, {sk_flags = 97, sk_attno = 0, sk_strategy = 0, sk_subtype = 575814664, sk_collation = 32764, sk_func = {fn_addr = 0x564d00000000, fn_oid = 575814656, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 139 '\213', fn_extra = 0x7ffc22523bf8, fn_mcxt = 0x564df4bcba8f , fn_expr = 0x7ffc22523b40}, sk_argument = 4294967393}, {sk_flags = 0, sk_attno = 97, sk_strategy = 0, sk_subtype = 4101062494, sk_collation = 22093, sk_func = {fn_addr = 0x0, fn_oid = 1202590843, fn_nargs = 31457, fn_strict = 132, fn_retset = 63, fn_stats = 123 '{', fn_extra = 0x408f400000000000, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x7ffc22523be0}, sk_argument = 0}, {sk_flags = 1202590843, sk_attno = 31457, sk_strategy = 16276, sk_subtype = 0, sk_collation = 1072693248, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 4143347720, fn_nargs = 22093, fn_strict = false, fn_retset = false, fn_stats = 43 '+', fn_extra = 0x3f747ae147ae147b, fn_mcxt = 0xe2eb851eba, fn_expr = 0xdf00e000e100e2}, sk_argument = 61643964806922462}} [19:54:52.869] keysz = 1 [19:54:52.869] i = [19:54:52.869] status = [19:54:52.869] strat_total = 1 [19:54:52.869] currItem = [19:54:52.869] blkno = 22093 [19:54:52.869] __func__ = "_bt_first" [19:54:52.869] #7 0x0000564df4390177 in btgettuple (scan=0x564df6ec6560, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [19:54:52.869] so = 0x564df6f6e9b8 [19:54:52.869] res = [19:54:52.869] #8 0x0000564df4376d73 in index_getnext_tid (scan=scan@entry=0x564df6ec6560, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [19:54:52.869] found = [19:54:52.869] __func__ = "index_getnext_tid" [19:54:52.869] #9 0x0000564df4bbf642 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x7f3b2570e3c8, indexRel=indexRel@entry=0x7f3b2570da68, indexscandir=indexscandir@entry=BackwardScanDirection, scankeys=scankeys@entry=0x7ffc22524880, typLen=, typByVal=, tableslot=0x564df6ec6450, outercontext=0x564df65e6a30, endpointDatum=0x564df6f1d670) at ../src/backend/utils/adt/selfuncs.c:6349 [19:54:52.869] have_data = false [19:54:52.869] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 22093, xmax = 4106479599, xip = 0x4000, xcnt = 23, subxip = 0x0, subxcnt = 0, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0x564df586e840 , active_count = 23, regd_count = 0, ph_node = {first_child = 0x0, next_sibling = 0x7f3b25ae6d08, prev_or_parent = 0x7f3b25ae6cc8}, whenTaken = 23, lsn = 94892855157584, snapXactCompletionCount = 140720884304608} [19:54:52.869] index_scan = 0x564df6ec6560 [19:54:52.869] vmbuffer = 0 [19:54:52.869] last_heap_block = 4294967295 [19:54:52.869] n_visited_heap_pages = 0 [19:54:52.869] tid = [19:54:52.869] values = {68719476752, 140720884304320, 94892854813008, 0, 94892854812752, 94892812318792, 94892855524760, 140720884304288, 94892855158368, 139892011241389, 140720884303640, 140720884304320, 94892854812672, 139892011234866, 139892011203783, 94892819279401, 140720884303744, 139892207587360, 575818180, 0, 2, 94892846243224, 8438021376, 94892846239840, 140720884303744, 0, 0, 94892818935225, 94892845857784, 94892818933728, 139892011986160, 139892011986160} [19:54:52.869] isnull = {false, false, false, false, false, false, false, false, 84, 182, 94, 244, 25, 31, 55, 224, false, false, false, false, false, false, false, false, 224, 107, 236, 246, 77, 86, false, false} [19:54:52.869] oldcontext = [19:54:52.869] __func__ = "get_actual_variable_endpoint" [19:54:52.869] #10 0x0000564df4bbfe29 in get_actual_variable_range (root=root@entry=0x564df6f1bce8, vardata=vardata@entry=0x7ffc22524ae0, sortop=97, collation=collation@entry=0, min=min@entry=0x0, max=0x564df6f1d670) at ../src/backend/utils/adt/selfuncs.c:6228 [19:54:52.869] tmpcontext = 0x564df6ec6350 [19:54:52.869] oldcontext = 0x564df65e6a30 [19:54:52.869] heapRel = 0x7f3b2570e3c8 [19:54:52.869] slot = 0x564df6ec6450 [19:54:52.869] typLen = 4 [19:54:52.869] indexRel = 0x7f3b2570da68 [19:54:52.869] typByVal = true [19:54:52.869] scankeys = {{sk_flags = 129, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}} [19:54:52.869] index = [19:54:52.869] indexscandir = ForwardScanDirection [19:54:52.869] lc__state = [19:54:52.869] have_data = true [19:54:52.869] rel = [19:54:52.869] rte = [19:54:52.869] lc = [19:54:52.869] #11 0x0000564df4bcab93 in ineq_histogram_selectivity (root=root@entry=0x564df6f1bce8, vardata=vardata@entry=0x7ffc22524ae0, opoid=opoid@entry=523, opproc=opproc@entry=0x7ffc22524a40, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [19:54:52.869] probe = 100 [19:54:52.869] ltcmp = [19:54:52.869] histfrac = [19:54:52.869] lobound = 99 [19:54:52.869] hibound = 101 [19:54:52.869] have_end = false [19:54:52.869] hist_selec = -1 [19:54:52.869] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x564df6f1d350, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [19:54:52.869] #12 0x0000564df4bcb204 in scalarineqsel (root=root@entry=0x564df6f1bce8, operator=operator@entry=523, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=collation@entry=0, vardata=vardata@entry=0x7ffc22524ae0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [19:54:52.869] stats = 0x7f3b2570d2a0 [19:54:52.869] opproc = {fn_addr = 0x564df4ac2b5e , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x564df65e6a30, fn_expr = 0x0} [19:54:52.869] mcv_selec = 0 [19:54:52.869] hist_selec = [19:54:52.869] sumcommon = 0 [19:54:52.869] selec = [19:54:52.869] #13 0x0000564df4bcb723 in scalarineqsel_wrapper (fcinfo=, isgt=isgt@entry=false, iseq=iseq@entry=true) at ../src/backend/utils/adt/selfuncs.c:1459 [19:54:52.869] root = 0x564df6f1bce8 [19:54:52.869] operator = 523 [19:54:52.869] args = [19:54:52.869] varRelid = [19:54:52.869] collation = 0 [19:54:52.869] vardata = {var = 0x564df6f1c178, rel = 0x564df65e8740, statsTuple = 0x7f3b2570d258, freefunc = 0x564df4c6ba82 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [19:54:52.869] other = 0x564df6f1d7b0 [19:54:52.869] varonleft = true [19:54:52.869] constval = 100000010 [19:54:52.869] consttype = 23 [19:54:52.869] selec = [19:54:52.869] #14 0x0000564df4bcb862 in scalarlesel (fcinfo=) at ../src/backend/utils/adt/selfuncs.c:1482 [19:54:52.869] No locals. [19:54:52.869] #15 0x0000564df4c844fd in FunctionCall4Coll (flinfo=flinfo@entry=0x7ffc22524bd0, collation=collation@entry=0, arg1=arg1@entry=94892855508200, arg2=arg2@entry=523, arg3=arg3@entry=94892855509848, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [19:54:52.869] fcinfodata = {fcinfo = {flinfo = 0x7ffc22524bd0, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x7ffc22524b80}, fcinfo_data = "\320KR\"\374\177", '\000' , "V\004\000\350\274\361\366MV\000\000\0000\310\364MV\000\000\v\002\000\000\000\000\000\000\000\274\361\366MV\000\000X\303\361\366MV\000\000\000\303\361\366MV", '\000' , "4\310\364MV\000"} [19:54:52.869] fcinfo = 0x7ffc22524b60 [19:54:52.869] result = [19:54:52.869] __func__ = "FunctionCall4Coll" [19:54:52.869] #16 0x0000564df4c84ca8 in OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=94892855508200, arg2=arg2@entry=523, arg3=arg3@entry=94892855509848, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [19:54:52.869] flinfo = {fn_addr = 0x564df4bcb84f , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x564df65e6a30, fn_expr = 0x0} [19:54:52.869] #17 0x0000564df47e4260 in restriction_selectivity (root=root@entry=0x564df6f1bce8, operatorid=operatorid@entry=523, args=0x564df6f1c358, inputcollid=0, varRelid=varRelid@entry=0) at ../src/include/postgres.h:324 [19:54:52.869] oprrest = [19:54:52.869] result = [19:54:52.869] __func__ = "restriction_selectivity" [19:54:52.869] #18 0x0000564df47125f0 in clause_selectivity_ext (root=root@entry=0x564df6f1bce8, clause=0x564df6f1c3f8, clause@entry=0x564df6f1cfd0, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=use_extended_stats@entry=true) at ../src/backend/optimizer/path/clausesel.c:848 [19:54:52.869] opclause = 0x564df6f1c3f8 [19:54:52.869] opno = 523 [19:54:52.869] s1 = 0.5 [19:54:52.869] rinfo = 0x564df6f1cfd0 [19:54:52.869] cacheable = true [19:54:52.869] #19 0x0000564df4712f5f in clauselist_selectivity_ext (root=root@entry=0x564df6f1bce8, clauses=0x564df6f1cf80, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=use_extended_stats@entry=true) at ../src/backend/optimizer/path/clausesel.c:183 [19:54:52.869] clause = 0x564df6f1cfd0 [19:54:52.869] rinfo = [19:54:52.869] s2 = [19:54:52.869] l__state = [19:54:52.869] s1 = 1 [19:54:52.869] rel = [19:54:52.869] estimatedclauses = 0x0 [19:54:52.869] rqlist = 0x564df6f1d760 [19:54:52.869] l = [19:54:52.869] listidx = 1 [19:54:52.869] #20 0x0000564df4713242 in clauselist_selectivity (root=root@entry=0x564df6f1bce8, clauses=, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [19:54:52.869] No locals. [19:54:52.869] #21 0x0000564df4722618 in set_baserel_size_estimates (root=root@entry=0x564df6f1bce8, rel=rel@entry=0x564df65e8740) at ../src/backend/optimizer/path/costsize.c:5286 [19:54:52.869] nrows = [19:54:52.869] #22 0x0000564df470711e in set_plain_rel_size (root=root@entry=0x564df6f1bce8, rel=rel@entry=0x564df65e8740, rte=rte@entry=0x564df65e7bf8) at ../src/backend/optimizer/path/allpaths.c:581 [19:54:52.869] No locals. [19:54:52.869] #23 0x0000564df470d38e in set_rel_size (root=root@entry=0x564df6f1bce8, rel=rel@entry=0x564df65e8740, rti=rti@entry=1, rte=rte@entry=0x564df65e7bf8) at ../src/backend/optimizer/path/allpaths.c:411 [19:54:52.869] __func__ = "set_rel_size" [19:54:52.869] #24 0x0000564df470d577 in set_base_rel_sizes (root=root@entry=0x564df6f1bce8) at ../src/backend/optimizer/path/allpaths.c:322 [19:54:52.869] rel = 0x564df65e8740 [19:54:52.869] rte = 0x564df65e7bf8 [19:54:52.869] rti = 1 [19:54:52.869] #25 0x0000564df471157d in make_one_rel (root=root@entry=0x564df6f1bce8, joinlist=joinlist@entry=0x564df6f1cd80) at ../src/backend/optimizer/path/allpaths.c:183 [19:54:52.869] rel = [19:54:52.869] rti = [19:54:52.869] total_pages = [19:54:52.869] #26 0x0000564df4775275 in query_planner (root=root@entry=0x564df6f1bce8, qp_callback=qp_callback@entry=0x564df477a5ce , qp_extra=qp_extra@entry=0x7ffc22524f30) at ../src/backend/optimizer/plan/planmain.c:280 [19:54:52.869] parse = 0x564df65e79e8 [19:54:52.869] joinlist = 0x564df6f1cd80 [19:54:52.869] final_rel = [19:54:52.869] __func__ = "query_planner" [19:54:52.869] #27 0x0000564df4787b38 in grouping_planner (root=root@entry=0x564df6f1bce8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [19:54:52.869] sort_input_targets = 0x564df6f1c478 [19:54:52.869] sort_input_target_parallel_safe = [19:54:52.869] grouping_target = [19:54:52.869] scanjoin_target = [19:54:52.869] activeWindows = 0x0 [19:54:52.869] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [19:54:52.869] sort_input_targets_contain_srfs = 0x2 [19:54:52.869] have_grouping = [19:54:52.869] wflists = 0x0 [19:54:52.869] gset_data = 0x0 [19:54:52.869] sort_input_target = [19:54:52.869] grouping_targets = 0x564df65e79e8 [19:54:52.869] grouping_target_parallel_safe = [19:54:52.869] scanjoin_targets = 0x564df6f1bce8 [19:54:52.869] scanjoin_target_parallel_safe = [19:54:52.869] grouping_targets_contain_srfs = 0x564df6f1c518 [19:54:52.869] scanjoin_targets_contain_srfs = 0x0 [19:54:52.869] scanjoin_target_same_exprs = [19:54:52.869] parse = 0x564df65e79e8 [19:54:52.869] offset_est = 0 [19:54:52.869] count_est = 0 [19:54:52.869] limit_tuples = -1 [19:54:52.869] have_postponed_srfs = false [19:54:52.869] final_target = [19:54:52.869] final_targets = 0x564df65e8670 [19:54:52.869] final_targets_contain_srfs = 0x564df47bd494 [19:54:52.869] final_target_parallel_safe = [19:54:52.869] current_rel = [19:54:52.869] final_rel = [19:54:52.869] extra = {limit_needed = 72, limit_tuples = 4.6883299942378923e-310, count_est = 94892855510296, offset_est = 94892855508200} [19:54:52.869] lc = [19:54:52.869] __func__ = "grouping_planner" [19:54:52.869] #28 0x0000564df478a96b in subquery_planner (glob=glob@entry=0x564df65e78d8, parse=parse@entry=0x564df65e79e8, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1089 [19:54:52.869] root = 0x564df6f1bce8 [19:54:52.869] newWithCheckOptions = [19:54:52.869] newHaving = [19:54:52.869] hasOuterJoins = [19:54:52.869] hasResultRTEs = false [19:54:52.869] final_rel = [19:54:52.869] l = 0x0 [19:54:52.869] #29 0x0000564df478b5fc in standard_planner (parse=0x564df65e79e8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:415 [19:54:52.869] result = [19:54:52.869] glob = 0x564df65e78d8 [19:54:52.869] tuple_fraction = 0 [19:54:52.869] root = [19:54:52.869] final_rel = [19:54:52.869] best_path = [19:54:52.869] top_plan = [19:54:52.869] lp = [19:54:52.869] lr = [19:54:52.869] #30 0x0000564df478c666 in planner (parse=parse@entry=0x564df65e79e8, query_string=query_string@entry=0x564df65e6b30 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:282 [19:54:52.869] result = [19:54:52.869] #31 0x0000564df49e5fc6 in pg_plan_query (querytree=querytree@entry=0x564df65e79e8, query_string=query_string@entry=0x564df65e6b30 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:912 [19:54:52.869] plan = [19:54:52.869] #32 0x0000564df49e63a7 in pg_plan_queries (querytrees=0x564df65e86f0, query_string=query_string@entry=0x564df65e6b30 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1006 [19:54:52.869] query = 0x564df65e79e8 [19:54:52.869] stmt = [19:54:52.869] query_list__state = [19:54:52.869] stmt_list = 0x0 [19:54:52.869] query_list = [19:54:52.869] #33 0x0000564df49e6954 in exec_simple_query (query_string=query_string@entry=0x564df65e6b30 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [19:54:52.869] cmdtaglen = 6 [19:54:52.869] snapshot_set = true [19:54:52.869] per_parsetree_context = 0x0 [19:54:52.869] plantree_list = [19:54:52.869] parsetree = 0x564df65e7858 [19:54:52.869] commandTag = CMDTAG_DELETE [19:54:52.869] qc = {commandTag = CMDTAG_CREATE_SUBSCRIPTION, nprocessed = 94892845853488} [19:54:52.869] querytree_list = [19:54:52.869] portal = [19:54:52.869] receiver = [19:54:52.869] format = 0 [19:54:52.869] cmdtagname = [19:54:52.869] parsetree_item__state = [19:54:52.869] dest = DestRemote [19:54:52.869] oldcontext = 0x564df667ace0 [19:54:52.869] parsetree_list = 0x564df65e7888 [19:54:52.869] parsetree_item = 0x564df65e78a0 [19:54:52.869] save_log_statement_stats = false [19:54:52.869] was_logged = false [19:54:52.869] use_implicit_block = false [19:54:52.869] msec_str = "\000TR\"\374\177\000\000H\307\311\364MV\000\0000RR\"\374\177\000\000W\000\000\000\000\000\000" [19:54:52.869] __func__ = "exec_simple_query" [19:54:52.869] #34 0x0000564df49e9575 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [19:54:52.869] query_string = 0x564df65e6b30 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [19:54:52.869] firstchar = [19:54:52.869] input_message = {data = 0x564df65e6b30 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [19:54:52.869] local_sigjmp_buf = {{__jmpbuf = {94892831777304, 3713237440925350083, 4, 140720884306944, 140720884307088, 140720884307092, 6983885020539205827, 3713239836693838019}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94892845583920, 15616, 94892831771392, 94892846107968, 140720884307088, 94892819458239, 0, 9, 2, 94892831777312, 94892845583920, 94892831771392, 140720884306944, 140720884307088, 140720884307092}}}} [19:54:52.869] send_ready_for_query = false [19:54:52.869] idle_in_transaction_timeout_enabled = false [19:54:52.869] idle_session_timeout_enabled = false [19:54:52.869] __func__ = "PostgresMain" [19:54:52.869] #35 0x0000564df49df697 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:54:52.869] bsdata = [19:54:52.869] #36 0x0000564df4897dbe in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc225253ac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc22525400) at ../src/backend/postmaster/launch_backend.c:274 [19:54:52.869] pid = [19:54:52.869] #37 0x0000564df489d86a in BackendStartup (client_sock=client_sock@entry=0x7ffc22525400) at ../src/backend/postmaster/postmaster.c:3414 [19:54:52.869] bn = 0x564df660f418 [19:54:52.869] pid = [19:54:52.869] startup_data = {canAcceptConnections = CAC_OK} [19:54:52.869] __func__ = "BackendStartup" [19:54:52.869] #38 0x0000564df489ddcc in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:54:52.869] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\3222;\177\000\000=\004\000\000\000\000\000\000\220\227C1;\177\000\000\240\177\2242;\177\000\000\270TR\"\374\177\000\000\264TR\"\374\177", '\000' , "\303\353\246\363MV\000\000\020ע\363MV\000\000\200UR\"\374\177\000\000xUR\"\374\177\000\000\225[\362\001Vp\370\030\240\004C/;\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [19:54:52.869] i = 0 [19:54:52.869] now = [19:54:52.869] last_lockfile_recheck_time = 1725047444 [19:54:52.869] last_touch_time = 1725047444 [19:54:52.869] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 575821248, user_data = 0x0}, {pos = 15, events = 0, fd = -207164477, user_data = 0x7f3b32d50668}, {pos = 792921648, events = 32571, fd = 852820704, user_data = 0x7c96e577}, {pos = 575821312, events = 32764, fd = 852650568, user_data = 0xf}, {pos = 792921648, events = 32571, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 852820704, user_data = 0x7ffc22525578}, {pos = 575821184, events = 32764, fd = 852821608, user_data = 0x0}, {pos = 32768, events = 0, fd = 8, user_data = 0x564df65e8930}, {pos = 1, events = 32571, fd = 575822499, user_data = 0xffffffff}, {pos = 826466304, events = 32571, fd = 848592800, user_data = 0x564df66137c8}, {pos = -161401176, events = 22093, fd = -161392447, user_data = 0x7f3b32d2cebe}, {pos = 1, events = 0, fd = 852820704, user_data = 0x1b7}, {pos = -182579784, events = 22093, fd = 0, user_data = 0x1}, {pos = -161584144, events = 22093, fd = 852676286, user_data = 0x1}, {pos = 0, events = 0, fd = 826466304, user_data = 0x7f3b314f2dc0 }, {pos = 16, events = 0, fd = 575822288, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f3b32d2f1aa}, {pos = 0, events = 0, fd = 826993940, user_data = 0x0}, {pos = -175719456, events = 22093, fd = 2, user_data = 0x7}, {pos = -161837360, events = 22093, fd = -191372210, user_data = 0x7367702f65736162}, {pos = 1952410737, events = 28781, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -161584144, events = 22093, fd = 852676286, user_data = 0x1}, {pos = 827027421, events = 32571, fd = 826500264, user_data = 0x564df6612490}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 828316768, events = 32571, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x564df65a8ed0}, {pos = 827030010, events = 32571, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 963399525, fd = 168454516, user_data = 0x30353237310a6174}, {pos = 875837236, events = 808716852, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 22016, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 828299744, events = 32571, fd = 826937710, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x18f870561b03f000}, {pos = 828302816, events = 32571, fd = -328, user_data = 0x0}, {pos = -161401496, events = 22093, fd = 1024, user_data = 0x564df6613568}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 15565, events = 0, fd = -328, user_data = 0x0}, {pos = -161584144, events = 22093, fd = 827273171, user_data = 0x7ffc22525a88}, {pos = -187900234, events = 22093, fd = -175660592, user_data = 0x564df4cbc973 }, {pos = -161401696, events = 22093, fd = -161584592, user_data = 0x564df66134a0}, {pos = 827021358, events = 32571, fd = 0, user_data = 0x564df4cce5dd }, {pos = -161401696, events = 1, fd = -187898074, user_data = 0x564df65e6a30}, {pos = 453242880, events = 418934870, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 826944177, user_data = 0x7f3b314a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 453242880, user_data = 0x564df65be160}, {pos = 453242880, events = 418934870, fd = 11, user_data = 0x18f870561b03f000}, {pos = 0, events = 0, fd = 826651193, user_data = 0x1}, {pos = -192316741, events = 22093, fd = 4194304, user_data = 0x564df4cbc807 }, {pos = -161750688, events = 22093, fd = -161584592, user_data = 0x564df65be160}, {pos = 1, events = 0, fd = 0, user_data = 0x564df4cce5dd }, {pos = -161750688, events = 22093, fd = -187898074, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x564df46d0661 }, {pos = 0, events = 0, fd = -194160213, user_data = 0xb}, {pos = -192295592, events = 22093, fd = -179246960, user_data = 0x564df65e7408}} [19:54:52.869] nevents = 1 [19:54:52.869] __func__ = "ServerLoop" [19:54:52.869] #39 0x0000564df489f542 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x564df65a4d90) at ../src/backend/postmaster/postmaster.c:1346 [19:54:52.869] opt = [19:54:52.869] status = [19:54:52.869] userDoption = [19:54:52.869] listen_addr_saved = false [19:54:52.869] output_config_variable = [19:54:52.869] __func__ = "PostmasterMain" [19:54:52.869] #40 0x0000564df46e0a8c in main (argc=8, argv=0x564df65a4d90) at ../src/backend/main/main.c:197 [19:54:52.869] do_check_root =