[19:54:18.487] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [19:54:18.822] dumping /tmp/cores/postgres.12457.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [19:54:18.945] [New LWP 101690] [19:54:19.024] Core was generated by `postgres: postgres regression [local] DELETE'. [19:54:19.024] Program terminated with signal SIGABRT, Aborted. [19:54:19.024] Sent by thr_kill() from pid 12457 and user 1003. [19:54:19.024] #0 0x000000082bf5d41a in thr_kill () from /lib/libc.so.7 [19:54:19.158] [19:54:19.158] Thread 1 (LWP 101690): [19:54:19.158] #0 0x000000082bf5d41a in thr_kill () from /lib/libc.so.7 [19:54:19.158] No symbol table info available. [19:54:19.158] #1 0x000000082bed6e64 in raise () from /lib/libc.so.7 [19:54:19.158] No symbol table info available. [19:54:19.158] #2 0x000000082bf876f9 in abort () from /lib/libc.so.7 [19:54:19.158] No symbol table info available. [19:54:19.158] #3 0x0000000000a58dc5 in ExceptionalCondition (conditionName=0x2ad5c9 "!BTScanPosIsPinned(so->currPos)", fileName=, lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [19:54:19.158] No locals. [19:54:19.158] #4 0x00000000005ef846 in _bt_readnextpage (scan=scan@entry=0x84a5935d0, blkno=1, expectNext=2, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [19:54:19.158] rel = 0x844d177d8 [19:54:19.158] so = 0x8370d8b78 [19:54:19.158] page = [19:54:19.158] status = [19:54:19.158] opaque = [19:54:19.158] #5 0x00000000005ee8d0 in _bt_steppage (scan=scan@entry=0x84a5935d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [19:54:19.158] blkno = 2 [19:54:19.158] expectNext = 4 [19:54:19.158] so = 0x8370d8b78 [19:54:19.158] status = [19:54:19.158] #6 0x00000000005ed556 in _bt_first (scan=scan@entry=0x84a5935d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [19:54:19.158] buf = 11106 [19:54:19.158] 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 = 0x5dcaa0 , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x84a593000, fn_expr = 0x84a6da038}, sk_argument = 0}, {sk_flags = 1638426, sk_attno = 24, sk_strategy = 23, sk_subtype = 1376278, sk_collation = 1245204, sk_func = {fn_addr = 0xf001000110012, fn_oid = 851982, fn_nargs = 12, fn_strict = 11, fn_retset = false, fn_stats = 10 '\n', fn_extra = 0x3000400050006, fn_mcxt = 0x27002800010002, fn_expr = 0x23002400250026}, sk_argument = 8725861719146530}, {sk_flags = 1221923288, sk_attno = 8, sk_strategy = 0, sk_subtype = 1638426, sk_collation = 1507352, sk_func = {fn_addr = 0x13001400150016, fn_oid = 1114130, fn_nargs = 16, fn_strict = 15, fn_retset = false, fn_stats = 14 '\016', fn_extra = 0x700080009000a, fn_mcxt = 0x3000400050006, fn_expr = 0x10002}, sk_argument = 6146720}, {sk_flags = 351, sk_attno = 2, sk_strategy = 1, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0xaa7b55 , fn_oid = 555815056, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 251 '\373', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x821210ac0}, sk_argument = 11173323}, {sk_flags = 1221923288, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x821210ae0, fn_oid = 11173323, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0xa68239 , fn_mcxt = 0x0, fn_expr = 0x3039323733aa7b55}, sk_argument = 0}, {sk_flags = 3719588, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x821211090, fn_oid = 555815328, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 85 'U', fn_extra = 0x38c1a4, fn_mcxt = 0x2cece9, fn_expr = 0x8212111a0}, sk_argument = 3719596}, {sk_flags = 555815040, sk_attno = 8, sk_strategy = 0, sk_subtype = 11167385, sk_collation = 0, sk_func = {fn_addr = 0x5dcc60 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x836f5e000, fn_expr = 0x8370f8838}, sk_argument = 2620}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 555813808, sk_collation = 8, sk_func = {fn_addr = 0x1000101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x5dcc60 }, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x836f5e000, fn_oid = 923670432, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 60 '<', fn_extra = 0x200020000, fn_mcxt = 0x3b600000000, fn_expr = 0x5dca50 }, sk_argument = 281483566645598}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5d17ba , fn_oid = 1222929304, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x848e46b98}, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x836f5e000, fn_oid = 923670432, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 152 '\230', fn_extra = 0x200020000, fn_mcxt = 0x3b600000000, fn_expr = 0x5d17ba }, sk_argument = 35582667672}, {sk_flags = 10912313, sk_attno = 0, sk_strategy = 0, sk_subtype = 1221923288, sk_collation = 8, sk_func = {fn_addr = 0x5d17ba , fn_oid = 644, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x284, fn_mcxt = 0x0, fn_expr = 0x821210cf0}, sk_argument = 9147970}, {sk_flags = 16843009, sk_attno = 0, sk_strategy = 0, sk_subtype = 20, sk_collation = 0, sk_func = {fn_addr = 0x2d1292d401010101, fn_oid = 1122759552, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0xa68239 , fn_mcxt = 0x821210cf0, fn_expr = 0x91c46f }, sk_argument = 1042}, {sk_flags = 986965952, sk_attno = 8, sk_strategy = 0, sk_subtype = 1042, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 555814240, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 66 'B', fn_extra = 0x1, fn_mcxt = 0xb, fn_expr = 0xbb5910ab00000007}, sk_argument = 35482497920}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098624, sk_collation = 0, sk_func = {fn_addr = 0x821210d60, fn_oid = 9553007, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 72 'H', fn_extra = 0x8370acb48, fn_mcxt = 0x1, fn_expr = 0x8}, sk_argument = 34915552816}, {sk_flags = 9157226, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 8, sk_func = {fn_addr = 0xffffffff00000009, fn_oid = 8, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 24 '\030', fn_extra = 0x70, fn_mcxt = 0x837093548, fn_expr = 0x821210ecc}, sk_argument = 8}, {sk_flags = 513, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912894, sk_collation = 1663, sk_func = {fn_addr = 0x4e100004000, fn_oid = 0, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x821210e00, fn_expr = 0x621eaf }, sk_argument = 12100176}, {sk_flags = 15952, sk_attno = 0, sk_strategy = 0, sk_subtype = 555814480, sk_collation = 8, sk_func = {fn_addr = 0x8d7fb6 , fn_oid = 1042, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x401, fn_mcxt = 0x8370381c0, fn_expr = 0x821210e50}, sk_argument = 11874}, {sk_flags = 1154578392, sk_attno = 8, sk_strategy = 0, sk_subtype = 1085214720, sk_collation = 8, sk_func = {fn_addr = 0x821210e70, fn_oid = 6430383, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 80 'P', fn_extra = 0x406f, fn_mcxt = 0x821210ec0, fn_expr = 0x8d7fb6 }, sk_argument = 35607099200}, {sk_flags = 9561429, sk_attno = 0, sk_strategy = 0, sk_subtype = 1236362940, sk_collation = 0, sk_func = {fn_addr = 0x839ae2f68, fn_oid = 555814592, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 206 '\316', fn_extra = 0x837091868, fn_mcxt = 0x8407c9000, fn_expr = 0x821210ee0}, sk_argument = 6430383}, {sk_flags = 12100176, sk_attno = 0, sk_strategy = 0, sk_subtype = 16487, sk_collation = 0, sk_func = {fn_addr = 0x821210f30, fn_oid = 9273270, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0xa3c}, sk_argument = 34915553072}, {sk_flags = 11293, sk_attno = 0, sk_strategy = 0, sk_subtype = 923350344, sk_collation = 8, sk_func = {fn_addr = 0x840667000, fn_oid = 555815424, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 66 'B', fn_extra = 0xa3c, fn_mcxt = 0xa68239 , fn_expr = 0x821210f80}, sk_argument = 35514316832}, {sk_flags = 11470, sk_attno = 0, sk_strategy = 0, sk_subtype = 987633344, sk_collation = 8, sk_func = {fn_addr = 0x2cce, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x8b9642 , fn_mcxt = 0x1, fn_expr = 0x14}, sk_argument = 9749575710380392452}, {sk_flags = 1122759552, sk_attno = 8, sk_strategy = 0, sk_subtype = 20, sk_collation = 0, sk_func = {fn_addr = 0xa68239 , fn_oid = 555814912, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0xb84001 , fn_mcxt = 0x0, fn_expr = 0xb95ad0 }, sk_argument = 1}, {sk_flags = 922950656, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8212110a0, fn_oid = 10742610, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 174 '\256', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 37294}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x91ae, fn_oid = 102, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0xb95ad0 , fn_mcxt = 0x844d13ad8, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = 555815072, sk_attno = 8, sk_strategy = 0, sk_subtype = 10742879, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 11011721, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x84a5942f0, fn_mcxt = 0x84a63e7e0, fn_expr = 0x844d177d8}, sk_argument = 1}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 555815216, sk_collation = 8, sk_func = {fn_addr = 0xa4a085 , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x44d1add8, fn_mcxt = 0x844d177d8, fn_expr = 0x1000091ae}, sk_argument = 5}, {sk_flags = 1248060992, sk_attno = 8, sk_strategy = 0, sk_subtype = 923467048, sk_collation = 8, sk_func = {fn_addr = 0x844d1add8, fn_oid = 1154578392, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xa49b35 , fn_mcxt = 0x2c01, fn_expr = 0x1}, sk_argument = 6}, {sk_flags = 10912313, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x84a5931a0, fn_oid = 555815424, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 57 '9', fn_extra = 0x821211200, fn_mcxt = 0x82bf9a055, fn_expr = 0x83702b100}, sk_argument = 35327455168}, {sk_flags = 11293, sk_attno = 2, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x83702b100, fn_oid = 922923408, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0x0, fn_mcxt = 0x5aa281666e654703, fn_expr = 0x84a593000}, sk_argument = 27416}, {sk_flags = 27352, sk_attno = 0, sk_strategy = 0, sk_subtype = 555815536, sk_collation = 8, sk_func = {fn_addr = 0x82bf9a055, fn_oid = 555815488, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 103 'g', fn_extra = 0x2000, fn_mcxt = 0x844d177d8, fn_expr = 0x0}, sk_argument = 1}}} [19:54:19.158] startKeys = {0x84a593500, 0x0, 0x84a593000, 0x8370f7ba0, 0x91aa, 0xb700b800b900ba, 0xb300b400b500b6, 0xaf000000000101, 0x0, 0xa700a800000001, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x84a593000, 0x8370f8838, 0x91ae, 0x7f008000810082, 0x7b007c007d007e, 0x77000001000101, 0x0, 0x6f007000000002, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x84a593000, 0x8370e17a0} [19:54:19.158] notnullkeys = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x20000000003b6, fn_oid = 2650, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xa3c, fn_mcxt = 0x30000, fn_expr = 0x0}, sk_argument = 34915549136}, {sk_flags = 6248338, sk_attno = 0, sk_strategy = 0, sk_subtype = 986933632, sk_collation = 8, sk_func = {fn_addr = 0x8370d8b78, fn_oid = 1221924280, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x3708dd28, fn_mcxt = 0xa68239 , fn_expr = 0x370d8b01}, sk_argument = 8589934593}, {sk_flags = 5178, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912313, sk_collation = 0, sk_func = {fn_addr = 0x143a, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 58 ':', fn_extra = 0x83ad7f1c0, fn_mcxt = 0x143a, fn_expr = 0x0}, sk_argument = 34915549264}, {sk_flags = 10912313, sk_attno = 0, sk_strategy = 0, sk_subtype = 5188, sk_collation = 0, sk_func = {fn_addr = 0xd, fn_oid = 5188, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x1444, fn_mcxt = 0xa68239 , fn_expr = 0x821210090}, sk_argument = 9147970}, {sk_flags = 538, sk_attno = 0, sk_strategy = 0, sk_subtype = 986933696, sk_collation = 8, sk_func = {fn_addr = 0x21a, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0xa68239 , fn_mcxt = 0x21210090, fn_expr = 0x6}, sk_argument = 539}, {sk_flags = 986933760, sk_attno = 8, sk_strategy = 0, sk_subtype = 539, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 555811072, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 66 'B', fn_extra = 0x3708dd28, fn_mcxt = 0x0, fn_expr = 0xd7efca000000001}, sk_argument = 35482497920}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098624, sk_collation = 0, sk_func = {fn_addr = 0x821210100, fn_oid = 9553007, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x8370acbc8, fn_mcxt = 0x1, fn_expr = 0x4}, sk_argument = 34915549648}, {sk_flags = 9157226, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 8, sk_func = {fn_addr = 0xffffffff00000005, fn_oid = 555811200, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 74 'J', fn_extra = 0x70, fn_mcxt = 0x848e46618, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 950, sk_attno = 0, sk_strategy = 2, sk_subtype = 3380, sk_collation = 0, sk_func = {fn_addr = 0xa6300004000, fn_oid = 3379, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x821210200, fn_expr = 0x5f5792 <_bt_check_compare+1218>}, sk_argument = 35346672128}, {sk_flags = 923634552, sk_attno = 8, sk_strategy = 0, sk_subtype = 1221924280, sk_collation = 8, sk_func = {fn_addr = 0x848e46608, fn_oid = 923327784, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x370d8b01, fn_mcxt = 0x200000001, fn_expr = 0x3b6}, sk_argument = 34915549880}, {sk_flags = 555811548, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 992363008, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 160 '\240', fn_extra = 0x5f4fa1 <_bt_checkkeys+321>, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 34915549815}, {sk_flags = 555811396, sk_attno = 8, sk_strategy = 0, sk_subtype = 555811548, sk_collation = 8, sk_func = {fn_addr = 0xa6264a , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x83708df38, fn_mcxt = 0x0, fn_expr = 0x848d515b8}, sk_argument = 8599100770}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 923634552, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 10912313, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xe0, fn_mcxt = 0x21ec, fn_expr = 0x83adb5e40}, sk_argument = 8684}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 555811632, sk_collation = 8, sk_func = {fn_addr = 0x8b9642 , fn_oid = 555811664, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0xf3c7e5e100000000, fn_mcxt = 0x842ebf380, fn_expr = 0x14}, sk_argument = 12098624}, {sk_flags = 555811632, sk_attno = 8, sk_strategy = 0, sk_subtype = 9553007, sk_collation = 0, sk_func = {fn_addr = 0x844d1d288, fn_oid = 922988360, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x1, fn_mcxt = 0x821210400, fn_expr = 0x8bba6a }, sk_argument = 1}, {sk_flags = 2, sk_attno = -1, sk_strategy = 65535, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0xb85318 , fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x82121049c, fn_mcxt = 0x1, fn_expr = 0x370d8b78}, sk_argument = 7142530613279}, {sk_flags = 16384, sk_attno = 3379, sk_strategy = 0, sk_subtype = 0, sk_collation = 1, sk_func = {fn_addr = 0x100000000, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x91c46f , fn_mcxt = 0x83adb5e40, fn_expr = 0x200000000}, sk_argument = 72057594037927937}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1154601608, sk_collation = 8, sk_func = {fn_addr = 0x70, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x8212104d0, fn_mcxt = 0x8b9887 , fn_expr = 0x70}, sk_argument = 35514339976}, {sk_flags = 555812172, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x40000000067f, fn_oid = 3379, fn_nargs = 1663, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x83703af48, fn_mcxt = 0x70, fn_expr = 0x0}, sk_argument = 34915550448}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 986946048, sk_collation = 8, sk_func = {fn_addr = 0x200000000, fn_oid = 1, fn_nargs = 8, fn_strict = false, fn_retset = true, fn_stats = 0 '\000', fn_extra = 0x21ec, fn_mcxt = 0x1, fn_expr = 0x821210500}, sk_argument = 10888778}, {sk_flags = 1247361280, sk_attno = 8, sk_strategy = 0, sk_subtype = 1247361352, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x8bdd62 , fn_mcxt = 0x21ec, fn_expr = 0x8370d8bd0}, sk_argument = 35347193408}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 1154601608, sk_collation = 8, sk_func = {fn_addr = 0x8370d8b78, fn_oid = 555812224, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 199 '\307', fn_extra = 0x84a593500, fn_mcxt = 0x58000100000001, fn_expr = 0x0}, sk_argument = 35283372920}, {sk_flags = 1247361280, sk_attno = 8, sk_strategy = 0, sk_subtype = 257, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 1, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x3b600000000, fn_mcxt = 0x5dcc60 , fn_expr = 0x1000200000164}, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1247358976, sk_collation = 8, sk_func = {fn_addr = 0x8370f8838, fn_oid = 2620, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x1, fn_mcxt = 0x1000101, fn_expr = 0x0}, sk_argument = 2}, {sk_flags = 196608, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5dcc60 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x84a593000, fn_expr = 0x8370e17a0}, sk_argument = 2620}, {sk_flags = 131072, sk_attno = 2, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5dca50 , fn_oid = 350, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x84a593000, fn_expr = 0x8370e1a48}, sk_argument = 0}, {sk_flags = 196608, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5dcc60 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x84a593000, fn_expr = 0x8370e17a0}, sk_argument = 2656}, {sk_flags = 131072, sk_attno = 2, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5dca50 , fn_oid = 350, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x84a593500, fn_mcxt = 0x84a593000, fn_expr = 0x8370e1a48}, sk_argument = 0}, {sk_flags = 2604, sk_attno = 0, sk_strategy = 0, sk_subtype = 131072, sk_collation = 2, sk_func = {fn_addr = 0x3b600000000, fn_oid = 6146640, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 94 '^', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x84a593000}, sk_argument = 35283409480}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1247360256, sk_collation = 8, sk_func = {fn_addr = 0x2000000f2, fn_oid = 555815368, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x212107b0, fn_mcxt = 0x1, fn_expr = 0xb89c48 }, sk_argument = 35346816896}, {sk_flags = 987078528, sk_attno = 8, sk_strategy = 0, sk_subtype = 1221923736, sk_collation = 8, sk_func = {fn_addr = 0x8370d8b78, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x848d51398, fn_mcxt = 0x84a5937f0, fn_expr = 0x84a593838}, sk_argument = 2}, {sk_flags = 4264696, sk_attno = 0, sk_strategy = 0, sk_subtype = 555812944, sk_collation = 8, sk_func = {fn_addr = 0x101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x5dcc60 }, sk_argument = 281483566645604}} [19:54:19.158] blkno = 8 [19:54:19.158] rel = 0x844d177d8 [19:54:19.158] so = 0x8370d8b78 [19:54:19.158] keysz = [19:54:19.158] strat_total = 1 [19:54:19.158] i = [19:54:19.158] strat = [19:54:19.158] stack = [19:54:19.158] offnum = [19:54:19.158] status = [19:54:19.158] currItem = [19:54:19.158] #7 0x00000000005e9ee3 in btgettuple (scan=0x84a5935d0, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [19:54:19.158] so = 0x8370d8b78 [19:54:19.158] res = [19:54:19.158] #8 0x00000000005dbf11 in index_getnext_tid (scan=scan@entry=0x84a5935d0, direction=6, direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [19:54:19.158] found = [19:54:19.158] #9 0x0000000000a06ba8 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x844d1d6b8, indexRel=indexRel@entry=0x844d177d8, indexscandir=BackwardScanDirection, scankeys=scankeys@entry=0x821211530, typLen=4, typByVal=true, tableslot=0x84a593360, outercontext=0x836f5e000, endpointDatum=0x848e473f8) at ../src/backend/utils/adt/selfuncs.c:6349 [19:54:19.158] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 0, xmax = 555816016, xip = 0xa3ed88 , xcnt = 12075009, subxip = 0x0, subxcnt = 12147408, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0xb8a260 , active_count = 0, regd_count = 0, ph_node = {first_child = 0x8212114f0, next_sibling = 0xa3eb52 , prev_or_parent = 0x17}, whenTaken = 0, lsn = 0, snapXactCompletionCount = 0} [19:54:19.158] vmbuffer = 0 [19:54:19.158] values = {34915554464, 10795333, 844429225099264, 4080218931200, 10233264, 281483566645432, 514, 0, 35607097344, 0, 37294, 1407383473487872, 4080218931200, 9916896, 281483566645394, 6100738, 0, 35607097344, 0, 0, 844429225099264, 4080218931200, 10233264, 10912313, 2940418, 0, 35607097344, 34915554400, 37290, 0, 35282661632, 35607098208} [19:54:19.158] isnull = {23, false , 23, false, false, false, false, false, false, false} [19:54:19.158] have_data = false [19:54:19.158] last_heap_block = 4294967295 [19:54:19.158] n_visited_heap_pages = 0 [19:54:19.158] index_scan = 0x84a5935d0 [19:54:19.158] tid = [19:54:19.158] oldcontext = [19:54:19.158] #10 0x00000000009fe932 in get_actual_variable_range (root=, vardata=, sortop=97, collation=, min=0x0, max=0x848e473f8) at ../src/backend/utils/adt/selfuncs.c:6228 [19:54:19.158] typLen = 4 [19:54:19.158] tmpcontext = 0x84a593000 [19:54:19.158] oldcontext = 0x836f5e000 [19:54:19.158] heapRel = 0x844d1d6b8 [19:54:19.158] slot = 0x84a593360 [19:54:19.158] typByVal = true [19:54:19.158] scankeys = {{sk_flags = 129, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}} [19:54:19.158] indexRel = 0x844d177d8 [19:54:19.158] index = [19:54:19.158] indexscandir = ForwardScanDirection [19:54:19.158] lc__state = {l = , i = 0} [19:54:19.158] have_data = false [19:54:19.158] rel = [19:54:19.158] rte = 0x848d52e98 [19:54:19.158] lc = [19:54:19.158] #11 0x00000000009fe234 in ineq_histogram_selectivity (root=root@entry=0x836f5f240, vardata=vardata@entry=0x8212117d0, opoid=opoid@entry=523, opproc=opproc@entry=0x821211730, isgt=false, iseq=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [19:54:19.158] probe = 100 [19:54:19.158] ltcmp = [19:54:19.158] lobound = 99 [19:54:19.158] hibound = 101 [19:54:19.158] have_end = false [19:54:19.158] histfrac = [19:54:19.158] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x848e470d8, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [19:54:19.158] hist_selec = -1 [19:54:19.158] #12 0x0000000000a02571 in scalarineqsel (root=root@entry=0x836f5f240, operator=operator@entry=523, isgt=false, iseq=true, collation=0, vardata=vardata@entry=0x8212117d0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [19:54:19.158] opproc = {fn_addr = 0x975100 , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x836f5e000, fn_expr = 0x0} [19:54:19.158] sumcommon = 0 [19:54:19.158] mcv_selec = [19:54:19.158] hist_selec = [19:54:19.158] selec = [19:54:19.158] stats = [19:54:19.158] #13 0x00000000009ff223 in scalarineqsel_wrapper (fcinfo=, isgt=false, iseq=true) at ../src/backend/utils/adt/selfuncs.c:1459 [19:54:19.158] vardata = {var = 0x848e45ea8, rel = 0x848e462c8, statsTuple = 0x844d185f8, freefunc = 0xa53de0 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [19:54:19.158] other = 0x848e47538 [19:54:19.158] varonleft = true [19:54:19.158] root = 0x836f5f240 [19:54:19.158] operator = 523 [19:54:19.158] args = [19:54:19.158] varRelid = [19:54:19.158] collation = 0 [19:54:19.158] constval = 34915570152 [19:54:19.158] consttype = 738264736 [19:54:19.158] selec = [19:54:19.158] #14 0x0000000000a62f6f in FunctionCall4Coll (flinfo=0x821211860, collation=0, arg1=35281826368, arg2=523, arg3=35582664840, arg4=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [19:54:19.158] fcinfodata = {fcinfo = {flinfo = 0x821211860, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x8212118b0}, fcinfo_data = "`\030!!\b", '\000' , "\004\000@\362\3656\b", '\000' , "\v\002\000\000\000\000\000\000\000\000\2179\b\000\000\000\210`\344H\b\000\000\000\000\362\3656\b", '\000' , "\354\243\000\000\000\000"} [19:54:19.158] fcinfo = 0x821211890 [19:54:19.158] result = [19:54:19.158] __error = [19:54:19.158] #15 OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=35281826368, arg2=arg2@entry=523, arg3=arg3@entry=35582664840, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [19:54:19.158] flinfo = {fn_addr = 0x9ff270 , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x836f5e000, fn_expr = 0x0} [19:54:19.158] #16 0x000000000080153e in restriction_selectivity (root=root@entry=0x836f5f240, operatorid=523, args=0x848e46088, inputcollid=0, varRelid=varRelid@entry=0) at ../src/backend/optimizer/util/plancat.c:1963 [19:54:19.158] oprrest = 0 [19:54:19.158] result = [19:54:19.158] #17 0x00000000007a85e4 in clause_selectivity_ext (root=root@entry=0x836f5f240, clause=0x848e46128, clause@entry=0x848d51398, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:848 [19:54:19.158] opclause = 0x848e46128 [19:54:19.158] opno = [19:54:19.158] s1 = 0.5 [19:54:19.158] rinfo = 0x848d51398 [19:54:19.158] cacheable = true [19:54:19.158] #18 0x00000000007a8005 in clauselist_selectivity_ext (root=0x836f5f240, clauses=0x848e47028, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:183 [19:54:19.158] clause = 0x848d51398 [19:54:19.158] s2 = [19:54:19.158] rinfo = [19:54:19.158] l__state = {l = 0x848e47028, i = 1} [19:54:19.158] estimatedclauses = 0x0 [19:54:19.158] rqlist = 0x848e474e8 [19:54:19.158] s1 = 1 [19:54:19.158] rel = [19:54:19.158] listidx = 1 [19:54:19.158] l = [19:54:19.158] #19 0x00000000007a7ea0 in clauselist_selectivity (root=0x18d3a, clauses=0x6, varRelid=varRelid@entry=0, jointype=737530874, jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [19:54:19.158] No locals. [19:54:19.158] #20 0x00000000007afc44 in set_baserel_size_estimates (root=0x18d3a, root@entry=0x836f5f240, rel=rel@entry=0x848e462c8) at ../src/backend/optimizer/path/costsize.c:5286 [19:54:19.158] nrows = [19:54:19.158] #21 0x00000000007a6921 in set_plain_rel_size (root=0x836f5f240, rel=0x848e462c8, rte=0x848d52e98) at ../src/backend/optimizer/path/allpaths.c:581 [19:54:19.158] No locals. [19:54:19.158] #22 set_rel_size (root=root@entry=0x836f5f240, rel=rel@entry=0x848e462c8, rti=rti@entry=1, rte=rte@entry=0x848d52e98) at ../src/backend/optimizer/path/allpaths.c:411 [19:54:19.158] No locals. [19:54:19.158] #23 0x00000000007a3671 in set_base_rel_sizes (root=0x836f5f240) at ../src/backend/optimizer/path/allpaths.c:322 [19:54:19.158] rel = 0x848e462c8 [19:54:19.158] rte = 0x848d52e98 [19:54:19.158] rti = 1 [19:54:19.158] #24 make_one_rel (root=root@entry=0x836f5f240, joinlist=joinlist@entry=0x848e46f38) at ../src/backend/optimizer/path/allpaths.c:183 [19:54:19.158] total_pages = [19:54:19.158] rti = [19:54:19.158] rel = [19:54:19.158] #25 0x00000000007d3e44 in query_planner (root=root@entry=0x836f5f240, qp_callback=, qp_extra=qp_extra@entry=0x821211c20) at ../src/backend/optimizer/plan/planmain.c:280 [19:54:19.158] parse = 0x848e455f8 [19:54:19.158] final_rel = [19:54:19.158] joinlist = 0x848e46f38 [19:54:19.158] #26 0x00000000007d6e5b in grouping_planner (root=root@entry=0x836f5f240, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [19:54:19.158] sort_input_targets = 0x848d519d4 [19:54:19.158] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [19:54:19.158] activeWindows = 0x0 [19:54:19.158] grouping_target = [19:54:19.158] scanjoin_target = [19:54:19.158] sort_input_target_parallel_safe = [19:54:19.158] sort_input_targets_contain_srfs = 0x7f3da0 [19:54:19.158] wflists = 0x0 [19:54:19.158] gset_data = 0x0 [19:54:19.158] have_grouping = [19:54:19.158] grouping_targets = 0x848e46248 [19:54:19.158] scanjoin_targets = 0x79aaf1 [19:54:19.158] sort_input_target = [19:54:19.158] grouping_target_parallel_safe = [19:54:19.158] scanjoin_target_parallel_safe = [19:54:19.158] grouping_targets_contain_srfs = 0x848e46248 [19:54:19.158] scanjoin_targets_contain_srfs = 0x0 [19:54:19.158] scanjoin_target_same_exprs = [19:54:19.158] final_targets = 0x0 [19:54:19.158] final_targets_contain_srfs = 0x821211d80 [19:54:19.158] extra = {limit_needed = 241, limit_tuples = 1.1857575500189917e-321, count_est = 35582664360, offset_est = 35582664840} [19:54:19.158] parse = 0x848e455f8 [19:54:19.158] offset_est = 0 [19:54:19.158] count_est = 0 [19:54:19.158] limit_tuples = -1 [19:54:19.158] have_postponed_srfs = false [19:54:19.158] current_rel = [19:54:19.158] final_target = [19:54:19.158] final_target_parallel_safe = [19:54:19.158] final_rel = [19:54:19.158] lc = [19:54:19.158] #27 0x00000000007d54f9 in subquery_planner (glob=glob@entry=0x836f5fa18, parse=parse@entry=0x848e455f8, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1089 [19:54:19.158] root = 0x836f5f240 [19:54:19.158] hasOuterJoins = false [19:54:19.158] hasResultRTEs = false [19:54:19.158] l = [19:54:19.158] newWithCheckOptions = [19:54:19.158] newHaving = [19:54:19.158] final_rel = [19:54:19.158] #28 0x00000000007d4028 in standard_planner (parse=0x848e455f8, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:415 [19:54:19.158] glob = 0x836f5fa18 [19:54:19.158] tuple_fraction = [19:54:19.158] root = [19:54:19.158] final_rel = [19:54:19.158] best_path = [19:54:19.158] top_plan = [19:54:19.158] lp = [19:54:19.158] lr = [19:54:19.158] result = [19:54:19.158] #29 0x00000000008fd964 in pg_plan_query (querytree=querytree@entry=0x848e455f8, query_string=query_string@entry=0x836f5e100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:912 [19:54:19.158] plan = [19:54:19.158] #30 0x00000000008fda62 in pg_plan_queries (querytrees=0x848e45d88, query_string=query_string@entry=0x836f5e100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1006 [19:54:19.158] query = 0x848e455f8 [19:54:19.158] stmt = [19:54:19.158] query_list__state = {l = 0x848e45d88, i = 0} [19:54:19.158] stmt_list = 0x0 [19:54:19.158] query_list = [19:54:19.158] #31 0x0000000000901ed0 in exec_simple_query (query_string=query_string@entry=0x836f5e100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [19:54:19.158] cmdtaglen = 6 [19:54:19.158] snapshot_set = [19:54:19.158] per_parsetree_context = 0x0 [19:54:19.158] plantree_list = [19:54:19.158] qc = {commandTag = 555819008, nprocessed = 35097254575} [19:54:19.158] format = 8 [19:54:19.158] parsetree = 0x836f5f650 [19:54:19.158] commandTag = CMDTAG_DELETE [19:54:19.158] cmdtagname = [19:54:19.158] querytree_list = 0x0 [19:54:19.158] portal = [19:54:19.158] receiver = [19:54:19.158] parsetree_item__state = {l = 0x836f5f9c8, i = 0} [19:54:19.158] msec_str = "\000 !!\b\000\000\000\257\232\365+\b\000\000\000\214\"\322f\000\000\000\000\251JΎ4\373\332\001" [19:54:19.158] dest = DestRemote [19:54:19.158] was_logged = [19:54:19.158] oldcontext = 0x837038000 [19:54:19.158] parsetree_list = 0x836f5f9c8 [19:54:19.158] use_implicit_block = false [19:54:19.158] parsetree_item = 0x836f5f9e0 [19:54:19.158] save_log_statement_stats = [19:54:19.158] #32 0x00000000008ffd30 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [19:54:19.158] query_string = 0x836f5e100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [19:54:19.158] input_message = {data = 0x836f5e100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [19:54:19.158] firstchar = [19:54:19.158] local_sigjmp_buf = {{_sjb = {9433542, 34915557520, 34915557480, 34915558064, 12147320, 1, 8192, 8388608, 34915550079, 0, 0, 1}}} [19:54:19.158] send_ready_for_query = false [19:54:19.158] idle_in_transaction_timeout_enabled = false [19:54:19.158] idle_session_timeout_enabled = false [19:54:19.158] #33 0x00000000008fa509 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:54:19.158] bsdata = [19:54:19.158] #34 0x00000000008545b7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821212dd4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821212d10) at ../src/backend/postmaster/launch_backend.c:274 [19:54:19.158] pid = [19:54:19.158] #35 0x0000000000858978 in BackendStartup (client_sock=0x821212d10) at ../src/backend/postmaster/postmaster.c:3414 [19:54:19.158] startup_data = {canAcceptConnections = CAC_OK} [19:54:19.158] bn = 0x836f6a1c8 [19:54:19.158] pid = [19:54:19.158] __error = [19:54:19.158] save_errno = [19:54:19.158] __error = [19:54:19.158] __error = [19:54:19.158] #36 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:54:19.158] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\377\3656\b", '\000' , "p-!!\b\000\000\000h%\274)\b\000\000\000\v\000\000\000\000\000\000\000^\257\274)\b", '\000' , "\260-!!\b\000\000\000dC\205\000\000\000\000\000\300-!!\b", '\000' }, salen = 16}} [19:54:19.158] i = 0 [19:54:19.158] now = [19:54:19.158] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 737156226, events = 8, fd = 0, user_data = 0x821212cc0}, {pos = 922482136, events = 8, fd = 555821904, user_data = 0x0}, {pos = 0, events = 0, fd = 1852131075, user_data = 0x2554c12d430a}, {pos = 736323488, events = 8, fd = 736394616, user_data = 0x8212127d8}, {pos = 555821136, events = 8, fd = 555821016, user_data = 0x2554c12d430a}, {pos = 736301960, events = 8, fd = 736394616, user_data = 0x821212808}, {pos = 555821184, events = 8, fd = 555821064, user_data = 0x82be40194}, {pos = 570725384, events = 8, fd = 736362900, user_data = 0x821212870}, {pos = -1054018502, events = 9556, fd = 738185264, user_data = 0x1}, {pos = 555821216, events = 8, fd = -1053998326, user_data = 0x82be29858}, {pos = 736394616, events = 8, fd = 555821176, user_data = 0x8212128f0}, {pos = 555821176, events = 8, fd = 736357644, user_data = 0x822049408}, {pos = 736357644, events = 8, fd = 555821280, user_data = 0x2554c12cf43a}, {pos = 555821320, events = 8, fd = 555821768, user_data = 0x8212128f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1520599398, fd = 570748984, user_data = 0x800000001}, {pos = 570725384, events = 8, fd = 736301960, user_data = 0x82204e288}, {pos = 736270424, events = 8, fd = 570725384, user_data = 0x821212978}, {pos = 555821880, events = 8, fd = 555821408, user_data = 0x2554c12d3ca2}, {pos = 2699824, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 570748984, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 555822136, user_data = 0x22049408}, {pos = 555821952, events = 8, fd = 555821552, user_data = 0x1}, {pos = 555821880, events = 8, fd = 32, user_data = 0x8212129e0}, {pos = -1054000525, events = 9556, fd = 555821824, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82204f038}, {pos = 1, events = 8, fd = 570725384, user_data = 0x82be29858}, {pos = 555822136, events = 8, fd = 555821952, user_data = 0x8212129f0}, {pos = 0, events = 0, fd = 570695688, user_data = 0x20}, {pos = 555821936, events = 8, fd = -1054024985, user_data = 0x822042008}, {pos = 570696712, events = 8, fd = 570697736, user_data = 0x822042c08}, {pos = 570712072, events = 8, fd = 570713096, user_data = 0x822046808}, {pos = 570715144, events = 8, fd = 570716168, user_data = 0x822047408}, {pos = 570718216, events = 8, fd = 570719240, user_data = 0x822048008}, {pos = 570721288, events = 8, fd = 570722312, user_data = 0x822048c08}, {pos = 570724360, events = 8, fd = 570725384, user_data = 0x822049808}, {pos = 570727432, events = 8, fd = 570728456, user_data = 0x82204a408}, {pos = 570730504, events = 8, fd = 570731528, user_data = 0x82204b008}, {pos = 570733576, events = 8, fd = 570734600, user_data = 0x82204bc08}, {pos = 570740744, events = 8, fd = 570741768, user_data = 0x82204d808}, {pos = 570743816, events = 8, fd = 570695688, user_data = 0x293230}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82204f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555822136, events = 8, fd = 555821552, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 570748984, user_data = 0x1}, {pos = 570695688, events = 8, fd = 314, user_data = 0x821212c20}, {pos = -1054026257, events = 9556, fd = 2699824, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 570748984, user_data = 0x1}, {pos = 570725384, events = 8, fd = 922017792, user_data = 0x1}, {pos = 922018196, events = 8, fd = 0, user_data = 0x821212bf0}, {pos = 700228972, events = 8, fd = 1, user_data = 0x836f4e000}, {pos = 555822112, events = 8, fd = 700225282, user_data = 0x82bf5b170 }, {pos = 12072360, events = 0, fd = 737522032, user_data = 0x822049408}, {pos = 555822336, events = 8, fd = -1054026786, user_data = 0x836f6c800}, {pos = 1, events = 0, fd = -1054027170, user_data = 0x822042008}, {pos = 555822120, events = 8, fd = 555822336, user_data = 0x1c38}, {pos = 922091264, events = 8, fd = -1053947504, user_data = 0x0}, {pos = 555811711, events = 8, fd = 7886519, user_data = 0x821212cb0}, {pos = 700187664, events = 8, fd = 738185264, user_data = 0x82bfff310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821212ce0}, {pos = 700230557, events = 8, fd = 922017792, user_data = 0x16c7}, {pos = 555822400, events = 8, fd = 700197114, user_data = 0x0}, {pos = 0, events = 0, fd = 1852131075, user_data = 0x0}} [19:54:19.158] last_touch_time = 1725047395 [19:54:19.158] last_lockfile_recheck_time = 1725047395 [19:54:19.158] nevents = 1 [19:54:19.158] #37 0x0000000000856795 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821213328) at ../src/backend/postmaster/postmaster.c:1346 [19:54:19.158] userDoption = [19:54:19.158] listen_addr_saved = [19:54:19.158] output_config_variable = [19:54:19.158] opt = [19:54:19.158] status = [19:54:19.158] #38 0x00000000007923bc in main (argc=8, argv=0x821213328) at ../src/backend/main/main.c:197 [19:54:19.158] do_check_root = [19:54:19.167] [19:54:19.167] [19:54:19.167] [19:54:19.226] dumping /tmp/cores/postgres.12599.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:54:19.340] [New LWP 101672] [19:54:19.399] Core was generated by `postgres: old_node: postgres regression [local] DELETE'. [19:54:19.399] Program terminated with signal SIGABRT, Aborted. [19:54:19.399] Sent by thr_kill() from pid 12599 and user 1003. [19:54:19.399] #0 0x000000082bc1c41a in thr_kill () from /lib/libc.so.7 [19:54:19.508] [19:54:19.508] Thread 1 (LWP 101672): [19:54:19.508] #0 0x000000082bc1c41a in thr_kill () from /lib/libc.so.7 [19:54:19.508] No symbol table info available. [19:54:19.508] #1 0x000000082bb95e64 in raise () from /lib/libc.so.7 [19:54:19.508] No symbol table info available. [19:54:19.508] #2 0x000000082bc466f9 in abort () from /lib/libc.so.7 [19:54:19.508] No symbol table info available. [19:54:19.508] #3 0x0000000000a58dc5 in ExceptionalCondition (conditionName=0x2ad5c9 "!BTScanPosIsPinned(so->currPos)", fileName=, lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [19:54:19.508] No locals. [19:54:19.508] #4 0x00000000005ef846 in _bt_readnextpage (scan=scan@entry=0x84668c5d0, blkno=1, expectNext=2, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [19:54:19.508] rel = 0x845059168 [19:54:19.508] so = 0x835ab8a38 [19:54:19.508] page = [19:54:19.508] status = [19:54:19.508] opaque = [19:54:19.508] #5 0x00000000005ee8d0 in _bt_steppage (scan=scan@entry=0x84668c5d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [19:54:19.508] blkno = 2 [19:54:19.508] expectNext = 4 [19:54:19.508] so = 0x835ab8a38 [19:54:19.508] status = [19:54:19.508] #6 0x00000000005ed556 in _bt_first (scan=scan@entry=0x84668c5d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [19:54:19.508] buf = 15071 [19:54:19.508] 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 = 0x5dcaa0 , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x84668c000, fn_expr = 0x846cdb038}, sk_argument = 0}, {sk_flags = 1638426, sk_attno = 24, sk_strategy = 23, sk_subtype = 1376278, sk_collation = 1245204, sk_func = {fn_addr = 0xf001000110012, fn_oid = 851982, fn_nargs = 12, fn_strict = 11, fn_retset = false, fn_stats = 10 '\n', fn_extra = 0x3000400050006, fn_mcxt = 0x27002800010002, fn_expr = 0x23002400250026}, sk_argument = 8725861719146530}, {sk_flags = 1179431384, sk_attno = 8, sk_strategy = 0, sk_subtype = 1638426, sk_collation = 1507352, sk_func = {fn_addr = 0x13001400150016, fn_oid = 1114130, fn_nargs = 16, fn_strict = 15, fn_retset = false, fn_stats = 14 '\016', fn_extra = 0x700080009000a, fn_mcxt = 0x3000400050006, fn_expr = 0x10002}, sk_argument = 6146720}, {sk_flags = 351, sk_attno = 2, sk_strategy = 1, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0xaa7b55 , fn_oid = 557622912, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 251 '\373', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x8213ca0b0}, sk_argument = 11173323}, {sk_flags = 1179431384, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8213ca0d0, fn_oid = 11173323, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0xa68239 , fn_mcxt = 0x0, fn_expr = 0x3735313733aa7b55}, sk_argument = 0}, {sk_flags = 3719588, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8213ca680, fn_oid = 557623184, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 85 'U', fn_extra = 0x38c1a4, fn_mcxt = 0x2cece9, fn_expr = 0x8213ca790}, sk_argument = 3719596}, {sk_flags = 557622896, sk_attno = 8, sk_strategy = 0, sk_subtype = 11167385, sk_collation = 0, sk_func = {fn_addr = 0x5dcc60 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x835937000, fn_expr = 0x835ad8838}, sk_argument = 2620}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 557621664, sk_collation = 8, sk_func = {fn_addr = 0x1000101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x5dcc60 }, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x835937000, fn_oid = 900470688, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 60 '<', fn_extra = 0x200020000, fn_mcxt = 0x3b600000000, fn_expr = 0x5dca50 }, sk_argument = 281483566645598}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5d17ba , fn_oid = 1180495128, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x8465ced18}, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x835937000, fn_oid = 900470688, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 24 '\030', fn_extra = 0x200020000, fn_mcxt = 0x3b600000000, fn_expr = 0x5d17ba }, sk_argument = 35540233496}, {sk_flags = 10912313, sk_attno = 0, sk_strategy = 0, sk_subtype = 1179431384, sk_collation = 8, sk_func = {fn_addr = 0x5d17ba , fn_oid = 9234, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x2412, fn_mcxt = 0x0, fn_expr = 0x8213ca2e0}, sk_argument = 9147970}, {sk_flags = 16843009, sk_attno = 0, sk_strategy = 0, sk_subtype = 14, sk_collation = 0, sk_func = {fn_addr = 0x2f7abfee01010101, fn_oid = 1090638464, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0xa68239 , fn_mcxt = 0x8213ca2e0, fn_expr = 0x91c46f }, sk_argument = 4805}, {sk_flags = 955085696, sk_attno = 8, sk_strategy = 0, sk_subtype = 4805, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 557622096, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 66 'B', fn_extra = 0x1, fn_mcxt = 0xe, fn_expr = 0x120f1a8e00000007}, sk_argument = 35450376832}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098624, sk_collation = 0, sk_func = {fn_addr = 0x8213ca350, fn_oid = 9553007, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 72 'H', fn_extra = 0x835a8db48, fn_mcxt = 0x1, fn_expr = 0x8}, sk_argument = 34917360672}, {sk_flags = 9157226, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 8, sk_func = {fn_addr = 0xffffffff00000009, fn_oid = 8, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 24 '\030', fn_extra = 0x70, fn_mcxt = 0x835a78d48, fn_expr = 0x8213ca4bc}, sk_argument = 8}, {sk_flags = 9217, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912894, sk_collation = 1663, sk_func = {fn_addr = 0x4e100004003, fn_oid = 0, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x8213ca3f0, fn_expr = 0x621eaf }, sk_argument = 12100176}, {sk_flags = 15715, sk_attno = 0, sk_strategy = 0, sk_subtype = 557622336, sk_collation = 8, sk_func = {fn_addr = 0x8d7fb6 , fn_oid = 4805, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x1201, fn_mcxt = 0x8359df1c0, fn_expr = 0x8213ca440}, sk_argument = 15836}, {sk_flags = 1157992808, sk_attno = 8, sk_strategy = 0, sk_subtype = 1085550592, sk_collation = 8, sk_func = {fn_addr = 0x8213ca460, fn_oid = 6430383, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 80 'P', fn_extra = 0x3ef7, fn_mcxt = 0x8213ca4b0, fn_expr = 0x8d7fb6 }, sk_argument = 35541010240}, {sk_flags = 9561429, sk_attno = 0, sk_strategy = 0, sk_subtype = 3031234514, sk_collation = 0, sk_func = {fn_addr = 0x8359d4998, fn_oid = 557622448, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 19 '\023', fn_extra = 0x835a77068, fn_mcxt = 0x8407b1000, fn_expr = 0x8213ca780}, sk_argument = 6101058}, {sk_flags = 2, sk_attno = 16387, sk_strategy = 0, sk_subtype = 2620, sk_collation = 1, sk_func = {fn_addr = 0x0, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0xa3c}, sk_argument = 34917360960}, {sk_flags = 9545777, sk_attno = 0, sk_strategy = 0, sk_subtype = 12141320, sk_collation = 0, sk_func = {fn_addr = 0x845059168, fn_oid = 900256456, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 186 '\272', fn_extra = 0xa3c, fn_mcxt = 0xa68239 , fn_expr = 0x8213ca570}, sk_argument = 35517731248}, {sk_flags = 15379, sk_attno = 0, sk_strategy = 0, sk_subtype = 955762432, sk_collation = 8, sk_func = {fn_addr = 0x3c13, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0x8b9642 , fn_mcxt = 0x1, fn_expr = 0x9}, sk_argument = 14980995638123036676}, {sk_flags = 1090638464, sk_attno = 8, sk_strategy = 0, sk_subtype = 20, sk_collation = 0, sk_func = {fn_addr = 0xa68239 , fn_oid = 557622768, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0xb84001 , fn_mcxt = 0x0, fn_expr = 0xb95ad0 }, sk_argument = 1}, {sk_flags = 899521536, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8213ca690, fn_oid = 10742610, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 41 ')', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 37161}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x9129, fn_oid = 3, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0xb95ad0 , fn_mcxt = 0x845055468, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = 557622928, sk_attno = 8, sk_strategy = 0, sk_subtype = 10742879, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 11011721, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x84668d2f0, fn_mcxt = 0x846c1b7e0, fn_expr = 0x845059168}, sk_argument = 1}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 557623072, sk_collation = 8, sk_func = {fn_addr = 0xa4a085 , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x4505c768, fn_mcxt = 0x845059168, fn_expr = 0x100009129}, sk_argument = 5}, {sk_flags = 1187100224, sk_attno = 8, sk_strategy = 0, sk_subtype = 900271400, sk_collation = 8, sk_func = {fn_addr = 0x84505c768, fn_oid = 1157992808, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0xa49b35 , fn_mcxt = 0x3d01, fn_expr = 0x1}, sk_argument = 6}, {sk_flags = 10912313, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x84668c1a0, fn_oid = 557623280, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 57 '9', fn_extra = 0x8213ca7f0, fn_mcxt = 0x82bc59055, fn_expr = 0x8359d3100}, sk_argument = 35259238544}, {sk_flags = 15670, sk_attno = 2, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8359d3100, fn_oid = 899494288, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0x0, fn_mcxt = 0xb23f67c6b932af91, fn_expr = 0x84668c000}, sk_argument = 27416}, {sk_flags = 27352, sk_attno = 0, sk_strategy = 0, sk_subtype = 557623392, sk_collation = 8, sk_func = {fn_addr = 0x82bc59055, fn_oid = 557623344, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 103 'g', fn_extra = 0x2000, fn_mcxt = 0x845059168, fn_expr = 0x0}, sk_argument = 1}}} [19:54:19.508] startKeys = {0x84668c500, 0x0, 0x84668c000, 0x835ad7ba0, 0x9125, 0xb700b800b900ba, 0xb300b400b500b6, 0xaf000000000101, 0x0, 0xa700a800000001, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x84668c000, 0x835ad8838, 0x9129, 0x7f008000810082, 0x7b007c007d007e, 0x77000001000101, 0x0, 0x6f007000000002, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x84668c000, 0x835ac17a0} [19:54:19.508] notnullkeys = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x20000000003b6, fn_oid = 2650, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xa3c, fn_mcxt = 0x30000, fn_expr = 0x0}, sk_argument = 34917356992}, {sk_flags = 6248338, sk_attno = 0, sk_strategy = 0, sk_subtype = 955053376, sk_collation = 8, sk_func = {fn_addr = 0x835ab8a38, fn_oid = 1179432376, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x35a73528, fn_mcxt = 0xa68239 , fn_expr = 0x35ab8a01}, sk_argument = 8589934593}, {sk_flags = 9251, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912313, sk_collation = 0, sk_func = {fn_addr = 0x2423, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 35 '#', fn_extra = 0x838f1cb00, fn_mcxt = 0x2423, fn_expr = 0x0}, sk_argument = 34917357120}, {sk_flags = 10912313, sk_attno = 0, sk_strategy = 0, sk_subtype = 9252, sk_collation = 0, sk_func = {fn_addr = 0xa, fn_oid = 9252, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x2424, fn_mcxt = 0xa68239 , fn_expr = 0x8213c9680}, sk_argument = 9147970}, {sk_flags = 4301, sk_attno = 0, sk_strategy = 0, sk_subtype = 955053440, sk_collation = 8, sk_func = {fn_addr = 0x10cd, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 176 '\260', fn_extra = 0xa68239 , fn_mcxt = 0x213c9680, fn_expr = 0x1b}, sk_argument = 4302}, {sk_flags = 955053504, sk_attno = 8, sk_strategy = 0, sk_subtype = 4302, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 557618928, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 66 'B', fn_extra = 0x35a73528, fn_mcxt = 0x15, fn_expr = 0xe042013500000001}, sk_argument = 35450376832}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098624, sk_collation = 0, sk_func = {fn_addr = 0x8213c96f0, fn_oid = 9553007, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x835a8dbc8, fn_mcxt = 0x1, fn_expr = 0x4}, sk_argument = 34917357504}, {sk_flags = 9157226, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 8, sk_func = {fn_addr = 0xffffffff00000005, fn_oid = 557619056, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 74 'J', fn_extra = 0x70, fn_mcxt = 0x8465ce798, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 950, sk_attno = 0, sk_strategy = 2, sk_subtype = 3380, sk_collation = 0, sk_func = {fn_addr = 0xa6300004000, fn_oid = 3379, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x8213c97f0, fn_expr = 0x5f5792 <_bt_check_compare+1218>}, sk_argument = 35314791872}, {sk_flags = 900434488, sk_attno = 8, sk_strategy = 0, sk_subtype = 1179432376, sk_collation = 8, sk_func = {fn_addr = 0x8465ce788, fn_oid = 900150568, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x35ab8a01, fn_mcxt = 0x200000001, fn_expr = 0x3b6}, sk_argument = 34917357736}, {sk_flags = 557619404, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 991068672, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 144 '\220', fn_extra = 0x5f4fa1 <_bt_checkkeys+321>, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 34917357671}, {sk_flags = 557619252, sk_attno = 8, sk_strategy = 0, sk_subtype = 557619404, sk_collation = 8, sk_func = {fn_addr = 0xa6264a , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x835a73738, fn_mcxt = 0x0, fn_expr = 0x8464cb5b8}, sk_argument = 8599100770}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 900434488, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 10912313, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xe0, fn_mcxt = 0x3617, fn_expr = 0x838f64800}, sk_argument = 13847}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 557619488, sk_collation = 8, sk_func = {fn_addr = 0x8b9642 , fn_oid = 557619520, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 25 '\031', fn_extra = 0x1cf05fd900000000, fn_mcxt = 0x84101d280, fn_expr = 0x14}, sk_argument = 12098624}, {sk_flags = 557619488, sk_attno = 8, sk_strategy = 0, sk_subtype = 9553007, sk_collation = 0, sk_func = {fn_addr = 0x84505ec18, fn_oid = 900257608, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x1, fn_mcxt = 0x8213c99f0, fn_expr = 0x8bba6a }, sk_argument = 1}, {sk_flags = 2, sk_attno = -1, sk_strategy = 65535, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0xb85318 , fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 24 '\030', fn_extra = 0x8213c9a8c, fn_mcxt = 0x1, fn_expr = 0x35ab8a38}, sk_argument = 7142530613264}, {sk_flags = 16387, sk_attno = 3379, sk_strategy = 0, sk_subtype = 0, sk_collation = 1, sk_func = {fn_addr = 0x100000000, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 48 '0', fn_extra = 0x91c46f , fn_mcxt = 0x838f64800, fn_expr = 0x200000000}, sk_argument = 72057594037927937}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1158016024, sk_collation = 8, sk_func = {fn_addr = 0x70, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x8213c9ac0, fn_mcxt = 0x8b9887 , fn_expr = 0x70}, sk_argument = 35517754392}, {sk_flags = 557620028, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x40030000067f, fn_oid = 3379, fn_nargs = 1663, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x835a8d748, fn_mcxt = 0x70, fn_expr = 0x0}, sk_argument = 34917358304}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 955065792, sk_collation = 8, sk_func = {fn_addr = 0x200000000, fn_oid = 1, fn_nargs = 8, fn_strict = false, fn_retset = true, fn_stats = 0 '\000', fn_extra = 0x3617, fn_mcxt = 0x1, fn_expr = 0x8213c9af0}, sk_argument = 10888778}, {sk_flags = 1181272320, sk_attno = 8, sk_strategy = 0, sk_subtype = 1181272392, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x8bdd62 , fn_mcxt = 0x3617, fn_expr = 0x835ab8a90}, sk_argument = 35315402752}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 1158016024, sk_collation = 8, sk_func = {fn_addr = 0x835ab8a38, fn_oid = 557620080, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 199 '\307', fn_extra = 0x84668c500, fn_mcxt = 0x58000100000001, fn_expr = 0x0}, sk_argument = 35260172856}, {sk_flags = 1181272320, sk_attno = 8, sk_strategy = 0, sk_subtype = 257, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 1, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x3b600000000, fn_mcxt = 0x5dcc60 , fn_expr = 0x1000200000164}, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1181270016, sk_collation = 8, sk_func = {fn_addr = 0x835ad8838, fn_oid = 2620, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x1, fn_mcxt = 0x1000101, fn_expr = 0x0}, sk_argument = 2}, {sk_flags = 196608, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5dcc60 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x84668c000, fn_expr = 0x835ac17a0}, sk_argument = 2620}, {sk_flags = 131072, sk_attno = 2, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5dca50 , fn_oid = 350, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x84668c000, fn_expr = 0x835ac1a48}, sk_argument = 0}, {sk_flags = 196608, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5dcc60 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x84668c000, fn_expr = 0x835ac17a0}, sk_argument = 2656}, {sk_flags = 131072, sk_attno = 2, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5dca50 , fn_oid = 350, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x84668c500, fn_mcxt = 0x84668c000, fn_expr = 0x835ac1a48}, sk_argument = 0}, {sk_flags = 2604, sk_attno = 0, sk_strategy = 0, sk_subtype = 131072, sk_collation = 2, sk_func = {fn_addr = 0x3b600000000, fn_oid = 6146640, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 94 '^', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x84668c000}, sk_argument = 35260209736}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1181271296, sk_collation = 8, sk_func = {fn_addr = 0x2000000f3, fn_oid = 557623224, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x213c9da0, fn_mcxt = 0x1, fn_expr = 0xb89c48 }, sk_argument = 35314937664}, {sk_flags = 955199296, sk_attno = 8, sk_strategy = 0, sk_subtype = 1179431832, sk_collation = 8, sk_func = {fn_addr = 0x835ab8a38, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x8464cb398, fn_mcxt = 0x84668c7f0, fn_expr = 0x84668c838}, sk_argument = 2}, {sk_flags = 4264696, sk_attno = 0, sk_strategy = 0, sk_subtype = 557620800, sk_collation = 8, sk_func = {fn_addr = 0x101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x5dcc60 }, sk_argument = 281483566645604}} [19:54:19.508] blkno = 8 [19:54:19.508] rel = 0x845059168 [19:54:19.508] so = 0x835ab8a38 [19:54:19.508] keysz = [19:54:19.508] strat_total = 1 [19:54:19.508] i = [19:54:19.508] strat = [19:54:19.508] stack = [19:54:19.508] offnum = [19:54:19.508] status = [19:54:19.508] currItem = [19:54:19.508] #7 0x00000000005e9ee3 in btgettuple (scan=0x84668c5d0, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [19:54:19.508] so = 0x835ab8a38 [19:54:19.508] res = [19:54:19.508] #8 0x00000000005dbf11 in index_getnext_tid (scan=scan@entry=0x84668c5d0, direction=6, direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [19:54:19.508] found = [19:54:19.508] #9 0x0000000000a06ba8 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x84505f048, indexRel=indexRel@entry=0x845059168, indexscandir=BackwardScanDirection, scankeys=scankeys@entry=0x8213cab20, typLen=4, typByVal=true, tableslot=0x84668c360, outercontext=0x835937000, endpointDatum=0x8465cf578) at ../src/backend/utils/adt/selfuncs.c:6349 [19:54:19.508] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 0, xmax = 557623872, xip = 0xa3ed88 , xcnt = 12075009, subxip = 0x0, subxcnt = 12147408, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0xb8a260 , active_count = 0, regd_count = 0, ph_node = {first_child = 0x8213caae0, next_sibling = 0xa3eb52 , prev_or_parent = 0x17}, whenTaken = 0, lsn = 0, snapXactCompletionCount = 0} [19:54:19.508] vmbuffer = 0 [19:54:19.508] values = {34917362320, 10795333, 844429225099264, 4080218931200, 10233264, 281483566645432, 9218, 0, 35541008384, 0, 37161, 1407383473487872, 4080218931200, 9916896, 281483566645394, 6100738, 0, 35541008384, 0, 0, 844429225099264, 4080218931200, 10233264, 10912313, 2940418, 0, 35541008384, 34917362256, 37157, 0, 35259232512, 35541009248} [19:54:19.508] isnull = {23, false , 23, false, false, false, false, false, false, false} [19:54:19.508] have_data = false [19:54:19.508] last_heap_block = 4294967295 [19:54:19.508] n_visited_heap_pages = 0 [19:54:19.508] index_scan = 0x84668c5d0 [19:54:19.508] tid = [19:54:19.508] oldcontext = [19:54:19.508] #10 0x00000000009fe932 in get_actual_variable_range (root=, vardata=, sortop=97, collation=, min=0x0, max=0x8465cf578) at ../src/backend/utils/adt/selfuncs.c:6228 [19:54:19.508] typLen = 4 [19:54:19.508] tmpcontext = 0x84668c000 [19:54:19.508] oldcontext = 0x835937000 [19:54:19.508] heapRel = 0x84505f048 [19:54:19.508] slot = 0x84668c360 [19:54:19.508] typByVal = true [19:54:19.508] scankeys = {{sk_flags = 129, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}} [19:54:19.508] indexRel = 0x845059168 [19:54:19.508] index = [19:54:19.508] indexscandir = ForwardScanDirection [19:54:19.508] lc__state = {l = , i = 0} [19:54:19.508] have_data = false [19:54:19.508] rel = [19:54:19.508] rte = 0x8464cce98 [19:54:19.508] lc = [19:54:19.508] #11 0x00000000009fe234 in ineq_histogram_selectivity (root=root@entry=0x835938240, vardata=vardata@entry=0x8213cadc0, opoid=opoid@entry=523, opproc=opproc@entry=0x8213cad20, isgt=false, iseq=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [19:54:19.508] probe = 100 [19:54:19.508] ltcmp = [19:54:19.508] lobound = 99 [19:54:19.508] hibound = 101 [19:54:19.508] have_end = false [19:54:19.508] histfrac = [19:54:19.508] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x8465cf258, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [19:54:19.508] hist_selec = -1 [19:54:19.508] #12 0x0000000000a02571 in scalarineqsel (root=root@entry=0x835938240, operator=operator@entry=523, isgt=false, iseq=true, collation=0, vardata=vardata@entry=0x8213cadc0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [19:54:19.508] opproc = {fn_addr = 0x975100 , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x835937000, fn_expr = 0x0} [19:54:19.508] sumcommon = 0 [19:54:19.508] mcv_selec = [19:54:19.508] hist_selec = [19:54:19.508] selec = [19:54:19.508] stats = [19:54:19.508] #13 0x00000000009ff223 in scalarineqsel_wrapper (fcinfo=, isgt=false, iseq=true) at ../src/backend/utils/adt/selfuncs.c:1459 [19:54:19.508] vardata = {var = 0x8465ce028, rel = 0x8465ce448, statsTuple = 0x845059f88, freefunc = 0xa53de0 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [19:54:19.508] other = 0x8465cf6b8 [19:54:19.508] varonleft = true [19:54:19.508] root = 0x835938240 [19:54:19.508] operator = 523 [19:54:19.508] args = [19:54:19.508] varRelid = [19:54:19.508] collation = 0 [19:54:19.508] constval = 34917378080 [19:54:19.508] consttype = 734852768 [19:54:19.508] selec = [19:54:19.508] #14 0x0000000000a62f6f in FunctionCall4Coll (flinfo=0x8213cae50, collation=0, arg1=35258597952, arg2=523, arg3=35540230664, arg4=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [19:54:19.508] fcinfodata = {fcinfo = {flinfo = 0x8213cae50, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x8213caea0}, fcinfo_data = "P\256, "\004\000@\202\2235\b", '\000' , "\v\002\000\000\000\000\000\000\000\315Y7\b\000\000\000\b\342\\F\b\000\000\000\000\202\2235\b", '\000' , "\354\243\000\000\000\000"} [19:54:19.508] fcinfo = 0x8213cae80 [19:54:19.508] result = [19:54:19.508] __error = [19:54:19.508] #15 OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=35258597952, arg2=arg2@entry=523, arg3=arg3@entry=35540230664, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [19:54:19.508] flinfo = {fn_addr = 0x9ff270 , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x835937000, fn_expr = 0x0} [19:54:19.508] #16 0x000000000080153e in restriction_selectivity (root=root@entry=0x835938240, operatorid=523, args=0x8465ce208, inputcollid=0, varRelid=varRelid@entry=0) at ../src/backend/optimizer/util/plancat.c:1963 [19:54:19.508] oprrest = 0 [19:54:19.508] result = [19:54:19.508] #17 0x00000000007a85e4 in clause_selectivity_ext (root=root@entry=0x835938240, clause=0x8465ce2a8, clause@entry=0x8464cb398, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:848 [19:54:19.508] opclause = 0x8465ce2a8 [19:54:19.508] opno = [19:54:19.508] s1 = 0.5 [19:54:19.508] rinfo = 0x8464cb398 [19:54:19.508] cacheable = true [19:54:19.508] #18 0x00000000007a8005 in clauselist_selectivity_ext (root=0x835938240, clauses=0x8465cf1a8, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:183 [19:54:19.508] clause = 0x8464cb398 [19:54:19.508] s2 = [19:54:19.508] rinfo = [19:54:19.508] l__state = {l = 0x8465cf1a8, i = 1} [19:54:19.508] estimatedclauses = 0x0 [19:54:19.508] rqlist = 0x8465cf668 [19:54:19.508] s1 = 1 [19:54:19.508] rel = [19:54:19.508] listidx = 1 [19:54:19.508] l = [19:54:19.508] #19 0x00000000007a7ea0 in clauselist_selectivity (root=0x18d28, clauses=0x6, varRelid=varRelid@entry=0, jointype=734118906, jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [19:54:19.508] No locals. [19:54:19.508] #20 0x00000000007afc44 in set_baserel_size_estimates (root=0x18d28, root@entry=0x835938240, rel=rel@entry=0x8465ce448) at ../src/backend/optimizer/path/costsize.c:5286 [19:54:19.508] nrows = [19:54:19.508] #21 0x00000000007a6921 in set_plain_rel_size (root=0x835938240, rel=0x8465ce448, rte=0x8464cce98) at ../src/backend/optimizer/path/allpaths.c:581 [19:54:19.508] No locals. [19:54:19.508] #22 set_rel_size (root=root@entry=0x835938240, rel=rel@entry=0x8465ce448, rti=rti@entry=1, rte=rte@entry=0x8464cce98) at ../src/backend/optimizer/path/allpaths.c:411 [19:54:19.508] No locals. [19:54:19.508] #23 0x00000000007a3671 in set_base_rel_sizes (root=0x835938240) at ../src/backend/optimizer/path/allpaths.c:322 [19:54:19.508] rel = 0x8465ce448 [19:54:19.508] rte = 0x8464cce98 [19:54:19.508] rti = 1 [19:54:19.508] #24 make_one_rel (root=root@entry=0x835938240, joinlist=joinlist@entry=0x8465cf0b8) at ../src/backend/optimizer/path/allpaths.c:183 [19:54:19.508] total_pages = [19:54:19.508] rti = [19:54:19.508] rel = [19:54:19.508] #25 0x00000000007d3e44 in query_planner (root=root@entry=0x835938240, qp_callback=, qp_extra=qp_extra@entry=0x8213cb210) at ../src/backend/optimizer/plan/planmain.c:280 [19:54:19.508] parse = 0x8465cd778 [19:54:19.508] final_rel = [19:54:19.508] joinlist = 0x8465cf0b8 [19:54:19.508] #26 0x00000000007d6e5b in grouping_planner (root=root@entry=0x835938240, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [19:54:19.508] sort_input_targets = 0x8464cb9d4 [19:54:19.508] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [19:54:19.508] activeWindows = 0x0 [19:54:19.508] grouping_target = [19:54:19.508] scanjoin_target = [19:54:19.508] sort_input_target_parallel_safe = [19:54:19.508] sort_input_targets_contain_srfs = 0x7f3da0 [19:54:19.508] wflists = 0x0 [19:54:19.508] gset_data = 0x0 [19:54:19.508] have_grouping = [19:54:19.508] grouping_targets = 0x8465ce3c8 [19:54:19.508] scanjoin_targets = 0x79aaf1 [19:54:19.508] sort_input_target = [19:54:19.508] grouping_target_parallel_safe = [19:54:19.508] scanjoin_target_parallel_safe = [19:54:19.508] grouping_targets_contain_srfs = 0x8465ce3c8 [19:54:19.508] scanjoin_targets_contain_srfs = 0x0 [19:54:19.508] scanjoin_target_same_exprs = [19:54:19.508] final_targets = 0x0 [19:54:19.508] final_targets_contain_srfs = 0x8213cb370 [19:54:19.508] extra = {limit_needed = 241, limit_tuples = 1.1857575500189917e-321, count_est = 35540230184, offset_est = 35540230664} [19:54:19.508] parse = 0x8465cd778 [19:54:19.508] offset_est = 0 [19:54:19.508] count_est = 0 [19:54:19.508] limit_tuples = -1 [19:54:19.508] have_postponed_srfs = false [19:54:19.508] current_rel = [19:54:19.508] final_target = [19:54:19.508] final_target_parallel_safe = [19:54:19.508] final_rel = [19:54:19.508] lc = [19:54:19.508] #27 0x00000000007d54f9 in subquery_planner (glob=glob@entry=0x835938a18, parse=parse@entry=0x8465cd778, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1089 [19:54:19.508] root = 0x835938240 [19:54:19.508] hasOuterJoins = false [19:54:19.508] hasResultRTEs = false [19:54:19.508] l = [19:54:19.508] newWithCheckOptions = [19:54:19.508] newHaving = [19:54:19.508] final_rel = [19:54:19.508] #28 0x00000000007d4028 in standard_planner (parse=0x8465cd778, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:415 [19:54:19.508] glob = 0x835938a18 [19:54:19.508] tuple_fraction = [19:54:19.508] root = [19:54:19.508] final_rel = [19:54:19.508] best_path = [19:54:19.508] top_plan = [19:54:19.508] lp = [19:54:19.508] lr = [19:54:19.508] result = [19:54:19.508] #29 0x00000000008fd964 in pg_plan_query (querytree=querytree@entry=0x8465cd778, query_string=query_string@entry=0x835937100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:912 [19:54:19.508] plan = [19:54:19.508] #30 0x00000000008fda62 in pg_plan_queries (querytrees=0x8465cdf08, query_string=query_string@entry=0x835937100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1006 [19:54:19.508] query = 0x8465cd778 [19:54:19.508] stmt = [19:54:19.508] query_list__state = {l = 0x8465cdf08, i = 0} [19:54:19.508] stmt_list = 0x0 [19:54:19.508] query_list = [19:54:19.508] #31 0x0000000000901ed0 in exec_simple_query (query_string=query_string@entry=0x835937100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [19:54:19.508] cmdtaglen = 6 [19:54:19.508] snapshot_set = [19:54:19.508] per_parsetree_context = 0x0 [19:54:19.508] plantree_list = [19:54:19.508] qc = {commandTag = 557626864, nprocessed = 35093842607} [19:54:19.508] format = 8 [19:54:19.508] parsetree = 0x835938650 [19:54:19.508] commandTag = CMDTAG_DELETE [19:54:19.508] cmdtagname = [19:54:19.508] querytree_list = 0x0 [19:54:19.508] portal = [19:54:19.508] receiver = [19:54:19.508] parsetree_item__state = {l = 0x8359389c8, i = 0} [19:54:19.508] msec_str = "\360\265 [19:54:19.508] oldcontext = 0x8359df000 [19:54:19.508] parsetree_list = 0x8359389c8 [19:54:19.508] use_implicit_block = false [19:54:19.508] parsetree_item = 0x8359389e0 [19:54:19.508] save_log_statement_stats = [19:54:19.508] #32 0x00000000008ffd30 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [19:54:19.508] query_string = 0x835937100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [19:54:19.508] input_message = {data = 0x835937100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [19:54:19.508] firstchar = [19:54:19.508] local_sigjmp_buf = {{_sjb = {9433542, 34917365376, 34917365336, 34917365920, 12147320, 1, 8192, 8388608, 34917319551, 0, 0, 1}}} [19:54:19.508] send_ready_for_query = false [19:54:19.508] idle_in_transaction_timeout_enabled = false [19:54:19.508] idle_session_timeout_enabled = false [19:54:19.508] #33 0x00000000008fa509 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:54:19.508] bsdata = [19:54:19.508] #34 0x00000000008545b7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8213cc3c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8213cc300) at ../src/backend/postmaster/launch_backend.c:274 [19:54:19.508] pid = [19:54:19.508] #35 0x0000000000858978 in BackendStartup (client_sock=0x8213cc300) at ../src/backend/postmaster/postmaster.c:3414 [19:54:19.508] startup_data = {canAcceptConnections = CAC_OK} [19:54:19.508] bn = 0x835943628 [19:54:19.508] pid = [19:54:19.508] __error = [19:54:19.508] save_errno = [19:54:19.508] __error = [19:54:19.508] __error = [19:54:19.508] #36 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:54:19.508] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\300\216\2235\b", '\000' , "`\303, "\240\303}, salen = 16}} [19:54:19.508] i = 0 [19:54:19.508] now = [19:54:19.508] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 733744258, events = 8, fd = 0, user_data = 0x8213cc2b0}, {pos = 899282392, events = 8, fd = 557629760, user_data = 0x0}, {pos = 0, events = 0, fd = -1187860591, user_data = 0x389166f0930a}, {pos = 732911520, events = 8, fd = 732982648, user_data = 0x8213cbdc8}, {pos = 557628992, events = 8, fd = 557628872, user_data = 0x389166f0930a}, {pos = 732889992, events = 8, fd = 732982648, user_data = 0x8213cbdf8}, {pos = 557629040, events = 8, fd = 557628920, user_data = 0x82baff194}, {pos = 568615944, events = 8, fd = 732950932, user_data = 0x8213cbe60}, {pos = 1727022138, events = 14481, fd = 734773296, user_data = 0x1}, {pos = 557629072, events = 8, fd = 1727042314, user_data = 0x82bae8858}, {pos = 732982648, events = 8, fd = 557629032, user_data = 0x8213cbee0}, {pos = 557629032, events = 8, fd = 732945676, user_data = 0x821e46408}, {pos = 732945676, events = 8, fd = 557629136, user_data = 0x389166f0443a}, {pos = 557629176, events = 8, fd = 557629624, user_data = 0x8213cbee0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2990499782, fd = 568639544, user_data = 0x800000001}, {pos = 568615944, events = 8, fd = 732889992, user_data = 0x821e4b288}, {pos = 732858456, events = 8, fd = 568615944, user_data = 0x8213cbf68}, {pos = 557629736, events = 8, fd = 557629264, user_data = 0x389166f08ca2}, {pos = 2699824, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 568639544, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 557629992, user_data = 0x21e46408}, {pos = 557629808, events = 8, fd = 557629408, user_data = 0x1}, {pos = 557629736, events = 8, fd = 32, user_data = 0x8213cbfd0}, {pos = 1727040115, events = 14481, fd = 557629680, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821e4c038}, {pos = 1, events = 8, fd = 568615944, user_data = 0x82bae8858}, {pos = 557629992, events = 8, fd = 557629808, user_data = 0x8213cbfe0}, {pos = 0, events = 0, fd = 568586248, user_data = 0x20}, {pos = 557629792, events = 8, fd = 1727015655, user_data = 0x821e3f008}, {pos = 568587272, events = 8, fd = 568588296, user_data = 0x821e3fc08}, {pos = 568602632, events = 8, fd = 568603656, user_data = 0x821e43808}, {pos = 568605704, events = 8, fd = 568606728, user_data = 0x821e44408}, {pos = 568608776, events = 8, fd = 568609800, user_data = 0x821e45008}, {pos = 568611848, events = 8, fd = 568612872, user_data = 0x821e45c08}, {pos = 568614920, events = 8, fd = 568615944, user_data = 0x821e46808}, {pos = 568617992, events = 8, fd = 568619016, user_data = 0x821e47408}, {pos = 568621064, events = 8, fd = 568622088, user_data = 0x821e48008}, {pos = 568624136, events = 8, fd = 568625160, user_data = 0x821e48c08}, {pos = 568631304, events = 8, fd = 568632328, user_data = 0x821e4a808}, {pos = 568634376, events = 8, fd = 568586248, user_data = 0x293230}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821e4c038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557629992, events = 8, fd = 557629408, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 568639544, user_data = 0x1}, {pos = 568586248, events = 8, fd = 314, user_data = 0x8213cc210}, {pos = 1727014383, events = 14481, fd = 2699824, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 568639544, user_data = 0x1}, {pos = 568615944, events = 8, fd = 898789376, user_data = 0x1}, {pos = 898789780, events = 8, fd = 0, user_data = 0x8213cc1e0}, {pos = 710231404, events = 8, fd = 1, user_data = 0x835927000}, {pos = 557629968, events = 8, fd = 710227714, user_data = 0x82bc1a170 }, {pos = 12072360, events = 0, fd = 734110064, user_data = 0x821e46408}, {pos = 557630192, events = 8, fd = 1727013854, user_data = 0x835945800}, {pos = 1, events = 0, fd = 1727013470, user_data = 0x821e3f008}, {pos = 557629976, events = 8, fd = 557630192, user_data = 0x1c38}, {pos = 898862784, events = 8, fd = 1727093136, user_data = 0x0}, {pos = 557581183, events = 8, fd = 7886519, user_data = 0x8213cc2a0}, {pos = 710190096, events = 8, fd = 734773296, user_data = 0x82bcbe310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8213cc2d0}, {pos = 710232989, events = 8, fd = 898789376, user_data = 0x16ed}, {pos = 557630256, events = 8, fd = 710199546, user_data = 0x0}, {pos = 0, events = 0, fd = -1187860591, user_data = 0x0}} [19:54:19.508] last_touch_time = 1725047395 [19:54:19.508] last_lockfile_recheck_time = 1725047395 [19:54:19.508] nevents = 1 [19:54:19.508] #37 0x0000000000856795 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8213cc918) at ../src/backend/postmaster/postmaster.c:1346 [19:54:19.508] userDoption = [19:54:19.508] listen_addr_saved = [19:54:19.508] output_config_variable = [19:54:19.508] opt = [19:54:19.508] status = [19:54:19.508] #38 0x00000000007923bc in main (argc=4, argv=0x8213cc918) at ../src/backend/main/main.c:197 [19:54:19.508] do_check_root =