[17:29:24.185] src/tools/ci/cores_backtrace.sh linux /tmp/cores [17:29:24.422] dumping /tmp/cores/postgres-6-31111.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [17:29:24.687] [New LWP 31111] [17:29:24.687] [17:29:24.687] This GDB supports auto-downloading debuginfo from the following URLs: [17:29:24.687] [17:29:24.687] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [17:29:24.687] Debuginfod has been disabled. [17:29:24.687] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [17:29:24.818] [Thread debugging using libthread_db enabled] [17:29:24.818] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [17:29:24.818] Core was generated by `postgres: primary: postgres regression [local] DELETE '. [17:29:24.818] Program terminated with signal SIGABRT, Aborted. [17:29:24.818] #0 0x00007f2be6ca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:25.026] [17:29:25.026] Thread 1 (Thread 0x7f2be7435f00 (LWP 31111)): [17:29:25.026] #0 0x00007f2be6ca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:25.026] No symbol table info available. [17:29:25.026] #1 0x00007f2be6c5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:25.026] No symbol table info available. [17:29:25.026] #2 0x00007f2be6c45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:25.026] No symbol table info available. [17:29:25.026] #3 0x000056059b57c72c in ExceptionalCondition (conditionName=conditionName@entry=0x56059b7a5f48 "!BTScanPosIsPinned(so->currPos)", fileName=fileName@entry=0x56059b7a5dc8 "../src/backend/access/nbtree/nbtsearch.c", lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [17:29:25.026] No locals. [17:29:25.026] #4 0x000056059ac9b368 in _bt_readnextpage (scan=scan@entry=0x56059dc4d010, blkno=, expectNext=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [17:29:25.026] so = 0x56059dcfab98 [17:29:25.026] rel = 0x7f2be2454588 [17:29:25.026] page = [17:29:25.026] opaque = [17:29:25.026] status = [17:29:25.026] #5 0x000056059ac9bc99 in _bt_steppage (scan=scan@entry=0x56059dc4d010, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [17:29:25.026] so = 0x56059dcfab98 [17:29:25.026] blkno = 2 [17:29:25.026] expectNext = 4 [17:29:25.026] status = [17:29:25.026] #6 0x000056059ac9f0ae in _bt_first (scan=scan@entry=0x56059dc4d010, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [17:29:25.026] rel = 0x7f2be2454588 [17:29:25.026] so = 0x56059dcfab98 [17:29:25.026] buf = 22 [17:29:25.026] stack = [17:29:25.026] offnum = [17:29:25.026] strat = [17:29:25.026] 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 = 0x56059ac7eb43 , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x56059dc4ce00, fn_expr = 0x56059dcce998}, 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 = 22021, sk_func = {fn_addr = 0x7ffd2f7f2bd0, fn_oid = 2647418168, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x700000002, fn_mcxt = 0x56059dc83db8, fn_expr = 0x56059dbfeb80}, sk_argument = 94582121970968}, {sk_flags = -1647551752, sk_attno = 22021, sk_strategy = 0, sk_subtype = 2647416264, sk_collation = 22021, sk_func = {fn_addr = 0x56059dcc6988, fn_oid = 2647419272, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 88 'X', fn_extra = 0x1, fn_mcxt = 0x1, fn_expr = 0x56059b2e9e81 }, sk_argument = 94582121971656}, {sk_flags = 0, sk_attno = 22021, sk_strategy = 0, sk_subtype = 2646600576, sk_collation = 22021, sk_func = {fn_addr = 0x101000700000003, fn_oid = 2647146584, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 248 '\370', fn_extra = 0x56059dcc6988, fn_mcxt = 0x100000000000001, fn_expr = 0x56059dc84058}, sk_argument = 94582121974936}, {sk_flags = -1647820800, sk_attno = 22021, sk_strategy = 0, sk_subtype = 2647419272, sk_collation = 22021, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 0, fn_nargs = 0, fn_strict = 240, fn_retset = 63, fn_stats = 0 '\000', fn_extra = 0x56059dcc6c28, fn_mcxt = 0x101010101000000, fn_expr = 0x56059b2bc9bc }, sk_argument = 72340172838076673}, {sk_flags = 16843009, sk_attno = 0, sk_strategy = 8192, sk_subtype = 3805661640, sk_collation = 32555, sk_func = {fn_addr = 0x0, fn_oid = 3801510912, fn_nargs = 32555, fn_strict = false, fn_retset = false, fn_stats = 200 '\310', fn_extra = 0x1, fn_mcxt = 0x7ffd2f7f2cd0, fn_expr = 0x0}, sk_argument = 94582078177773}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 2602158288, sk_collation = 22021, sk_func = {fn_addr = 0x101010101010101, fn_oid = 796863696, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x4000, fn_expr = 0x56059b2e3849 }, sk_argument = 94582112633152}, {sk_flags = -1691881988, sk_attno = 22021, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x56059b281df6 , fn_oid = 0, fn_nargs = 1663, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1, fn_mcxt = 0x56059b2bc9bc , fn_expr = 0x56000}, sk_argument = 2305843009213702144}, {sk_flags = -489305656, sk_attno = 32555, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f2be2967400, fn_oid = 2603085308, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x56059b281df6 , fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = -1657159120, sk_attno = 22021, sk_strategy = 0, sk_subtype = 8192, sk_collation = 0, sk_func = {fn_addr = 0x2000, fn_oid = 796864656, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x4000, fn_mcxt = 0x1, fn_expr = 0x56059dc8aae8}, sk_argument = 2}, {sk_flags = -492261376, sk_attno = 32555, sk_strategy = 0, sk_subtype = 8192, sk_collation = 0, sk_func = {fn_addr = 0x67f00000000, fn_oid = 16384, fn_nargs = 2224, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x56059d39bed0, fn_mcxt = 0x4000, fn_expr = 0x1}, sk_argument = 8192}, {sk_flags = -1691488068, sk_attno = 22021, sk_strategy = 0, sk_subtype = 25112664, 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 = 2600380547, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x56059dc0a160, fn_mcxt = 0x0, fn_expr = 0x56059b2e9e81 }, sk_argument = 0}, {sk_flags = -1694533303, sk_attno = 22021, sk_strategy = 0, sk_subtype = 2646647136, sk_collation = 16799237, 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 = 796865024, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x7ffd2f7f31fc, fn_mcxt = 0x170000000, fn_expr = 0x2}, sk_argument = 18}, {sk_flags = -492408360, sk_attno = 32555, sk_strategy = 0, sk_subtype = 1660859324, sk_collation = 0, sk_func = {fn_addr = 0x7f00e296a480, 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 = 94582077827564}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 5, sk_func = {fn_addr = 0x56059b82dbe0, fn_oid = 3802599424, fn_nargs = 32555, fn_strict = false, fn_retset = false, fn_stats = 5 '\005', fn_extra = 0x0, fn_mcxt = 0x5, fn_expr = 0x56059b2c01ed }, sk_argument = 5}, {sk_flags = -1691957344, sk_attno = 22021, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f2be2a71000, fn_oid = 3796193000, fn_nargs = 32555, fn_strict = false, fn_retset = false, fn_stats = 45 '-', fn_extra = 0x0, fn_mcxt = 0x7f2b00000000, fn_expr = 0x1a0000001a}, sk_argument = 858993459200}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 22017, 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 = -1691194697, sk_attno = 22021, 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 = 164 '\244', fn_extra = 0x7f2be2a66e80, fn_mcxt = 0x3, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 2603775111, sk_collation = 22021, sk_func = {fn_addr = 0x7ffd2f7f32b0, fn_oid = 3802557953, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 176 '\260', fn_extra = 0x7f2be2a66e80, fn_mcxt = 0x56059d441da8, fn_expr = 0x56059b32765e }, sk_argument = 3802557953}, {sk_flags = -1691927846, sk_attno = 22021, sk_strategy = 0, sk_subtype = 796865196, sk_collation = 32765, sk_func = {fn_addr = 0x7ffd2f7f32ac, fn_oid = 3801526784, fn_nargs = 32555, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x2f7f3217, fn_mcxt = 0xf38710d700000002, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -1685919536, sk_attno = 22021, sk_strategy = 256, sk_subtype = 1, sk_collation = 16777217, sk_func = {fn_addr = 0x40000000067f, fn_oid = 37577, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x19ac9980e, fn_mcxt = 0x3e0, fn_expr = 0x7f2be2454ee8}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 2638486952, sk_collation = 22021, sk_func = {fn_addr = 0x7f2be6cb6e87, fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x6b0, fn_mcxt = 0x7f2be6cb6fed, fn_expr = 0x0}, sk_argument = 94582122327728}, {sk_flags = 1027, sk_attno = 0, sk_strategy = 0, sk_subtype = 114, sk_collation = 4294967295, sk_func = {fn_addr = 0x6ae0, fn_oid = 3873381472, fn_nargs = 32555, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 139826456511880}, {sk_flags = -422872566, sk_attno = 32555, sk_strategy = 0, sk_subtype = 27416, sk_collation = 0, sk_func = {fn_addr = 0x56059b5bf81d , fn_oid = 2646920704, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x56059b5bf81d , fn_expr = 0x56059dc4ce00}, sk_argument = 16384}, {sk_flags = 796866160, sk_attno = 32765, sk_strategy = 0, sk_subtype = 2646920904, sk_collation = 22021, sk_func = {fn_addr = 0x0, fn_oid = 2606499247, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x10, fn_mcxt = 0x1, fn_expr = 0x56059dcfab98}, sk_argument = 94582121746448}}} [17:29:25.026] startKeys = {0x56059dc4d1b0, 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} [17:29:25.026] notnullkeys = {{sk_flags = -1648365232, sk_attno = 22021, sk_strategy = 0, sk_subtype = 2605506237, sk_collation = 22021, sk_func = {fn_addr = 0x100000070, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x7f2be2453d38, fn_mcxt = 0x56059dbfeb80, fn_expr = 0x56059dbff270}, sk_argument = 2}, {sk_flags = -1688982922, sk_attno = 22021, sk_strategy = 0, sk_subtype = 3796174848, sk_collation = 0, sk_func = {fn_addr = 0x3f50624dd2f1a9fc, fn_oid = 96, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 71 'G', fn_extra = 0x0, fn_mcxt = 0x56059b57177b , fn_expr = 0x56059dbfeb80}, sk_argument = 94582080341225}, {sk_flags = 796861104, sk_attno = 32765, sk_strategy = 256, sk_subtype = 2647145064, sk_collation = 22021, sk_func = {fn_addr = 0x56059dbff150, fn_oid = 2647416264, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x56059b571772 , fn_mcxt = 0x1700000017, fn_expr = 0x101ffffffff}, sk_argument = 796860880}, {sk_flags = 796860912, sk_attno = 32765, sk_strategy = 0, sk_subtype = 2646600576, sk_collation = 22021, sk_func = {fn_addr = 0x60, fn_oid = 2646602352, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffd2f7f21f0, fn_mcxt = 0x56059b4d0631 , fn_expr = 0x7f2be26d4b40}, sk_argument = 94582081102317}, {sk_flags = 796860912, sk_attno = 32765, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 22016, fn_strict = 4, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x56059b588d00 , fn_mcxt = 0x60, fn_expr = 0x56059dbfeb00}, sk_argument = 94582121427568}, {sk_flags = -1648365056, sk_attno = 22021, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x56059b589100 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 152 '\230', fn_extra = 0x56059b4d0623 , fn_mcxt = 0x1000400000065, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = -1648372208, sk_attno = 22021, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2603523713, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x56059aff7949 , fn_mcxt = 0x56059dbff270, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = -1648364864, sk_attno = 22021, sk_strategy = 0, sk_subtype = 796861184, sk_collation = 32765, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x0, fn_mcxt = 0x56059b0210e1 , fn_expr = 0x0}, sk_argument = 94582070849692}, {sk_flags = 796861904, sk_attno = 32765, sk_strategy = 0, sk_subtype = 2605976233, sk_collation = 22021, sk_func = {fn_addr = 0x1600000001, fn_oid = 2605974736, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 24 '\030', fn_extra = 0x7f2be2440918, fn_mcxt = 0x7f2be2440920, fn_expr = 0x56059c180138 }, sk_argument = 1406730386}, {sk_flags = -1688971646, sk_attno = 22021, sk_strategy = 0, sk_subtype = 2618809864, sk_collation = 0, sk_func = {fn_addr = 0x2, fn_oid = 2638044672, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 112 'p', fn_extra = 0x10000001c, fn_mcxt = 0x60, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 796861904, sk_attno = 32765, sk_strategy = 0, sk_subtype = 2606586493, sk_collation = 1406730386, sk_func = {fn_addr = 0x17, fn_oid = 2596008551, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 16 '\020', fn_extra = 0x7f2be2453e08, fn_mcxt = 0x7ffd2f7f2460, fn_expr = 0x7f2be2453d78}, sk_argument = 94582122242456}, {sk_flags = -1688681277, sk_attno = 22021, sk_strategy = 0, sk_subtype = 3796188536, sk_collation = 32555, sk_func = {fn_addr = 0x7f2be2453d38, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 152 '\230', fn_extra = 0x1, fn_mcxt = 0x56059b542a76 , fn_expr = 0x1}, sk_argument = 94582121422144}, {sk_flags = 37577, sk_attno = 0, sk_strategy = 0, sk_subtype = 2605994567, sk_collation = 22021, sk_func = {fn_addr = 0x7ffd2f7f2460, fn_oid = 2606176123, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x56059b4d54ae , fn_mcxt = 0x56059dbff270, fn_expr = 0x56059dc839c8}, sk_argument = 2}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 2647144200, sk_collation = 22021, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 2646600576, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x56059dc83418, fn_mcxt = 0x56059b540aa9 , fn_expr = 0x7ffd2f7f25e0}, sk_argument = 94582080799952}, {sk_flags = -498792472, sk_attno = 32555, sk_strategy = 0, sk_subtype = 3796174824, sk_collation = 32555, sk_func = {fn_addr = 0x7f2be24507c0, fn_oid = 2638142120, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x56059b5444df , fn_mcxt = 0x56059dc83ad0, fn_expr = 0x92c9}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x6800000000, fn_oid = 37577, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x7f2be2450800, fn_mcxt = 0x7f2be24507c0, fn_expr = 0x2}, sk_argument = 10}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 2605984374, sk_collation = 22021, sk_func = {fn_addr = 0xa, fn_oid = 3796174920, fn_nargs = 32555, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x56059b545247 , fn_mcxt = 0x1, fn_expr = 0x56059b57177b }, sk_argument = 139826456496128}, {sk_flags = -1697266974, sk_attno = 22021, sk_strategy = 0, sk_subtype = 37577, sk_collation = 0, sk_func = {fn_addr = 0x1, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 169 '\251', fn_extra = 0x7f2be24507e8, fn_mcxt = 0x56059b5404d0 , fn_expr = 0x7f2be24507e8}, sk_argument = 139826456496104}, {sk_flags = -498792512, sk_attno = 32555, sk_strategy = 0, sk_subtype = 2638142120, sk_collation = 22021, sk_func = {fn_addr = 0x56059d3ed080, fn_oid = 2605991135, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x56059abc309c , fn_mcxt = 0x0, fn_expr = 0x56059b540aa9 }, sk_argument = 111669149696}, {sk_flags = -1688472014, sk_attno = 22021, sk_strategy = 0, sk_subtype = 2646595088, sk_collation = 22021, sk_func = {fn_addr = 0x328, fn_oid = 7, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 115 's', fn_extra = 0x9d3f5880, fn_mcxt = 0x7, fn_expr = 0x56059c17de08 }, sk_argument = 94582121972600}, {sk_flags = 796862208, sk_attno = 32765, sk_strategy = 0, sk_subtype = 101, sk_collation = 0, sk_func = {fn_addr = 0x7ffd2f7f2708, fn_oid = 3800227080, fn_nargs = 32555, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x56059b5d5a7d , fn_mcxt = 0x7f2be282dd08, fn_expr = 0x7f2be282dcc8}, sk_argument = 139826456509816}, {sk_flags = -494740144, sk_attno = 32555, sk_strategy = 0, sk_subtype = 3800227080, sk_collation = 32555, sk_func = {fn_addr = 0x56059b542a76 , fn_oid = 2647147384, fn_nargs = 22021, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x7ffd2f7f26f0, fn_mcxt = 0x56059b545247 , fn_expr = 0x7f2be282dd08}, sk_argument = 94582081322741}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 2606501103, sk_collation = 22021, sk_func = {fn_addr = 0x56059dc84588, fn_oid = 1, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x7ffd2f7f2850, fn_mcxt = 0x7ffd2f7f2800, fn_expr = 0x7ffd2f7f2808}, sk_argument = 0}, {sk_flags = 66, sk_attno = 0, sk_strategy = 0, sk_subtype = 97, sk_collation = 0, sk_func = {fn_addr = 0x56059b4cf331 , 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 = 136 '\210', fn_extra = 0x7f2be2454148, fn_mcxt = 0x7f2be2453d78, fn_expr = 0x7f2be2453d38}, sk_argument = 523}, {sk_flags = 796862704, sk_attno = 32765, sk_strategy = 0, sk_subtype = 796862688, sk_collation = 32765, sk_func = {fn_addr = 0xe29b542a76, 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 = 149 '\225', fn_extra = 0x56059b5bf632 , fn_mcxt = 0x56059dcd4e80, fn_expr = 0x40}, sk_argument = 3}, {sk_flags = -1688467597, sk_attno = 22021, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 2647477888, 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}} [17:29:25.026] keysz = 1 [17:29:25.026] i = [17:29:25.026] status = [17:29:25.026] strat_total = 1 [17:29:25.026] currItem = [17:29:25.026] blkno = 32765 [17:29:25.026] __func__ = "_bt_first" [17:29:25.026] #7 0x000056059ac96177 in btgettuple (scan=0x56059dc4d010, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [17:29:25.026] so = 0x56059dcfab98 [17:29:25.026] res = [17:29:25.026] #8 0x000056059ac7cd73 in index_getnext_tid (scan=scan@entry=0x56059dc4d010, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [17:29:25.026] found = [17:29:25.026] __func__ = "index_getnext_tid" [17:29:25.026] #9 0x000056059b4c5332 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x7f2be2454ee8, indexRel=indexRel@entry=0x7f2be2454588, indexscandir=indexscandir@entry=BackwardScanDirection, scankeys=scankeys@entry=0x7ffd2f7f3670, typLen=, typByVal=, tableslot=0x56059dc4cf00, outercontext=0x56059d3759e0, endpointDatum=0x56059dcca500) at ../src/backend/utils/adt/selfuncs.c:6349 [17:29:25.026] have_data = false [17:29:25.026] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 22021, xmax = 2605991135, xip = 0x4000, xcnt = 23, subxip = 0x0, subxcnt = 0, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0x56059c174720 , active_count = 23, regd_count = 0, ph_node = {first_child = 0x0, next_sibling = 0x7f2be282dd08, prev_or_parent = 0x7f2be282dcc8}, whenTaken = 23, lsn = 94582121745920, snapXactCompletionCount = 140725400320208} [17:29:25.026] index_scan = 0x56059dc4d010 [17:29:25.026] vmbuffer = 0 [17:29:25.026] last_heap_block = 4294967295 [17:29:25.026] n_visited_heap_pages = 0 [17:29:25.026] tid = [17:29:25.026] values = {68719476752, 9, 94582122374016, 94582122244880, 94582122372864, 94582081409931, 94582122374016, 94582081320498, 94582112475616, 10, 1, 94582081324915, 2647549128, 1, 94582122372864, 94582081145625, 140725400319344, 139826533175328, 2637652736, 0, 0, 94582112861360, 6932617696, 94582112858032, 140725400319344, 0, 0, 94582080801449, 94582112480168, 94582080799952, 139826460548336, 139826460548336} [17:29:25.026] isnull = {false, 95, 206, 157, false, false, false, false, true, false, false, false, 25, 31, 55, 224, 2, false, false, false, false, false, false, false, false, 95, 206, 157, 5, 86, false, false} [17:29:25.026] oldcontext = [17:29:25.026] __func__ = "get_actual_variable_endpoint" [17:29:25.026] #10 0x000056059b4c5b19 in get_actual_variable_range (root=root@entry=0x56059dcc8ac8, vardata=vardata@entry=0x7ffd2f7f38d0, sortop=97, collation=collation@entry=0, min=min@entry=0x0, max=0x56059dcca500) at ../src/backend/utils/adt/selfuncs.c:6228 [17:29:25.026] tmpcontext = 0x56059dc4ce00 [17:29:25.026] oldcontext = 0x56059d3759e0 [17:29:25.026] heapRel = 0x7f2be2454ee8 [17:29:25.026] slot = 0x56059dc4cf00 [17:29:25.026] typLen = 4 [17:29:25.026] indexRel = 0x7f2be2454588 [17:29:25.026] typByVal = true [17:29:25.026] 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}} [17:29:25.026] index = [17:29:25.026] indexscandir = ForwardScanDirection [17:29:25.026] lc__state = [17:29:25.026] have_data = true [17:29:25.026] rel = [17:29:25.026] rte = [17:29:25.026] lc = [17:29:25.026] #11 0x000056059b4d0883 in ineq_histogram_selectivity (root=root@entry=0x56059dcc8ac8, vardata=vardata@entry=0x7ffd2f7f38d0, opoid=opoid@entry=523, opproc=opproc@entry=0x7ffd2f7f3830, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [17:29:25.026] probe = 100 [17:29:25.026] ltcmp = [17:29:25.026] histfrac = [17:29:25.026] lobound = 99 [17:29:25.026] hibound = 101 [17:29:25.026] have_end = false [17:29:25.026] hist_selec = -1 [17:29:25.026] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x56059dcca1e0, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [17:29:25.026] #12 0x000056059b4d0ef4 in scalarineqsel (root=root@entry=0x56059dcc8ac8, operator=operator@entry=523, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=collation@entry=0, vardata=vardata@entry=0x7ffd2f7f38d0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [17:29:25.026] stats = 0x7f2be2453dc0 [17:29:25.026] opproc = {fn_addr = 0x56059b3c884e , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x56059d3759e0, fn_expr = 0x0} [17:29:25.026] mcv_selec = 0 [17:29:25.026] hist_selec = [17:29:25.026] sumcommon = 0 [17:29:25.026] selec = [17:29:25.026] #13 0x000056059b4d1413 in scalarineqsel_wrapper (fcinfo=, isgt=isgt@entry=false, iseq=iseq@entry=true) at ../src/backend/utils/adt/selfuncs.c:1459 [17:29:25.026] root = 0x56059dcc8ac8 [17:29:25.026] operator = 523 [17:29:25.026] args = [17:29:25.026] varRelid = [17:29:25.026] collation = 0 [17:29:25.026] vardata = {var = 0x56059dcc8fa8, rel = 0x56059d3776a0, statsTuple = 0x7f2be2453d78, freefunc = 0x56059b571772 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [17:29:25.026] other = 0x56059dd29038 [17:29:25.026] varonleft = true [17:29:25.026] constval = 100000010 [17:29:25.026] consttype = 23 [17:29:25.026] selec = [17:29:25.026] #14 0x000056059b4d1552 in scalarlesel (fcinfo=) at ../src/backend/utils/adt/selfuncs.c:1482 [17:29:25.026] No locals. [17:29:25.026] #15 0x000056059b58a1ed in FunctionCall4Coll (flinfo=flinfo@entry=0x7ffd2f7f39c0, collation=collation@entry=0, arg1=arg1@entry=94582122253000, arg2=arg2@entry=523, arg3=arg3@entry=94582122254728, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [17:29:25.026] fcinfodata = {fcinfo = {flinfo = 0x7ffd2f7f39c0, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x7ffd2f7f3970}, fcinfo_data = "\3009\177/\375\177", '\000' , "V\004\000Ȋ̝\005V\000\000\000\215X\233\005V\000\000\v\002\000\000\000\000\000\000\000\212̝\005V\000\000\210\221̝\005V\000\000\000\221̝\005V", '\000' , "\221X\233\005V\000"} [17:29:25.026] fcinfo = 0x7ffd2f7f3950 [17:29:25.026] result = [17:29:25.026] __func__ = "FunctionCall4Coll" [17:29:25.026] #16 0x000056059b58a998 in OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=94582122253000, arg2=arg2@entry=523, arg3=arg3@entry=94582122254728, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [17:29:25.026] flinfo = {fn_addr = 0x56059b4d153f , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x56059d3759e0, fn_expr = 0x0} [17:29:25.026] #17 0x000056059b0ea260 in restriction_selectivity (root=root@entry=0x56059dcc8ac8, operatorid=operatorid@entry=523, args=0x56059dcc9188, inputcollid=0, varRelid=varRelid@entry=0) at ../src/include/postgres.h:324 [17:29:25.026] oprrest = [17:29:25.026] result = [17:29:25.026] __func__ = "restriction_selectivity" [17:29:25.026] #18 0x000056059b0185f0 in clause_selectivity_ext (root=root@entry=0x56059dcc8ac8, clause=0x56059dcc9228, clause@entry=0x56059dcc9e60, 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 [17:29:25.026] opclause = 0x56059dcc9228 [17:29:25.026] opno = 523 [17:29:25.026] s1 = 0.5 [17:29:25.026] rinfo = 0x56059dcc9e60 [17:29:25.026] cacheable = true [17:29:25.026] #19 0x000056059b018f5f in clauselist_selectivity_ext (root=root@entry=0x56059dcc8ac8, clauses=0x56059dcc9e10, 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 [17:29:25.026] clause = 0x56059dcc9e60 [17:29:25.026] rinfo = [17:29:25.026] s2 = [17:29:25.026] l__state = [17:29:25.026] s1 = 1 [17:29:25.026] rel = [17:29:25.026] estimatedclauses = 0x0 [17:29:25.026] rqlist = 0x56059dd28fe8 [17:29:25.026] l = [17:29:25.026] listidx = 1 [17:29:25.026] #20 0x000056059b019242 in clauselist_selectivity (root=root@entry=0x56059dcc8ac8, clauses=, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [17:29:25.026] No locals. [17:29:25.026] #21 0x000056059b028618 in set_baserel_size_estimates (root=root@entry=0x56059dcc8ac8, rel=rel@entry=0x56059d3776a0) at ../src/backend/optimizer/path/costsize.c:5286 [17:29:25.026] nrows = [17:29:25.026] #22 0x000056059b00d11e in set_plain_rel_size (root=root@entry=0x56059dcc8ac8, rel=rel@entry=0x56059d3776a0, rte=rte@entry=0x56059d376ba8) at ../src/backend/optimizer/path/allpaths.c:581 [17:29:25.026] No locals. [17:29:25.026] #23 0x000056059b01338e in set_rel_size (root=root@entry=0x56059dcc8ac8, rel=rel@entry=0x56059d3776a0, rti=rti@entry=1, rte=rte@entry=0x56059d376ba8) at ../src/backend/optimizer/path/allpaths.c:411 [17:29:25.026] __func__ = "set_rel_size" [17:29:25.026] #24 0x000056059b013577 in set_base_rel_sizes (root=root@entry=0x56059dcc8ac8) at ../src/backend/optimizer/path/allpaths.c:322 [17:29:25.026] rel = 0x56059d3776a0 [17:29:25.026] rte = 0x56059d376ba8 [17:29:25.026] rti = 1 [17:29:25.026] #25 0x000056059b01757d in make_one_rel (root=root@entry=0x56059dcc8ac8, joinlist=joinlist@entry=0x56059dcc9c10) at ../src/backend/optimizer/path/allpaths.c:183 [17:29:25.026] rel = [17:29:25.026] rti = [17:29:25.026] total_pages = [17:29:25.026] #26 0x000056059b07b275 in query_planner (root=root@entry=0x56059dcc8ac8, qp_callback=qp_callback@entry=0x56059b0805ce , qp_extra=qp_extra@entry=0x7ffd2f7f3d20) at ../src/backend/optimizer/plan/planmain.c:280 [17:29:25.026] parse = 0x56059d376998 [17:29:25.026] joinlist = 0x56059dcc9c10 [17:29:25.026] final_rel = [17:29:25.026] __func__ = "query_planner" [17:29:25.026] #27 0x000056059b08db38 in grouping_planner (root=root@entry=0x56059dcc8ac8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [17:29:25.026] sort_input_targets = 0x56059dcc9278 [17:29:25.026] sort_input_target_parallel_safe = [17:29:25.026] grouping_target = [17:29:25.026] scanjoin_target = [17:29:25.026] activeWindows = 0x0 [17:29:25.026] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [17:29:25.026] sort_input_targets_contain_srfs = 0x2 [17:29:25.026] have_grouping = [17:29:25.026] wflists = 0x0 [17:29:25.026] gset_data = 0x0 [17:29:25.026] sort_input_target = [17:29:25.026] grouping_targets = 0x56059d376998 [17:29:25.026] grouping_target_parallel_safe = [17:29:25.026] scanjoin_targets = 0x56059dcc8ac8 [17:29:25.026] scanjoin_target_parallel_safe = [17:29:25.026] grouping_targets_contain_srfs = 0x56059dcc9318 [17:29:25.026] scanjoin_targets_contain_srfs = 0x0 [17:29:25.026] scanjoin_target_same_exprs = [17:29:25.026] parse = 0x56059d376998 [17:29:25.026] offset_est = 0 [17:29:25.026] count_est = 0 [17:29:25.026] limit_tuples = -1 [17:29:25.026] have_postponed_srfs = false [17:29:25.026] final_target = [17:29:25.026] final_targets = 0x56059d377620 [17:29:25.026] final_targets_contain_srfs = 0x56059b0c3494 [17:29:25.026] final_target_parallel_safe = [17:29:25.026] current_rel = [17:29:25.026] final_rel = [17:29:25.026] extra = {limit_needed = 192, limit_tuples = 4.6729777315964182e-310, count_est = 94582122255128, offset_est = 94582122253000} [17:29:25.026] lc = [17:29:25.026] __func__ = "grouping_planner" [17:29:25.026] #28 0x000056059b09096b in subquery_planner (glob=glob@entry=0x56059d376888, parse=parse@entry=0x56059d376998, 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 [17:29:25.026] root = 0x56059dcc8ac8 [17:29:25.026] newWithCheckOptions = [17:29:25.026] newHaving = [17:29:25.026] hasOuterJoins = [17:29:25.026] hasResultRTEs = false [17:29:25.026] final_rel = [17:29:25.026] l = 0x0 [17:29:25.026] #29 0x000056059b0915fc in standard_planner (parse=parse@entry=0x56059d376998, query_string=query_string@entry=0x56059d375ae0 "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 [17:29:25.026] result = [17:29:25.026] glob = 0x56059d376888 [17:29:25.026] tuple_fraction = 0 [17:29:25.026] root = [17:29:25.026] final_rel = [17:29:25.026] best_path = [17:29:25.026] top_plan = [17:29:25.026] lp = [17:29:25.026] lr = [17:29:25.026] #30 0x00007f2be43e6551 in pgss_planner (parse=0x56059d376998, query_string=0x56059d375ae0 "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 [17:29:25.026] _save_exception_stack = 0x7ffd2f7f4380 [17:29:25.026] _save_context_stack = 0x0 [17:29:25.026] _local_sigjmp_buf = {{__jmpbuf = {94582112479640, -6855083192256057213, 0, 2048, 0, 94582112475872, -924154122753298301, -972451812856713085}, __mask_was_saved = 0, __saved_mask = {__val = {1, 0, 94582112479640, 9166180295724421508, 94582081411709, 0, 94582075205763, 0, 94582112479640, 0, 94582075208382, 0, 0, 94582122252840, 94582077664852, 0}}}} [17:29:25.026] _do_rethrow = false [17:29:25.026] result = 0x56059b5444df [17:29:25.026] #31 0x000056059b09265c in planner (parse=parse@entry=0x56059d376998, query_string=query_string@entry=0x56059d375ae0 "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 [17:29:25.026] result = [17:29:25.026] #32 0x000056059b2ebcb6 in pg_plan_query (querytree=querytree@entry=0x56059d376998, query_string=query_string@entry=0x56059d375ae0 "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 [17:29:25.026] plan = [17:29:25.026] #33 0x000056059b2ec097 in pg_plan_queries (querytrees=0x56059dcc8a78, query_string=query_string@entry=0x56059d375ae0 "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 [17:29:25.026] query = 0x56059d376998 [17:29:25.026] stmt = [17:29:25.026] query_list__state = [17:29:25.026] stmt_list = 0x0 [17:29:25.026] query_list = [17:29:25.026] #34 0x000056059b2ec644 in exec_simple_query (query_string=query_string@entry=0x56059d375ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [17:29:25.026] cmdtaglen = 6 [17:29:25.026] snapshot_set = true [17:29:25.026] per_parsetree_context = 0x0 [17:29:25.026] plantree_list = [17:29:25.026] parsetree = 0x56059d376808 [17:29:25.026] commandTag = CMDTAG_DELETE [17:29:25.026] qc = {commandTag = CMDTAG_CREATE_SUBSCRIPTION, nprocessed = 94582112475872} [17:29:25.026] querytree_list = [17:29:25.026] portal = [17:29:25.026] receiver = [17:29:25.026] format = 0 [17:29:25.026] cmdtagname = [17:29:25.026] parsetree_item__state = [17:29:25.026] dest = DestRemote [17:29:25.026] oldcontext = 0x56059d409450 [17:29:25.026] parsetree_list = 0x56059d376838 [17:29:25.026] parsetree_item = 0x56059d376850 [17:29:25.026] save_log_statement_stats = false [17:29:25.026] was_logged = true [17:29:25.026] use_implicit_block = false [17:29:25.026] msec_str = "0E\177/\375\177\000\0008$Z\233\005V\000\000`C\177/\375\177\000\000W\000\000\000\000\000\000" [17:29:25.026] __func__ = "exec_simple_query" [17:29:25.026] #35 0x000056059b2ef265 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [17:29:25.026] query_string = 0x56059d375ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [17:29:25.026] firstchar = [17:29:25.026] input_message = {data = 0x56059d375ae0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [17:29:25.026] local_sigjmp_buf = {{__jmpbuf = {94582093644024, -6855085053314879357, 4, 140725400323376, 140725400323520, 140725400323524, -924154125085331325, -6855087644547895165}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94582112725456, 0, 168, 94582081325017, 0, 10, 2, 94582093644032, 94582112206464, 94582093638112, 140725400323376, 140725400323520, 140725400323524}}}} [17:29:25.026] send_ready_for_query = false [17:29:25.026] idle_in_transaction_timeout_enabled = false [17:29:25.026] idle_session_timeout_enabled = false [17:29:25.026] __func__ = "PostgresMain" [17:29:25.026] #36 0x000056059b2e5387 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [17:29:25.026] bsdata = [17:29:25.026] #37 0x000056059b19ddbe in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd2f7f44dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd2f7f4530) at ../src/backend/postmaster/launch_backend.c:274 [17:29:25.026] pid = [17:29:25.026] #38 0x000056059b1a386a in BackendStartup (client_sock=client_sock@entry=0x7ffd2f7f4530) at ../src/backend/postmaster/postmaster.c:3414 [17:29:25.026] bn = 0x56059d3a2738 [17:29:25.026] pid = [17:29:25.026] startup_data = {canAcceptConnections = CAC_OK} [17:29:25.026] __func__ = "BackendStartup" [17:29:25.026] #39 0x000056059b1a3dcc in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [17:29:25.026] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\302\346+\177\000\000\364E\177/\375\177\000\000\312\340]\350+\177\000\000>\004\000\000\000\000\000\000\260\227\303\346+\177\000\000\240o\025\350+\177\000\000\370E\177/\375\177\000\000\364E\177/\375\177\000\000\000\000\000\000\000\000\000\000\220E\177/\375\177\000\000\303K7\232\005V\000\000\02073\232\005V\000\000\300F\177/\375\177\000\000\270F\177/\375\177\000\000\225[\362\001\000\000\000", __ss_align = 94582112647936}, salen = 2}} [17:29:25.026] i = 0 [17:29:25.026] now = [17:29:25.026] last_lockfile_recheck_time = 1725211592 [17:29:25.026] last_touch_time = 1725211532 [17:29:25.026] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f2be86082e0}, {pos = 796870200, events = 0, fd = 0, user_data = 0x7f2be8608668}, {pos = -1707652157, events = 22021, fd = -396327320, user_data = 0x7f2be7444630}, {pos = -396328224, events = 32555, fd = 2090263927, user_data = 0x7ffd2f7f4740}, {pos = -396498360, events = 32555, fd = 15, user_data = 0x7f2be7444630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -396328224, events = 32555, fd = 796870328, user_data = 0x7ffd2f7f46c0}, {pos = -396327320, events = 32555, fd = 0, user_data = 0x56059d3a1398}, {pos = -1657138568, events = 22021, fd = -1657120479, user_data = 0x7f2b00000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f2be6c2e020}, {pos = -401248352, events = 32555, fd = -1657138280, user_data = 0x7ffd2f7f4ab0}, {pos = -1657120312, events = 22021, fd = -1657118384, user_data = 0x56059d3a1398}, {pos = -396328224, events = 32555, fd = 439, user_data = 0x56059bae6db8 }, {pos = 0, events = 0, fd = 1, user_data = 0x56059d377920}, {pos = -396472642, events = 32555, fd = 1, user_data = 0x0}, {pos = -423436256, events = 32555, fd = -422629952, user_data = 0x7ffd2f7f4b20}, {pos = 796871424, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -396463686, user_data = 0x0}, {pos = -422908636, events = 32555, fd = 0, user_data = 0x56059c171ac0 }, {pos = 2, events = 0, fd = 7, user_data = 0x56059d337f20}, {pos = 1952410737, events = 28781, fd = -423402296, user_data = 0x7f2be6c9c880 }, {pos = -415015496, events = 32555, fd = 8096, user_data = 0x100007f00000002}, {pos = -422875155, events = 32555, fd = 2, user_data = 0x56059d3aa990}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -421585824, events = 32555, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x56059d337f20}, {pos = -422872566, events = 32555, fd = 1769300525, user_data = 0x56059d337f20}, {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 = 0x3139352f0a202020}, {pos = 1633182986, events = 1429222223, fd = 0, user_data = 0x0}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -414866112, user_data = 0x7f2be745aa80}, {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 = 0xf5113314db75500}, {pos = -421599776, events = 32555, fd = -328, user_data = 0x0}, {pos = -1657138888, events = 22021, fd = 1024, user_data = 0x56059d3a1138}, {pos = 796871608, events = 32765, fd = -422871393, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 22202, events = 0, fd = -328, user_data = 0x0}, {pos = -1657308896, events = 22021, fd = -422629421, user_data = 0x7ffd2f7f4bb8}, {pos = -1688388698, events = 22021, fd = -1676148560, user_data = 0x56059b5c2663 }, {pos = -1657139088, events = 22021, fd = -1657316896, user_data = 0x56059d3a1070}, {pos = -422881218, events = 32555, fd = 0, user_data = 0x56059b5d42cd }, {pos = -1657139088, events = 1, fd = -1688386538, user_data = 0x56059d3759e0}, {pos = 1303860480, events = 256971569, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -422958415, user_data = 0x7f2be6ca14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1303860480, user_data = 0x56059d34d110}, {pos = 1303860480, events = 256971569, fd = 11, user_data = 0xf5113314db75500}, {pos = 0, events = 0, fd = -423251399, user_data = 0x1}, {pos = -1692804421, events = 22021, fd = 4194304, user_data = 0x56059b5c24f7 }, {pos = -1657482992, events = 22021, fd = -1657316896, user_data = 0x56059d34d110}, {pos = 1, events = 0, fd = 0, user_data = 0x56059b5d42cd }, {pos = -1657482992, events = 22021, fd = -1688386538, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x56059afd6661 }, {pos = 0, events = 0, fd = -1694647893, user_data = 0xb}, {pos = -1692783272, events = 22021, fd = -1679734640, user_data = 0x56059d376398}} [17:29:25.026] nevents = 1 [17:29:25.026] __func__ = "ServerLoop" [17:29:25.026] #40 0x000056059b1a5542 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x56059d333d80) at ../src/backend/postmaster/postmaster.c:1346 [17:29:25.026] opt = [17:29:25.026] status = [17:29:25.026] userDoption = [17:29:25.026] listen_addr_saved = false [17:29:25.026] output_config_variable = [17:29:25.026] __func__ = "PostmasterMain" [17:29:25.026] #41 0x000056059afe6a8c in main (argc=4, argv=0x56059d333d80) at ../src/backend/main/main.c:197 [17:29:25.026] do_check_root = [17:29:25.048] -e [17:29:25.048] [17:29:25.048] [17:29:25.115] dumping /tmp/cores/postgres-6-25490.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [17:29:25.366] [New LWP 25490] [17:29:25.366] [17:29:25.366] This GDB supports auto-downloading debuginfo from the following URLs: [17:29:25.366] [17:29:25.366] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [17:29:25.366] Debuginfod has been disabled. [17:29:25.366] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [17:29:25.470] [Thread debugging using libthread_db enabled] [17:29:25.470] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [17:29:25.470] Core was generated by `postgres: old_node: postgres regression [local] DELETE '. [17:29:25.470] Program terminated with signal SIGABRT, Aborted. [17:29:25.470] #0 0x00007f7a522a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:25.638] [17:29:25.638] Thread 1 (Thread 0x7f7a521d4f00 (LWP 25490)): [17:29:25.638] #0 0x00007f7a522a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:25.638] No symbol table info available. [17:29:25.638] #1 0x00007f7a5225afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:25.638] No symbol table info available. [17:29:25.638] #2 0x00007f7a52245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:25.638] No symbol table info available. [17:29:25.638] #3 0x0000556800cc472c in ExceptionalCondition (conditionName=conditionName@entry=0x556800eedf48 "!BTScanPosIsPinned(so->currPos)", fileName=fileName@entry=0x556800eeddc8 "../src/backend/access/nbtree/nbtsearch.c", lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [17:29:25.638] No locals. [17:29:25.638] #4 0x00005568003e3368 in _bt_readnextpage (scan=scan@entry=0x5568026e7120, blkno=, expectNext=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [17:29:25.638] so = 0x5568027c6f48 [17:29:25.638] rel = 0x7f7a46851608 [17:29:25.638] page = [17:29:25.638] opaque = [17:29:25.638] status = [17:29:25.638] #5 0x00005568003e3c99 in _bt_steppage (scan=scan@entry=0x5568026e7120, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [17:29:25.638] so = 0x5568027c6f48 [17:29:25.638] blkno = 2 [17:29:25.638] expectNext = 4 [17:29:25.638] status = [17:29:25.638] #6 0x00005568003e70ae in _bt_first (scan=scan@entry=0x5568026e7120, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [17:29:25.638] rel = 0x7f7a46851608 [17:29:25.638] so = 0x5568027c6f48 [17:29:25.638] buf = 4349 [17:29:25.638] stack = [17:29:25.638] offnum = [17:29:25.638] strat = [17:29:25.638] 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 = 0x5568003c6b43 , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5568026e6f10, fn_expr = 0x5568027976a8}, 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 = 16671034, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 176 '\260', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x55680279e300}, 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 = 192 '\300', fn_extra = 0x1, fn_mcxt = 0x5, fn_expr = 0x1}, sk_argument = 72057594037927936}, {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 = 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 = 41547777, sk_collation = 21864, sk_func = {fn_addr = 0x0, fn_oid = 10690177, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x556800793026 , fn_mcxt = 0x5568027b83c8, fn_expr = 0x101000000000003}, sk_argument = 93905206617688}, {sk_flags = 41547896, sk_attno = 21760, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 226, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x5568009b29ec , fn_expr = 0x0}, sk_argument = 93905175649921}, {sk_flags = 16210912, sk_attno = 21864, sk_strategy = 0, sk_subtype = 10690177, sk_collation = 21864, sk_func = {fn_addr = 0x35a0, fn_oid = 7600457, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 160 '\240', fn_extra = 0x5568027abf78, fn_mcxt = 0x5568027abf10, fn_expr = 0x5568027ad398}, sk_argument = 93905206563816}, {sk_flags = 1034234848, sk_attno = 32765, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 41682704, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 27 '\033', fn_extra = 0x5568007e4e6d , fn_mcxt = 0x5568027ad398, fn_expr = 0x5568007e4e6d }, sk_argument = 140725637688288}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5568027c0710, fn_oid = 7604335, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 60 '<', fn_extra = 0x5568027abec0, fn_mcxt = 0x5568027abf78, fn_expr = 0x556802777200}, sk_argument = 93905206563736}, {sk_flags = 1034234848, sk_attno = 32765, 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 = 13661746, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x40, fn_mcxt = 0x3, fn_expr = 0x556800d08773 }, sk_argument = 41381824}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 1187139000, sk_collation = 16809850, 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 = 1034234880, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 80 'P', fn_extra = 0x5568009d9465 , fn_mcxt = 0x7f7a4f620ac0, fn_expr = 0x5568009d9e62 }, sk_argument = 93905205686312}, {sk_flags = 27544, sk_attno = 21864, sk_strategy = 0, sk_subtype = 1034235200, sk_collation = 32765, sk_func = {fn_addr = 0x5500018bc720, 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 = 93905175128556}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 13731, sk_func = {fn_addr = 0x556800f75be0, fn_oid = 1304547328, fn_nargs = 32634, fn_strict = false, fn_retset = false, fn_stats = 163 '\243', fn_extra = 0x0, fn_mcxt = 0x35a3, fn_expr = 0x556800a081ed }, sk_argument = 13731}, {sk_flags = 10176416, sk_attno = 21864, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f7a4dc1d000, fn_oid = 1183129448, fn_nargs = 32634, fn_strict = false, fn_retset = false, fn_stats = 45 '-', fn_extra = 0x1, fn_mcxt = 0x556800a6f487 , 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 = 10939063, sk_attno = 21864, 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 = 164 '\244', fn_extra = 0x7f7a470aeb00, fn_mcxt = 0x3, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 10941575, sk_collation = 21864, sk_func = {fn_addr = 0x7ffd3da52ea0, fn_oid = 1191897857, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 160 '\240', fn_extra = 0x7f7a470aeb00, fn_mcxt = 0x55680274ace8, fn_expr = 0x556800a6f65e }, sk_argument = 1191897857}, {sk_flags = 10205914, sk_attno = 21864, sk_strategy = 0, sk_subtype = 1034235548, sk_collation = 32765, sk_func = {fn_addr = 0x7ffd3da52e9c, fn_oid = 1188474752, fn_nargs = 32634, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x3da52e07, fn_mcxt = 0xcdf071f100000002, 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 = 37536, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1003e180e, fn_mcxt = 0x3e0, fn_expr = 0x7f7a46851f68}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 41200872, sk_collation = 21864, sk_func = {fn_addr = 0x7f7a522b6e87, fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x6b0, fn_mcxt = 0x7f7a522b6fed, fn_expr = 0x0}, sk_argument = 93905206524864}, {sk_flags = 1027, sk_attno = 0, sk_strategy = 0, sk_subtype = 114, sk_collation = 4294967295, sk_func = {fn_addr = 0x6ae0, fn_oid = 1379867744, fn_nargs = 32634, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 140163145864712}, {sk_flags = 1378581002, sk_attno = 32634, sk_strategy = 0, sk_subtype = 27416, sk_collation = 0, sk_func = {fn_addr = 0x556800d0781d , fn_oid = 40791824, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x556800d0781d , fn_expr = 0x5568026e6f10}, sk_argument = 16384}, {sk_flags = 1034236512, sk_attno = 32765, sk_strategy = 0, sk_subtype = 40792024, sk_collation = 21864, sk_func = {fn_addr = 0x0, fn_oid = 13665711, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 16 '\020', fn_extra = 0x10, fn_mcxt = 0x1, fn_expr = 0x5568027c6f48}, sk_argument = 93905205752096}}} [17:29:25.638] startKeys = {0x5568026e72c0, 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} [17:29:25.638] notnullkeys = {{sk_flags = 40681760, sk_attno = 21864, sk_strategy = 0, sk_subtype = 40682128, sk_collation = 21864, sk_func = {fn_addr = 0x7ffd3da51df0, fn_oid = 1034231072, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffd3da51de8, fn_mcxt = 0x5568026cc120, fn_expr = 0x55680080c051 }, sk_argument = 93905206879496}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x7ffd3da51de8, fn_oid = 1034231152, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 207 '\317', fn_extra = 0x5568026cc290, fn_mcxt = 0x5568026cbb50, fn_expr = 0x0}, sk_argument = 93905205751568}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 40682128, sk_collation = 21864, sk_func = {fn_addr = 0x7ffd3da51df0, fn_oid = 40680272, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffd3da51de8, fn_mcxt = 0x5568026cc120, fn_expr = 0x55680081163d }, 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 = 232 '\350', fn_extra = 0x5568026cc120, fn_mcxt = 0x556800c15ebd , fn_expr = 0x550000000101}, sk_argument = 0}, {sk_flags = 1183124984, sk_attno = 32634, sk_strategy = 0, sk_subtype = 1183124920, sk_collation = 32634, sk_func = {fn_addr = 0x5568026cbb50, fn_oid = 40682048, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x556800c8aa76 , fn_mcxt = 0x4684de20, fn_expr = 0x3f50624dd2f1a9fc}, sk_argument = 96}, {sk_flags = 13161031, sk_attno = 21864, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x556800cb977b , fn_oid = 40680272, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 233 '\351', fn_extra = 0x1007ffd3da51fa0, fn_mcxt = 0x5568027fa6b8, fn_expr = 0x5568026cc120}, sk_argument = 93905206638264}, {sk_flags = 1183124984, sk_attno = 32634, sk_strategy = 0, sk_subtype = 13342578, sk_collation = 21864, sk_func = {fn_addr = 0x1700000017, fn_oid = 4294967295, fn_nargs = 257, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x7ffd3da51ee0, fn_mcxt = 0x5568026cbb50, fn_expr = 0x60}, sk_argument = 93905205641792}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 1034231520, sk_collation = 32765, sk_func = {fn_addr = 0x556800c18631 , fn_oid = 1185752832, fn_nargs = 32634, fn_strict = false, fn_retset = false, fn_stats = 237 '\355', fn_extra = 0x7ffd3da51ee0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 1219358395203584}, {sk_flags = 40680272, sk_attno = 21864, sk_strategy = 0, sk_subtype = 13438208, sk_collation = 21864, sk_func = {fn_addr = 0x60, fn_oid = 40680192, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x5568026cc200, fn_mcxt = 0x2, fn_expr = 0x556800cd1100 }, sk_argument = 0}, {sk_flags = 13445528, sk_attno = 21864, sk_strategy = 0, sk_subtype = 12682787, sk_collation = 21864, sk_func = {fn_addr = 0x1000400000065, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5568026ca5e0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 93905175649921}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 7600457, sk_collation = 21864, sk_func = {fn_addr = 0x5568026cc240, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5568026cc290, fn_mcxt = 0x7ffd3da51ff0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 40680272, sk_attno = 21864, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5568007690e1 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 156 '\234', fn_extra = 0x1, fn_mcxt = 0x556800c88aa9 , fn_expr = 0x1600000001}, sk_argument = 93905178100944}, {sk_flags = 1185763240, sk_attno = 32634, sk_strategy = 0, sk_subtype = 1185763240, sk_collation = 32634, sk_func = {fn_addr = 0x7f7a46ad4fb0, fn_oid = 25985336, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 146 '\222', fn_extra = 0x556800c8d682 , fn_mcxt = 0x18c5e08, fn_expr = 0x2}, sk_argument = 93905197049088}, {sk_flags = 1185689904, sk_attno = 32634, 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 = 0x7ffd3da522c0, fn_mcxt = 0x53d9009200d1da7d, fn_expr = 0x17}, sk_argument = 93905168134759}, {sk_flags = 16, sk_attno = 16, sk_strategy = 0, sk_subtype = 1183125128, sk_collation = 32634, sk_func = {fn_addr = 0x7ffd3da52150, fn_oid = 1183124984, fn_nargs = 32634, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x556800cd44c3 , fn_mcxt = 0x7f7a46850df8, fn_expr = 0x7f7a46850db8}, sk_argument = 1}, {sk_flags = 41679496, sk_attno = 21864, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x556800c8aa76 , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 16 '\020', fn_extra = 0x92a0, fn_mcxt = 0x556800c8d247 , fn_expr = 0x7ffd3da52150}, sk_argument = 93905178302331}, {sk_flags = 40676624, sk_attno = 21864, sk_strategy = 0, sk_subtype = 12702894, sk_collation = 21864, sk_func = {fn_addr = 0x5568026cc240, fn_oid = 41920024, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x1, fn_mcxt = 0x5568027fa358, fn_expr = 0x3ff0000000000000}, sk_argument = 93905205640016}, {sk_flags = 1, sk_attno = 260, sk_strategy = 0, sk_subtype = 41918568, sk_collation = 21864, sk_func = {fn_addr = 0x556800c88aa9 , fn_oid = 1034232528, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0x7f7a4684de08, fn_mcxt = 0x7f7a4684de08, fn_expr = 0x7f7a4684dde0}, sk_argument = 93905197145640}, {sk_flags = 32184192, sk_attno = 21864, sk_strategy = 0, sk_subtype = 13157599, sk_collation = 21864, sk_func = {fn_addr = 0x5568027fa720, fn_oid = 37536, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x556800d07632 , fn_mcxt = 0x5568026ca5e0, fn_expr = 0x6}, sk_argument = 0}, {sk_flags = 13666163, sk_attno = 21864, sk_strategy = 0, sk_subtype = 1183112736, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 245 '\365', fn_extra = 0xdf00e000e100e2, fn_mcxt = 0xdb00dc00dd00de, fn_expr = 0xd700d800d900da}, sk_argument = 59392130632974550}, {sk_flags = 13697234, sk_attno = 208, sk_strategy = 207, sk_subtype = 13435086, sk_collation = 13304012, sk_func = {fn_addr = 0xc700c800c900ca, fn_oid = 12910790, fn_nargs = 196, fn_strict = 195, fn_retset = false, fn_stats = 194 '\302', fn_extra = 0xbb00bc00bd00be, fn_mcxt = 0xb700b800b900ba, fn_expr = 0xb300b400b500b6}, sk_argument = 49258876850208946}, {sk_flags = 11337902, sk_attno = 172, sk_strategy = 171, sk_subtype = 11075754, sk_collation = 10944680, sk_func = {fn_addr = 0xa300a400a500a6, fn_oid = 10551458, fn_nargs = 160, fn_strict = 159, fn_retset = false, fn_stats = 158 '\236', fn_extra = 0x9700980099009a, fn_mcxt = 0x93009400950096, fn_expr = 0x8f009000910092}, sk_argument = 39125623067443342}, {sk_flags = 8978570, sk_attno = 136, sk_strategy = 135, sk_subtype = 8716422, sk_collation = 8585348, sk_func = {fn_addr = 0x7f008000810082, fn_oid = 8192126, fn_nargs = 124, fn_strict = 123, fn_retset = false, fn_stats = 165 '\245', fn_extra = 0x556800d07632 , fn_mcxt = 0x55680279db90, fn_expr = 0x40}, sk_argument = 3}, {sk_flags = 13666163, sk_attno = 21864, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 41540496, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5, fn_mcxt = 0x1, fn_expr = 0x7ffd3da52710}, sk_argument = 140725637686248}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 13752957, sk_collation = 21864, sk_func = {fn_addr = 0x2, fn_oid = 7547011, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55680279e430, fn_mcxt = 0x395, fn_expr = 0x556800732d79 }, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1034235680, sk_collation = 32765, sk_func = {fn_addr = 0x556800e65bcb , fn_oid = 1034235200, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 159 '\237', fn_extra = 0x7ffd3da52d40, fn_mcxt = 0xc8, fn_expr = 0x4fffffffe}, sk_argument = 140725637687040}, {sk_flags = 1034232800, sk_attno = 32765, sk_strategy = 0, sk_subtype = 41540752, sk_collation = 21864, sk_func = {fn_addr = 0x2000002, fn_oid = 13342587, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 200 '\310', fn_extra = 0x556800000000, fn_mcxt = 0x92a7, 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 = 0x153da525b0, fn_mcxt = 0x0, fn_expr = 0x7ffd3da525b0}, sk_argument = 65}, {sk_flags = 520, sk_attno = 0, sk_strategy = 0, sk_subtype = 528, sk_collation = 0, sk_func = {fn_addr = 0x16, fn_oid = 1034233055, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x556800d07632 , fn_mcxt = 0x55680279db90, fn_expr = 0x1a8}, sk_argument = 6}, {sk_flags = 41656776, sk_attno = 21864, sk_strategy = 0, sk_subtype = 41657504, sk_collation = 21864, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 104 'h', fn_extra = 0x7ffd3da525b0, fn_mcxt = 0x556800c136ae , fn_expr = 0x5568027ba1c8}, sk_argument = 93905206608840}, {sk_flags = 41657512, sk_attno = 21864, sk_strategy = 0, sk_subtype = 13752957, sk_collation = 21864, sk_func = {fn_addr = 0x0, fn_oid = 13452556, fn_nargs = 21864, fn_strict = false, fn_retset = false, fn_stats = 80 'P', fn_extra = 0x146853290, fn_mcxt = 0x40d0000000000000, fn_expr = 0x5568027bb0d8}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 41649096, sk_collation = 21864, sk_func = {fn_addr = 0x4089000000000000, fn_oid = 0, fn_nargs = -30848, fn_strict = 195, fn_retset = 64, fn_stats = 86 'V', fn_extra = 0x0, fn_mcxt = 0xe200764b9b, fn_expr = 0xdf00e000e100e2}, sk_argument = 61643964806922462}} [17:29:25.638] keysz = 1 [17:29:25.638] i = [17:29:25.638] status = [17:29:25.638] strat_total = 1 [17:29:25.638] currItem = [17:29:25.638] blkno = 21864 [17:29:25.638] __func__ = "_bt_first" [17:29:25.638] #7 0x00005568003de177 in btgettuple (scan=0x5568026e7120, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [17:29:25.638] so = 0x5568027c6f48 [17:29:25.638] res = [17:29:25.638] #8 0x00005568003c4d73 in index_getnext_tid (scan=scan@entry=0x5568026e7120, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [17:29:25.638] found = [17:29:25.638] __func__ = "index_getnext_tid" [17:29:25.638] #9 0x0000556800c0d332 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x7f7a46851f68, indexRel=indexRel@entry=0x7f7a46851608, indexscandir=indexscandir@entry=BackwardScanDirection, scankeys=scankeys@entry=0x7ffd3da53260, typLen=, typByVal=, tableslot=0x5568026e7010, outercontext=0x556801e389c0, endpointDatum=0x556802775c00) at ../src/backend/utils/adt/selfuncs.c:6349 [17:29:25.638] have_data = false [17:29:25.638] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 21864, xmax = 13157599, xip = 0x4003, xcnt = 23, subxip = 0x0, subxcnt = 0, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0x5568018bc720 , active_count = 23, regd_count = 0, ph_node = {first_child = 0x0, next_sibling = 0x7f7a46c2ad08, prev_or_parent = 0x7f7a46c2acc8}, whenTaken = 23, lsn = 93905205751568, snapXactCompletionCount = 140725637690560} [17:29:25.638] index_scan = 0x5568026e7120 [17:29:25.638] vmbuffer = 0 [17:29:25.638] last_heap_block = 4294967295 [17:29:25.638] n_visited_heap_pages = 0 [17:29:25.638] tid = [17:29:25.638] values = {68719476752, 140725637690272, 93905205634784, 0, 93905205634528, 93905171486792, 93905206346536, 140725637690240, 93905205752352, 140163149156269, 140725637689592, 140725637690272, 93905205634304, 140163149149746, 140163149118663, 93905178446617, 140725637689696, 140163342077984, 1034236836, 0, 2, 93905197040528, 4336353936, 93905197037216, 140725637689696, 0, 0, 93905178102441, 93905196653448, 93905178100944, 140163149901040, 140163149901040} [17:29:25.638] isnull = {false, false, false, false, false, false, false, false, 84, 150, 99, false, 25, 31, 55, 224, false, false, false, false, false, false, false, false, 160, 119, 110, 2, 104, 85, false, false} [17:29:25.638] oldcontext = [17:29:25.638] __func__ = "get_actual_variable_endpoint" [17:29:25.638] #10 0x0000556800c0db19 in get_actual_variable_range (root=root@entry=0x556802774278, vardata=vardata@entry=0x7ffd3da534c0, sortop=97, collation=collation@entry=0, min=min@entry=0x0, max=0x556802775c00) at ../src/backend/utils/adt/selfuncs.c:6228 [17:29:25.638] tmpcontext = 0x5568026e6f10 [17:29:25.638] oldcontext = 0x556801e389c0 [17:29:25.638] heapRel = 0x7f7a46851f68 [17:29:25.638] slot = 0x5568026e7010 [17:29:25.638] typLen = 4 [17:29:25.638] indexRel = 0x7f7a46851608 [17:29:25.638] typByVal = true [17:29:25.638] 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}} [17:29:25.638] index = [17:29:25.638] indexscandir = ForwardScanDirection [17:29:25.638] lc__state = [17:29:25.638] have_data = true [17:29:25.638] rel = [17:29:25.638] rte = [17:29:25.638] lc = [17:29:25.638] #11 0x0000556800c18883 in ineq_histogram_selectivity (root=root@entry=0x556802774278, vardata=vardata@entry=0x7ffd3da534c0, opoid=opoid@entry=523, opproc=opproc@entry=0x7ffd3da53420, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [17:29:25.638] probe = 100 [17:29:25.638] ltcmp = [17:29:25.638] histfrac = [17:29:25.638] lobound = 99 [17:29:25.638] hibound = 101 [17:29:25.638] have_end = false [17:29:25.638] hist_selec = -1 [17:29:25.638] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x5568027758e0, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [17:29:25.638] #12 0x0000556800c18ef4 in scalarineqsel (root=root@entry=0x556802774278, operator=operator@entry=523, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=collation@entry=0, vardata=vardata@entry=0x7ffd3da534c0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [17:29:25.638] stats = 0x7f7a46850e40 [17:29:25.638] opproc = {fn_addr = 0x556800b1084e , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x556801e389c0, fn_expr = 0x0} [17:29:25.638] mcv_selec = 0 [17:29:25.638] hist_selec = [17:29:25.638] sumcommon = 0 [17:29:25.638] selec = [17:29:25.638] #13 0x0000556800c19413 in scalarineqsel_wrapper (fcinfo=, isgt=isgt@entry=false, iseq=iseq@entry=true) at ../src/backend/utils/adt/selfuncs.c:1459 [17:29:25.638] root = 0x556802774278 [17:29:25.638] operator = 523 [17:29:25.638] args = [17:29:25.638] varRelid = [17:29:25.638] collation = 0 [17:29:25.638] vardata = {var = 0x556802774708, rel = 0x556801e3a6d0, statsTuple = 0x7f7a46850df8, freefunc = 0x556800cb9772 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [17:29:25.638] other = 0x556802775d40 [17:29:25.638] varonleft = true [17:29:25.638] constval = 100000010 [17:29:25.638] consttype = 23 [17:29:25.638] selec = [17:29:25.638] #14 0x0000556800c19552 in scalarlesel (fcinfo=) at ../src/backend/utils/adt/selfuncs.c:1482 [17:29:25.638] No locals. [17:29:25.638] #15 0x0000556800cd21ed in FunctionCall4Coll (flinfo=flinfo@entry=0x7ffd3da535b0, collation=collation@entry=0, arg1=arg1@entry=93905206329976, arg2=arg2@entry=523, arg3=arg3@entry=93905206331624, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [17:29:25.638] fcinfodata = {fcinfo = {flinfo = 0x7ffd3da535b0, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x7ffd3da53560}, fcinfo_data = "\2605\245=\375\177", '\000' , "U\004\000xBw\002hU\000\000\000\r\315\000hU\000\000\v\002\000\000\000\000\000\000\000Bw\002hU\000\000\350Hw\002hU\000\000\000Hw\002hU", '\000' , "\021\315\000hU\000"} [17:29:25.638] fcinfo = 0x7ffd3da53540 [17:29:25.638] result = [17:29:25.638] __func__ = "FunctionCall4Coll" [17:29:25.638] #16 0x0000556800cd2998 in OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=93905206329976, arg2=arg2@entry=523, arg3=arg3@entry=93905206331624, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [17:29:25.638] flinfo = {fn_addr = 0x556800c1953f , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x556801e389c0, fn_expr = 0x0} [17:29:25.638] #17 0x0000556800832260 in restriction_selectivity (root=root@entry=0x556802774278, operatorid=operatorid@entry=523, args=0x5568027748e8, inputcollid=0, varRelid=varRelid@entry=0) at ../src/include/postgres.h:324 [17:29:25.638] oprrest = [17:29:25.638] result = [17:29:25.638] __func__ = "restriction_selectivity" [17:29:25.638] #18 0x00005568007605f0 in clause_selectivity_ext (root=root@entry=0x556802774278, clause=0x556802774988, clause@entry=0x556802775560, 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 [17:29:25.638] opclause = 0x556802774988 [17:29:25.638] opno = 523 [17:29:25.638] s1 = 0.5 [17:29:25.638] rinfo = 0x556802775560 [17:29:25.638] cacheable = true [17:29:25.638] #19 0x0000556800760f5f in clauselist_selectivity_ext (root=root@entry=0x556802774278, clauses=0x556802775510, 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 [17:29:25.638] clause = 0x556802775560 [17:29:25.638] rinfo = [17:29:25.638] s2 = [17:29:25.638] l__state = [17:29:25.638] s1 = 1 [17:29:25.638] rel = [17:29:25.638] estimatedclauses = 0x0 [17:29:25.638] rqlist = 0x556802775cf0 [17:29:25.638] l = [17:29:25.638] listidx = 1 [17:29:25.638] #20 0x0000556800761242 in clauselist_selectivity (root=root@entry=0x556802774278, clauses=, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [17:29:25.638] No locals. [17:29:25.638] #21 0x0000556800770618 in set_baserel_size_estimates (root=root@entry=0x556802774278, rel=rel@entry=0x556801e3a6d0) at ../src/backend/optimizer/path/costsize.c:5286 [17:29:25.638] nrows = [17:29:25.638] #22 0x000055680075511e in set_plain_rel_size (root=root@entry=0x556802774278, rel=rel@entry=0x556801e3a6d0, rte=rte@entry=0x556801e39b88) at ../src/backend/optimizer/path/allpaths.c:581 [17:29:25.638] No locals. [17:29:25.638] #23 0x000055680075b38e in set_rel_size (root=root@entry=0x556802774278, rel=rel@entry=0x556801e3a6d0, rti=rti@entry=1, rte=rte@entry=0x556801e39b88) at ../src/backend/optimizer/path/allpaths.c:411 [17:29:25.638] __func__ = "set_rel_size" [17:29:25.638] #24 0x000055680075b577 in set_base_rel_sizes (root=root@entry=0x556802774278) at ../src/backend/optimizer/path/allpaths.c:322 [17:29:25.638] rel = 0x556801e3a6d0 [17:29:25.638] rte = 0x556801e39b88 [17:29:25.638] rti = 1 [17:29:25.638] #25 0x000055680075f57d in make_one_rel (root=root@entry=0x556802774278, joinlist=joinlist@entry=0x556802775310) at ../src/backend/optimizer/path/allpaths.c:183 [17:29:25.638] rel = [17:29:25.638] rti = [17:29:25.638] total_pages = [17:29:25.638] #26 0x00005568007c3275 in query_planner (root=root@entry=0x556802774278, qp_callback=qp_callback@entry=0x5568007c85ce , qp_extra=qp_extra@entry=0x7ffd3da53910) at ../src/backend/optimizer/plan/planmain.c:280 [17:29:25.638] parse = 0x556801e39978 [17:29:25.638] joinlist = 0x556802775310 [17:29:25.638] final_rel = [17:29:25.638] __func__ = "query_planner" [17:29:25.638] #27 0x00005568007d5b38 in grouping_planner (root=root@entry=0x556802774278, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [17:29:25.638] sort_input_targets = 0x556802774a08 [17:29:25.638] sort_input_target_parallel_safe = [17:29:25.638] grouping_target = [17:29:25.638] scanjoin_target = [17:29:25.638] activeWindows = 0x0 [17:29:25.638] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [17:29:25.638] sort_input_targets_contain_srfs = 0x2 [17:29:25.638] have_grouping = [17:29:25.638] wflists = 0x0 [17:29:25.638] gset_data = 0x0 [17:29:25.638] sort_input_target = [17:29:25.638] grouping_targets = 0x556801e39978 [17:29:25.638] grouping_target_parallel_safe = [17:29:25.638] scanjoin_targets = 0x556802774278 [17:29:25.638] scanjoin_target_parallel_safe = [17:29:25.638] grouping_targets_contain_srfs = 0x556802774aa8 [17:29:25.638] scanjoin_targets_contain_srfs = 0x0 [17:29:25.638] scanjoin_target_same_exprs = [17:29:25.638] parse = 0x556801e39978 [17:29:25.638] offset_est = 0 [17:29:25.638] count_est = 0 [17:29:25.638] limit_tuples = -1 [17:29:25.638] have_postponed_srfs = false [17:29:25.638] final_target = [17:29:25.638] final_targets = 0x556801e3a600 [17:29:25.638] final_targets_contain_srfs = 0x55680080b494 [17:29:25.638] final_target_parallel_safe = [17:29:25.638] current_rel = [17:29:25.638] final_rel = [17:29:25.638] extra = {limit_needed = 216, limit_tuples = 4.6395336413275106e-310, count_est = 93905206332072, offset_est = 93905206329976} [17:29:25.638] lc = [17:29:25.638] __func__ = "grouping_planner" [17:29:25.638] #28 0x00005568007d896b in subquery_planner (glob=glob@entry=0x556801e39868, parse=parse@entry=0x556801e39978, 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 [17:29:25.638] root = 0x556802774278 [17:29:25.638] newWithCheckOptions = [17:29:25.638] newHaving = [17:29:25.638] hasOuterJoins = [17:29:25.638] hasResultRTEs = false [17:29:25.638] final_rel = [17:29:25.638] l = 0x0 [17:29:25.638] #29 0x00005568007d95fc in standard_planner (parse=0x556801e39978, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:415 [17:29:25.638] result = [17:29:25.638] glob = 0x556801e39868 [17:29:25.638] tuple_fraction = 0 [17:29:25.638] root = [17:29:25.638] final_rel = [17:29:25.638] best_path = [17:29:25.638] top_plan = [17:29:25.638] lp = [17:29:25.638] lr = [17:29:25.638] #30 0x00005568007da666 in planner (parse=parse@entry=0x556801e39978, query_string=query_string@entry=0x556801e38ac0 "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 [17:29:25.638] result = [17:29:25.638] #31 0x0000556800a33cb6 in pg_plan_query (querytree=querytree@entry=0x556801e39978, query_string=query_string@entry=0x556801e38ac0 "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 [17:29:25.638] plan = [17:29:25.638] #32 0x0000556800a34097 in pg_plan_queries (querytrees=0x556801e3a680, query_string=query_string@entry=0x556801e38ac0 "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 [17:29:25.638] query = 0x556801e39978 [17:29:25.638] stmt = [17:29:25.638] query_list__state = [17:29:25.638] stmt_list = 0x0 [17:29:25.638] query_list = [17:29:25.638] #33 0x0000556800a34644 in exec_simple_query (query_string=query_string@entry=0x556801e38ac0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [17:29:25.638] cmdtaglen = 6 [17:29:25.638] snapshot_set = true [17:29:25.638] per_parsetree_context = 0x0 [17:29:25.638] plantree_list = [17:29:25.638] parsetree = 0x556801e397e8 [17:29:25.638] commandTag = CMDTAG_DELETE [17:29:25.638] qc = {commandTag = CMDTAG_CREATE_SUBSCRIPTION, nprocessed = 93905196649152} [17:29:25.638] querytree_list = [17:29:25.638] portal = [17:29:25.638] receiver = [17:29:25.638] format = 0 [17:29:25.638] cmdtagname = [17:29:25.638] parsetree_item__state = [17:29:25.638] dest = DestRemote [17:29:25.638] oldcontext = 0x556801ecc6f0 [17:29:25.638] parsetree_list = 0x556801e39818 [17:29:25.638] parsetree_item = 0x556801e39830 [17:29:25.638] save_log_statement_stats = false [17:29:25.638] was_logged = true [17:29:25.638] use_implicit_block = false [17:29:25.638] msec_str = "\340=\245=\375\177\000\0008\244\316\000hU\000\000\020<\245=\375\177\000\000W\000\000\000\000\000\000" [17:29:25.638] __func__ = "exec_simple_query" [17:29:25.638] #34 0x0000556800a37265 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [17:29:25.638] query_string = 0x556801e38ac0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [17:29:25.638] firstchar = [17:29:25.638] input_message = {data = 0x556801e38ac0 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [17:29:25.638] local_sigjmp_buf = {{__jmpbuf = {93905190945016, -2251739224103991787, 4, 140725637692896, 140725637693040, 140725637693044, -5338367235866507755, -2251741244106881515}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93905196379712, 14336, 93905190939104, 93905196906624, 140725637693040, 93905178625455, 0, 9, 2, 93905190945024, 93905196379712, 93905190939104, 140725637692896, 140725637693040, 140725637693044}}}} [17:29:25.638] send_ready_for_query = false [17:29:25.638] idle_in_transaction_timeout_enabled = false [17:29:25.638] idle_session_timeout_enabled = false [17:29:25.638] __func__ = "PostgresMain" [17:29:25.638] #35 0x0000556800a2d387 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [17:29:25.638] bsdata = [17:29:25.638] #36 0x00005568008e5dbe in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd3da53d8c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd3da53de0) at ../src/backend/postmaster/launch_backend.c:274 [17:29:25.638] pid = [17:29:25.638] #37 0x00005568008eb86a in BackendStartup (client_sock=client_sock@entry=0x7ffd3da53de0) at ../src/backend/postmaster/postmaster.c:3414 [17:29:25.638] bn = 0x556801e6dbf8 [17:29:25.638] pid = [17:29:25.638] startup_data = {canAcceptConnections = CAC_OK} [17:29:25.638] __func__ = "BackendStartup" [17:29:25.638] #38 0x00005568008ebdcc in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [17:29:25.638] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\245=\375\177\000\000t>\245=\375\177", '\000' , "\303˫\377gU\000\000\020\267\247\377gU\000\000@?\245=\375\177\000\0008?\245=\375\177\000\000\225[\362\001\000\000\000\000\240\264\bSz\177\000\000+", '\000' , "\330ʫ\377gU\000\000h\026\272Sz\177\000\0000\266\bSz\177\000", __ss_align = 140163367441120}, salen = 2}} [17:29:25.638] i = 0 [17:29:25.638] now = [17:29:25.638] last_lockfile_recheck_time = 1725211553 [17:29:25.638] last_touch_time = 1725211493 [17:29:25.638] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -5518397, events = 21863, fd = 1404704360, user_data = 0x7f7a5308b630}, {pos = 1404703456, events = 32634, fd = 2090263927, user_data = 0x7ffd3da53fc0}, {pos = 1404533320, events = 32634, fd = 15, user_data = 0x7f7a5308b630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1404703456, events = 32634, fd = 1034239800, user_data = 0x7ffd3da53f40}, {pos = 1404704360, events = 32634, fd = 0, user_data = 0x556801e38ad8}, {pos = 1378581002, events = 32634, fd = 31689432, user_data = 0x556800000001}, {pos = 32768, events = 0, fd = -1, user_data = 0x7f7a5222e020}, {pos = 1400475552, events = 32634, fd = 31880184, user_data = 0x556801e672d8}, {pos = 31879345, events = 21864, fd = 1404559038, user_data = 0x1}, {pos = 1404703456, events = 32634, fd = 439, user_data = 0x55680122edb8 }, {pos = 0, events = 0, fd = 1, user_data = 0x556801e38ad8}, {pos = 1404559038, events = 32634, fd = 1, user_data = 0x0}, {pos = 1378017312, events = 32634, fd = 1378823616, user_data = 0x10}, {pos = 1034240944, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1404567994, user_data = 0x0}, {pos = 1378544932, events = 32634, fd = 0, user_data = 0x5568018b9ac0 }, {pos = 2, events = 0, fd = 7, user_data = 0x556801dfaee0}, {pos = 10253720, events = 21864, fd = 31897664, user_data = 0x5568009c851c }, {pos = 31897755, events = 21864, fd = 8096, user_data = 0x7367702f65736162}, {pos = 1952410737, events = 28781, fd = 1, user_data = 0x0}, {pos = 1378051272, events = 32634, fd = 1378470016, user_data = 0x41e}, {pos = 1378578055, events = 32634, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 1379867744, events = 32634, 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 = 13661746, events = 21864, fd = 31853264, user_data = 0x7f7a522b56eb}, {pos = 1379850720, events = 32634, fd = 1378488686, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x99195125a65fdc00}, {pos = 1379853792, events = 32634, 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 = 31879576, user_data = 0x556800d07ef5 }, {pos = 31879376, events = 21864, fd = 3, user_data = 0x0}, {pos = 16229, events = 0, fd = -328, user_data = 0x0}, {pos = 31689432, events = 21864, fd = 1378824147, user_data = 0x7ffd3da54468}, {pos = 13745062, events = 21864, fd = 25985200, user_data = 0x556800d0a663 }, {pos = 31879376, events = 21864, fd = 31689152, user_data = 0x556801e670d0}, {pos = 1378572011, events = 32634, fd = 0, user_data = 0x556800d1c2cd }, {pos = 31879376, events = 1, fd = 13747222, user_data = 0x556801e389c0}, {pos = -1503667200, events = 2568573221, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1378495153, user_data = 0x7f7a522a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1503667200, user_data = 0x556801e100f0}, {pos = -1503667200, events = 2568573221, fd = 11, user_data = 0x99195125a65fdc00}, {pos = 0, events = 0, fd = 1378202169, user_data = 0x1}, {pos = 9329339, events = 21864, fd = 4194304, user_data = 0x556800d0a4f7 }, {pos = 31523056, events = 21864, fd = 31689152, user_data = 0x556801e100f0}, {pos = 1, events = 0, fd = 0, user_data = 0x556800d1c2cd }, {pos = 31523056, events = 21864, fd = 13747222, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55680071e661 }, {pos = 0, events = 0, fd = 7485867, user_data = 0xb}, {pos = 9350488, events = 21864, fd = 22399120, user_data = 0x556801e39368}} [17:29:25.638] nevents = 1 [17:29:25.638] __func__ = "ServerLoop" [17:29:25.638] #39 0x00005568008ed542 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x556801df6d50) at ../src/backend/postmaster/postmaster.c:1346 [17:29:25.638] opt = [17:29:25.638] status = [17:29:25.638] userDoption = [17:29:25.638] listen_addr_saved = false [17:29:25.638] output_config_variable = [17:29:25.638] __func__ = "PostmasterMain" [17:29:25.638] #40 0x000055680072ea8c in main (argc=4, argv=0x556801df6d50) at ../src/backend/main/main.c:197 [17:29:25.638] do_check_root = [17:29:25.660] -e [17:29:25.660] [17:29:25.660] [17:29:25.727] dumping /tmp/cores/postgres-6-25048.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [17:29:25.990] [New LWP 25048] [17:29:25.990] [17:29:25.990] This GDB supports auto-downloading debuginfo from the following URLs: [17:29:25.990] [17:29:25.990] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [17:29:25.990] Debuginfod has been disabled. [17:29:25.990] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [17:29:26.104] [Thread debugging using libthread_db enabled] [17:29:26.104] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [17:29:26.104] Core was generated by `postgres: postgres regression [local] DELETE '. [17:29:26.104] Program terminated with signal SIGABRT, Aborted. [17:29:26.104] #0 0x00007f531cca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:26.260] [17:29:26.260] Thread 1 (Thread 0x7f531d434f00 (LWP 25048)): [17:29:26.260] #0 0x00007f531cca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:26.260] No symbol table info available. [17:29:26.260] #1 0x00007f531cc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:26.260] No symbol table info available. [17:29:26.260] #2 0x00007f531cc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [17:29:26.260] No symbol table info available. [17:29:26.260] #3 0x000055c2d8c4172c in ExceptionalCondition (conditionName=conditionName@entry=0x55c2d8e6af48 "!BTScanPosIsPinned(so->currPos)", fileName=fileName@entry=0x55c2d8e6adc8 "../src/backend/access/nbtree/nbtsearch.c", lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [17:29:26.260] No locals. [17:29:26.260] #4 0x000055c2d8360368 in _bt_readnextpage (scan=scan@entry=0x55c2da7794d0, blkno=, expectNext=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [17:29:26.260] so = 0x55c2da802fe8 [17:29:26.260] rel = 0x7f5310faadc8 [17:29:26.260] page = [17:29:26.260] opaque = [17:29:26.260] status = [17:29:26.260] #5 0x000055c2d8360c99 in _bt_steppage (scan=scan@entry=0x55c2da7794d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [17:29:26.260] so = 0x55c2da802fe8 [17:29:26.260] blkno = 2 [17:29:26.260] expectNext = 4 [17:29:26.260] status = [17:29:26.260] #6 0x000055c2d83640ae in _bt_first (scan=scan@entry=0x55c2da7794d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [17:29:26.260] rel = 0x7f5310faadc8 [17:29:26.260] so = 0x55c2da802fe8 [17:29:26.260] buf = 11487 [17:29:26.260] stack = [17:29:26.260] offnum = [17:29:26.260] strat = [17:29:26.260] 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 = 0x55c2d8343b43 , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55c2da7792c0, fn_expr = 0x55c2da7d3748}, 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 = 3640013114, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 80 'P', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x55c2da7da3a0}, 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 = 0x55c2da7fc5b8, fn_expr = 0x1}, sk_argument = 94295342894345}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 3666042264, sk_collation = 21954, sk_func = {fn_addr = 0x55c2da7fbe38, fn_oid = 3631263173, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 56 '8', 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 = 0x7ffdf686f801, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -629151872, sk_attno = 21954, sk_strategy = 0, sk_subtype = 3634032257, sk_collation = 21954, sk_func = {fn_addr = 0x0, fn_oid = 3630942537, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 109 'm', fn_extra = 0x7f00f686f8a0, fn_mcxt = 0x0, fn_expr = 0x55c2da7b2b48}, sk_argument = 94295377521560}, {sk_flags = -158926592, sk_attno = 32765, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 3665807280, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 27 '\033', fn_extra = 0x55c2d8ef2be0, fn_mcxt = 0x55c2da7b2b48, fn_expr = 0x55c2d8761e6d }, sk_argument = 140728739494144}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55c2da7fc7b0, fn_oid = 3630946415, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x7f5317673000, fn_mcxt = 0x7f5310fa72a0, fn_expr = 0x55c2da7b2a90}, sk_argument = 94295377521480}, {sk_flags = -158926592, sk_attno = 32765, 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 = 3637003826, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 160 '\240', fn_extra = 0x40, fn_mcxt = 0x3, fn_expr = 0x55c2d8c85773 }, sk_argument = 3665504336}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 288873912, sk_collation = 16809811, 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 = 4136040704, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 112 'p', fn_extra = 0x55c2d8956465 , fn_mcxt = 0x7f531a085dc0, fn_expr = 0x55c2d8956e62 }, sk_argument = 94295376867528}, {sk_flags = 11320, sk_attno = 21954, sk_strategy = 0, sk_subtype = 4136041056, sk_collation = 32765, sk_func = {fn_addr = 0x5500d9839720, 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 = 94295345527276}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 11701, sk_func = {fn_addr = 0x55c2d8ef2be0, fn_oid = 392802304, fn_nargs = 32595, fn_strict = false, fn_retset = false, fn_stats = 181 '\265', fn_extra = 0x0, fn_mcxt = 0x2db5, fn_expr = 0x55c2d89851ed }, sk_argument = 11701}, {sk_flags = -661448800, sk_attno = 21954, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f531769b000, fn_oid = 284866344, fn_nargs = 32595, fn_strict = false, fn_retset = false, fn_stats = 45 '-', fn_extra = 0x1, fn_mcxt = 0x55c2d89ec487 , 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 = -660686153, sk_attno = 21954, 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 = 164 '\244', fn_extra = 0x7f5311ae9080, fn_mcxt = 0x3, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 3634283655, sk_collation = 21954, sk_func = {fn_addr = 0x7ffdf686fbc0, fn_oid = 296652801, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x7f5311ae9080, fn_mcxt = 0x55c2da786d88, fn_expr = 0x55c2d89ec65e }, sk_argument = 296652801}, {sk_flags = -661419302, sk_attno = 21954, sk_strategy = 0, sk_subtype = 4136041404, sk_collation = 32765, sk_func = {fn_addr = 0x7ffdf686fbbc, fn_oid = 290210432, fn_nargs = 32595, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xf686fb27, fn_mcxt = 0x1cba0ced00000002, 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 = 37752, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1d835e80e, fn_mcxt = 0x3e0, fn_expr = 0x7f5310fab728}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3665325448, sk_collation = 21954, sk_func = {fn_addr = 0x7f531ccb6e87, fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x6b0, fn_mcxt = 0x7f531ccb6fed, fn_expr = 0x0}, sk_argument = 94295377706080}, {sk_flags = 1027, sk_attno = 0, sk_strategy = 0, sk_subtype = 114, sk_collation = 4294967295, sk_func = {fn_addr = 0x6ae0, fn_oid = 484383840, fn_nargs = 32595, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 139994743877064}, {sk_flags = 483097098, sk_attno = 32595, sk_strategy = 0, sk_subtype = 27416, sk_collation = 0, sk_func = {fn_addr = 0x55c2d8c8481d , fn_oid = 3665269440, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x55c2d8c8481d , fn_expr = 0x55c2da7792c0}, sk_argument = 16384}, {sk_flags = -158924928, sk_attno = 32765, sk_strategy = 0, sk_subtype = 3665269640, sk_collation = 21954, sk_func = {fn_addr = 0x0, fn_oid = 3637007791, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x10, fn_mcxt = 0x1, fn_expr = 0x55c2da802fe8}, sk_argument = 94295377286352}}} [17:29:26.260] startKeys = {0x55c2da779670, 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} [17:29:26.260] notnullkeys = {{sk_flags = -630160960, sk_attno = 21954, sk_strategy = 0, sk_subtype = 3664806704, sk_collation = 21954, sk_func = {fn_addr = 0x7ffdf686eb10, fn_oid = 4136036928, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffdf686eb08, fn_mcxt = 0x55c2da7081c0, fn_expr = 0x55c2d8789051 }, sk_argument = 94295378060712}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x7ffdf686eb08, fn_oid = 4136037008, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 207 '\317', fn_extra = 0x55c2da708330, fn_mcxt = 0x55c2da707bf0, fn_expr = 0x0}, sk_argument = 94295377285824}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3664806704, sk_collation = 21954, sk_func = {fn_addr = 0x7ffdf686eb10, fn_oid = 3664804848, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x7ffdf686eb08, fn_mcxt = 0x55c2da7081c0, fn_expr = 0x55c2d878e63d }, 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 = 0x55c2da7081c0, fn_mcxt = 0x55c2d8b92ebd , fn_expr = 0x550000000101}, sk_argument = 0}, {sk_flags = 284861880, sk_attno = 32595, sk_strategy = 0, sk_subtype = 284861816, sk_collation = 32595, sk_func = {fn_addr = 0x55c2da707bf0, fn_oid = 3664806624, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x55c2d8c07a76 , fn_mcxt = 0x10fa70d0, fn_expr = 0x3f50624dd2f1a9fc}, sk_argument = 96}, {sk_flags = -658464185, sk_attno = 21954, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55c2d8c3677b , fn_oid = 3664804848, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 233 '\351', fn_extra = 0x1007ffdf686ecc0, fn_mcxt = 0x55c2da836758, fn_expr = 0x55c2da7081c0}, sk_argument = 94295377819480}, {sk_flags = 284861880, sk_attno = 32595, sk_strategy = 0, sk_subtype = 3636684658, sk_collation = 21954, sk_func = {fn_addr = 0x1700000017, fn_oid = 4294967295, fn_nargs = 257, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0x7ffdf686ec00, fn_mcxt = 0x55c2da707bf0, fn_expr = 0x60}, sk_argument = 94295376823008}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 4136037376, sk_collation = 32765, sk_func = {fn_addr = 0x55c2d8b95631 , fn_oid = 287488648, fn_nargs = 32595, fn_strict = false, fn_retset = false, fn_stats = 237 '\355', fn_extra = 0x7ffdf686ec00, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 1219358395203584}, {sk_flags = -630162448, sk_attno = 21954, sk_strategy = 0, sk_subtype = 3636780288, sk_collation = 21954, sk_func = {fn_addr = 0x60, fn_oid = 3664804608, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0x55c2da708200, fn_mcxt = 0x2, fn_expr = 0x55c2d8c4e100 }, sk_argument = 0}, {sk_flags = -658179688, sk_attno = 21954, sk_strategy = 0, sk_subtype = 3636024867, sk_collation = 21954, sk_func = {fn_addr = 0x1000400000065, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55c2da706680, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 94295346048641}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3630942537, sk_collation = 21954, sk_func = {fn_addr = 0x55c2da7082e0, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55c2da708330, fn_mcxt = 0x7ffdf686ed10, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -630162448, sk_attno = 21954, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55c2d86e60e1 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 156 '\234', fn_extra = 0x1, fn_mcxt = 0x55c2d8c05aa9 , fn_expr = 0x1600000001}, sk_argument = 94295348499664}, {sk_flags = 284781656, sk_attno = 32595, sk_strategy = 0, sk_subtype = 284781656, sk_collation = 32595, sk_func = {fn_addr = 0x7f5310f96c60, fn_oid = 3649327416, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 146 '\222', fn_extra = 0x55c2d8c0a682 , fn_mcxt = 0xd9842e08, fn_expr = 0x2}, sk_argument = 94295368220416}, {sk_flags = 287424376, sk_attno = 32595, 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 = 0x7ffdf686efe0, fn_mcxt = 0x53d90092d8c9aa7d, fn_expr = 0x17}, sk_argument = 94295338533479}, {sk_flags = 16, sk_attno = 16, sk_strategy = 0, sk_subtype = 284862024, sk_collation = 32595, sk_func = {fn_addr = 0x7ffdf686ee70, fn_oid = 284861880, fn_nargs = 32595, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x55c2d8c514c3 , fn_mcxt = 0x7f5310faa5b8, fn_expr = 0x7f5310faa578}, sk_argument = 1}, {sk_flags = -629163224, sk_attno = 21954, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x55c2d8c07a76 , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 176 '\260', fn_extra = 0x9378, fn_mcxt = 0x55c2d8c0a247 , fn_expr = 0x7ffdf686ee70}, sk_argument = 94295348701051}, {sk_flags = -630166096, sk_attno = 21954, sk_strategy = 0, sk_subtype = 3636044974, sk_collation = 21954, sk_func = {fn_addr = 0x55c2da7082e0, fn_oid = 3666044600, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x1, fn_mcxt = 0x55c2da8363f8, fn_expr = 0x3ff0000000000000}, sk_argument = 94295376821232}, {sk_flags = 1, sk_attno = 260, sk_strategy = 0, sk_subtype = 3666043144, sk_collation = 21954, sk_func = {fn_addr = 0x55c2d8c05aa9 , fn_oid = 4136038384, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0x7f5310fa70b8, fn_mcxt = 0x7f5310fa70b8, fn_expr = 0x7f5310fa7090}, sk_argument = 94295368316904}, {sk_flags = -638668544, sk_attno = 21954, sk_strategy = 0, sk_subtype = 3636499679, sk_collation = 21954, sk_func = {fn_addr = 0x55c2da8367c0, fn_oid = 37752, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55c2d8c84632 , fn_mcxt = 0x55c2da706680, fn_expr = 0x6}, sk_argument = 0}, {sk_flags = -657959053, sk_attno = 21954, sk_strategy = 0, sk_subtype = 284848336, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 149 '\225', fn_extra = 0x55c2da706780, fn_mcxt = 0x55c2da706890, fn_expr = 0x5}, sk_argument = 140728739494808}, {sk_flags = -629609704, sk_attno = 21954, sk_strategy = 0, sk_subtype = 3637003826, sk_collation = 21954, sk_func = {fn_addr = 0x55c2da706680, fn_oid = 64, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x55c2d8c85773 , fn_mcxt = 0xda706680, 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 = 69 'E', fn_extra = 0x55c2d8c84632 , fn_mcxt = 0x55c2da7d9c30, fn_expr = 0x40}, sk_argument = 3}, {sk_flags = -657959053, sk_attno = 21954, sk_strategy = 0, sk_subtype = 2, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 3665665072, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5, fn_mcxt = 0x1, fn_expr = 0x7ffdf686f430}, sk_argument = 140728739492104}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 3637095037, sk_collation = 21954, sk_func = {fn_addr = 0x2, fn_oid = 3630889091, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55c2da7da4d0, fn_mcxt = 0x395, fn_expr = 0x55c2d86afd79 }, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4136041536, sk_collation = 32765, sk_func = {fn_addr = 0x55c2d8de2bcb , fn_oid = 4136041056, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 159 '\237', fn_extra = 0x7ffdf686fa60, fn_mcxt = 0xc8, fn_expr = 0x4fffffffe}, sk_argument = 140728739492896}, {sk_flags = -158928640, sk_attno = 32765, sk_strategy = 0, sk_subtype = 3665665328, sk_collation = 21954, 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 = 284862920, sk_attno = 32595, sk_strategy = 0, sk_subtype = 284862856, sk_collation = 32595, sk_func = {fn_addr = 0x7f5310faa5b8, fn_oid = 284861816, fn_nargs = 32595, fn_strict = false, fn_retset = false, fn_stats = 11 '\v', fn_extra = 0x7ffdf686f300, fn_mcxt = 0x7ffdf686f2f0, fn_expr = 0x55c2d8c07a76 }, sk_argument = 140728739492616}, {sk_flags = 97, sk_attno = 0, sk_strategy = 0, sk_subtype = 4136039176, sk_collation = 32765, sk_func = {fn_addr = 0x55c200000000, fn_oid = 4136039168, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 123 '{', fn_extra = 0x7ffdf686f2f8, fn_mcxt = 0x55c2d8b9677f , fn_expr = 0x7ffdf686f240}, sk_argument = 4294967393}, {sk_flags = 0, sk_attno = 97, sk_strategy = 0, sk_subtype = 3631083358, sk_collation = 21954, 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 = 0x7ffdf686f2e0}, 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 = 3665804856, fn_nargs = 21954, fn_strict = false, fn_retset = false, fn_stats = 43 '+', fn_extra = 0x3f747ae147ae147b, fn_mcxt = 0xe2eb851eba, fn_expr = 0xdf00e000e100e2}, sk_argument = 61643964806922462}} [17:29:26.260] keysz = 1 [17:29:26.260] i = [17:29:26.260] status = [17:29:26.260] strat_total = 1 [17:29:26.260] currItem = [17:29:26.260] blkno = 21954 [17:29:26.260] __func__ = "_bt_first" [17:29:26.260] #7 0x000055c2d835b177 in btgettuple (scan=0x55c2da7794d0, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [17:29:26.260] so = 0x55c2da802fe8 [17:29:26.260] res = [17:29:26.260] #8 0x000055c2d8341d73 in index_getnext_tid (scan=scan@entry=0x55c2da7794d0, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [17:29:26.260] found = [17:29:26.260] __func__ = "index_getnext_tid" [17:29:26.260] #9 0x000055c2d8b8a332 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x7f5310fab728, indexRel=indexRel@entry=0x7f5310faadc8, indexscandir=indexscandir@entry=BackwardScanDirection, scankeys=scankeys@entry=0x7ffdf686ff80, typLen=, typByVal=, tableslot=0x55c2da7793c0, outercontext=0x55c2d9e72a30, endpointDatum=0x55c2da7b1ca0) at ../src/backend/utils/adt/selfuncs.c:6349 [17:29:26.260] have_data = false [17:29:26.260] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 21954, xmax = 3636499679, xip = 0x4000, xcnt = 23, subxip = 0x0, subxcnt = 0, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0x55c2d9839720 , active_count = 23, regd_count = 0, ph_node = {first_child = 0x0, next_sibling = 0x7f5311383d08, prev_or_parent = 0x7f5311383cc8}, whenTaken = 23, lsn = 94295377285824, snapXactCompletionCount = 140728739496416} [17:29:26.260] index_scan = 0x55c2da7794d0 [17:29:26.260] vmbuffer = 0 [17:29:26.260] last_heap_block = 4294967295 [17:29:26.260] n_visited_heap_pages = 0 [17:29:26.260] tid = [17:29:26.260] values = {68719476752, 140728739496128, 94295376816000, 0, 94295376815744, 94295341885512, 94295377527752, 140728739496096, 94295377286608, 139994747166637, 140728739495448, 140728739496128, 94295376815616, 139994747160114, 139994747129031, 94295348845337, 140728739495552, 139994942869536, 4136042692, 0, 2, 94295368211848, 7960478512, 94295368208480, 140728739495552, 0, 0, 94295348501161, 94295367826424, 94295348499664, 139994747911408, 139994747911408} [17:29:26.260] isnull = {false, false, false, false, false, false, false, false, 84, 102, 91, 216, 25, 31, 55, 224, false, false, false, false, false, false, false, false, 80, 155, 119, 218, 194, 85, false, false} [17:29:26.260] oldcontext = [17:29:26.260] __func__ = "get_actual_variable_endpoint" [17:29:26.260] #10 0x000055c2d8b8ab19 in get_actual_variable_range (root=root@entry=0x55c2da7b0318, vardata=vardata@entry=0x7ffdf68701e0, sortop=97, collation=collation@entry=0, min=min@entry=0x0, max=0x55c2da7b1ca0) at ../src/backend/utils/adt/selfuncs.c:6228 [17:29:26.260] tmpcontext = 0x55c2da7792c0 [17:29:26.260] oldcontext = 0x55c2d9e72a30 [17:29:26.260] heapRel = 0x7f5310fab728 [17:29:26.260] slot = 0x55c2da7793c0 [17:29:26.260] typLen = 4 [17:29:26.260] indexRel = 0x7f5310faadc8 [17:29:26.260] typByVal = true [17:29:26.260] 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}} [17:29:26.260] index = [17:29:26.260] indexscandir = ForwardScanDirection [17:29:26.260] lc__state = [17:29:26.260] have_data = true [17:29:26.260] rel = [17:29:26.260] rte = [17:29:26.260] lc = [17:29:26.260] #11 0x000055c2d8b95883 in ineq_histogram_selectivity (root=root@entry=0x55c2da7b0318, vardata=vardata@entry=0x7ffdf68701e0, opoid=opoid@entry=523, opproc=opproc@entry=0x7ffdf6870140, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [17:29:26.260] probe = 100 [17:29:26.260] ltcmp = [17:29:26.260] histfrac = [17:29:26.260] lobound = 99 [17:29:26.260] hibound = 101 [17:29:26.260] have_end = false [17:29:26.260] hist_selec = -1 [17:29:26.260] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x55c2da7b1980, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [17:29:26.260] #12 0x000055c2d8b95ef4 in scalarineqsel (root=root@entry=0x55c2da7b0318, operator=operator@entry=523, isgt=isgt@entry=false, iseq=iseq@entry=true, collation=collation@entry=0, vardata=vardata@entry=0x7ffdf68701e0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [17:29:26.260] stats = 0x7f5310faa600 [17:29:26.260] opproc = {fn_addr = 0x55c2d8a8d84e , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55c2d9e72a30, fn_expr = 0x0} [17:29:26.260] mcv_selec = 0 [17:29:26.260] hist_selec = [17:29:26.260] sumcommon = 0 [17:29:26.260] selec = [17:29:26.260] #13 0x000055c2d8b96413 in scalarineqsel_wrapper (fcinfo=, isgt=isgt@entry=false, iseq=iseq@entry=true) at ../src/backend/utils/adt/selfuncs.c:1459 [17:29:26.260] root = 0x55c2da7b0318 [17:29:26.260] operator = 523 [17:29:26.260] args = [17:29:26.260] varRelid = [17:29:26.260] collation = 0 [17:29:26.260] vardata = {var = 0x55c2da7b07a8, rel = 0x55c2d9e74740, statsTuple = 0x7f5310faa5b8, freefunc = 0x55c2d8c36772 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [17:29:26.260] other = 0x55c2da7b1de0 [17:29:26.260] varonleft = true [17:29:26.260] constval = 100000010 [17:29:26.260] consttype = 23 [17:29:26.260] selec = [17:29:26.260] #14 0x000055c2d8b96552 in scalarlesel (fcinfo=) at ../src/backend/utils/adt/selfuncs.c:1482 [17:29:26.260] No locals. [17:29:26.260] #15 0x000055c2d8c4f1ed in FunctionCall4Coll (flinfo=flinfo@entry=0x7ffdf68702d0, collation=collation@entry=0, arg1=arg1@entry=94295377511192, arg2=arg2@entry=523, arg3=arg3@entry=94295377512840, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [17:29:26.260] fcinfodata = {fcinfo = {flinfo = 0x7ffdf68702d0, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x7ffdf6870280}, fcinfo_data = "\320\002\207\366\375\177", '\000' , "U\004\000\030\003{\332\302U\000\000\000\335\304\330\302U\000\000\v\002\000\000\000\000\000\000\000\003{\332\302U\000\000\210\t{\332\302U\000\000\000\t{\332\302U", '\000' , "\341\304\330\302U\000"} [17:29:26.260] fcinfo = 0x7ffdf6870260 [17:29:26.260] result = [17:29:26.260] __func__ = "FunctionCall4Coll" [17:29:26.260] #16 0x000055c2d8c4f998 in OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=94295377511192, arg2=arg2@entry=523, arg3=arg3@entry=94295377512840, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [17:29:26.260] flinfo = {fn_addr = 0x55c2d8b9653f , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55c2d9e72a30, fn_expr = 0x0} [17:29:26.260] #17 0x000055c2d87af260 in restriction_selectivity (root=root@entry=0x55c2da7b0318, operatorid=operatorid@entry=523, args=0x55c2da7b0988, inputcollid=0, varRelid=varRelid@entry=0) at ../src/include/postgres.h:324 [17:29:26.260] oprrest = [17:29:26.260] result = [17:29:26.260] __func__ = "restriction_selectivity" [17:29:26.260] #18 0x000055c2d86dd5f0 in clause_selectivity_ext (root=root@entry=0x55c2da7b0318, clause=0x55c2da7b0a28, clause@entry=0x55c2da7b1600, 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 [17:29:26.260] opclause = 0x55c2da7b0a28 [17:29:26.260] opno = 523 [17:29:26.260] s1 = 0.5 [17:29:26.260] rinfo = 0x55c2da7b1600 [17:29:26.260] cacheable = true [17:29:26.260] #19 0x000055c2d86ddf5f in clauselist_selectivity_ext (root=root@entry=0x55c2da7b0318, clauses=0x55c2da7b15b0, 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 [17:29:26.260] clause = 0x55c2da7b1600 [17:29:26.260] rinfo = [17:29:26.260] s2 = [17:29:26.260] l__state = [17:29:26.260] s1 = 1 [17:29:26.260] rel = [17:29:26.260] estimatedclauses = 0x0 [17:29:26.260] rqlist = 0x55c2da7b1d90 [17:29:26.260] l = [17:29:26.260] listidx = 1 [17:29:26.260] #20 0x000055c2d86de242 in clauselist_selectivity (root=root@entry=0x55c2da7b0318, clauses=, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [17:29:26.260] No locals. [17:29:26.260] #21 0x000055c2d86ed618 in set_baserel_size_estimates (root=root@entry=0x55c2da7b0318, rel=rel@entry=0x55c2d9e74740) at ../src/backend/optimizer/path/costsize.c:5286 [17:29:26.260] nrows = [17:29:26.260] #22 0x000055c2d86d211e in set_plain_rel_size (root=root@entry=0x55c2da7b0318, rel=rel@entry=0x55c2d9e74740, rte=rte@entry=0x55c2d9e73bf8) at ../src/backend/optimizer/path/allpaths.c:581 [17:29:26.260] No locals. [17:29:26.260] #23 0x000055c2d86d838e in set_rel_size (root=root@entry=0x55c2da7b0318, rel=rel@entry=0x55c2d9e74740, rti=rti@entry=1, rte=rte@entry=0x55c2d9e73bf8) at ../src/backend/optimizer/path/allpaths.c:411 [17:29:26.260] __func__ = "set_rel_size" [17:29:26.260] #24 0x000055c2d86d8577 in set_base_rel_sizes (root=root@entry=0x55c2da7b0318) at ../src/backend/optimizer/path/allpaths.c:322 [17:29:26.260] rel = 0x55c2d9e74740 [17:29:26.260] rte = 0x55c2d9e73bf8 [17:29:26.260] rti = 1 [17:29:26.260] #25 0x000055c2d86dc57d in make_one_rel (root=root@entry=0x55c2da7b0318, joinlist=joinlist@entry=0x55c2da7b13b0) at ../src/backend/optimizer/path/allpaths.c:183 [17:29:26.260] rel = [17:29:26.260] rti = [17:29:26.260] total_pages = [17:29:26.260] #26 0x000055c2d8740275 in query_planner (root=root@entry=0x55c2da7b0318, qp_callback=qp_callback@entry=0x55c2d87455ce , qp_extra=qp_extra@entry=0x7ffdf6870630) at ../src/backend/optimizer/plan/planmain.c:280 [17:29:26.260] parse = 0x55c2d9e739e8 [17:29:26.260] joinlist = 0x55c2da7b13b0 [17:29:26.260] final_rel = [17:29:26.260] __func__ = "query_planner" [17:29:26.260] #27 0x000055c2d8752b38 in grouping_planner (root=root@entry=0x55c2da7b0318, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [17:29:26.260] sort_input_targets = 0x55c2da7b0aa8 [17:29:26.260] sort_input_target_parallel_safe = [17:29:26.260] grouping_target = [17:29:26.260] scanjoin_target = [17:29:26.260] activeWindows = 0x0 [17:29:26.260] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [17:29:26.260] sort_input_targets_contain_srfs = 0x2 [17:29:26.260] have_grouping = [17:29:26.260] wflists = 0x0 [17:29:26.260] gset_data = 0x0 [17:29:26.260] sort_input_target = [17:29:26.260] grouping_targets = 0x55c2d9e739e8 [17:29:26.260] grouping_target_parallel_safe = [17:29:26.260] scanjoin_targets = 0x55c2da7b0318 [17:29:26.260] scanjoin_target_parallel_safe = [17:29:26.260] grouping_targets_contain_srfs = 0x55c2da7b0b48 [17:29:26.260] scanjoin_targets_contain_srfs = 0x0 [17:29:26.260] scanjoin_target_same_exprs = [17:29:26.260] parse = 0x55c2d9e739e8 [17:29:26.260] offset_est = 0 [17:29:26.260] count_est = 0 [17:29:26.260] limit_tuples = -1 [17:29:26.260] have_postponed_srfs = false [17:29:26.260] final_target = [17:29:26.260] final_targets = 0x55c2d9e74670 [17:29:26.260] final_targets_contain_srfs = 0x55c2d8788494 [17:29:26.260] final_target_parallel_safe = [17:29:26.260] current_rel = [17:29:26.260] final_rel = [17:29:26.260] extra = {limit_needed = 120, limit_tuples = 4.6588106589911231e-310, count_est = 94295377513288, offset_est = 94295377511192} [17:29:26.260] lc = [17:29:26.260] __func__ = "grouping_planner" [17:29:26.260] #28 0x000055c2d875596b in subquery_planner (glob=glob@entry=0x55c2d9e738d8, parse=parse@entry=0x55c2d9e739e8, 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 [17:29:26.260] root = 0x55c2da7b0318 [17:29:26.260] newWithCheckOptions = [17:29:26.260] newHaving = [17:29:26.260] hasOuterJoins = [17:29:26.260] hasResultRTEs = false [17:29:26.260] final_rel = [17:29:26.260] l = 0x0 [17:29:26.260] #29 0x000055c2d87565fc in standard_planner (parse=0x55c2d9e739e8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:415 [17:29:26.260] result = [17:29:26.260] glob = 0x55c2d9e738d8 [17:29:26.260] tuple_fraction = 0 [17:29:26.260] root = [17:29:26.260] final_rel = [17:29:26.260] best_path = [17:29:26.260] top_plan = [17:29:26.260] lp = [17:29:26.260] lr = [17:29:26.260] #30 0x000055c2d8757666 in planner (parse=parse@entry=0x55c2d9e739e8, query_string=query_string@entry=0x55c2d9e72b30 "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 [17:29:26.260] result = [17:29:26.260] #31 0x000055c2d89b0cb6 in pg_plan_query (querytree=querytree@entry=0x55c2d9e739e8, query_string=query_string@entry=0x55c2d9e72b30 "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 [17:29:26.260] plan = [17:29:26.260] #32 0x000055c2d89b1097 in pg_plan_queries (querytrees=0x55c2d9e746f0, query_string=query_string@entry=0x55c2d9e72b30 "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 [17:29:26.260] query = 0x55c2d9e739e8 [17:29:26.260] stmt = [17:29:26.260] query_list__state = [17:29:26.260] stmt_list = 0x0 [17:29:26.260] query_list = [17:29:26.260] #33 0x000055c2d89b1644 in exec_simple_query (query_string=query_string@entry=0x55c2d9e72b30 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [17:29:26.260] cmdtaglen = 6 [17:29:26.260] snapshot_set = true [17:29:26.260] per_parsetree_context = 0x0 [17:29:26.260] plantree_list = [17:29:26.260] parsetree = 0x55c2d9e73858 [17:29:26.260] commandTag = CMDTAG_DELETE [17:29:26.260] qc = {commandTag = CMDTAG_CREATE_SUBSCRIPTION, nprocessed = 94295367822128} [17:29:26.260] querytree_list = [17:29:26.260] portal = [17:29:26.260] receiver = [17:29:26.260] format = 0 [17:29:26.260] cmdtagname = [17:29:26.260] parsetree_item__state = [17:29:26.260] dest = DestRemote [17:29:26.260] oldcontext = 0x55c2d9f06ce0 [17:29:26.260] parsetree_list = 0x55c2d9e73888 [17:29:26.260] parsetree_item = 0x55c2d9e738a0 [17:29:26.260] save_log_statement_stats = false [17:29:26.260] was_logged = false [17:29:26.260] use_implicit_block = false [17:29:26.260] msec_str = "\000\v\207\366\375\177\000\0008t\306\330\302U\000\0000\t\207\366\375\177\000\000W\000\000\000\000\000\000" [17:29:26.260] __func__ = "exec_simple_query" [17:29:26.260] #34 0x000055c2d89b4265 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [17:29:26.260] query_string = 0x55c2d9e72b30 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [17:29:26.260] firstchar = [17:29:26.260] input_message = {data = 0x55c2d9e72b30 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [17:29:26.260] local_sigjmp_buf = {{__jmpbuf = {94295361343736, -9209418345951599119, 4, 140728739498752, 140728739498896, 140728739498900, -3148072453436676623, -9209420402478488079}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94295367552560, 15616, 94295361337824, 94295368076608, 140728739498896, 94295349024175, 0, 9, 2, 94295361343744, 94295367552560, 94295361337824, 140728739498752, 140728739498896, 140728739498900}}}} [17:29:26.260] send_ready_for_query = false [17:29:26.260] idle_in_transaction_timeout_enabled = false [17:29:26.260] idle_session_timeout_enabled = false [17:29:26.260] __func__ = "PostgresMain" [17:29:26.260] #35 0x000055c2d89aa387 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [17:29:26.260] bsdata = [17:29:26.260] #36 0x000055c2d8862dbe in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffdf6870aac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdf6870b00) at ../src/backend/postmaster/launch_backend.c:274 [17:29:26.260] pid = [17:29:26.260] #37 0x000055c2d886886a in BackendStartup (client_sock=client_sock@entry=0x7ffdf6870b00) at ../src/backend/postmaster/postmaster.c:3414 [17:29:26.260] bn = 0x55c2d9e9b5a8 [17:29:26.260] pid = [17:29:26.260] startup_data = {canAcceptConnections = CAC_OK} [17:29:26.260] __func__ = "BackendStartup" [17:29:26.260] #38 0x000055c2d8868dcc in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [17:29:26.260] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\\\036S\177\000\000>\004\000\000\000\000\000\000\260\227\303\034S\177\000\000\240\017\024\036S\177\000\000\270\v\207\366\375\177\000\000\264\v\207\366\375\177", '\000' , "Û\243\327\302U\000\000\020\207\237\327\302U\000\000\200\f\207\366\375\177\000\000x\f\207\366\375\177\000\000\225[\362\001 \033\221$\2404D\035S\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [17:29:26.260] i = 0 [17:29:26.260] now = [17:29:26.260] last_lockfile_recheck_time = 1725211551 [17:29:26.260] last_touch_time = 1725211491 [17:29:26.260] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -158921536, user_data = 0x0}, {pos = 15, events = 0, fd = -677143613, user_data = 0x7f531e5f2668}, {pos = 491009584, events = 32595, fd = 509551328, user_data = 0x7c96e577}, {pos = -158921472, events = 32765, fd = 509381192, user_data = 0xf}, {pos = 491009584, events = 32595, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 509551328, user_data = 0x7ffdf6870c78}, {pos = -158921600, events = 32765, fd = 509552232, user_data = 0x0}, {pos = 32768, events = 0, fd = 8, user_data = 0x55c2d9e74930}, {pos = 1, events = 32595, fd = -158920285, user_data = 0xffffffff}, {pos = 482533408, events = 32595, fd = 504631200, user_data = 0x55c2d9e9f7c8}, {pos = -638978392, events = 21954, fd = -638969663, user_data = 0x7f531e5ceebe}, {pos = 1, events = 0, fd = 509551328, user_data = 0x1b7}, {pos = -652558920, events = 21954, fd = 0, user_data = 0x1}, {pos = -639161360, events = 21954, fd = 509406910, user_data = 0x1}, {pos = 0, events = 0, fd = 482533408, user_data = 0x7f531ccf2dc0 }, {pos = 16, events = 0, fd = -158920496, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f531e5d11ba}, {pos = 0, events = 0, fd = 483061028, user_data = 0x0}, {pos = -645698880, events = 21954, fd = 2, user_data = 0x7}, {pos = -639414576, events = 21954, fd = -661352130, user_data = 0x7367702f65736162}, {pos = 1952410737, events = 28781, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -639161360, events = 21954, fd = 509406910, user_data = 0x1}, {pos = 483094509, events = 32595, fd = 482567368, user_data = 0x55c2d9e9e490}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 484383840, events = 32595, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55c2d9e34ed0}, {pos = 483097098, events = 32595, 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 = 1330665049, fd = 168458090, user_data = 0x32353237310a6174}, {pos = 959721777, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, 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 = 484366816, events = 32595, fd = 483004782, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x24911b20140cad00}, {pos = 484369888, events = 32595, fd = -328, user_data = 0x0}, {pos = -638978712, events = 21954, fd = 1024, user_data = 0x55c2d9e9f568}, {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 = 15730, events = 0, fd = -328, user_data = 0x0}, {pos = -639161360, events = 21954, fd = 483340243, user_data = 0x7ffdf6871188}, {pos = -657880154, events = 21954, fd = -645640016, user_data = 0x55c2d8c87663 }, {pos = -638978912, events = 21954, fd = -639161808, user_data = 0x55c2d9e9f4a0}, {pos = 483088446, events = 32595, fd = 0, user_data = 0x55c2d8c992cd }, {pos = -638978912, events = 1, fd = -657877994, user_data = 0x55c2d9e72a30}, {pos = 336375040, events = 613489440, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 483011249, user_data = 0x7f531cca14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 336375040, user_data = 0x55c2d9e4a160}, {pos = 336375040, events = 613489440, fd = 11, user_data = 0x24911b20140cad00}, {pos = 0, events = 0, fd = 482718265, user_data = 0x1}, {pos = -662295877, events = 21954, fd = 4194304, user_data = 0x55c2d8c874f7 }, {pos = -639327904, events = 21954, fd = -639161808, user_data = 0x55c2d9e4a160}, {pos = 1, events = 0, fd = 0, user_data = 0x55c2d8c992cd }, {pos = -639327904, events = 21954, fd = -657877994, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55c2d869b661 }, {pos = 0, events = 0, fd = -664139349, user_data = 0xb}, {pos = -662274728, events = 21954, fd = -649226096, user_data = 0x55c2d9e73408}} [17:29:26.260] nevents = 1 [17:29:26.260] __func__ = "ServerLoop" [17:29:26.260] #39 0x000055c2d886a542 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55c2d9e30d90) at ../src/backend/postmaster/postmaster.c:1346 [17:29:26.260] opt = [17:29:26.260] status = [17:29:26.260] userDoption = [17:29:26.260] listen_addr_saved = false [17:29:26.260] output_config_variable = [17:29:26.260] __func__ = "PostmasterMain" [17:29:26.260] #40 0x000055c2d86aba8c in main (argc=8, argv=0x55c2d9e30d90) at ../src/backend/main/main.c:197 [17:29:26.260] do_check_root =