[17:28:16.194] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [17:28:16.548] dumping /tmp/cores/postgres.12448.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [17:28:16.672] [New LWP 101663] [17:28:16.758] Core was generated by `postgres: postgres regression [local] DELETE'. [17:28:16.758] Program terminated with signal SIGABRT, Aborted. [17:28:16.758] Sent by thr_kill() from pid 12448 and user 1003. [17:28:16.758] #0 0x0000000829ec541a in thr_kill () from /lib/libc.so.7 [17:28:16.897] [17:28:16.897] Thread 1 (LWP 101663): [17:28:16.897] #0 0x0000000829ec541a in thr_kill () from /lib/libc.so.7 [17:28:16.897] No symbol table info available. [17:28:16.897] #1 0x0000000829e3ee64 in raise () from /lib/libc.so.7 [17:28:16.897] No symbol table info available. [17:28:16.897] #2 0x0000000829eef6f9 in abort () from /lib/libc.so.7 [17:28:16.897] No symbol table info available. [17:28:16.897] #3 0x0000000000a58c95 in ExceptionalCondition (conditionName=0x2ad5c9 "!BTScanPosIsPinned(so->currPos)", fileName=, lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [17:28:16.897] No locals. [17:28:16.897] #4 0x00000000005ef846 in _bt_readnextpage (scan=scan@entry=0x8472515d0, blkno=1, expectNext=2, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [17:28:16.897] rel = 0x845c5e928 [17:28:16.897] so = 0x8359ff8f8 [17:28:16.897] page = [17:28:16.897] status = [17:28:16.897] opaque = [17:28:16.897] #5 0x00000000005ee8d0 in _bt_steppage (scan=scan@entry=0x8472515d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [17:28:16.897] blkno = 2 [17:28:16.897] expectNext = 4 [17:28:16.897] so = 0x8359ff8f8 [17:28:16.897] status = [17:28:16.897] #6 0x00000000005ed556 in _bt_first (scan=scan@entry=0x8472515d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [17:28:16.897] buf = 10667 [17:28:16.897] 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 = 0x847251000, fn_expr = 0x8481f4038}, 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 = 1209782744, 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 = 0xaa7a25 , fn_oid = 551786672, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 251 '\373', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x820e392e0}, sk_argument = 11173019}, {sk_flags = 1209782744, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x820e39300, fn_oid = 11173019, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xa68109 , fn_mcxt = 0x0, fn_expr = 0x3834333733aa7a25}, sk_argument = 0}, {sk_flags = 3719557, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x820e398b0, fn_oid = 551786944, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 37 '%', fn_extra = 0x38c185, fn_mcxt = 0x2cecb3, fn_expr = 0x820e399c0}, sk_argument = 3719565}, {sk_flags = 551786656, sk_attno = 8, sk_strategy = 0, sk_subtype = 11167081, 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 = 0x835885000, fn_expr = 0x835a1f838}, sk_argument = 2620}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 551785424, 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 = 0x835885000, fn_oid = 899712928, 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 = 1192986840, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x8471b88d8}, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x835885000, fn_oid = 899712928, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 216 '\330', fn_extra = 0x200020000, fn_mcxt = 0x3b600000000, fn_expr = 0x5d17ba }, sk_argument = 35552725208}, {sk_flags = 10912009, sk_attno = 0, sk_strategy = 0, sk_subtype = 1209782744, sk_collation = 8, sk_func = {fn_addr = 0x5d17ba , fn_oid = 5193, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x1449, fn_mcxt = 0x0, fn_expr = 0x820e39510}, sk_argument = 9147666}, {sk_flags = 16843009, sk_attno = 0, sk_strategy = 0, sk_subtype = 6, sk_collation = 0, sk_func = {fn_addr = 0x32a2042601010101, fn_oid = 1099178880, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0xa68109 , fn_mcxt = 0x820e39510, fn_expr = 0x91c33f }, sk_argument = 1042}, {sk_flags = 963385280, sk_attno = 8, sk_strategy = 0, sk_subtype = 1042, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 551785856, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 18 '\022', fn_extra = 0x1, fn_mcxt = 0xb, fn_expr = 0xbb5910ab00000007}, sk_argument = 35458917248}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098320, sk_collation = 0, sk_func = {fn_addr = 0x820e39580, fn_oid = 9552703, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 72 'H', fn_extra = 0x8359d3b48, fn_mcxt = 0x1, fn_expr = 0x8}, sk_argument = 34911524432}, {sk_flags = 9156922, 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 = 232 '\350', fn_extra = 0x70, fn_mcxt = 0x8359bad48, fn_expr = 0x820e396ec}, sk_argument = 8}, {sk_flags = 5121, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912590, 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 = 0x820e39620, fn_expr = 0x621eaf }, sk_argument = 12099872}, {sk_flags = 16535, sk_attno = 0, sk_strategy = 0, sk_subtype = 551786096, sk_collation = 8, sk_func = {fn_addr = 0x8d7e86 , fn_oid = 1042, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x401, fn_mcxt = 0x83595f1c0, fn_expr = 0x820e39670}, sk_argument = 11443}, {sk_flags = 1170598184, sk_attno = 8, sk_strategy = 0, sk_subtype = 1058103296, sk_collation = 8, sk_func = {fn_addr = 0x820e39690, fn_oid = 6430383, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x407e, fn_mcxt = 0x820e396e0, fn_expr = 0x8d7e86 }, sk_argument = 35553351488}, {sk_flags = 9561125, sk_attno = 0, sk_strategy = 0, sk_subtype = 1236362940, sk_collation = 0, sk_func = {fn_addr = 0x835953890, fn_oid = 551786208, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0x8359b9068, fn_mcxt = 0x83ed50000, fn_expr = 0x820e399b0}, sk_argument = 6101058}, {sk_flags = 2, sk_attno = 16384, sk_strategy = 0, sk_subtype = 2620, sk_collation = 1, sk_func = {fn_addr = 0x1, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0xa3c}, sk_argument = 34911524720}, {sk_flags = 9545473, sk_attno = 0, sk_strategy = 0, sk_subtype = 12141016, sk_collation = 0, sk_func = {fn_addr = 0x845c5e928, fn_oid = 899494600, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 186 '\272', fn_extra = 0xa3c, fn_mcxt = 0xa68109 , fn_expr = 0x820e397a0}, sk_argument = 35530336624}, {sk_flags = 10960, sk_attno = 0, sk_strategy = 0, sk_subtype = 964020032, sk_collation = 8, sk_func = {fn_addr = 0x2ad0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 16 '\020', fn_extra = 0x8b9512 , fn_mcxt = 0x1, fn_expr = 0x1c}, sk_argument = 1590257185177206788}, {sk_flags = 1099178880, sk_attno = 8, sk_strategy = 0, sk_subtype = 20, sk_collation = 0, sk_func = {fn_addr = 0xa68109 , fn_oid = 551786528, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 88 'X', fn_extra = 0xb83f01 , fn_mcxt = 0x0, fn_expr = 0xb959a0 }, sk_argument = 1}, {sk_flags = 898993152, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x820e398c0, fn_oid = 10742306, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 232 '\350', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 37352}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x91e8, fn_oid = 29, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0xb959a0 , fn_mcxt = 0x845c5ac28, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = 551786688, sk_attno = 8, sk_strategy = 0, sk_subtype = 10742575, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 11011417, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x8472522f0, fn_mcxt = 0x8480b37e0, fn_expr = 0x845c5e928}, sk_argument = 1}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 551786832, sk_collation = 8, sk_func = {fn_addr = 0xa49f55 , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x45c61f28, fn_mcxt = 0x845c5e928, fn_expr = 0x1000091e8}, sk_argument = 5}, {sk_flags = 1208694336, sk_attno = 8, sk_strategy = 0, sk_subtype = 899509544, sk_collation = 8, sk_func = {fn_addr = 0x845c61f28, fn_oid = 1170598184, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0xa49a05 , fn_mcxt = 0x2a01, fn_expr = 0x1}, sk_argument = 6}, {sk_flags = 10912009, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8472511a0, fn_oid = 551787040, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 9 '\t', fn_extra = 0x820e39a20, fn_mcxt = 0x829f02055, fn_expr = 0x835952100}, sk_argument = 35258710688}, {sk_flags = 10865, sk_attno = 2, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x835952100, fn_oid = 898965904, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0x0, fn_mcxt = 0x2210b151e82a8cfc, fn_expr = 0x847251000}, sk_argument = 27416}, {sk_flags = 27352, sk_attno = 0, sk_strategy = 0, sk_subtype = 551787152, sk_collation = 8, sk_func = {fn_addr = 0x829f02055, fn_oid = 551787104, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 55 '7', fn_extra = 0x2000, fn_mcxt = 0x845c5e928, fn_expr = 0x0}, sk_argument = 1}}} [17:28:16.897] startKeys = {0x847251500, 0x0, 0x847251000, 0x835a1eba0, 0x91e4, 0xb700b800b900ba, 0xb300b400b500b6, 0xaf000000000101, 0x0, 0xa700a800000001, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x847251000, 0x835a1f838, 0x91e8, 0x7f008000810082, 0x7b007c007d007e, 0x77000001000101, 0x0, 0x6f007000000002, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x847251000, 0x835a087a0} [17:28:16.897] 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 = 34911520752}, {sk_flags = 6248338, sk_attno = 0, sk_strategy = 0, sk_subtype = 963352960, sk_collation = 8, sk_func = {fn_addr = 0x8359ff8f8, fn_oid = 1209783736, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 72 'H', fn_extra = 0x359b5528, fn_mcxt = 0xa68109 , fn_expr = 0x359ff801}, sk_argument = 8589934593}, {sk_flags = 5214, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912009, sk_collation = 0, sk_func = {fn_addr = 0x145e, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 94 '^', fn_extra = 0x839702ac0, fn_mcxt = 0x145e, fn_expr = 0x0}, sk_argument = 34911520880}, {sk_flags = 10912009, sk_attno = 0, sk_strategy = 0, sk_subtype = 5215, sk_collation = 0, sk_func = {fn_addr = 0x15, fn_oid = 5215, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x145f, fn_mcxt = 0xa68109 , fn_expr = 0x820e388b0}, sk_argument = 9147666}, {sk_flags = 538, sk_attno = 0, sk_strategy = 0, sk_subtype = 963353024, sk_collation = 8, sk_func = {fn_addr = 0x21a, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0xa68109 , fn_mcxt = 0x20e388b0, fn_expr = 0x6}, sk_argument = 539}, {sk_flags = 963353088, sk_attno = 8, sk_strategy = 0, sk_subtype = 539, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 551782688, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 18 '\022', fn_extra = 0x359b5528, fn_mcxt = 0x0, fn_expr = 0xd7efca000000001}, sk_argument = 35458917248}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098320, sk_collation = 0, sk_func = {fn_addr = 0x820e38920, fn_oid = 9552703, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x8359d3bc8, fn_mcxt = 0x1, fn_expr = 0x4}, sk_argument = 34911521264}, {sk_flags = 9156922, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 8, sk_func = {fn_addr = 0xffffffff00000005, fn_oid = 551782816, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 26 '\032', fn_extra = 0x70, fn_mcxt = 0x8471b8358, 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 = 0x820e38a20, fn_expr = 0x5f5792 <_bt_check_compare+1218>}, sk_argument = 35323091456}, {sk_flags = 899676408, sk_attno = 8, sk_strategy = 0, sk_subtype = 1209783736, sk_collation = 8, sk_func = {fn_addr = 0x8471b8348, fn_oid = 899372328, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x359ff801, fn_mcxt = 0x200000001, fn_expr = 0x3b6}, sk_argument = 34911521496}, {sk_flags = 551783164, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 968782336, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x5f4fa1 <_bt_checkkeys+321>, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 34911521431}, {sk_flags = 551783012, sk_attno = 8, sk_strategy = 0, sk_subtype = 551783164, sk_collation = 8, sk_func = {fn_addr = 0xa6251a , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 248 '\370', fn_extra = 0x8359b5738, fn_mcxt = 0x0, fn_expr = 0x8481bd5b8}, sk_argument = 8599100466}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 899676408, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 10912009, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xe0, fn_mcxt = 0x2571, fn_expr = 0x839746f80}, sk_argument = 9585}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 551783248, sk_collation = 8, sk_func = {fn_addr = 0x8b9512 , fn_oid = 551783280, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0xf3c7e5e100000000, fn_mcxt = 0x841842380, fn_expr = 0x14}, sk_argument = 12098320}, {sk_flags = 551783248, sk_attno = 8, sk_strategy = 0, sk_subtype = 9552703, sk_collation = 0, sk_func = {fn_addr = 0x845c643d8, fn_oid = 899495368, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x1, fn_mcxt = 0x820e38c20, fn_expr = 0x8bb93a }, sk_argument = 1}, {sk_flags = 2, sk_attno = -1, sk_strategy = 65535, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0xb851e8 , fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 216 '\330', fn_extra = 0x820e38cbc, fn_mcxt = 0x1, fn_expr = 0x359ff8f8}, 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 = 96 '`', fn_extra = 0x91c33f , fn_mcxt = 0x839746f80, fn_expr = 0x200000000}, sk_argument = 72057594037927937}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1170621400, 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 = 0x820e38cf0, fn_mcxt = 0x8b9757 , fn_expr = 0x70}, sk_argument = 35530359768}, {sk_flags = 551783788, 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 = 0x8359d35c8, fn_mcxt = 0x70, fn_expr = 0x0}, sk_argument = 34911522064}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 963365376, 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 = 0x2571, fn_mcxt = 0x1, fn_expr = 0x820e38d20}, sk_argument = 10888474}, {sk_flags = 1193613568, sk_attno = 8, sk_strategy = 0, sk_subtype = 1193613640, 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 = 0x8bdc32 , fn_mcxt = 0x2571, fn_expr = 0x8359ff950}, sk_argument = 35323670400}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 1170621400, sk_collation = 8, sk_func = {fn_addr = 0x8359ff8f8, fn_oid = 551783840, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 199 '\307', fn_extra = 0x847251500, fn_mcxt = 0x58000100000001, fn_expr = 0x0}, sk_argument = 35259414776}, {sk_flags = 1193613568, 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 = 1193611264, sk_collation = 8, sk_func = {fn_addr = 0x835a1f838, fn_oid = 2620, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 248 '\370', 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 = 0x847251000, fn_expr = 0x835a087a0}, 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 = 0x847251000, fn_expr = 0x835a08a48}, 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 = 0x847251000, fn_expr = 0x835a087a0}, 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 = 0x847251500, fn_mcxt = 0x847251000, fn_expr = 0x835a08a48}, 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 = 0x847251000}, sk_argument = 35259451976}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1193612544, sk_collation = 8, sk_func = {fn_addr = 0x2000000f4, fn_oid = 551786984, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x20e38fd0, fn_mcxt = 0x1, fn_expr = 0xb89b18 }, sk_argument = 35323237696}, {sk_flags = 963499328, sk_attno = 8, sk_strategy = 0, sk_subtype = 1209783192, sk_collation = 8, sk_func = {fn_addr = 0x8359ff8f8, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x8481bd398, fn_mcxt = 0x8472517f0, fn_expr = 0x847251838}, sk_argument = 2}, {sk_flags = 4264696, sk_attno = 0, sk_strategy = 0, sk_subtype = 551784560, 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}} [17:28:16.897] blkno = 8 [17:28:16.897] rel = 0x845c5e928 [17:28:16.897] so = 0x8359ff8f8 [17:28:16.897] keysz = [17:28:16.897] strat_total = 1 [17:28:16.897] i = [17:28:16.897] strat = [17:28:16.897] stack = [17:28:16.897] offnum = [17:28:16.897] status = [17:28:16.897] currItem = [17:28:16.897] #7 0x00000000005e9ee3 in btgettuple (scan=0x8472515d0, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [17:28:16.897] so = 0x8359ff8f8 [17:28:16.897] res = [17:28:16.897] #8 0x00000000005dbf11 in index_getnext_tid (scan=scan@entry=0x8472515d0, direction=6, direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [17:28:16.897] found = [17:28:16.897] #9 0x0000000000a06a78 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x845c64808, indexRel=indexRel@entry=0x845c5e928, indexscandir=BackwardScanDirection, scankeys=scankeys@entry=0x820e39d50, typLen=4, typByVal=true, tableslot=0x847251360, outercontext=0x835885000, endpointDatum=0x8471b9138) at ../src/backend/utils/adt/selfuncs.c:6349 [17:28:16.897] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 0, xmax = 551787632, xip = 0xa3ec58 , xcnt = 12074753, subxip = 0x0, subxcnt = 12147104, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0xb8a130 , active_count = 0, regd_count = 0, ph_node = {first_child = 0x820e39d10, next_sibling = 0xa3ea22 , prev_or_parent = 0x17}, whenTaken = 0, lsn = 0, snapXactCompletionCount = 0} [17:28:16.897] vmbuffer = 0 [17:28:16.897] values = {34911526080, 10795029, 844429225099264, 4080218931200, 10232960, 281483566645432, 5122, 0, 35553349632, 0, 37352, 1407383473487872, 4080218931200, 9916592, 281483566645394, 6100738, 0, 35553349632, 0, 0, 844429225099264, 4080218931200, 10232960, 10912009, 2940418, 0, 35553349632, 34911526016, 37348, 0, 35258704128, 35553350496} [17:28:16.897] isnull = {23, false , 23, false, false, false, false, false, false, false} [17:28:16.897] have_data = false [17:28:16.897] last_heap_block = 4294967295 [17:28:16.897] n_visited_heap_pages = 0 [17:28:16.897] index_scan = 0x8472515d0 [17:28:16.897] tid = [17:28:16.897] oldcontext = [17:28:16.897] #10 0x00000000009fe802 in get_actual_variable_range (root=, vardata=, sortop=97, collation=, min=0x0, max=0x8471b9138) at ../src/backend/utils/adt/selfuncs.c:6228 [17:28:16.897] typLen = 4 [17:28:16.897] tmpcontext = 0x847251000 [17:28:16.897] oldcontext = 0x835885000 [17:28:16.897] heapRel = 0x845c64808 [17:28:16.897] slot = 0x847251360 [17:28:16.897] typByVal = true [17:28:16.897] 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:28:16.897] indexRel = 0x845c5e928 [17:28:16.897] index = [17:28:16.897] indexscandir = ForwardScanDirection [17:28:16.897] lc__state = {l = , i = 0} [17:28:16.897] have_data = false [17:28:16.897] rel = [17:28:16.897] rte = 0x8481bee98 [17:28:16.897] lc = [17:28:16.897] #11 0x00000000009fe104 in ineq_histogram_selectivity (root=root@entry=0x835886240, vardata=vardata@entry=0x820e39ff0, opoid=opoid@entry=523, opproc=opproc@entry=0x820e39f50, isgt=false, iseq=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [17:28:16.897] probe = 100 [17:28:16.897] ltcmp = [17:28:16.897] lobound = 99 [17:28:16.897] hibound = 101 [17:28:16.897] have_end = false [17:28:16.897] histfrac = [17:28:16.897] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x8471b8e18, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [17:28:16.897] hist_selec = -1 [17:28:16.897] #12 0x0000000000a02441 in scalarineqsel (root=root@entry=0x835886240, operator=operator@entry=523, isgt=false, iseq=true, collation=0, vardata=vardata@entry=0x820e39ff0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [17:28:16.897] opproc = {fn_addr = 0x974fd0 , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x835885000, fn_expr = 0x0} [17:28:16.897] sumcommon = 0 [17:28:16.897] mcv_selec = [17:28:16.897] hist_selec = [17:28:16.897] selec = [17:28:16.897] stats = [17:28:16.897] #13 0x00000000009ff0f3 in scalarineqsel_wrapper (fcinfo=, isgt=false, iseq=true) at ../src/backend/utils/adt/selfuncs.c:1459 [17:28:16.897] vardata = {var = 0x8471b7be8, rel = 0x8471b8008, statsTuple = 0x845c5f748, freefunc = 0xa53cb0 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [17:28:16.897] other = 0x8471b9278 [17:28:16.897] varonleft = true [17:28:16.897] root = 0x835886240 [17:28:16.897] operator = 523 [17:28:16.897] args = [17:28:16.897] varRelid = [17:28:16.897] collation = 0 [17:28:16.897] constval = 35232317584 [17:28:16.897] consttype = 2441780737 [17:28:16.897] selec = [17:28:16.897] #14 0x0000000000a62e3f in FunctionCall4Coll (flinfo=0x820e3a080, collation=0, arg1=35257868864, arg2=523, arg3=35552722376, arg4=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [17:28:16.897] fcinfodata = {fcinfo = {flinfo = 0x820e3a080, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x820e3a0d0}, fcinfo_data = "\200\240\343 \b", '\000' , "\004\000@b\2105\b", '\000' , "\v\002\000\000\000\000\000\000\000\034p8\b\000\000\000\310}\033G\b\000\000\000\000b\2105\b", '\000' , "\353\243\000\000\000\000"} [17:28:16.897] fcinfo = 0x820e3a0b0 [17:28:16.897] result = [17:28:16.897] __error = [17:28:16.897] #15 OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=35257868864, arg2=arg2@entry=523, arg3=arg3@entry=35552722376, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [17:28:16.897] flinfo = {fn_addr = 0x9ff140 , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x835885000, fn_expr = 0x0} [17:28:16.897] #16 0x000000000080153e in restriction_selectivity (root=root@entry=0x835886240, operatorid=523, args=0x8471b7dc8, inputcollid=0, varRelid=varRelid@entry=0) at ../src/backend/optimizer/util/plancat.c:1963 [17:28:16.897] oprrest = 0 [17:28:16.897] result = [17:28:16.897] #17 0x00000000007a85e4 in clause_selectivity_ext (root=root@entry=0x835886240, clause=0x8471b7e68, clause@entry=0x8481bd398, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:848 [17:28:16.897] opclause = 0x8471b7e68 [17:28:16.897] opno = [17:28:16.897] s1 = 0.5 [17:28:16.897] rinfo = 0x8481bd398 [17:28:16.897] cacheable = true [17:28:16.897] #18 0x00000000007a8005 in clauselist_selectivity_ext (root=0x835886240, clauses=0x8471b8d68, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:183 [17:28:16.897] clause = 0x8481bd398 [17:28:16.897] s2 = [17:28:16.897] rinfo = [17:28:16.897] l__state = {l = 0x8471b8d68, i = 1} [17:28:16.897] estimatedclauses = 0x0 [17:28:16.897] rqlist = 0x8471b9228 [17:28:16.897] s1 = 1 [17:28:16.897] rel = [17:28:16.897] listidx = 1 [17:28:16.897] l = [17:28:16.897] #19 0x00000000007a7ea0 in clauselist_selectivity (root=0x18d1f, clauses=0x6, varRelid=varRelid@entry=0, jointype=703353850, jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [17:28:16.897] No locals. [17:28:16.897] #20 0x00000000007afc44 in set_baserel_size_estimates (root=0x18d1f, root@entry=0x835886240, rel=rel@entry=0x8471b8008) at ../src/backend/optimizer/path/costsize.c:5286 [17:28:16.897] nrows = [17:28:16.897] #21 0x00000000007a6921 in set_plain_rel_size (root=0x835886240, rel=0x8471b8008, rte=0x8481bee98) at ../src/backend/optimizer/path/allpaths.c:581 [17:28:16.897] No locals. [17:28:16.897] #22 set_rel_size (root=root@entry=0x835886240, rel=rel@entry=0x8471b8008, rti=rti@entry=1, rte=rte@entry=0x8481bee98) at ../src/backend/optimizer/path/allpaths.c:411 [17:28:16.897] No locals. [17:28:16.897] #23 0x00000000007a3671 in set_base_rel_sizes (root=0x835886240) at ../src/backend/optimizer/path/allpaths.c:322 [17:28:16.897] rel = 0x8471b8008 [17:28:16.897] rte = 0x8481bee98 [17:28:16.897] rti = 1 [17:28:16.897] #24 make_one_rel (root=root@entry=0x835886240, joinlist=joinlist@entry=0x8471b8c78) at ../src/backend/optimizer/path/allpaths.c:183 [17:28:16.897] total_pages = [17:28:16.897] rti = [17:28:16.897] rel = [17:28:16.897] #25 0x00000000007d3e44 in query_planner (root=root@entry=0x835886240, qp_callback=, qp_extra=qp_extra@entry=0x820e3a440) at ../src/backend/optimizer/plan/planmain.c:280 [17:28:16.897] parse = 0x8471b7338 [17:28:16.897] final_rel = [17:28:16.897] joinlist = 0x8471b8c78 [17:28:16.897] #26 0x00000000007d6e5b in grouping_planner (root=root@entry=0x835886240, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [17:28:16.897] sort_input_targets = 0x8481bd9d4 [17:28:16.897] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [17:28:16.897] activeWindows = 0x0 [17:28:16.897] grouping_target = [17:28:16.897] scanjoin_target = [17:28:16.897] sort_input_target_parallel_safe = [17:28:16.897] sort_input_targets_contain_srfs = 0x7f3da0 [17:28:16.897] wflists = 0x0 [17:28:16.897] gset_data = 0x0 [17:28:16.897] have_grouping = [17:28:16.897] grouping_targets = 0x8471b7f88 [17:28:16.897] scanjoin_targets = 0x79aaf1 [17:28:16.897] sort_input_target = [17:28:16.897] grouping_target_parallel_safe = [17:28:16.897] scanjoin_target_parallel_safe = [17:28:16.897] grouping_targets_contain_srfs = 0x8471b7f88 [17:28:16.897] scanjoin_targets_contain_srfs = 0x0 [17:28:16.897] scanjoin_target_same_exprs = [17:28:16.897] final_targets = 0x0 [17:28:16.897] final_targets_contain_srfs = 0x820e3a5a0 [17:28:16.897] extra = {limit_needed = 241, limit_tuples = 1.1857575500189917e-321, count_est = 35552721896, offset_est = 35552722376} [17:28:16.897] parse = 0x8471b7338 [17:28:16.897] offset_est = 0 [17:28:16.897] count_est = 0 [17:28:16.897] limit_tuples = -1 [17:28:16.897] have_postponed_srfs = false [17:28:16.897] current_rel = [17:28:16.897] final_target = [17:28:16.897] final_target_parallel_safe = [17:28:16.897] final_rel = [17:28:16.897] lc = [17:28:16.897] #27 0x00000000007d54f9 in subquery_planner (glob=glob@entry=0x835886a18, parse=parse@entry=0x8471b7338, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1089 [17:28:16.897] root = 0x835886240 [17:28:16.897] hasOuterJoins = false [17:28:16.897] hasResultRTEs = false [17:28:16.897] l = [17:28:16.897] newWithCheckOptions = [17:28:16.897] newHaving = [17:28:16.897] final_rel = [17:28:16.897] #28 0x00000000007d4028 in standard_planner (parse=0x8471b7338, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:415 [17:28:16.897] glob = 0x835886a18 [17:28:16.897] tuple_fraction = [17:28:16.897] root = [17:28:16.897] final_rel = [17:28:16.897] best_path = [17:28:16.897] top_plan = [17:28:16.897] lp = [17:28:16.897] lr = [17:28:16.897] result = [17:28:16.897] #29 0x00000000008fd834 in pg_plan_query (querytree=querytree@entry=0x8471b7338, query_string=query_string@entry=0x835885100 "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:28:16.897] plan = [17:28:16.897] #30 0x00000000008fd932 in pg_plan_queries (querytrees=0x8471b7ac8, query_string=query_string@entry=0x835885100 "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:28:16.897] query = 0x8471b7338 [17:28:16.897] stmt = [17:28:16.897] query_list__state = {l = 0x8471b7ac8, i = 0} [17:28:16.897] stmt_list = 0x0 [17:28:16.897] query_list = [17:28:16.897] #31 0x0000000000901da0 in exec_simple_query (query_string=query_string@entry=0x835885100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [17:28:16.897] cmdtaglen = 6 [17:28:16.897] snapshot_set = [17:28:16.897] per_parsetree_context = 0x0 [17:28:16.897] plantree_list = [17:28:16.897] qc = {commandTag = 551790624, nprocessed = 35063077551} [17:28:16.897] format = 8 [17:28:16.897] parsetree = 0x835886650 [17:28:16.897] commandTag = CMDTAG_DELETE [17:28:16.897] cmdtagname = [17:28:16.897] querytree_list = 0x0 [17:28:16.897] portal = [17:28:16.897] receiver = [17:28:16.897] parsetree_item__state = {l = 0x8358869c8, i = 0} [17:28:16.897] msec_str = " \250\343 \b\000\000\000\257\032\354)\b\000\000\000Q\243\324f\000\000\000\000\335\r\371g\333\325,q" [17:28:16.897] dest = DestRemote [17:28:16.897] was_logged = [17:28:16.897] oldcontext = 0x83595f000 [17:28:16.897] parsetree_list = 0x8358869c8 [17:28:16.897] use_implicit_block = false [17:28:16.897] parsetree_item = 0x8358869e0 [17:28:16.897] save_log_statement_stats = [17:28:16.897] #32 0x00000000008ffc00 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [17:28:16.897] query_string = 0x835885100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [17:28:16.897] input_message = {data = 0x835885100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [17:28:16.897] firstchar = [17:28:16.897] local_sigjmp_buf = {{_sjb = {9433238, 34911529136, 34911529096, 34911529680, 12147016, 1, 8192, 8388608, 34911486847, 0, 0, 1}}} [17:28:16.897] send_ready_for_query = false [17:28:16.897] idle_in_transaction_timeout_enabled = false [17:28:16.897] idle_session_timeout_enabled = false [17:28:16.897] #33 0x00000000008fa3d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [17:28:16.897] bsdata = [17:28:16.897] #34 0x00000000008545b7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820e3b5f4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820e3b530) at ../src/backend/postmaster/launch_backend.c:274 [17:28:16.897] pid = [17:28:16.897] #35 0x0000000000858978 in BackendStartup (client_sock=0x820e3b530) at ../src/backend/postmaster/postmaster.c:3414 [17:28:16.897] startup_data = {canAcceptConnections = CAC_OK} [17:28:16.897] bn = 0x8358911c8 [17:28:16.897] pid = [17:28:16.897] __error = [17:28:16.897] save_errno = [17:28:16.897] __error = [17:28:16.897] __error = [17:28:16.897] #36 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [17:28:16.897] 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 = "\000o\2105\b", '\000' , "\220\265\343 \b\000\000\000hE\374*\b\000\000\000\v\000\000\000\000\000\000\000^\317\374*\b", '\000' , "е\343 \b\000\000\000dC\205\000\000\000\000\000\340\265\343 \b", '\000' }, salen = 16}} [17:28:16.897] i = 0 [17:28:16.897] now = [17:28:16.897] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 702979202, events = 8, fd = 0, user_data = 0x820e3b4e0}, {pos = 898524632, events = 8, fd = 551793520, user_data = 0x0}, {pos = 0, events = 0, fd = -399864580, user_data = 0x3a643be2630a}, {pos = 702146464, events = 8, fd = 702217592, user_data = 0x820e3aff8}, {pos = 551792752, events = 8, fd = 551792632, user_data = 0x3a643be2630a}, {pos = 702124936, events = 8, fd = 702217592, user_data = 0x820e3b028}, {pos = 551792800, events = 8, fd = 551792680, user_data = 0x829da8194}, {pos = 555705352, events = 8, fd = 702185876, user_data = 0x820e3b090}, {pos = 1004672058, events = 14948, fd = 704008240, user_data = 0x1}, {pos = 551792832, events = 8, fd = 1004692234, user_data = 0x829d91858}, {pos = 702217592, events = 8, fd = 551792792, user_data = 0x820e3b110}, {pos = 551792792, events = 8, fd = 702180620, user_data = 0x8211f6408}, {pos = 702180620, events = 8, fd = 551792896, user_data = 0x3a643be2143a}, {pos = 551792936, events = 8, fd = 551793384, user_data = 0x820e3b110}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 571519313, fd = 555728952, user_data = 0x800000001}, {pos = 555705352, events = 8, fd = 702124936, user_data = 0x8211fb288}, {pos = 702093400, events = 8, fd = 555705352, user_data = 0x820e3b198}, {pos = 551793496, events = 8, fd = 551793024, user_data = 0x3a643be25ca2}, {pos = 2699824, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 555728952, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 551793752, user_data = 0x211f6408}, {pos = 551793568, events = 8, fd = 551793168, user_data = 0x1}, {pos = 551793496, events = 8, fd = 32, user_data = 0x820e3b200}, {pos = 1004690035, events = 14948, fd = 551793440, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8211fc038}, {pos = 1, events = 8, fd = 555705352, user_data = 0x829d91858}, {pos = 551793752, events = 8, fd = 551793568, user_data = 0x820e3b210}, {pos = 0, events = 0, fd = 555675656, user_data = 0x20}, {pos = 551793552, events = 8, fd = 1004665575, user_data = 0x8211ef008}, {pos = 555676680, events = 8, fd = 555677704, user_data = 0x8211efc08}, {pos = 555692040, events = 8, fd = 555693064, user_data = 0x8211f3808}, {pos = 555695112, events = 8, fd = 555696136, user_data = 0x8211f4408}, {pos = 555698184, events = 8, fd = 555699208, user_data = 0x8211f5008}, {pos = 555701256, events = 8, fd = 555702280, user_data = 0x8211f5c08}, {pos = 555704328, events = 8, fd = 555705352, user_data = 0x8211f6808}, {pos = 555707400, events = 8, fd = 555708424, user_data = 0x8211f7408}, {pos = 555710472, events = 8, fd = 555711496, user_data = 0x8211f8008}, {pos = 555713544, events = 8, fd = 555714568, user_data = 0x8211f8c08}, {pos = 555720712, events = 8, fd = 555721736, user_data = 0x8211fa808}, {pos = 555723784, events = 8, fd = 555675656, user_data = 0x293230}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8211fc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 551793752, events = 8, fd = 551793168, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 555728952, user_data = 0x1}, {pos = 555675656, events = 8, fd = 314, user_data = 0x820e3b440}, {pos = 1004664303, events = 14948, fd = 2699824, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 555728952, user_data = 0x1}, {pos = 555705352, events = 8, fd = 898060288, user_data = 0x1}, {pos = 898060692, events = 8, fd = 0, user_data = 0x820e3b410}, {pos = 721208684, events = 8, fd = 1, user_data = 0x835875000}, {pos = 551793728, events = 8, fd = 721204994, user_data = 0x829ec3170 }, {pos = 12072056, events = 0, fd = 703345008, user_data = 0x8211f6408}, {pos = 551793952, events = 8, fd = 1004663774, user_data = 0x835893800}, {pos = 1, events = 0, fd = 1004663390, user_data = 0x8211ef008}, {pos = 551793736, events = 8, fd = 551793952, user_data = 0x1c38}, {pos = 898133760, events = 8, fd = 1004743056, user_data = 0x0}, {pos = 551748479, events = 8, fd = 7886519, user_data = 0x820e3b4d0}, {pos = 721167376, events = 8, fd = 704008240, user_data = 0x829f67310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820e3b500}, {pos = 721210269, events = 8, fd = 898060288, user_data = 0x16b1}, {pos = 551794016, events = 8, fd = 721176826, user_data = 0x0}, {pos = 0, events = 0, fd = -399864580, user_data = 0x0}} [17:28:16.897] last_touch_time = 1725211430 [17:28:16.897] last_lockfile_recheck_time = 1725211430 [17:28:16.897] nevents = 1 [17:28:16.897] #37 0x0000000000856795 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820e3bb40) at ../src/backend/postmaster/postmaster.c:1346 [17:28:16.897] userDoption = [17:28:16.897] listen_addr_saved = [17:28:16.897] output_config_variable = [17:28:16.897] opt = [17:28:16.897] status = [17:28:16.897] #38 0x00000000007923bc in main (argc=8, argv=0x820e3bb40) at ../src/backend/main/main.c:197 [17:28:16.897] do_check_root = [17:28:16.908] [17:28:16.908] [17:28:16.908] [17:28:16.969] dumping /tmp/cores/postgres.12799.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [17:28:17.085] [New LWP 101629] [17:28:17.152] Core was generated by `postgres: old_node: postgres regression [local] DELETE'. [17:28:17.152] Program terminated with signal SIGABRT, Aborted. [17:28:17.152] Sent by thr_kill() from pid 12799 and user 1003. [17:28:17.152] #0 0x000000082aa2841a in thr_kill () from /lib/libc.so.7 [17:28:17.269] [17:28:17.269] Thread 1 (LWP 101629): [17:28:17.269] #0 0x000000082aa2841a in thr_kill () from /lib/libc.so.7 [17:28:17.269] No symbol table info available. [17:28:17.269] #1 0x000000082a9a1e64 in raise () from /lib/libc.so.7 [17:28:17.269] No symbol table info available. [17:28:17.269] #2 0x000000082aa526f9 in abort () from /lib/libc.so.7 [17:28:17.269] No symbol table info available. [17:28:17.269] #3 0x0000000000a58c95 in ExceptionalCondition (conditionName=0x2ad5c9 "!BTScanPosIsPinned(so->currPos)", fileName=, lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [17:28:17.269] No locals. [17:28:17.269] #4 0x00000000005ef846 in _bt_readnextpage (scan=scan@entry=0x844d215d0, blkno=1, expectNext=2, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [17:28:17.269] rel = 0x84240c078 [17:28:17.269] so = 0x8344bdf38 [17:28:17.269] page = [17:28:17.269] status = [17:28:17.269] opaque = [17:28:17.269] #5 0x00000000005ee8d0 in _bt_steppage (scan=scan@entry=0x844d215d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [17:28:17.269] blkno = 2 [17:28:17.269] expectNext = 4 [17:28:17.269] so = 0x8344bdf38 [17:28:17.269] status = [17:28:17.269] #6 0x00000000005ed556 in _bt_first (scan=scan@entry=0x844d215d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [17:28:17.269] buf = 15126 [17:28:17.269] 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 = 0x844d21000, fn_expr = 0x845346038}, 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 = 1152770520, 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 = 0xaa7a25 , fn_oid = 557422960, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 251 '\373', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x8213993a0}, sk_argument = 11173019}, {sk_flags = 1152770520, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8213993c0, fn_oid = 11173019, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0xa68109 , fn_mcxt = 0x0, fn_expr = 0x3433323733aa7a25}, sk_argument = 0}, {sk_flags = 3719557, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x821399970, fn_oid = 557423232, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 37 '%', fn_extra = 0x38c185, fn_mcxt = 0x2cecb3, fn_expr = 0x821399a80}, sk_argument = 3719565}, {sk_flags = 557422944, sk_attno = 8, sk_strategy = 0, sk_subtype = 11167081, 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 = 0x83433c000, fn_expr = 0x8344dd838}, sk_argument = 2620}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 557421712, 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 = 0x83433c000, fn_oid = 877422496, 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 = 1153823192, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x844c5f1d8}, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x83433c000, fn_oid = 877422496, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 216 '\330', fn_extra = 0x200020000, fn_mcxt = 0x3b600000000, fn_expr = 0x5d17ba }, sk_argument = 35513561560}, {sk_flags = 10912009, sk_attno = 0, sk_strategy = 0, sk_subtype = 1152770520, sk_collation = 8, sk_func = {fn_addr = 0x5d17ba , fn_oid = 4407, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1137, fn_mcxt = 0x0, fn_expr = 0x8213995d0}, sk_argument = 9147666}, {sk_flags = 16843009, sk_attno = 0, sk_strategy = 0, sk_subtype = 8, sk_collation = 0, sk_func = {fn_addr = 0x1f4b1bc801010101, fn_oid = 1046827648, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0xa68109 , fn_mcxt = 0x8213995d0, fn_expr = 0x91c33f }, sk_argument = 4805}, {sk_flags = 911274880, sk_attno = 8, sk_strategy = 0, sk_subtype = 4805, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 557422144, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 18 '\022', fn_extra = 0x1, fn_mcxt = 0xe, fn_expr = 0x120f1a8e00000007}, sk_argument = 35406566016}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098320, sk_collation = 0, sk_func = {fn_addr = 0x821399640, fn_oid = 9552703, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 200 '\310', fn_extra = 0x834492b48, fn_mcxt = 0x1, fn_expr = 0x8}, sk_argument = 34917160720}, {sk_flags = 9156922, 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 = 232 '\350', fn_extra = 0x70, fn_mcxt = 0x83447ddc8, fn_expr = 0x8213997ac}, sk_argument = 8}, {sk_flags = 4353, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912590, 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 = 0x8213996e0, fn_expr = 0x621eaf }, sk_argument = 12099872}, {sk_flags = 15666, sk_attno = 0, sk_strategy = 0, sk_subtype = 557422384, sk_collation = 8, sk_func = {fn_addr = 0x8d7e86 , fn_oid = 4805, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x1201, fn_mcxt = 0x8343e41c0, fn_expr = 0x821399730}, sk_argument = 15934}, {sk_flags = 1111539832, sk_attno = 8, sk_strategy = 0, sk_subtype = 1042542592, sk_collation = 8, sk_func = {fn_addr = 0x821399750, fn_oid = 6430383, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x3f1d, fn_mcxt = 0x8213997a0, fn_expr = 0x8d7e86 }, sk_argument = 35514357568}, {sk_flags = 9561125, sk_attno = 0, sk_strategy = 0, sk_subtype = 3031234514, sk_collation = 0, sk_func = {fn_addr = 0x83f6e6f68, fn_oid = 557422496, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 35 '#', fn_extra = 0x83447c0e8, fn_mcxt = 0x83de09000, fn_expr = 0x821399a70}, sk_argument = 6101058}, {sk_flags = 2, sk_attno = 16387, sk_strategy = 0, sk_subtype = 2620, sk_collation = 1, sk_func = {fn_addr = 0x1, 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 = 34917161008}, {sk_flags = 9545473, sk_attno = 0, sk_strategy = 0, sk_subtype = 12141016, sk_collation = 0, sk_func = {fn_addr = 0x84240c078, fn_oid = 877208264, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 186 '\272', fn_extra = 0xa3c, fn_mcxt = 0xa68109 , fn_expr = 0x821399860}, sk_argument = 35471278272}, {sk_flags = 15395, sk_attno = 0, sk_strategy = 0, sk_subtype = 911952640, sk_collation = 8, sk_func = {fn_addr = 0x3c23, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0x8b9512 , fn_mcxt = 0x1, fn_expr = 0x13}, sk_argument = 8735652949633531908}, {sk_flags = 1046827648, sk_attno = 8, sk_strategy = 0, sk_subtype = 20, sk_collation = 0, sk_func = {fn_addr = 0xa68109 , fn_oid = 557422816, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 88 'X', fn_extra = 0xb83f01 , fn_mcxt = 0x0, fn_expr = 0xb959a0 }, sk_argument = 1}, {sk_flags = 876473344, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x821399980, fn_oid = 10742306, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 118 'v', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 37238}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x9176, fn_oid = 120, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0xb959a0 , fn_mcxt = 0x842408378, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = 557422976, sk_attno = 8, sk_strategy = 0, sk_subtype = 10742575, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 11011417, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x844d222f0, fn_mcxt = 0x8452827e0, fn_expr = 0x84240c078}, sk_argument = 1}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 557423120, sk_collation = 8, sk_func = {fn_addr = 0xa49f55 , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x4240f678, fn_mcxt = 0x84240c078, fn_expr = 0x100009176}, sk_argument = 5}, {sk_flags = 1160259136, sk_attno = 8, sk_strategy = 0, sk_subtype = 877223208, sk_collation = 8, sk_func = {fn_addr = 0x84240f678, fn_oid = 1111539832, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0xa49a05 , fn_mcxt = 0x3d01, fn_expr = 0x1}, sk_argument = 6}, {sk_flags = 10912009, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x844d211a0, fn_oid = 557423328, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 9 '\t', fn_extra = 0x821399ae0, fn_mcxt = 0x82aa65055, fn_expr = 0x8343d8100}, sk_argument = 35236189736}, {sk_flags = 15723, sk_attno = 2, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8343d8100, fn_oid = 876446096, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0x0, fn_mcxt = 0xf1ea5a487fd45234, fn_expr = 0x844d21000}, sk_argument = 27416}, {sk_flags = 27352, sk_attno = 0, sk_strategy = 0, sk_subtype = 557423440, sk_collation = 8, sk_func = {fn_addr = 0x82aa65055, fn_oid = 557423392, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 55 '7', fn_extra = 0x2000, fn_mcxt = 0x84240c078, fn_expr = 0x0}, sk_argument = 1}}} [17:28:17.269] startKeys = {0x844d21500, 0x0, 0x844d21000, 0x8344dcba0, 0x9172, 0xb700b800b900ba, 0xb300b400b500b6, 0xaf000000000101, 0x0, 0xa700a800000001, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x844d21000, 0x8344dd838, 0x9176, 0x7f008000810082, 0x7b007c007d007e, 0x77000001000101, 0x0, 0x6f007000000002, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x844d21000, 0x8344c67a0} [17:28:17.269] 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 = 34917157040}, {sk_flags = 6248338, sk_attno = 0, sk_strategy = 0, sk_subtype = 911242560, sk_collation = 8, sk_func = {fn_addr = 0x8344bdf38, fn_oid = 1152771512, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 72 'H', fn_extra = 0x344785a8, fn_mcxt = 0xa68109 , fn_expr = 0x344bdf01}, sk_argument = 8589934593}, {sk_flags = 9271, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912009, sk_collation = 0, sk_func = {fn_addr = 0x2437, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 55 '7', fn_extra = 0x836555000, fn_mcxt = 0x2437, fn_expr = 0x0}, sk_argument = 34917157168}, {sk_flags = 10912009, sk_attno = 0, sk_strategy = 0, sk_subtype = 9272, sk_collation = 0, sk_func = {fn_addr = 0x8, fn_oid = 9272, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x2438, fn_mcxt = 0xa68109 , fn_expr = 0x821398970}, sk_argument = 9147666}, {sk_flags = 4301, sk_attno = 0, sk_strategy = 0, sk_subtype = 911242624, sk_collation = 8, sk_func = {fn_addr = 0x10cd, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 160 '\240', fn_extra = 0xa68109 , fn_mcxt = 0x21398970, fn_expr = 0x1b}, sk_argument = 4302}, {sk_flags = 911242688, sk_attno = 8, sk_strategy = 0, sk_subtype = 4302, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 557418976, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 18 '\022', fn_extra = 0x344785a8, fn_mcxt = 0x15, fn_expr = 0xe042013500000001}, sk_argument = 35406566016}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098320, sk_collation = 0, sk_func = {fn_addr = 0x8213989e0, fn_oid = 9552703, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 168 '\250', fn_extra = 0x834492bc8, fn_mcxt = 0x1, fn_expr = 0x4}, sk_argument = 34917157552}, {sk_flags = 9156922, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 8, sk_func = {fn_addr = 0xffffffff00000005, fn_oid = 557419104, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 26 '\032', fn_extra = 0x70, fn_mcxt = 0x844c5ec58, 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 = 0x821398ae0, fn_expr = 0x5f5792 <_bt_check_compare+1218>}, sk_argument = 35270981056}, {sk_flags = 877387576, sk_attno = 8, sk_strategy = 0, sk_subtype = 1152771512, sk_collation = 8, sk_func = {fn_addr = 0x844c5ec48, fn_oid = 877102504, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 184 '\270', fn_extra = 0x344bdf01, fn_mcxt = 0x200000001, fn_expr = 0x3b6}, sk_argument = 34917157784}, {sk_flags = 557419452, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 947257856, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x5f4fa1 <_bt_checkkeys+321>, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 34917157719}, {sk_flags = 557419300, sk_attno = 8, sk_strategy = 0, sk_subtype = 557419452, sk_collation = 8, sk_func = {fn_addr = 0xa6251a , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x8344787b8, fn_mcxt = 0x0, fn_expr = 0x844b5e5b8}, sk_argument = 8599100466}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 877387576, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 10912009, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xe0, fn_mcxt = 0x32c0, fn_expr = 0x83658f240}, sk_argument = 12992}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 557419536, sk_collation = 8, sk_func = {fn_addr = 0x8b9512 , fn_oid = 557419568, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 25 '\031', fn_extra = 0x1cf05fd900000000, fn_mcxt = 0x83e655280, fn_expr = 0x14}, sk_argument = 12098320}, {sk_flags = 557419536, sk_attno = 8, sk_strategy = 0, sk_subtype = 9552703, sk_collation = 0, sk_func = {fn_addr = 0x842411b28, fn_oid = 877208392, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x1, fn_mcxt = 0x821398ce0, fn_expr = 0x8bb93a }, sk_argument = 1}, {sk_flags = 2, sk_attno = -1, sk_strategy = 65535, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0xb851e8 , fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x821398d7c, fn_mcxt = 0x1, fn_expr = 0x344bdf38}, 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 = 32 ' ', fn_extra = 0x91c33f , fn_mcxt = 0x83658f240, fn_expr = 0x200000000}, sk_argument = 72057594037927937}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1111563048, 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 = 0x821398db0, fn_mcxt = 0x8b9757 , fn_expr = 0x70}, sk_argument = 35471301416}, {sk_flags = 557420076, 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 = 0x834492348, fn_mcxt = 0x70, fn_expr = 0x0}, sk_argument = 34917158352}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 911254976, 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 = 0x32c0, fn_mcxt = 0x1, fn_expr = 0x821398de0}, sk_argument = 10888474}, {sk_flags = 1154619648, sk_attno = 8, sk_strategy = 0, sk_subtype = 1154619720, 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 = 0x8bdc32 , fn_mcxt = 0x32c0, fn_expr = 0x8344bdf90}, sk_argument = 35271537216}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 1111563048, sk_collation = 8, sk_func = {fn_addr = 0x8344bdf38, fn_oid = 557420128, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 199 '\307', fn_extra = 0x844d21500, fn_mcxt = 0x58000100000001, fn_expr = 0x0}, sk_argument = 35237125944}, {sk_flags = 1154619648, 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 = 1154617344, sk_collation = 8, sk_func = {fn_addr = 0x8344dd838, 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 = 0x844d21000, fn_expr = 0x8344c67a0}, 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 = 0x844d21000, fn_expr = 0x8344c6a48}, 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 = 0x844d21000, fn_expr = 0x8344c67a0}, 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 = 0x844d21500, fn_mcxt = 0x844d21000, fn_expr = 0x8344c6a48}, 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 = 0x844d21000}, sk_argument = 35237161544}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1154618624, sk_collation = 8, sk_func = {fn_addr = 0x2000000f2, fn_oid = 557423272, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x21399090, fn_mcxt = 0x1, fn_expr = 0xb89b18 }, sk_argument = 35271125632}, {sk_flags = 911387264, sk_attno = 8, sk_strategy = 0, sk_subtype = 1152770968, sk_collation = 8, sk_func = {fn_addr = 0x8344bdf38, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x844b5e398, fn_mcxt = 0x844d217f0, fn_expr = 0x844d21838}, sk_argument = 2}, {sk_flags = 4264696, sk_attno = 0, sk_strategy = 0, sk_subtype = 557420848, 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}} [17:28:17.269] blkno = 8 [17:28:17.269] rel = 0x84240c078 [17:28:17.269] so = 0x8344bdf38 [17:28:17.269] keysz = [17:28:17.269] strat_total = 1 [17:28:17.269] i = [17:28:17.269] strat = [17:28:17.269] stack = [17:28:17.269] offnum = [17:28:17.269] status = [17:28:17.269] currItem = [17:28:17.269] #7 0x00000000005e9ee3 in btgettuple (scan=0x844d215d0, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [17:28:17.269] so = 0x8344bdf38 [17:28:17.269] res = [17:28:17.269] #8 0x00000000005dbf11 in index_getnext_tid (scan=scan@entry=0x844d215d0, direction=6, direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [17:28:17.269] found = [17:28:17.269] #9 0x0000000000a06a78 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x842411f58, indexRel=indexRel@entry=0x84240c078, indexscandir=BackwardScanDirection, scankeys=scankeys@entry=0x821399e10, typLen=4, typByVal=true, tableslot=0x844d21360, outercontext=0x83433c000, endpointDatum=0x844c5fa38) at ../src/backend/utils/adt/selfuncs.c:6349 [17:28:17.269] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 0, xmax = 557423920, xip = 0xa3ec58 , xcnt = 12074753, subxip = 0x0, subxcnt = 12147104, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0xb8a130 , active_count = 0, regd_count = 0, ph_node = {first_child = 0x821399dd0, next_sibling = 0xa3ea22 , prev_or_parent = 0x17}, whenTaken = 0, lsn = 0, snapXactCompletionCount = 0} [17:28:17.269] vmbuffer = 0 [17:28:17.269] values = {34917162368, 10795029, 844429225099264, 4080218931200, 10232960, 281483566645432, 4354, 0, 35514355712, 0, 37238, 1407383473487872, 4080218931200, 9916592, 281483566645394, 6100738, 0, 35514355712, 0, 0, 844429225099264, 4080218931200, 10232960, 10912009, 2940418, 0, 35514355712, 34917162304, 37234, 0, 35236184320, 35514356576} [17:28:17.269] isnull = {23, false , 23, false, false, false, false, false, false, false} [17:28:17.269] have_data = false [17:28:17.269] last_heap_block = 4294967295 [17:28:17.269] n_visited_heap_pages = 0 [17:28:17.269] index_scan = 0x844d215d0 [17:28:17.269] tid = [17:28:17.269] oldcontext = [17:28:17.269] #10 0x00000000009fe802 in get_actual_variable_range (root=, vardata=, sortop=97, collation=, min=0x0, max=0x844c5fa38) at ../src/backend/utils/adt/selfuncs.c:6228 [17:28:17.269] typLen = 4 [17:28:17.269] tmpcontext = 0x844d21000 [17:28:17.269] oldcontext = 0x83433c000 [17:28:17.269] heapRel = 0x842411f58 [17:28:17.269] slot = 0x844d21360 [17:28:17.269] typByVal = true [17:28:17.269] 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:28:17.269] indexRel = 0x84240c078 [17:28:17.269] index = [17:28:17.269] indexscandir = ForwardScanDirection [17:28:17.269] lc__state = {l = , i = 0} [17:28:17.269] have_data = false [17:28:17.269] rel = [17:28:17.269] rte = 0x844b5fe98 [17:28:17.269] lc = [17:28:17.269] #11 0x00000000009fe104 in ineq_histogram_selectivity (root=root@entry=0x83433d240, vardata=vardata@entry=0x82139a0b0, opoid=opoid@entry=523, opproc=opproc@entry=0x82139a010, isgt=false, iseq=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [17:28:17.269] probe = 100 [17:28:17.269] ltcmp = [17:28:17.269] lobound = 99 [17:28:17.269] hibound = 101 [17:28:17.269] have_end = false [17:28:17.269] histfrac = [17:28:17.269] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x844c5f718, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [17:28:17.269] hist_selec = -1 [17:28:17.269] #12 0x0000000000a02441 in scalarineqsel (root=root@entry=0x83433d240, operator=operator@entry=523, isgt=false, iseq=true, collation=0, vardata=vardata@entry=0x82139a0b0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [17:28:17.269] opproc = {fn_addr = 0x974fd0 , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x83433c000, fn_expr = 0x0} [17:28:17.269] sumcommon = 0 [17:28:17.269] mcv_selec = [17:28:17.269] hist_selec = [17:28:17.269] selec = [17:28:17.269] stats = [17:28:17.269] #13 0x00000000009ff0f3 in scalarineqsel_wrapper (fcinfo=, isgt=false, iseq=true) at ../src/backend/utils/adt/selfuncs.c:1459 [17:28:17.269] vardata = {var = 0x844c5e4e8, rel = 0x844c5e908, statsTuple = 0x84240ce98, freefunc = 0xa53cb0 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [17:28:17.269] other = 0x844c5fb78 [17:28:17.269] varonleft = true [17:28:17.269] root = 0x83433d240 [17:28:17.269] operator = 523 [17:28:17.269] args = [17:28:17.269] varRelid = [17:28:17.269] collation = 0 [17:28:17.269] constval = 34917178120 [17:28:17.269] consttype = 716027552 [17:28:17.269] selec = [17:28:17.269] #14 0x0000000000a62e3f in FunctionCall4Coll (flinfo=0x82139a140, collation=0, arg1=35235549760, arg2=523, arg3=35513558728, arg4=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [17:28:17.269] fcinfodata = {fcinfo = {flinfo = 0x82139a140, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x82139a190}, fcinfo_data = "@\2419!\b", '\000' , "\004\000@\32234\b", '\000' , "\v\002\000\000\000\000\000\000\000\006Q?\b\000\000\000\310\346\305D\b\000\000\000\000\32234\b", '\000' , "\353\243\000\000\000\000"} [17:28:17.269] fcinfo = 0x82139a170 [17:28:17.269] result = [17:28:17.269] __error = [17:28:17.269] #15 OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=35235549760, arg2=arg2@entry=523, arg3=arg3@entry=35513558728, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [17:28:17.269] flinfo = {fn_addr = 0x9ff140 , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x83433c000, fn_expr = 0x0} [17:28:17.269] #16 0x000000000080153e in restriction_selectivity (root=root@entry=0x83433d240, operatorid=523, args=0x844c5e6c8, inputcollid=0, varRelid=varRelid@entry=0) at ../src/backend/optimizer/util/plancat.c:1963 [17:28:17.269] oprrest = 0 [17:28:17.269] result = [17:28:17.269] #17 0x00000000007a85e4 in clause_selectivity_ext (root=root@entry=0x83433d240, clause=0x844c5e768, clause@entry=0x844b5e398, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:848 [17:28:17.269] opclause = 0x844c5e768 [17:28:17.269] opno = [17:28:17.269] s1 = 0.5 [17:28:17.269] rinfo = 0x844b5e398 [17:28:17.269] cacheable = true [17:28:17.269] #18 0x00000000007a8005 in clauselist_selectivity_ext (root=0x83433d240, clauses=0x844c5f668, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:183 [17:28:17.269] clause = 0x844b5e398 [17:28:17.269] s2 = [17:28:17.269] rinfo = [17:28:17.269] l__state = {l = 0x844c5f668, i = 1} [17:28:17.269] estimatedclauses = 0x0 [17:28:17.269] rqlist = 0x844c5fb28 [17:28:17.269] s1 = 1 [17:28:17.269] rel = [17:28:17.269] listidx = 1 [17:28:17.269] l = [17:28:17.269] #19 0x00000000007a7ea0 in clauselist_selectivity (root=0x18cfd, clauses=0x6, varRelid=varRelid@entry=0, jointype=715293690, jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [17:28:17.269] No locals. [17:28:17.269] #20 0x00000000007afc44 in set_baserel_size_estimates (root=0x18cfd, root@entry=0x83433d240, rel=rel@entry=0x844c5e908) at ../src/backend/optimizer/path/costsize.c:5286 [17:28:17.269] nrows = [17:28:17.269] #21 0x00000000007a6921 in set_plain_rel_size (root=0x83433d240, rel=0x844c5e908, rte=0x844b5fe98) at ../src/backend/optimizer/path/allpaths.c:581 [17:28:17.269] No locals. [17:28:17.269] #22 set_rel_size (root=root@entry=0x83433d240, rel=rel@entry=0x844c5e908, rti=rti@entry=1, rte=rte@entry=0x844b5fe98) at ../src/backend/optimizer/path/allpaths.c:411 [17:28:17.269] No locals. [17:28:17.269] #23 0x00000000007a3671 in set_base_rel_sizes (root=0x83433d240) at ../src/backend/optimizer/path/allpaths.c:322 [17:28:17.269] rel = 0x844c5e908 [17:28:17.269] rte = 0x844b5fe98 [17:28:17.269] rti = 1 [17:28:17.269] #24 make_one_rel (root=root@entry=0x83433d240, joinlist=joinlist@entry=0x844c5f578) at ../src/backend/optimizer/path/allpaths.c:183 [17:28:17.269] total_pages = [17:28:17.269] rti = [17:28:17.269] rel = [17:28:17.269] #25 0x00000000007d3e44 in query_planner (root=root@entry=0x83433d240, qp_callback=, qp_extra=qp_extra@entry=0x82139a500) at ../src/backend/optimizer/plan/planmain.c:280 [17:28:17.269] parse = 0x844c5dc38 [17:28:17.269] final_rel = [17:28:17.269] joinlist = 0x844c5f578 [17:28:17.269] #26 0x00000000007d6e5b in grouping_planner (root=root@entry=0x83433d240, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [17:28:17.269] sort_input_targets = 0x844b5e9d4 [17:28:17.269] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [17:28:17.269] activeWindows = 0x0 [17:28:17.269] grouping_target = [17:28:17.269] scanjoin_target = [17:28:17.269] sort_input_target_parallel_safe = [17:28:17.269] sort_input_targets_contain_srfs = 0x7f3da0 [17:28:17.269] wflists = 0x0 [17:28:17.269] gset_data = 0x0 [17:28:17.269] have_grouping = [17:28:17.269] grouping_targets = 0x844c5e888 [17:28:17.269] scanjoin_targets = 0x79aaf1 [17:28:17.269] sort_input_target = [17:28:17.269] grouping_target_parallel_safe = [17:28:17.269] scanjoin_target_parallel_safe = [17:28:17.269] grouping_targets_contain_srfs = 0x844c5e888 [17:28:17.269] scanjoin_targets_contain_srfs = 0x0 [17:28:17.269] scanjoin_target_same_exprs = [17:28:17.269] final_targets = 0x0 [17:28:17.269] final_targets_contain_srfs = 0x82139a660 [17:28:17.269] extra = {limit_needed = 241, limit_tuples = 1.1857575500189917e-321, count_est = 35513558248, offset_est = 35513558728} [17:28:17.269] parse = 0x844c5dc38 [17:28:17.269] offset_est = 0 [17:28:17.269] count_est = 0 [17:28:17.269] limit_tuples = -1 [17:28:17.269] have_postponed_srfs = false [17:28:17.269] current_rel = [17:28:17.269] final_target = [17:28:17.269] final_target_parallel_safe = [17:28:17.269] final_rel = [17:28:17.269] lc = [17:28:17.269] #27 0x00000000007d54f9 in subquery_planner (glob=glob@entry=0x83433da18, parse=parse@entry=0x844c5dc38, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1089 [17:28:17.269] root = 0x83433d240 [17:28:17.269] hasOuterJoins = false [17:28:17.269] hasResultRTEs = false [17:28:17.269] l = [17:28:17.269] newWithCheckOptions = [17:28:17.269] newHaving = [17:28:17.269] final_rel = [17:28:17.269] #28 0x00000000007d4028 in standard_planner (parse=0x844c5dc38, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:415 [17:28:17.269] glob = 0x83433da18 [17:28:17.269] tuple_fraction = [17:28:17.269] root = [17:28:17.269] final_rel = [17:28:17.269] best_path = [17:28:17.269] top_plan = [17:28:17.269] lp = [17:28:17.269] lr = [17:28:17.269] result = [17:28:17.269] #29 0x00000000008fd834 in pg_plan_query (querytree=querytree@entry=0x844c5dc38, query_string=query_string@entry=0x83433c100 "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:28:17.269] plan = [17:28:17.269] #30 0x00000000008fd932 in pg_plan_queries (querytrees=0x844c5e3c8, query_string=query_string@entry=0x83433c100 "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:28:17.269] query = 0x844c5dc38 [17:28:17.269] stmt = [17:28:17.269] query_list__state = {l = 0x844c5e3c8, i = 0} [17:28:17.269] stmt_list = 0x0 [17:28:17.269] query_list = [17:28:17.269] #31 0x0000000000901da0 in exec_simple_query (query_string=query_string@entry=0x83433c100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [17:28:17.269] cmdtaglen = 6 [17:28:17.269] snapshot_set = [17:28:17.269] per_parsetree_context = 0x0 [17:28:17.269] plantree_list = [17:28:17.269] qc = {commandTag = 557426912, nprocessed = 35075017391} [17:28:17.269] format = 8 [17:28:17.269] parsetree = 0x83433d650 [17:28:17.269] commandTag = CMDTAG_DELETE [17:28:17.269] cmdtagname = [17:28:17.269] querytree_list = 0x0 [17:28:17.269] portal = [17:28:17.269] receiver = [17:28:17.269] parsetree_item__state = {l = 0x83433d9c8, i = 0} [17:28:17.269] msec_str = "\340\2509!\b\000\000\000\257J\242*\b\000\000\000Q\243\324f\000\000\000\000\307\357\347\363]7\r\212" [17:28:17.269] dest = DestRemote [17:28:17.269] was_logged = [17:28:17.269] oldcontext = 0x8343e4000 [17:28:17.269] parsetree_list = 0x83433d9c8 [17:28:17.269] use_implicit_block = false [17:28:17.269] parsetree_item = 0x83433d9e0 [17:28:17.269] save_log_statement_stats = [17:28:17.269] #32 0x00000000008ffc00 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [17:28:17.269] query_string = 0x83433c100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [17:28:17.269] input_message = {data = 0x83433c100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [17:28:17.269] firstchar = [17:28:17.269] local_sigjmp_buf = {{_sjb = {9433238, 34917165424, 34917165384, 34917165968, 12147016, 1, 8192, 8388608, 34917122943, 0, 0, 1}}} [17:28:17.269] send_ready_for_query = false [17:28:17.269] idle_in_transaction_timeout_enabled = false [17:28:17.269] idle_session_timeout_enabled = false [17:28:17.269] #33 0x00000000008fa3d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [17:28:17.269] bsdata = [17:28:17.269] #34 0x00000000008545b7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82139b6b4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82139b5f0) at ../src/backend/postmaster/launch_backend.c:274 [17:28:17.269] pid = [17:28:17.269] #35 0x0000000000858978 in BackendStartup (client_sock=0x82139b5f0) at ../src/backend/postmaster/postmaster.c:3414 [17:28:17.269] startup_data = {canAcceptConnections = CAC_OK} [17:28:17.269] bn = 0x834348268 [17:28:17.269] pid = [17:28:17.269] __error = [17:28:17.269] save_errno = [17:28:17.269] __error = [17:28:17.269] __error = [17:28:17.269] #36 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [17:28:17.269] 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\33634\b", '\000' , "P\2669!\b\000\000\000h\265\027*\b\000\000\000\v\000\000\000\000\000\000\000^?\030*\b", '\000' , "\220\2669!\b\000\000\000dC\205\000\000\000\000\000\240\2669!\b", '\000' }, salen = 16}} [17:28:17.269] i = 0 [17:28:17.269] now = [17:28:17.269] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 714919042, events = 8, fd = 0, user_data = 0x82139b5a0}, {pos = 876234200, events = 8, fd = 557429808, user_data = 0x0}, {pos = 0, events = 0, fd = 2144621108, user_data = 0x21909322630a}, {pos = 714086304, events = 8, fd = 714157432, user_data = 0x82139b0b8}, {pos = 557429040, events = 8, fd = 557428920, user_data = 0x21909322630a}, {pos = 714064776, events = 8, fd = 714157432, user_data = 0x82139b0e8}, {pos = 557429088, events = 8, fd = 557428968, user_data = 0x82a90b194}, {pos = 559252488, events = 8, fd = 714125716, user_data = 0x82139b150}, {pos = -1826483142, events = 8592, fd = 715948080, user_data = 0x1}, {pos = 557429120, events = 8, fd = -1826462966, user_data = 0x82a8f4858}, {pos = 714157432, events = 8, fd = 557429080, user_data = 0x82139b1d0}, {pos = 557429080, events = 8, fd = 714120460, user_data = 0x821558408}, {pos = 714120460, events = 8, fd = 557429184, user_data = 0x21909322143a}, {pos = 557429224, events = 8, fd = 557429672, user_data = 0x82139b1d0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 4058667592, fd = 559276088, user_data = 0x800000001}, {pos = 559252488, events = 8, fd = 714064776, user_data = 0x82155d288}, {pos = 714033240, events = 8, fd = 559252488, user_data = 0x82139b258}, {pos = 557429784, events = 8, fd = 557429312, user_data = 0x219093225ca2}, {pos = 2699824, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 559276088, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 557430040, user_data = 0x21558408}, {pos = 557429856, events = 8, fd = 557429456, user_data = 0x1}, {pos = 557429784, events = 8, fd = 32, user_data = 0x82139b2c0}, {pos = -1826465165, events = 8592, fd = 557429728, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82155e038}, {pos = 1, events = 8, fd = 559252488, user_data = 0x82a8f4858}, {pos = 557430040, events = 8, fd = 557429856, user_data = 0x82139b2d0}, {pos = 0, events = 0, fd = 559222792, user_data = 0x20}, {pos = 557429840, events = 8, fd = -1826489625, user_data = 0x821551008}, {pos = 559223816, events = 8, fd = 559224840, user_data = 0x821551c08}, {pos = 559239176, events = 8, fd = 559240200, user_data = 0x821555808}, {pos = 559242248, events = 8, fd = 559243272, user_data = 0x821556408}, {pos = 559245320, events = 8, fd = 559246344, user_data = 0x821557008}, {pos = 559248392, events = 8, fd = 559249416, user_data = 0x821557c08}, {pos = 559251464, events = 8, fd = 559252488, user_data = 0x821558808}, {pos = 559254536, events = 8, fd = 559255560, user_data = 0x821559408}, {pos = 559257608, events = 8, fd = 559258632, user_data = 0x82155a008}, {pos = 559260680, events = 8, fd = 559261704, user_data = 0x82155ac08}, {pos = 559267848, events = 8, fd = 559268872, user_data = 0x82155c808}, {pos = 559270920, events = 8, fd = 559222792, user_data = 0x293230}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82155e038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557430040, events = 8, fd = 557429456, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 559276088, user_data = 0x1}, {pos = 559222792, events = 8, fd = 314, user_data = 0x82139b500}, {pos = -1826490897, events = 8592, fd = 2699824, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 559276088, user_data = 0x1}, {pos = 559252488, events = 8, fd = 875741184, user_data = 0x1}, {pos = 875741588, events = 8, fd = 0, user_data = 0x82139b4d0}, {pos = 706229612, events = 8, fd = 1, user_data = 0x83432c000}, {pos = 557430016, events = 8, fd = 706225922, user_data = 0x82aa26170 }, {pos = 12072056, events = 0, fd = 715284848, user_data = 0x821558408}, {pos = 557430240, events = 8, fd = -1826491426, user_data = 0x83434a800}, {pos = 1, events = 0, fd = -1826491810, user_data = 0x821551008}, {pos = 557430024, events = 8, fd = 557430240, user_data = 0x1c38}, {pos = 875814592, events = 8, fd = -1826412144, user_data = 0x0}, {pos = 557384575, events = 8, fd = 7886519, user_data = 0x82139b590}, {pos = 706188304, events = 8, fd = 715948080, user_data = 0x82aaca310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82139b5c0}, {pos = 706231197, events = 8, fd = 875741184, user_data = 0x1706}, {pos = 557430304, events = 8, fd = 706197754, user_data = 0x0}, {pos = 0, events = 0, fd = 2144621108, user_data = 0x0}} [17:28:17.269] last_touch_time = 1725211430 [17:28:17.269] last_lockfile_recheck_time = 1725211430 [17:28:17.269] nevents = 1 [17:28:17.269] #37 0x0000000000856795 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82139bc00) at ../src/backend/postmaster/postmaster.c:1346 [17:28:17.269] userDoption = [17:28:17.269] listen_addr_saved = [17:28:17.269] output_config_variable = [17:28:17.269] opt = [17:28:17.269] status = [17:28:17.269] #38 0x00000000007923bc in main (argc=4, argv=0x82139bc00) at ../src/backend/main/main.c:197 [17:28:17.269] do_check_root = [17:28:17.279] [17:28:17.279] [17:28:17.279] [17:28:17.340] dumping /tmp/cores/postgres.19303.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [17:28:17.464] [New LWP 101656] [17:28:17.529] Core was generated by `postgres: primary: postgres regression [local] DELETE'. [17:28:17.529] Program terminated with signal SIGABRT, Aborted. [17:28:17.529] Sent by thr_kill() from pid 19303 and user 1003. [17:28:17.529] #0 0x000000082b58d41a in thr_kill () from /lib/libc.so.7 [17:28:17.646] [17:28:17.646] Thread 1 (LWP 101656): [17:28:17.646] #0 0x000000082b58d41a in thr_kill () from /lib/libc.so.7 [17:28:17.646] No symbol table info available. [17:28:17.646] #1 0x000000082b506e64 in raise () from /lib/libc.so.7 [17:28:17.646] No symbol table info available. [17:28:17.646] #2 0x000000082b5b76f9 in abort () from /lib/libc.so.7 [17:28:17.646] No symbol table info available. [17:28:17.646] #3 0x0000000000a58c95 in ExceptionalCondition (conditionName=0x2ad5c9 "!BTScanPosIsPinned(so->currPos)", fileName=, lineNumber=lineNumber@entry=2266) at ../src/backend/utils/error/assert.c:66 [17:28:17.646] No locals. [17:28:17.646] #4 0x00000000005ef846 in _bt_readnextpage (scan=scan@entry=0x83ea2b5d0, blkno=1, expectNext=2, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2266 [17:28:17.646] rel = 0x83cbdfac8 [17:28:17.646] so = 0x8349d1638 [17:28:17.646] page = [17:28:17.646] status = [17:28:17.646] opaque = [17:28:17.646] #5 0x00000000005ee8d0 in _bt_steppage (scan=scan@entry=0x83ea2b5d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2163 [17:28:17.646] blkno = 2 [17:28:17.646] expectNext = 4 [17:28:17.646] so = 0x8349d1638 [17:28:17.646] status = [17:28:17.646] #6 0x00000000005ed556 in _bt_first (scan=scan@entry=0x83ea2b5d0, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1461 [17:28:17.646] buf = 48 [17:28:17.646] 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 = 0x83ea2b000, fn_expr = 0x83f24d038}, 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 = 0x10002, fn_expr = 0x100002}, sk_argument = 35410592520}, {sk_flags = 563474400, sk_attno = 8, sk_strategy = 0, sk_subtype = 727233149, sk_collation = 8, sk_func = {fn_addr = 0x3f2a0790, fn_oid = 3140446, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x11, fn_mcxt = 0x33383137332f3438, fn_expr = 0x383336312f657361}, sk_argument = 34923212656}, {sk_flags = 11166962, sk_attno = 0, sk_strategy = 0, sk_subtype = 1050854168, sk_collation = 8, sk_func = {fn_addr = 0x82ab3e5df, fn_oid = 1050854279, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x39373137332f3438}, sk_argument = 4049640074812683105}, {sk_flags = 3140446, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x2195f0a0, fn_oid = 727975584, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x180, fn_mcxt = 0x100002, fn_expr = 0x83ea2c308}, sk_argument = 34923212976}, {sk_flags = 727233149, sk_attno = 8, sk_strategy = 0, sk_subtype = 528438443, sk_collation = 0, sk_func = {fn_addr = 0x2feb5e, fn_oid = 384, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 17 '\021', fn_extra = 0x39373137332f3438, fn_mcxt = 0x383336312f657361, fn_expr = 0x82195f040}, sk_argument = 11166962}, {sk_flags = 1050854168, sk_attno = 8, sk_strategy = 0, sk_subtype = 1050854152, sk_collation = 8, sk_func = {fn_addr = 0x83ea2c387, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x82b6406a0 <__stack_chk_guard>, fn_mcxt = 0x82195f060, fn_expr = 0xab2872 }, sk_argument = 3140446}, {sk_flags = 128, sk_attno = 0, sk_strategy = 0, sk_subtype = 563474800, sk_collation = 8, sk_func = {fn_addr = 0xab2839 , fn_oid = 881226728, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x913b, fn_mcxt = 0xffffffff, fn_expr = 0x0}, sk_argument = 11835728}, {sk_flags = 528438443, sk_attno = -7851, sk_strategy = 4567, sk_subtype = 384, sk_collation = 0, sk_func = {fn_addr = 0x82195f0f0, fn_oid = 9203247, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 24 '\030', fn_extra = 0x690, fn_mcxt = 0x100002, fn_expr = 0x180}, sk_argument = 35377025024}, {sk_flags = 1017288336, sk_attno = 8, sk_strategy = 0, sk_subtype = 563474800, sk_collation = 8, sk_func = {fn_addr = 0x5d17ba , fn_oid = 563474960, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0xa00001100000000, fn_mcxt = 0x4000, fn_expr = 0x3000000018}, sk_argument = 35377079936}, {sk_flags = 563474544, sk_attno = 8, sk_strategy = 0, sk_subtype = 11011417, sk_collation = 0, sk_func = {fn_addr = 0x8348673b8, fn_oid = 881226680, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 112 'p', fn_extra = 0x8f7780 <_mdnblocks+16>, fn_mcxt = 0x8348673b8, fn_expr = 0x5d17ba }, sk_argument = 34923213232}, {sk_flags = 10912009, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5d17ba , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x82195f220}, sk_argument = 9147666}, {sk_flags = 16843009, sk_attno = 0, sk_strategy = 0, sk_subtype = 25, sk_collation = 0, sk_func = {fn_addr = 0xc5e1c69901010101, fn_oid = 928321408, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0xa68109 , fn_mcxt = 0x82195f220, fn_expr = 0x91c33f }, sk_argument = 107}, {sk_flags = 927262720, sk_attno = 8, sk_strategy = 0, sk_subtype = 107, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 563475088, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 18 '\022', fn_extra = 0x1, fn_mcxt = 0xb, fn_expr = 0xbb5910ab00000007}, sk_argument = 35288059776}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098320, sk_collation = 0, sk_func = {fn_addr = 0x82195f290, fn_oid = 9552703, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x83498fb48, fn_mcxt = 0x1, fn_expr = 0x8}, sk_argument = 34923213664}, {sk_flags = 9156922, 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 = 232 '\350', fn_extra = 0x70, fn_mcxt = 0x8349a9488, fn_expr = 0x82195f3fc}, sk_argument = 8}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912590, 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 = 0x82195f330, fn_expr = 0x621eaf }, sk_argument = 12099872}, {sk_flags = 15883, sk_attno = 0, sk_strategy = 0, sk_subtype = 563475328, sk_collation = 8, sk_func = {fn_addr = 0x8d7e86 , fn_oid = 107, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x1, fn_mcxt = 0x83491a1c0, fn_expr = 0x82195f380}, sk_argument = 67}, {sk_flags = 1019083464, sk_attno = 8, sk_strategy = 0, sk_subtype = 927805440, sk_collation = 8, sk_func = {fn_addr = 0x82195f3a0, fn_oid = 6430383, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x404d, fn_mcxt = 0x82195f3f0, fn_expr = 0x8d7e86 }, sk_argument = 35410589504}, {sk_flags = 9561125, sk_attno = 0, sk_strategy = 0, sk_subtype = 1236362940, sk_collation = 0, sk_func = {fn_addr = 0x8348fc730, fn_oid = 563475440, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 28 '\034', fn_extra = 0x8349a77a8, fn_mcxt = 0x837485000, fn_expr = 0x82195f6c0}, sk_argument = 6101058}, {sk_flags = 2, sk_attno = 16384, sk_strategy = 0, sk_subtype = 2620, sk_collation = 1, sk_func = {fn_addr = 0x1, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0xa3c}, sk_argument = 34923213952}, {sk_flags = 9545473, sk_attno = 0, sk_strategy = 0, sk_subtype = 12141016, sk_collation = 0, sk_func = {fn_addr = 0x83cbdfac8, fn_oid = 883027656, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 186 '\272', fn_extra = 0xa3c, fn_mcxt = 0xa68109 , fn_expr = 0x82195f4b0}, sk_argument = 35378821904}, {sk_flags = 28, sk_attno = 0, sk_strategy = 0, sk_subtype = 927257664, sk_collation = 8, sk_func = {fn_addr = 0x1c, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x8b9512 , fn_mcxt = 0x1, fn_expr = 0x13}, sk_argument = 17387022204079702020}, {sk_flags = 928321408, sk_attno = 8, sk_strategy = 0, sk_subtype = 20, sk_collation = 0, sk_func = {fn_addr = 0xa68109 , fn_oid = 563475760, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 88 'X', fn_extra = 0xb83f01 , fn_mcxt = 0x0, fn_expr = 0xb959a0 }, sk_argument = 1}, {sk_flags = 881859584, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x82195f5d0, fn_oid = 10742306, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 63 '?', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 37183}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x913f, fn_oid = 6, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0xb959a0 , fn_mcxt = 0x83cbdbdc8, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = 563475920, sk_attno = 8, sk_strategy = 0, sk_subtype = 10742575, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 11011417, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x83ea2c2f0, fn_mcxt = 0x83f2d57e0, fn_expr = 0x83cbdfac8}, sk_argument = 1}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 563476064, sk_collation = 8, sk_func = {fn_addr = 0xa49f55 , fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x3cbe30c8, fn_mcxt = 0x83cbdfac8, fn_expr = 0x10000913f}, sk_argument = 5}, {sk_flags = 1059935808, sk_attno = 8, sk_strategy = 0, sk_subtype = 882453800, sk_collation = 8, sk_func = {fn_addr = 0x83cbe30c8, fn_oid = 1019083464, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 48 '0', fn_extra = 0xa49a05 , fn_mcxt = 0x1, fn_expr = 0x1}, sk_argument = 6}, {sk_flags = 10912009, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x83ea2b1a0, fn_oid = 563476272, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 9 '\t', fn_extra = 0x82195f730, fn_mcxt = 0x82b5ca055, fn_expr = 0x8348fb100}, sk_argument = 35241576856}, {sk_flags = 34, sk_attno = 2, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8348fb100, fn_oid = 881832336, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 20 '\024', fn_extra = 0x0, fn_mcxt = 0x11d7e1551f7f54ab, fn_expr = 0x83ea2b000}, sk_argument = 27416}, {sk_flags = 27352, sk_attno = 0, sk_strategy = 0, sk_subtype = 563476384, sk_collation = 8, sk_func = {fn_addr = 0x82b5ca055, fn_oid = 563476336, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 55 '7', fn_extra = 0x2000, fn_mcxt = 0x83cbdfac8, fn_expr = 0x0}, sk_argument = 1}}} [17:28:17.646] startKeys = {0x83ea2b500, 0x0, 0x83ea2b000, 0x8349eeba0, 0x913b, 0xb700b800b900ba, 0xb300b400b500b6, 0xaf000000000101, 0x0, 0xa700a800000001, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x83ea2b000, 0x8349ef838, 0x913f, 0x7f008000810082, 0x7b007c007d007e, 0x77000001000101, 0x0, 0x6f007000000002, 0x100030000, 0x3b600000000, 0x5dcc60 , 0x1000200000164, 0x2, 0x0, 0x83ea2b000, 0x83494e7a0} [17:28:17.646] 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 = 34923209984}, {sk_flags = 6248338, sk_attno = 0, sk_strategy = 0, sk_subtype = 927257216, sk_collation = 8, sk_func = {fn_addr = 0x8349d1638, fn_oid = 1050240344, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x349a3c68, fn_mcxt = 0xa68109 , fn_expr = 0x349d1601}, sk_argument = 8589934593}, {sk_flags = 126, sk_attno = 0, sk_strategy = 0, sk_subtype = 10912009, sk_collation = 0, sk_func = {fn_addr = 0x7e, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 126 '~', fn_extra = 0x83744ecc0, fn_mcxt = 0x7e, fn_expr = 0x0}, sk_argument = 34923210112}, {sk_flags = 10912009, sk_attno = 0, sk_strategy = 0, sk_subtype = 128, sk_collation = 0, sk_func = {fn_addr = 0x7, fn_oid = 128, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x80, fn_mcxt = 0xa68109 , fn_expr = 0x82195e5c0}, sk_argument = 9147666}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 927256064, sk_collation = 8, sk_func = {fn_addr = 0x3, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0xa68109 , fn_mcxt = 0x2195e5c0, fn_expr = 0x6}, sk_argument = 79}, {sk_flags = 927260928, sk_attno = 8, sk_strategy = 0, sk_subtype = 79, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 563471920, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 18 '\022', fn_extra = 0x349a3c68, fn_mcxt = 0x0, fn_expr = 0xd7efca000000001}, sk_argument = 35288059776}, {sk_flags = 20, sk_attno = 0, sk_strategy = 0, sk_subtype = 12098320, sk_collation = 0, sk_func = {fn_addr = 0x82195e630, fn_oid = 9552703, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 104 'h', fn_extra = 0x83498fbc8, fn_mcxt = 0x1, fn_expr = 0x4}, sk_argument = 34923210496}, {sk_flags = 9156922, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 8, sk_func = {fn_addr = 0xffffffff00000005, fn_oid = 563472048, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 26 '\032', fn_extra = 0x70, fn_mcxt = 0x83e996788, 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 = 0x82195e730, fn_expr = 0x5f5792 <_bt_check_compare+1218>}, sk_argument = 35286999296}, {sk_flags = 882710072, sk_attno = 8, sk_strategy = 0, sk_subtype = 1050240344, sk_collation = 8, sk_func = {fn_addr = 0x83e996778, fn_oid = 882523240, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x349d1601, fn_mcxt = 0x200000001, fn_expr = 0x3b6}, sk_argument = 34923210728}, {sk_flags = 563472396, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 927908352, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0x5f4fa1 <_bt_checkkeys+321>, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 34923210663}, {sk_flags = 563472244, sk_attno = 8, sk_strategy = 0, sk_subtype = 563472396, sk_collation = 8, sk_func = {fn_addr = 0x2fc87a, fn_oid = 927260928, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x8349a3e78, fn_mcxt = 0x374eb000, fn_expr = 0x83e996558}, sk_argument = 8599100553}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 882710072, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 10912009, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xe0, fn_mcxt = 0x6, fn_expr = 0x83744cec0}, sk_argument = 6}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 563472480, sk_collation = 8, sk_func = {fn_addr = 0x8b9512 , fn_oid = 563472512, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0xf3c7e5e100000000, fn_mcxt = 0x837550f80, fn_expr = 0x14}, sk_argument = 12098320}, {sk_flags = 563472480, sk_attno = 8, sk_strategy = 0, sk_subtype = 9552703, sk_collation = 0, sk_func = {fn_addr = 0x83cbe5578, fn_oid = 882438600, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x1, fn_mcxt = 0x82195e930, fn_expr = 0x8bb93a }, sk_argument = 1}, {sk_flags = 2, sk_attno = -1, sk_strategy = 65535, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0xb851e8 , fn_oid = 112, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x82195e9cc, fn_mcxt = 0x1, fn_expr = 0x349d1638}, sk_argument = 7142530613279}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 11172389, sk_collation = 0, sk_func = {fn_addr = 0x82195ef40, fn_oid = 4294967291, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 5 '\005', fn_extra = 0x0, fn_mcxt = 0x82195e970, fn_expr = 0xaa7c9b }, sk_argument = 72057594037927937}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1019106680, 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 = 0x82195ea00, fn_mcxt = 0x33383137338b9757, fn_expr = 0x0}, sk_argument = 3140451}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 563474240, sk_collation = 8, sk_func = {fn_addr = 0x82195f050, fn_oid = 3140456, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xaa716c , fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 11172389, sk_attno = 0, sk_strategy = 0, sk_subtype = 563474448, sk_collation = 8, sk_func = {fn_addr = 0xfffffffb, fn_oid = 5, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x82195ea40, fn_mcxt = 0xaa7c9b , fn_expr = 0x800001691}, sk_argument = 3131514}, {sk_flags = 1050851584, sk_attno = 8, sk_strategy = 0, sk_subtype = 1050851656, sk_collation = 8, sk_func = {fn_addr = 0x6, fn_oid = 927305728, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x39373137338bdc89, fn_mcxt = 0x0, fn_expr = 0x2feb63}, sk_argument = 0}, {sk_flags = 563474448, sk_attno = 8, sk_strategy = 0, sk_subtype = 563474720, sk_collation = 8, sk_func = {fn_addr = 0x2feb68, fn_oid = 563474432, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 108 'l', fn_extra = 0x83ea2b500, fn_mcxt = 0x0, fn_expr = 0x82195f010}, sk_argument = 11167147}, {sk_flags = 1050851584, 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 = 1050849280, sk_collation = 8, sk_func = {fn_addr = 0x8349ef838, fn_oid = 2620, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 104 'h', fn_extra = 0x82195f0a0, 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 = 0x83ea2b000, fn_expr = 0x83494e7a0}, 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 = 0x83ea2b000, fn_expr = 0x83494ea48}, 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 = 0x83ea2b000, fn_expr = 0x83494e7a0}, 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 = 0x83ea2b500, fn_mcxt = 0x83ea2b000, fn_expr = 0x83494ea48}, 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 = 0x83ea2b000}, sk_argument = 35241912904}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1050850560, sk_collation = 8, sk_func = {fn_addr = 0x8374c5440, fn_oid = 563473696, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 161 '\241', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x82195ecf7}, sk_argument = 34923211972}, {sk_flags = 563473756, sk_attno = 8, sk_strategy = 0, sk_subtype = 3131514, sk_collation = 0, sk_func = {fn_addr = 0x3744dc40, fn_oid = 882710072, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x374c5000, fn_mcxt = 0x83ea2b7f0, fn_expr = 0x83ea2b838}, sk_argument = 1}, {sk_flags = 882710072, sk_attno = 8, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, 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}} [17:28:17.646] blkno = 8 [17:28:17.646] rel = 0x83cbdfac8 [17:28:17.646] so = 0x8349d1638 [17:28:17.646] keysz = [17:28:17.646] strat_total = 1 [17:28:17.646] i = [17:28:17.646] strat = [17:28:17.646] stack = [17:28:17.646] offnum = [17:28:17.646] status = [17:28:17.646] currItem = [17:28:17.646] #7 0x00000000005e9ee3 in btgettuple (scan=0x83ea2b5d0, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:225 [17:28:17.646] so = 0x8349d1638 [17:28:17.646] res = [17:28:17.646] #8 0x00000000005dbf11 in index_getnext_tid (scan=scan@entry=0x83ea2b5d0, direction=6, direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:590 [17:28:17.646] found = [17:28:17.646] #9 0x0000000000a06a78 in get_actual_variable_endpoint (heapRel=heapRel@entry=0x83cbe59a8, indexRel=indexRel@entry=0x83cbdfac8, indexscandir=BackwardScanDirection, scankeys=scankeys@entry=0x82195fa60, typLen=4, typByVal=true, tableslot=0x83ea2b360, outercontext=0x83485d000, endpointDatum=0x83e997568) at ../src/backend/utils/adt/selfuncs.c:6349 [17:28:17.646] SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin = 0, xmax = 563476864, xip = 0xa3ec58 , xcnt = 12074753, subxip = 0x0, subxcnt = 12147104, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, vistest = 0xb8a130 , active_count = 0, regd_count = 0, ph_node = {first_child = 0x82195fa20, next_sibling = 0xa3ea22 , prev_or_parent = 0x17}, whenTaken = 0, lsn = 0, snapXactCompletionCount = 0} [17:28:17.646] vmbuffer = 0 [17:28:17.646] values = {34923215312, 10795029, 844429225099264, 4080218931200, 10232960, 281483566645432, 2, 0, 35410587648, 0, 37183, 1407383473487872, 4080218931200, 9916592, 281483566645394, 6100738, 0, 35410587648, 0, 0, 844429225099264, 4080218931200, 10232960, 10912009, 2940418, 0, 35410587648, 34923215248, 37179, 0, 35241570560, 35410588512} [17:28:17.646] isnull = {23, false , 23, false, false, false, false, false, false, false} [17:28:17.646] have_data = false [17:28:17.646] last_heap_block = 4294967295 [17:28:17.646] n_visited_heap_pages = 0 [17:28:17.646] index_scan = 0x83ea2b5d0 [17:28:17.646] tid = [17:28:17.646] oldcontext = [17:28:17.646] #10 0x00000000009fe802 in get_actual_variable_range (root=, vardata=, sortop=97, collation=, min=0x0, max=0x83e997568) at ../src/backend/utils/adt/selfuncs.c:6228 [17:28:17.646] typLen = 4 [17:28:17.646] tmpcontext = 0x83ea2b000 [17:28:17.646] oldcontext = 0x83485d000 [17:28:17.646] heapRel = 0x83cbe59a8 [17:28:17.646] slot = 0x83ea2b360 [17:28:17.646] typByVal = true [17:28:17.646] 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:28:17.646] indexRel = 0x83cbdfac8 [17:28:17.646] index = [17:28:17.646] indexscandir = ForwardScanDirection [17:28:17.646] lc__state = {l = , i = 0} [17:28:17.646] have_data = false [17:28:17.646] rel = [17:28:17.646] rte = 0x83485ea18 [17:28:17.646] lc = [17:28:17.646] #11 0x00000000009fe104 in ineq_histogram_selectivity (root=root@entry=0x83e9951f8, vardata=vardata@entry=0x82195fd00, opoid=opoid@entry=523, opproc=opproc@entry=0x82195fc60, isgt=false, iseq=true, collation=0, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:1129 [17:28:17.646] probe = 100 [17:28:17.646] ltcmp = [17:28:17.646] lobound = 99 [17:28:17.646] hibound = 101 [17:28:17.646] have_end = false [17:28:17.646] histfrac = [17:28:17.646] sslot = {staop = 97, stacoll = 0, valuetype = 23, values = 0x83e997248, nvalues = 101, numbers = 0x0, nnumbers = 0, values_arr = 0x0, numbers_arr = 0x0} [17:28:17.646] hist_selec = -1 [17:28:17.646] #12 0x0000000000a02441 in scalarineqsel (root=root@entry=0x83e9951f8, operator=operator@entry=523, isgt=false, iseq=true, collation=0, vardata=vardata@entry=0x82195fd00, constval=100000010, consttype=23) at ../src/backend/utils/adt/selfuncs.c:688 [17:28:17.646] opproc = {fn_addr = 0x974fd0 , fn_oid = 149, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x83485d000, fn_expr = 0x0} [17:28:17.646] sumcommon = 0 [17:28:17.646] mcv_selec = [17:28:17.646] hist_selec = [17:28:17.646] selec = [17:28:17.646] stats = [17:28:17.646] #13 0x00000000009ff0f3 in scalarineqsel_wrapper (fcinfo=, isgt=false, iseq=true) at ../src/backend/utils/adt/selfuncs.c:1459 [17:28:17.646] vardata = {var = 0x83e995f08, rel = 0x83e996328, statsTuple = 0x83cbe08e8, freefunc = 0xa53cb0 , vartype = 23, atttype = 23, atttypmod = -1, isunique = true, acl_ok = true} [17:28:17.646] other = 0x83e9976a8 [17:28:17.646] varonleft = true [17:28:17.646] root = 0x83e9951f8 [17:28:17.646] operator = 523 [17:28:17.646] args = [17:28:17.646] varRelid = [17:28:17.646] collation = 0 [17:28:17.646] constval = 35422028132 [17:28:17.646] consttype = 2341574399 [17:28:17.646] selec = [17:28:17.646] #14 0x0000000000a62e3f in FunctionCall4Coll (flinfo=0x82195fd90, collation=0, arg1=35409973752, arg2=523, arg3=35409977576, arg4=0) at ../src/backend/utils/fmgr/fmgr.c:1213 [17:28:17.646] fcinfodata = {fcinfo = {flinfo = 0x82195fd90, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 4, args = 0x82195fde0}, fcinfo_data = "\220\375\225!\b", '\000' , "\004\000\370Q\231>\b", '\000' , "\v\002\000\000\000\000\000\000\000a\333:\b\000\000\000\350`\231>\b\000\000\000\000Q\231>\b", '\000' , "\353\243\000\000\000\000"} [17:28:17.646] fcinfo = 0x82195fdc0 [17:28:17.646] result = [17:28:17.646] __error = [17:28:17.646] #15 OidFunctionCall4Coll (functionId=, collation=collation@entry=0, arg1=arg1@entry=35409973752, arg2=arg2@entry=523, arg3=arg3@entry=35409977576, arg4=arg4@entry=0) at ../src/backend/utils/fmgr/fmgr.c:1449 [17:28:17.646] flinfo = {fn_addr = 0x9ff140 , fn_oid = 336, fn_nargs = 4, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x83485d000, fn_expr = 0x0} [17:28:17.646] #16 0x000000000080153e in restriction_selectivity (root=root@entry=0x83e9951f8, operatorid=523, args=0x83e9960e8, inputcollid=0, varRelid=varRelid@entry=0) at ../src/backend/optimizer/util/plancat.c:1963 [17:28:17.646] oprrest = 0 [17:28:17.646] result = [17:28:17.646] #17 0x00000000007a85e4 in clause_selectivity_ext (root=root@entry=0x83e9951f8, clause=0x83e996188, clause@entry=0x8348f75b8, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:848 [17:28:17.646] opclause = 0x83e996188 [17:28:17.646] opno = [17:28:17.646] s1 = 0.5 [17:28:17.646] rinfo = 0x8348f75b8 [17:28:17.646] cacheable = true [17:28:17.646] #18 0x00000000007a8005 in clauselist_selectivity_ext (root=0x83e9951f8, clauses=0x83e997198, varRelid=varRelid@entry=0, jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0, use_extended_stats=) at ../src/backend/optimizer/path/clausesel.c:183 [17:28:17.646] clause = 0x8348f75b8 [17:28:17.646] s2 = [17:28:17.646] rinfo = [17:28:17.646] l__state = {l = 0x83e997198, i = 1} [17:28:17.646] estimatedclauses = 0x0 [17:28:17.646] rqlist = 0x83e997658 [17:28:17.646] s1 = 1 [17:28:17.646] rel = [17:28:17.646] listidx = 1 [17:28:17.646] l = [17:28:17.646] #19 0x00000000007a7ea0 in clauselist_selectivity (root=0x18d18, clauses=0x6, varRelid=varRelid@entry=0, jointype=727241722, jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0) at ../src/backend/optimizer/path/clausesel.c:106 [17:28:17.646] No locals. [17:28:17.646] #20 0x00000000007afc44 in set_baserel_size_estimates (root=0x18d18, root@entry=0x83e9951f8, rel=rel@entry=0x83e996328) at ../src/backend/optimizer/path/costsize.c:5286 [17:28:17.646] nrows = [17:28:17.646] #21 0x00000000007a6921 in set_plain_rel_size (root=0x83e9951f8, rel=0x83e996328, rte=0x83485ea18) at ../src/backend/optimizer/path/allpaths.c:581 [17:28:17.646] No locals. [17:28:17.646] #22 set_rel_size (root=root@entry=0x83e9951f8, rel=rel@entry=0x83e996328, rti=rti@entry=1, rte=rte@entry=0x83485ea18) at ../src/backend/optimizer/path/allpaths.c:411 [17:28:17.646] No locals. [17:28:17.646] #23 0x00000000007a3671 in set_base_rel_sizes (root=0x83e9951f8) at ../src/backend/optimizer/path/allpaths.c:322 [17:28:17.646] rel = 0x83e996328 [17:28:17.646] rte = 0x83485ea18 [17:28:17.646] rti = 1 [17:28:17.646] #24 make_one_rel (root=root@entry=0x83e9951f8, joinlist=joinlist@entry=0x83e9970a8) at ../src/backend/optimizer/path/allpaths.c:183 [17:28:17.646] total_pages = [17:28:17.646] rti = [17:28:17.646] rel = [17:28:17.646] #25 0x00000000007d3e44 in query_planner (root=root@entry=0x83e9951f8, qp_callback=, qp_extra=qp_extra@entry=0x821960150) at ../src/backend/optimizer/plan/planmain.c:280 [17:28:17.646] parse = 0x83e995608 [17:28:17.646] final_rel = [17:28:17.646] joinlist = 0x83e9970a8 [17:28:17.646] #26 0x00000000007d6e5b in grouping_planner (root=root@entry=0x83e9951f8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1520 [17:28:17.646] sort_input_targets = 0x8348f7c77 [17:28:17.646] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [17:28:17.646] activeWindows = 0x0 [17:28:17.646] grouping_target = [17:28:17.646] scanjoin_target = [17:28:17.646] sort_input_target_parallel_safe = [17:28:17.646] sort_input_targets_contain_srfs = 0x7f3da0 [17:28:17.646] wflists = 0x0 [17:28:17.646] gset_data = 0x0 [17:28:17.646] have_grouping = [17:28:17.646] grouping_targets = 0x83e9962a8 [17:28:17.646] scanjoin_targets = 0x79aaf1 [17:28:17.646] sort_input_target = [17:28:17.646] grouping_target_parallel_safe = [17:28:17.646] scanjoin_target_parallel_safe = [17:28:17.646] grouping_targets_contain_srfs = 0x83e9962a8 [17:28:17.646] scanjoin_targets_contain_srfs = 0x0 [17:28:17.646] scanjoin_target_same_exprs = [17:28:17.646] final_targets = 0x0 [17:28:17.646] final_targets_contain_srfs = 0x8219602b0 [17:28:17.646] extra = {limit_needed = 241, limit_tuples = 1.1857575500189917e-321, count_est = 35409977096, offset_est = 35409977576} [17:28:17.646] parse = 0x83e995608 [17:28:17.646] offset_est = 0 [17:28:17.646] count_est = 0 [17:28:17.646] limit_tuples = -1 [17:28:17.646] have_postponed_srfs = false [17:28:17.646] current_rel = [17:28:17.646] final_target = [17:28:17.646] final_target_parallel_safe = [17:28:17.646] final_rel = [17:28:17.646] lc = [17:28:17.646] #27 0x00000000007d54f9 in subquery_planner (glob=glob@entry=0x8348f74a8, parse=parse@entry=0x83e995608, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1089 [17:28:17.646] root = 0x83e9951f8 [17:28:17.646] hasOuterJoins = false [17:28:17.646] hasResultRTEs = false [17:28:17.646] l = [17:28:17.646] newWithCheckOptions = [17:28:17.646] newHaving = [17:28:17.646] final_rel = [17:28:17.646] #28 0x00000000007d4028 in standard_planner (parse=parse@entry=0x83e995608, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:415 [17:28:17.646] glob = 0x8348f74a8 [17:28:17.646] tuple_fraction = [17:28:17.646] root = [17:28:17.646] final_rel = [17:28:17.646] best_path = [17:28:17.646] top_plan = [17:28:17.646] lp = [17:28:17.646] lr = [17:28:17.646] result = [17:28:17.646] #29 0x0000000836fa76cf in pgss_planner (parse=0x83e995608, query_string=0x83485d100 "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:28:17.646] _local_sigjmp_buf = {{_sjb = {35282122055, 12138280, 34923217992, 34923218448, 0, 12145053, 12138272, 34923218832, 34923217791, 11574246, 8, 34359738368}}} [17:28:17.646] _save_exception_stack = 0x821960790 [17:28:17.646] _save_context_stack = 0x0 [17:28:17.646] _do_rethrow = false [17:28:17.646] result = [17:28:17.646] #30 0x00000000008fd834 in pg_plan_query (querytree=querytree@entry=0x83e995608, query_string=query_string@entry=0x83485d100 "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:28:17.646] plan = [17:28:17.646] #31 0x00000000008fd932 in pg_plan_queries (querytrees=0x83e995de8, query_string=query_string@entry=0x83485d100 "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:28:17.646] query = 0x83e995608 [17:28:17.646] stmt = [17:28:17.646] query_list__state = {l = 0x83e995de8, i = 0} [17:28:17.646] stmt_list = 0x0 [17:28:17.646] query_list = [17:28:17.646] #32 0x0000000000901da0 in exec_simple_query (query_string=query_string@entry=0x83485d100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;") at ../src/backend/tcop/postgres.c:1203 [17:28:17.646] cmdtaglen = 6 [17:28:17.646] snapshot_set = [17:28:17.646] per_parsetree_context = 0x0 [17:28:17.646] plantree_list = [17:28:17.646] qc = {commandTag = 563480320, nprocessed = 35086965423} [17:28:17.646] format = 8 [17:28:17.646] parsetree = 0x83485e650 [17:28:17.646] commandTag = CMDTAG_DELETE [17:28:17.646] cmdtagname = [17:28:17.646] querytree_list = 0x0 [17:28:17.646] portal = [17:28:17.646] receiver = [17:28:17.646] parsetree_item__state = {l = 0x83485e9c8, i = 0} [17:28:17.646] msec_str = "\000\a\226!\b\000\000\000\257\232X+\b\000\000\000|\243\324f\000\000\000\0007\252X7\330", [17:28:17.646] dest = DestRemote [17:28:17.646] was_logged = [17:28:17.646] oldcontext = 0x83491a000 [17:28:17.646] parsetree_list = 0x83485e9c8 [17:28:17.646] use_implicit_block = false [17:28:17.646] parsetree_item = 0x83485e9e0 [17:28:17.646] save_log_statement_stats = [17:28:17.646] #33 0x00000000008ffc00 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [17:28:17.646] query_string = 0x83485d100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;" [17:28:17.646] input_message = {data = 0x83485d100 "DELETE FROM transition_table_level1\n WHERE level1_no BETWEEN 100000000 AND 100000010;", len = 87, maxlen = 1024, cursor = 87} [17:28:17.646] firstchar = [17:28:17.646] local_sigjmp_buf = {{_sjb = {9433238, 34923218832, 34923218792, 34923219376, 12147016, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [17:28:17.646] send_ready_for_query = false [17:28:17.646] idle_in_transaction_timeout_enabled = false [17:28:17.646] idle_session_timeout_enabled = false [17:28:17.646] #34 0x00000000008fa3d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [17:28:17.646] bsdata = [17:28:17.646] #35 0x00000000008545b7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8219614d4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821961410) at ../src/backend/postmaster/launch_backend.c:274 [17:28:17.646] pid = [17:28:17.646] #36 0x0000000000858978 in BackendStartup (client_sock=0x821961410) at ../src/backend/postmaster/postmaster.c:3414 [17:28:17.646] startup_data = {canAcceptConnections = CAC_OK} [17:28:17.646] bn = 0x834869358 [17:28:17.646] pid = [17:28:17.646] __error = [17:28:17.646] save_errno = [17:28:17.646] __error = [17:28:17.646] __error = [17:28:17.646] #37 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [17:28:17.646] 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 = " ܅4\b", '\000' , "p\024\226!\b\000\000\000h5\263*\b\000\000\000\v\000\000\000\000\000\000\000^\277\263*\b", '\000' , "\260\024\226!\b\000\000\000dC\205\000\000\000\000\000\300\024\226!\b", '\000' }, salen = 16}} [17:28:17.646] i = 0 [17:28:17.646] now = [17:28:17.646] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 726867074, events = 8, fd = 0, user_data = 0x8219613c0}, {pos = 881612248, events = 8, fd = 563483216, user_data = 0x0}, {pos = 816657162, events = 13482, fd = 726034336, user_data = 0x82b477d78}, {pos = 563482312, events = 8, fd = 563482432, user_data = 0x821960ec8}, {pos = 816657162, events = 13482, fd = 726012808, user_data = 0x82b477d78}, {pos = 563482360, events = 8, fd = 563482480, user_data = 0x821960ef8}, {pos = 726073748, events = 8, fd = 565507080, user_data = 0x82b470194}, {pos = 563482464, events = 8, fd = 816636986, user_data = 0x821960f00}, {pos = 716379152, events = 8, fd = 727896112, user_data = 0x34aa30ad330a}, {pos = 725981272, events = 8, fd = 726105464, user_data = 0x821960f68}, {pos = 563482592, events = 8, fd = 563482472, user_data = 0x82b46ed0c}, {pos = 565507080, events = 8, fd = 726068492, user_data = 0x821960fd0}, {pos = 816636986, events = 13482, fd = 563482616, user_data = 0x8219611c8}, {pos = 563482592, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821b55038}, {pos = 1, events = 299360597, fd = 565507080, user_data = 0x82b461388}, {pos = 565528520, events = 8, fd = 0, user_data = 0x0}, {pos = 563482728, events = 8, fd = 563483192, user_data = 0x821961050}, {pos = 816655522, events = 13482, fd = 2699824, user_data = 0x6d68b}, {pos = 2090263927, events = 299360597, fd = 565530680, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821961338}, {pos = 565507080, events = 3, fd = 563483264, user_data = 0x821b54828}, {pos = 656, events = 0, fd = 563483192, user_data = 0x821961068}, {pos = 563482832, events = 8, fd = 816655131, user_data = 0x821961200}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 565530680, events = 8, fd = 1, user_data = 0x821b4f408}, {pos = 725981272, events = 8, fd = 563483448, user_data = 0x821961280}, {pos = 563482848, events = 8, fd = 0, user_data = 0x821b48008}, {pos = 33, events = 0, fd = 563483248, user_data = 0x34aa30accae7}, {pos = 565477384, events = 8, fd = 565478408, user_data = 0x821b48808}, {pos = 565480456, events = 8, fd = 565493768, user_data = 0x821b4c408}, {pos = 565495816, events = 8, fd = 565496840, user_data = 0x821b4d008}, {pos = 565498888, events = 8, fd = 565499912, user_data = 0x821b4dc08}, {pos = 565501960, events = 8, fd = 565502984, user_data = 0x821b4e808}, {pos = 565505032, events = 8, fd = 565506056, user_data = 0x821b4f408}, {pos = 565508104, events = 8, fd = 565509128, user_data = 0x821b50008}, {pos = 565511176, events = 8, fd = 565512200, user_data = 0x821b50c08}, {pos = 565514248, events = 8, fd = 565515272, user_data = 0x821b51808}, {pos = 565517320, events = 8, fd = 565522440, user_data = 0x821b53408}, {pos = 565524488, events = 8, fd = 565525512, user_data = 0x821b56408}, {pos = 843071000, events = 0, fd = 565477384, user_data = 0x293230}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821b55038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 563483448, events = 8, fd = 563482848, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 565530680, user_data = 0x1}, {pos = 565477384, events = 8, fd = 314, user_data = 0x821961320}, {pos = 816629231, events = 13482, fd = 2699824, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565530680, user_data = 0x1}, {pos = 565507080, events = 8, fd = 881119232, user_data = 0x1}, {pos = 881119636, events = 8, fd = 0, user_data = 0x8219612f0}, {pos = 716420460, events = 8, fd = 1, user_data = 0x83484d000}, {pos = 563483424, events = 8, fd = 716416770, user_data = 0x82b58b170 }, {pos = 12072056, events = 0, fd = 727232880, user_data = 0x821b4f408}, {pos = 563483648, events = 8, fd = 816628702, user_data = 0x83486b800}, {pos = 1, events = 0, fd = 816628318, user_data = 0x821b48008}, {pos = 563483432, events = 8, fd = 563483648, user_data = 0x1c38}, {pos = 881187872, events = 8, fd = 816707984, user_data = 0x0}, {pos = 563479423, events = 8, fd = 7886519, user_data = 0x8219613b0}, {pos = 716379152, events = 8, fd = 727896112, user_data = 0x82b62f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8219613e0}, {pos = 716422045, events = 8, fd = 881119232, user_data = 0x305c}, {pos = 563483712, events = 8, fd = 716388602, user_data = 0x0}, {pos = 0, events = 0, fd = 528438443, user_data = 0x0}} [17:28:17.646] last_touch_time = 1725211466 [17:28:17.646] last_lockfile_recheck_time = 1725211466 [17:28:17.646] nevents = 1 [17:28:17.646] #38 0x0000000000856795 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821961a28) at ../src/backend/postmaster/postmaster.c:1346 [17:28:17.646] userDoption = [17:28:17.646] listen_addr_saved = [17:28:17.646] output_config_variable = [17:28:17.646] opt = [17:28:17.646] status = [17:28:17.646] #39 0x00000000007923bc in main (argc=4, argv=0x821961a28) at ../src/backend/main/main.c:197 [17:28:17.646] do_check_root =