[01:32:51.194] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [01:32:51.525] dumping /tmp/cores/postgres.26035.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:32:51.669] [New LWP 101844] [01:32:51.759] Core was generated by `postgres: cascade: startup waiting for 000000020000000000000004'. [01:32:51.759] Program terminated with signal SIGQUIT, Quit. [01:32:51.759] Sent by thr_kill() from pid 26035 and user 1002. [01:32:51.759] #0 0x000000082aee575a in _sigprocmask () from /lib/libc.so.7 [01:32:51.801] [01:32:51.801] Thread 1 (LWP 101844): [01:32:51.801] #0 0x000000082aee575a in _sigprocmask () from /lib/libc.so.7 [01:32:51.801] No symbol table info available. [01:32:51.801] #1 0x000000082af22a7f in _system () from /lib/libc.so.7 [01:32:51.801] No symbol table info available. [01:32:51.801] #2 0x0000000829c168a3 in ?? () from /lib/libthr.so.3 [01:32:51.801] No symbol table info available. [01:32:51.801] #3 0x0000000000688ee7 in RestoreArchivedFile (path=path@entry=0x820d8b1e0 "`\262\330 \b", xlogfname=xlogfname@entry=0x820d8b630 "00000002", '0' , "4", recovername=, expectedSize=16777216, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [01:32:51.801] xlogpath = "pg_wal/RECOVERYXLOG\000RY\000\220\020\233\371*\b\000\000\000\005\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\000\262\330 \b\000\000\000\001\000\000\000\000\000\000\000\360\255\330 \b\000\000\000\027\376\345*\b", '\000' , "`\300\301\000\000\000\000\000002", '\000' , "002\000\000\000\000\00000000000", '\000' , "\260\255\330 \b\000\000\000\315\362\311Ea>\000\000\250^\333*\b\000\000\000"... [01:32:51.801] lastRestartPointFname = "00000001", '0' , "2", '\000' , "嫲\000\000\000\000\0008\260\330 \b\000\000\000\376\377\377\377\000\000\000\000ĩ\330 \b\000\000\000\377\377\377\377\000\000\000\000\210\260\330 \b", '\000' , "p\251\330 \b\000\000\000&\257\262", '\000' , "嫲\000\000\000\000\000\210\260\330 \b\000\000\000\376\377\377\377\000\000\000\000\002", '\000' , "嫲\000\000\000\000"... [01:32:51.801] stat_buf = {st_dev = 34910811616, st_ino = 34910811696, st_nlink = 12489952, st_mode = 2, st_padding0 = 0, st_uid = 0, st_gid = 551072208, st_padding1 = 8, st_rdev = 35079454231, st_atim = {tv_sec = 34910810464, tv_nsec = 12697696}, st_mtim = {tv_sec = 875573296, tv_nsec = 0}, st_ctim = {tv_sec = 3420208, tv_nsec = 3472328296227680304}, st_birthtim = {tv_sec = 206158430224, tv_nsec = 34910811664}, st_size = 34910810688, st_blocks = 11769155, st_blksize = 1298088780, st_flags = 1095979845, st_gen = 6731306431112, st_spare = {35078753568, 6731306411016, 34910810616, 34910811064, 34910810592, 68587503610962, 2627925, 134090501, 206158430240, 34910810592}} [01:32:51.801] restartRedoPtr = 33554472 [01:32:51.801] restartTli = 1 [01:32:51.801] restartSegNo = [01:32:51.801] xlogRestoreCmd = 0x61f4178a928 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/data/t_025_stuck_on_old_timeline_primary_data/archives/00000002", '0' , "4\" \"pg_wal/RECOVERYXLOG\"" [01:32:51.801] rc = [01:32:51.801] #4 0x00000000006945f0 in XLogFileRead (segno=segno@entry=4, tli=tli@entry=2, source=source@entry=XLOG_FROM_ARCHIVE, notfoundOk=true) at ../src/backend/access/transam/xlogrecovery.c:4232 [01:32:51.801] xlogfname = "00000002", '0' , "4\000I\343\261&\215\024\220\000\000\000\000\000\000\000\000\220\266\330 \b\000\000\000\200\266\330 \b\000\000\000\242\t\356*\b\000\000" [01:32:51.801] activitymsg = "waiting for 00000002", '0' , "4\000\006\000\000x\f\000\000\000\000\000\000\220\266\330 \b\000\000\000\003\000\000\000\000\000\000\000`\266\330 \b\000\000\000U\n\356*\b\000\000" [01:32:51.801] path = "`\262\330 \b\000\000\000\313\352\311Ea>\000\000\030\000\000\0000", '\000' , "P\000!A\037\006\000\000\001\000\000\000\000\000\000\000\b\244 A\037\006\000\000 M\333*\b\000\000\000\270\264\330 \b\000\000\000\b\264\330 \b\000\000\000p\262\330 \b", '\000' , "\b0 A\037\006\000\000 \000\000\000\000\000\000\000\360\263\330 \b\000\000\000w\214\311Ea>\000\000\b0 A\037\006\000\000\b4 A\037\006\000\000\b8 A\037\006\000\000\b< A\037\006\000\000\bp A\037\006\000\000\bt A\037\006\000\000\bx A\037\006\000\000"... [01:32:51.801] fd = [01:32:51.801] #5 0x00000000006902bc in XLogFileReadAnyTLI (segno=4, source=XLOG_FROM_ANY) at ../src/backend/access/transam/xlogrecovery.c:4360 [01:32:51.801] hent = [01:32:51.801] tli = 2 [01:32:51.801] cell__state = {l = 0x61f4175f918, i = 0} [01:32:51.801] path = "\000\000\000\004\000\000\000\0000000002", '0' , "3\000\200b%A\037\006\000\000\000\000\000\000\000\000\000\000\200\267\330 \b\000\000\000\032H\362*\b\000\000\000\200\000\000\002\000\000\000\000\270\271uA\037\006\000\000\002\000\000\000\000\000\000\000\200\000\000\002", '\000' , "\002", '\000' , "\001\000\000\000\343}i\000\000\000\000\000\000\000\000\002", '\000' , "\374\006\340A\037\006\000\000\343}i\000\000\000\000\000\020\a\340A\037\006\000\000\000\000\b\000\000\000\000\000\374\006\340A\037\006\000\000\000\370\330 \b\000\000\000\020\a\340A\037\006", '\000' ... [01:32:51.801] tles = 0x61f4175f918 [01:32:51.801] cell = [01:32:51.801] fd = [01:32:51.801] cell__state = [01:32:51.801] hent = [01:32:51.801] tli = [01:32:51.801] beginseg = [01:32:51.801] __error = [01:32:51.801] __error = [01:32:51.801] #6 WaitForWALToBecomeAvailable (RecPtr=67202168, tliRecPtr=67202144, replayTLI=2, replayLSN=67202144, randAccess=, fetching_ckpt=, nonblocking=) at ../src/backend/access/transam/xlogrecovery.c:3794 [01:32:51.801] startWalReceiver = [01:32:51.801] streaming_reply_sent = true [01:32:51.801] now = [01:32:51.801] startWalReceiver = [01:32:51.801] oldSource = [01:32:51.801] wait_time = [01:32:51.801] __error = [01:32:51.801] __error = [01:32:51.801] __error = [01:32:51.801] havedata = [01:32:51.801] ptr = [01:32:51.801] tli = [01:32:51.801] __error = [01:32:51.801] latestChunkStart = [01:32:51.801] __error = [01:32:51.801] #7 XLogPageRead (xlogreader=0x61f4161d0a0, targetPagePtr=67198976, reqLen=3192, targetRecPtr=67202144, readBuf=0x61f4175b9b8 "\030\321\005") at ../src/backend/access/transam/xlogrecovery.c:3364 [01:32:51.801] private = 0x61f4161d080 [01:32:51.801] emode = 15 [01:32:51.801] targetSegNo = 4 [01:32:51.801] targetPageOff = 90112 [01:32:51.801] io_start = [01:32:51.801] r = [01:32:51.801] #8 0x000000000069739a in ReadPageInternal (state=0x61f4161d0a0, pageptr=pageptr@entry=67198976, reqLen=3192) at ../src/backend/access/transam/xlogreader.c:1071 [01:32:51.801] targetSegNo = 4 [01:32:51.801] targetPageOff = 90112 [01:32:51.801] readLen = [01:32:51.801] hdr = [01:32:51.801] err = [01:32:51.801] #9 0x000000000069614b in XLogDecodeNextRecord (state=0x61f4161d0a0, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:598 [01:32:51.801] errormsg = 0x2f200000300 [01:32:51.801] randAccess = [01:32:51.801] decoded = 0x0 [01:32:51.801] RecPtr = 67202144 [01:32:51.801] assembled = false [01:32:51.801] targetPagePtr = 67198976 [01:32:51.801] targetRecOff = 3168 [01:32:51.801] readOff = [01:32:51.801] pageHeaderSize = [01:32:51.801] record = [01:32:51.801] gotheader = [01:32:51.801] len = [01:32:51.801] total_len = [01:32:51.801] buffer = [01:32:51.801] gotlen = [01:32:51.801] pageHeader = [01:32:51.801] contdata = [01:32:51.801] save_copy = [01:32:51.801] #10 XLogReadAhead (state=0x61f4161d0a0, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:984 [01:32:51.801] result = [01:32:51.801] #11 0x000000000068d818 in XLogPrefetcherNextBlock (pgsr_private=6731310685904, lsn=0x61f4178a388) at ../src/backend/access/transam/xlogprefetcher.c:490 [01:32:51.801] nonblocking = false [01:32:51.801] record = 0x0 [01:32:51.801] prefetcher = 0x61f4161ded0 [01:32:51.801] reader = 0x61f4161d0a0 [01:32:51.801] replaying_lsn = 67201736 [01:32:51.801] #12 0x000000000068d485 in lrq_prefetch (lrq=0x61f4178a118) at ../src/backend/access/transam/xlogprefetcher.c:252 [01:32:51.801] No locals. [01:32:51.801] #13 lrq_complete_lsn (lrq=0x61f4178a118, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [01:32:51.801] No locals. [01:32:51.801] #14 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x61f4161ded0, errmsg=errmsg@entry=0x820d8fd60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [01:32:51.801] replayed_up_to = [01:32:51.801] record = [01:32:51.801] #15 0x000000000069101a in ReadRecord (xlogprefetcher=0x61f4161ded0, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=2) at ../src/backend/access/transam/xlogrecovery.c:3163 [01:32:51.801] errormsg = 0x0 [01:32:51.801] xlogreader = 0x61f4161d0a0 [01:32:51.801] private = [01:32:51.801] record = [01:32:51.801] #16 0x0000000000691919 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1841 [01:32:51.801] ru0 = {tv = {tv_sec = 1755221098, tv_usec = 195954}, ru = {ru_utime = {tv_sec = 0, tv_usec = 1179}, ru_stime = {tv_sec = 0, tv_usec = 0}, ru_maxrss = 27720, ru_ixrss = 6168, ru_idrss = 376, ru_isrss = 128, ru_minflt = 158, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 0, ru_msgsnd = 0, ru_msgrcv = 0, ru_nsignals = 0, ru_nvcsw = 12, ru_nivcsw = 3}} [01:32:51.801] xtime = [01:32:51.801] reachedRecoveryTarget = false [01:32:51.801] replayTLI = 2 [01:32:51.801] record = [01:32:51.801] #17 0x0000000000682083 in StartupXLOG () at ../src/backend/access/transam/xlog.c:6011 [01:32:51.801] wasShutdown = false [01:32:51.801] haveTblspcMap = false [01:32:51.801] haveBackupLabel = true [01:32:51.801] timebuf = "2025-08-15 01:24:57 UTC", '\000' [01:32:51.801] promoted = false [01:32:51.801] didCrash = [01:32:51.801] checkPoint = {redo = 33554472, ThisTimeLineID = 1, PrevTimeLineID = , fullPageWrites = true, wal_level = , nextXid = {value = }, nextOid = , nextMulti = , nextMultiOffset = , oldestXid = , oldestXidDB = , oldestMulti = , oldestMultiDB = , time = , oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 754} [01:32:51.801] oldestActiveXID = [01:32:51.801] performedWalRecovery = [01:32:51.801] endOfRecoveryInfo = [01:32:51.801] EndOfLog = [01:32:51.801] EndOfLogTLI = [01:32:51.801] abortedRecPtr = [01:32:51.801] missingContrecPtr = [01:32:51.801] newTLI = [01:32:51.801] Insert = [01:32:51.801] #18 0x00000000008c757b in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [01:32:51.801] No locals. [01:32:51.801] #19 0x00000000008c100b in postmaster_child_launch (child_type=child_type@entry=B_STARTUP, child_slot=89, startup_data=startup_data@entry=0x0, startup_data_len=startup_data_len@entry=0, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:290 [01:32:51.801] pid = [01:32:51.801] #20 0x00000000008c3de7 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3980 [01:32:51.801] pmchild = 0x0 [01:32:51.801] pid = [01:32:51.801] #21 0x00000000008c37e2 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820d949f0) at ../src/backend/postmaster/postmaster.c:1393 [01:32:51.801] userDoption = [01:32:51.801] listen_addr_saved = false [01:32:51.801] output_config_variable = [01:32:51.801] opt = [01:32:51.801] status = [01:32:51.801] #22 0x00000000007f5630 in main (argc=4, argv=0x820d949f0) at ../src/backend/main/main.c:231 [01:32:51.801] do_check_root = [01:32:51.801] dispatch_option = DISPATCH_POSTMASTER [01:32:51.809] [01:32:51.809] [01:32:51.809] [01:32:51.865] dumping /tmp/cores/postgres.82967.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [01:32:51.991] [New LWP 101808] [01:32:52.059] Core was generated by `postgres: postgres regression [local] EXPLAIN'. [01:32:52.059] Program terminated with signal SIGABRT, Aborted. [01:32:52.059] Sent by thr_kill() from pid 82967 and user 1002. [01:32:52.059] #0 0x000000082e1e41ba in thr_kill () from /lib/libc.so.7 [01:32:52.130] [01:32:52.130] Thread 1 (LWP 101808): [01:32:52.130] #0 0x000000082e1e41ba in thr_kill () from /lib/libc.so.7 [01:32:52.130] No symbol table info available. [01:32:52.130] #1 0x000000082e15d5d4 in raise () from /lib/libc.so.7 [01:32:52.130] No symbol table info available. [01:32:52.130] #2 0x000000082e210b59 in abort () from /lib/libc.so.7 [01:32:52.130] No symbol table info available. [01:32:52.130] #3 0x0000000000ada325 in ExceptionalCondition (conditionName=0x3683d9 "n >= 0 && n < list->length", fileName=, lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [01:32:52.130] No locals. [01:32:52.130] #4 0x000000000085dab6 in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [01:32:52.130] No locals. [01:32:52.130] #5 list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [01:32:52.130] No locals. [01:32:52.130] #6 0x000000000085da0b in var_is_nonnullable (root=0x2b35b2c96478, var=var@entry=0x2b35b34d9900, use_rel_info=false) at ../src/backend/optimizer/util/clauses.c:4235 [01:32:52.130] rte = [01:32:52.130] notnullattnums = 0x0 [01:32:52.130] #7 0x000000000085d37d in eval_const_expressions_mutator (node=0x2b35b34d9880, context=) at ../src/backend/optimizer/util/clauses.c:3556 [01:32:52.130] varg = 0x2b35b34d9900 [01:32:52.130] result = [01:32:52.130] ntest = 0x2b35b34d9880 [01:32:52.130] arg = 0x2b35b34d9900 [01:32:52.130] newntest = [01:32:52.130] #8 0x000000000085fa68 in simplify_and_arguments (args=, context=context@entry=0x8219c6728, haveNull=haveNull@entry=0x8219c66d0, forceFalse=forceFalse@entry=0x8219c66e4) at ../src/backend/optimizer/util/clauses.c:3964 [01:32:52.130] arg = 0x2b35b34d9880 [01:32:52.130] newargs = 0x2b35b34d9a90 [01:32:52.130] unprocessed_args = 0x0 [01:32:52.130] #9 0x000000000085d283 in eval_const_expressions_mutator (node=0x2b35b34d96c0, context=) at ../src/backend/optimizer/util/clauses.c:2877 [01:32:52.130] haveNull = false [01:32:52.130] forceFalse = false [01:32:52.130] newargs = [01:32:52.130] expr = 0x2b35b34d96c0 [01:32:52.130] #10 0x000000000085c2bb in eval_const_expressions (root=root@entry=0x2b35b2c96478, node=0x0, node@entry=0x2b35b34d96c0) at ../src/backend/optimizer/util/clauses.c:2272 [01:32:52.130] context = {boundParams = , root = 0x2b35b2c96478, active_fns = 0x0, case_val = 0x0, estimate = false} [01:32:52.130] #11 0x000000000084ccbf in convert_EXISTS_sublink_to_join (root=0x2b35b2c96478, sublink=, under_not=false, available_rels=available_rels@entry=0x2b35b2c96a58) at ../src/backend/optimizer/plan/subselect.c:1541 [01:32:52.130] je = [01:32:52.130] lc__state = {l = 0x2b35b34d9670, i = 0} [01:32:52.130] subroot = {type = T_Invalid, parse = 0xae9c19 , glob = 0x2d9a28, query_level = 0, parent_root = 0x2b35b2d6f100, plan_params = 0x2b35b2d70a48, outer_params = 0x200c1c640, simple_rel_array = 0x0, simple_rel_array_size = -1294536448, simple_rte_array = 0x2b35b2d6f190, append_rel_array = 0x200000014, all_baserels = 0x0, outer_join_rels = 0x637ad655219c68b0, all_query_rels = 0x2b35b2d6f190, join_rel_list = 0x14, join_rel_hash = 0x2b35b2d70a48, join_rel_level = 0x8219c68d0, join_cur_level = 1045849784, init_plans = 0x1, cte_plan_ids = 0x1, multiexpr_params = 0x8219c6840, join_domains = 0xabdbb8 , eq_classes = 0xc1c6b0 , ec_merging_done = false, canon_pathkeys = 0x2b35b2c968d8, left_join_clauses = 0x0, right_join_clauses = 0x8219c6860, full_join_clauses = 0x53, join_info_list = 0x8219c68c0, last_rinfo_serial = 11420980, all_result_relids = 0x6181b0 , leaf_result_relids = 0xae9eae , append_rel_list = 0x2, row_identity_vars = 0x0, rowMarks = 0x2b35b2c30c00, placeholder_list = 0x2b35b2dcccd0, placeholder_array = 0x2b35b2dcd1e8, placeholder_array_size = 563898640, fkey_list = 0x2b35b2d73100, query_pathkeys = 0x53, group_pathkeys = 0x1219c6900, num_groupby_pathkeys = 0, window_pathkeys = 0x33052d95219c68e0, distinct_pathkeys = 0x0, sort_pathkeys = 0x4, setop_pathkeys = 0x2b35b2dccc88, part_schemes = 0x2b35b2c968d8, initial_rels = 0x0, upper_rels = {0xa9ca, 0x0, 0x8219c6a90, 0xacc290 , 0x3000100000000, 0x3b600000000, 0xa3f9f0 , 0x10002000000b8}, upper_targets = {0x2, 0x0, 0x2b35b2c30c00, 0x0, 0xa9ca, 0x5000500000000, 0x3b600000000, 0x9f2f40 }, processed_groupClause = 0x1000200000092, processed_distinctClause = 0x2, processed_tlist = 0x0, update_colnos = 0x2b35b2c30c00, grouping_map = 0x0, minmax_aggs = 0x0, planner_cxt = 0x3000900000000, total_table_pages = 5.6537043501316985e-317, tuple_fraction = 5.3094033413173715e-317, limit_tuples = 1.3907136014837293e-309, qual_security_level = 563898882, hasJoinRTEs = 8, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 25, placeholdersFrozen = 156, hasRecursion = 174, group_rtindex = 0, agginfos = 0x2b35b2c30c00, aggtransinfos = 0x0, numOrderedAggs = -1294536448, hasNonPartialAggs = 53, hasNonSerialAggs = 43, wt_param_id = 563899108, non_recursive_path = 0x0, curOuterRels = 0x8219c6a78, curOuterParams = 0x2b35b34a0100, isAltSubplan = 0x2b35b2d6f190, isUsedSubplan = 0x100000014, join_search_private = 0x0, partColsUpdated = 2, partPruneInfos = 0x2b35b34a0190} [01:32:52.130] parse = 0x2b35b34c6d48 [01:32:52.130] subselect = 0x2b35b34390c8 [01:32:52.130] newWhere = 0x0 [01:32:52.130] all_clauses = 0x2b35b34d9670 [01:32:52.130] upper_reference_exists = false [01:32:52.130] whereClause = 0x2b35b34d96c0 [01:32:52.130] lc = [01:32:52.130] rtoffset = [01:32:52.130] clause_varnos = [01:32:52.130] upper_varnos = [01:32:52.130] varno = [01:32:52.130] result = [01:32:52.130] #12 0x00000000008545c2 in pull_up_sublinks_qual_recurse (root=0x18db0, node=0x6, jtlink1=0x2b35b2c6be20, available_rels1=0x2b35b2c96a58, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [01:32:52.130] child_rels = 0xb0284f [01:32:52.130] sublink = 0x6 [01:32:52.130] j = [01:32:52.130] #13 0x00000000008513b9 in pull_up_sublinks_jointree_recurse (root=root@entry=0x2b35b2c96478, jtnode=, relids=relids@entry=0x8219c6b80) at ../src/backend/optimizer/prep/prepjointree.c:787 [01:32:52.130] leftrelids = 0x2b35b2c96928 [01:32:52.130] rightrelids = 0x2b35b2c96a58 [01:32:52.130] jtlink = 0x2b35b2c6be08 [01:32:52.130] j = 0x2b35b2c6be08 [01:32:52.130] #14 0x0000000000851265 in pull_up_sublinks_jointree_recurse (root=root@entry=0x2b35b2c96478, jtnode=0x2b35b34c7d58, relids=relids@entry=0x8219c6bc0) at ../src/backend/optimizer/prep/prepjointree.c:706 [01:32:52.130] childrelids = 0x3 [01:32:52.130] newchild = [01:32:52.130] l__state = {l = 0x2b35b3504440, i = 0} [01:32:52.130] jtlink = 0x3 [01:32:52.130] frelids = 0x0 [01:32:52.130] newf = [01:32:52.130] f = 0x2b35b34c7d58 [01:32:52.130] newfromlist = 0x0 [01:32:52.130] l = 0x82e1e419a [01:32:52.130] #15 0x000000000085119a in pull_up_sublinks (root=0x18db0, root@entry=0x2b35b2c96478) at ../src/backend/optimizer/prep/prepjointree.c:653 [01:32:52.130] relids = 0x2b35b34c7d58 [01:32:52.130] jtnode = [01:32:52.130] #16 0x000000000083cd9a in subquery_planner (glob=glob@entry=0x2b35b34392d8, parse=parse@entry=0x2b35b34c6d48, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:751 [01:32:52.130] root = 0x2b35b2c96478 [01:32:52.130] hasOuterJoins = [01:32:52.130] hasResultRTEs = [01:32:52.130] l = [01:32:52.130] newWithCheckOptions = [01:32:52.130] newHaving = [01:32:52.130] final_rel = [01:32:52.130] #17 0x000000000083c512 in standard_planner (parse=0x2b35b34c6d48, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:436 [01:32:52.130] glob = 0x2b35b34392d8 [01:32:52.130] tuple_fraction = [01:32:52.130] root = [01:32:52.130] final_rel = [01:32:52.130] best_path = [01:32:52.130] top_plan = [01:32:52.130] lp = [01:32:52.130] lr = [01:32:52.130] result = [01:32:52.130] #18 0x000000000083c39e in planner (parse=0x18db0, parse@entry=0x2b35b34c6d48, query_string=0x6 , query_string@entry=0x2b35b2c22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=0, cursorOptions@entry=2048, boundParams=0x82e1e419a , boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:295 [01:32:52.130] result = [01:32:52.130] #19 0x0000000000977874 in pg_plan_query (querytree=querytree@entry=0x2b35b34c6d48, query_string=query_string@entry=0x2b35b2c22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [01:32:52.130] plan = [01:32:52.130] #20 0x0000000000700d1a in standard_ExplainOneQuery (query=0x2b35b34c6d48, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x2b35b3439038, queryString=0x2b35b2c22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [01:32:52.130] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 47509634075784, shared_blks_dirtied = 47509634075784, shared_blks_written = 11544655, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 47509634075784, temp_blks_read = 2, temp_blks_written = 47509641392704, shared_blk_read_time = {ticks = 34923638208}, shared_blk_write_time = {ticks = 6087146}, local_blk_read_time = {ticks = 70368744221130}, local_blk_write_time = {ticks = 47509641392624}, temp_blk_read_time = {ticks = 34923638384}, temp_blk_write_time = {ticks = 9531722}} [01:32:52.130] bufusage = {shared_blks_hit = 280, shared_blks_read = 602289656, shared_blks_dirtied = 4294967288, shared_blks_written = 47509641644545, local_blks_hit = 47509641644680, local_blks_read = 0, local_blks_dirtied = 34923638272, local_blks_written = 7325316, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 47509632388648}, local_blk_read_time = {ticks = 47509641391432}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34923638352}, temp_blk_write_time = {ticks = 11582912}} [01:32:52.130] mem_counters = {nblocks = 34923638128, freechunks = 11544655, totalspace = 240, freespace = 47509634075784} [01:32:52.130] planduration = {ticks = 8355684} [01:32:52.130] planner_ctx = 0x0 [01:32:52.130] saved_ctx = [01:32:52.130] planstart = {ticks = -280602289656} [01:32:52.130] plan = [01:32:52.130] #21 0x00000000007009d2 in ExplainOneQuery (query=0x18db0, cursorOptions=2048, into=0x0, es=0x2b35b3439038, pstate=0x2b35b2c30eb8, params=0x0) at ../src/backend/commands/explain.c:309 [01:32:52.130] No locals. [01:32:52.130] #22 ExplainQuery (pstate=pstate@entry=0x2b35b2c30eb8, stmt=stmt@entry=0x2b35b34c6d18, params=params@entry=0x0, dest=0x2b35b2c30e28) at ../src/backend/commands/explain.c:223 [01:32:52.130] l__state = {l = , i = 0} [01:32:52.130] l = 0x2b35b2c6bcb0 [01:32:52.130] es = 0x2b35b3439038 [01:32:52.130] jstate = [01:32:52.130] query = [01:32:52.130] rewritten = 0x2b35b2c6bc98 [01:32:52.130] tstate = [01:32:52.130] #23 0x000000000097eae0 in standard_ProcessUtility (pstmt=0x2b35b3504b60, queryString=0x2b35b2c22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x2b35b2c30e28, qc=0x8219c7018) at ../src/backend/tcop/utility.c:866 [01:32:52.130] isAtomicContext = false [01:32:52.130] parsetree = 0x2b35b34c6d18 [01:32:52.130] readonly_flags = [01:32:52.130] pstate = 0x2b35b2c30eb8 [01:32:52.130] isTopLevel = [01:32:52.130] #24 0x000000000097e778 in ProcessUtility (pstmt=0x18db0, queryString=0x6 , readOnlyTree=, context=773734810, params=0x0, queryEnv=0x0, dest=0x2b35b2c30e28, qc=0x8219c7018) at ../src/backend/tcop/utility.c:523 [01:32:52.130] No locals. [01:32:52.130] #25 0x000000000097e2ac in PortalRunUtility (portal=portal@entry=0x2b35b2d78100, pstmt=0x2b35b3504b60, isTopLevel=, setHoldSnapshot=true, dest=dest@entry=0x2b35b2c30e28, qc=qc@entry=0x8219c7018) at ../src/backend/tcop/pquery.c:1153 [01:32:52.130] No locals. [01:32:52.130] #26 0x000000000097d4ea in FillPortalStore (portal=portal@entry=0x2b35b2d78100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [01:32:52.130] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:32:52.130] treceiver = 0x2b35b2c30e28 [01:32:52.130] #27 0x000000000097d224 in PortalRun (portal=portal@entry=0x2b35b2d78100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x2b35b3504cc0, altdest=altdest@entry=0x2b35b3504cc0, qc=qc@entry=0x8219c7150) at ../src/backend/tcop/pquery.c:760 [01:32:52.130] _local_sigjmp_buf = {{_sjb = {9949637, 47509633728768, 34923638856, 34923639104, 34923638864, 12690440, 34923639120, 12617384, 12583807, 0, 47509633696639, 47506633261056}}} [01:32:52.130] _save_exception_stack = 0x8219c7200 [01:32:52.130] _save_context_stack = 0x0 [01:32:52.130] _do_rethrow = false [01:32:52.130] saveTopTransactionResourceOwner = 0x2b35b2d873c8 [01:32:52.130] saveTopTransactionContext = 0x2b35b2de8000 [01:32:52.130] saveActivePortal = 0x0 [01:32:52.130] saveResourceOwner = 0x2b35b2d873c8 [01:32:52.130] savePortalContext = 0x0 [01:32:52.130] saveMemoryContext = 0x2b35b2de8000 [01:32:52.130] result = [01:32:52.130] nprocessed = [01:32:52.130] #28 0x000000000097c089 in exec_simple_query (query_string=query_string@entry=0x2b35b2c22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [01:32:52.130] cmdtaglen = 7 [01:32:52.130] snapshot_set = [01:32:52.130] per_parsetree_context = 0x0 [01:32:52.130] plantree_list = [01:32:52.130] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:32:52.130] format = 0 [01:32:52.130] parsetree = 0x2b35b2d7f548 [01:32:52.130] commandTag = [01:32:52.130] cmdtagname = [01:32:52.130] querytree_list = [01:32:52.130] portal = 0x2b35b2d78100 [01:32:52.130] receiver = 0x2b35b3504cc0 [01:32:52.130] parsetree_item__state = {l = 0x2b35b2d80500, i = 0} [01:32:52.130] msec_str = "\000\000\000\000\b", '\000' , "\240q\234!\b\000\000\000U\n\036.\b\000\000" [01:32:52.130] dest = DestRemote [01:32:52.130] was_logged = [01:32:52.130] oldcontext = 0x2b35b2de8000 [01:32:52.130] parsetree_list = 0x2b35b2d80500 [01:32:52.130] use_implicit_block = false [01:32:52.130] parsetree_item = 0x2b35b2d80518 [01:32:52.130] save_log_statement_stats = [01:32:52.130] #29 0x0000000000979ad5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4763 [01:32:52.130] query_string = 0x2b35b2c22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [01:32:52.130] input_message = {data = 0x2b35b2c22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [01:32:52.130] firstchar = [01:32:52.130] local_sigjmp_buf = {{_sjb = {9932491, 34923639296, 34923639288, 34923639888, 12491620, 12491352, 12699224, 12693156, 895, 0, 0, 34359738369}}} [01:32:52.130] send_ready_for_query = false [01:32:52.130] idle_in_transaction_timeout_enabled = false [01:32:52.130] idle_session_timeout_enabled = false [01:32:52.130] #30 0x0000000000973f79 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [01:32:52.130] bsdata = [01:32:52.130] #31 0x00000000008c100b in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x8219c7eb8, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x8219c7ed0) at ../src/backend/postmaster/launch_backend.c:290 [01:32:52.130] pid = [01:32:52.130] #32 0x00000000008c5978 in BackendStartup (client_sock=0x8219c7ed0) at ../src/backend/postmaster/postmaster.c:3587 [01:32:52.130] startup_data = {canAcceptConnections = CAC_OK, socket_created = 808536451037652, fork_started = } [01:32:52.130] bn = 0x2b35b2d461e8 [01:32:52.130] cac = CAC_OK [01:32:52.130] pid = [01:32:52.130] __error = [01:32:52.130] save_errno = [01:32:52.130] __error = [01:32:52.130] __error = [01:32:52.130] #33 ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [01:32:52.130] 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 = "\r", '\000' , "0\177\234!\b\000\000\000X\306%,\b\000\000\000\032\001\000\000\000\000\000\000\276N&,\b", '\000' , "p\177\234!\b\000\000\000T\r\214\000\000\000\000\000\200\177\234!\b", '\000' }, salen = 16}} [01:32:52.130] i = 0 [01:32:52.130] now = [01:32:52.130] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 773358988, user_data = 0x0}, {pos = 563904128, events = 8, fd = -1295424040, user_data = 0x8219c7d10}, {pos = 0, events = 0, fd = 0, user_data = 0xe7aa262a3075002b}, {pos = 774471168, events = 8, fd = 563902848, user_data = 0x34d9feed72cd}, {pos = 772516792, events = 8, fd = 772591772, user_data = 0x8219c7998}, {pos = 563902992, events = 8, fd = 563902896, user_data = 0x34d9feed72cd}, {pos = 772513648, events = 8, fd = 772591772, user_data = 0x8219c79c8}, {pos = 563903040, events = 8, fd = 772562372, user_data = 0x82e0c5dc4}, {pos = 563902960, events = 8, fd = -17993011, user_data = 0x82e0be410}, {pos = 772591772, events = 8, fd = 563902984, user_data = 0x8219c7a80}, {pos = 772565300, events = 8, fd = 772565300, user_data = 0x2b35b280a408}, {pos = 3, events = 0, fd = 563903088, user_data = 0x34d9feed24fb}, {pos = 563903104, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 563903176, user_data = 0x8219c7c88}, {pos = 563903152, events = 8, fd = -17994670, user_data = 0x29609b}, {pos = -1300172152, events = 11061, fd = 772531216, user_data = 0x2b35b280a408}, {pos = 563903240, events = 8, fd = 563903688, user_data = 0x8219c7af0}, {pos = -17994670, events = 13529, fd = 2735915, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = -1300168624, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x8219c7dc8}, {pos = -1295973024, events = 3, fd = 563903768, user_data = 0x2b35b280fac8}, {pos = 656, events = 0, fd = 563903688, user_data = 0x8219c7b08}, {pos = 563903344, events = 8, fd = -17995061, user_data = 0x8219c7d88}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1300168624, events = 11061, fd = 1, user_data = 0x2b35b280a408}, {pos = 772531216, events = 8, fd = 563903944, user_data = 0x8219c7d18}, {pos = 563903360, events = 8, fd = 0, user_data = 0x2b35b2803008}, {pos = 32, events = 0, fd = 563903744, user_data = 0x34d9feed0c77}, {pos = -1300221944, events = 11061, fd = -1300220920, user_data = 0x2b35b2803808}, {pos = -1300218872, events = 11061, fd = -1300205560, user_data = 0x2b35b2807408}, {pos = -1300203512, events = 11061, fd = -1300202488, user_data = 0x2b35b2808008}, {pos = -1300200440, events = 11061, fd = -1300199416, user_data = 0x2b35b2808c08}, {pos = -1300197368, events = 11061, fd = -1300196344, user_data = 0x2b35b2809808}, {pos = -1300194296, events = 11061, fd = -1300193272, user_data = 0x2b35b280a408}, {pos = -1300191224, events = 11061, fd = -1300190200, user_data = 0x2b35b280b008}, {pos = -1300188152, events = 11061, fd = -1300187128, user_data = 0x2b35b280bc08}, {pos = -1300185080, events = 11061, fd = -1300184056, user_data = 0x2b35b280c808}, {pos = -1300182008, events = 11061, fd = -1300176888, user_data = 0x2b35b280e408}, {pos = -1300174840, events = 11061, fd = -1300173816, user_data = 0x2b35b2803008}, {pos = 2735915, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -1300168624, events = 11061, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 563903944, user_data = 0x8219c7b80}, {pos = 32, events = 32, fd = -1300221944, user_data = 0x378}, {pos = 2113896, events = 0, fd = 296, user_data = 0x2b35b2810050}, {pos = 563903920, events = 8, fd = -18020479, user_data = 0x2b35b2c31000}, {pos = 2735915, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -1300168624, events = 11061, fd = 1, user_data = 0x2b35b280a408}, {pos = 12579040, events = 0, fd = 773725968, user_data = 0x2b35b2803008}, {pos = 2840000, events = 0, fd = 740705465, user_data = 0x1}, {pos = -1295966208, events = 11061, fd = 563903920, user_data = 0x82c263642}, {pos = 773725968, events = 8, fd = 12579040, user_data = 0x82e1e1f10 }, {pos = -1300192248, events = 11061, fd = 563904144, user_data = 0x34d9feed0574}, {pos = 563904000, events = 8, fd = 1, user_data = 0x34d9feed03ee}, {pos = -1300221944, events = 11061, fd = 563903928, user_data = 0x8219c7e90}, {pos = 6792, events = 0, fd = 12, user_data = 0x34d9feee43a0}, {pos = 0, events = 0, fd = -1295907969, user_data = 0xc1c650 }, {pos = 563904064, events = 8, fd = 740664672, user_data = 0x82e2864b0 <__thr_jtable>}, {pos = 774408096, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 563904112, events = 8, fd = 740664672, user_data = 0x82e2864b0 <__thr_jtable>}, {pos = 774408096, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 563904160, events = 8, fd = 740707069, user_data = 0x2b35b2c12000}, {pos = 6457, events = 0, fd = 563904256, user_data = 0x82c25c9ea}} [01:32:52.130] last_touch_time = 1755221054 [01:32:52.130] last_lockfile_recheck_time = 1755221234 [01:32:52.130] nevents = 1 [01:32:52.130] #34 0x00000000008c381a in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8219c8510) at ../src/backend/postmaster/postmaster.c:1400 [01:32:52.130] userDoption = [01:32:52.130] listen_addr_saved = false [01:32:52.130] output_config_variable = [01:32:52.130] opt = [01:32:52.130] status = [01:32:52.130] #35 0x00000000007f5630 in main (argc=8, argv=0x8219c8510) at ../src/backend/main/main.c:231 [01:32:52.130] do_check_root = [01:32:52.130] dispatch_option = DISPATCH_POSTMASTER [01:32:52.138] [01:32:52.138] [01:32:52.138] [01:32:52.190] dumping /tmp/cores/postgres.83113.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:32:52.316] [New LWP 101827] [01:32:52.384] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN'. [01:32:52.384] Program terminated with signal SIGABRT, Aborted. [01:32:52.384] Sent by thr_kill() from pid 83113 and user 1002. [01:32:52.384] #0 0x000000082e8571ba in thr_kill () from /lib/libc.so.7 [01:32:52.447] [01:32:52.447] Thread 1 (LWP 101827): [01:32:52.447] #0 0x000000082e8571ba in thr_kill () from /lib/libc.so.7 [01:32:52.447] No symbol table info available. [01:32:52.447] #1 0x000000082e7d05d4 in raise () from /lib/libc.so.7 [01:32:52.447] No symbol table info available. [01:32:52.447] #2 0x000000082e883b59 in abort () from /lib/libc.so.7 [01:32:52.447] No symbol table info available. [01:32:52.447] #3 0x0000000000ada325 in ExceptionalCondition (conditionName=0x3683d9 "n >= 0 && n < list->length", fileName=, lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [01:32:52.447] No locals. [01:32:52.447] #4 0x000000000085dab6 in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [01:32:52.447] No locals. [01:32:52.447] #5 list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [01:32:52.447] No locals. [01:32:52.447] #6 0x000000000085da0b in var_is_nonnullable (root=0x14dd949f478, var=var@entry=0x14dd9ce3900, use_rel_info=false) at ../src/backend/optimizer/util/clauses.c:4235 [01:32:52.447] rte = [01:32:52.447] notnullattnums = 0x0 [01:32:52.447] #7 0x000000000085d37d in eval_const_expressions_mutator (node=0x14dd9ce3880, context=) at ../src/backend/optimizer/util/clauses.c:3556 [01:32:52.447] varg = 0x14dd9ce3900 [01:32:52.447] result = [01:32:52.447] ntest = 0x14dd9ce3880 [01:32:52.447] arg = 0x14dd9ce3900 [01:32:52.447] newntest = [01:32:52.447] #8 0x000000000085fa68 in simplify_and_arguments (args=, context=context@entry=0x8218b10b8, haveNull=haveNull@entry=0x8218b1060, forceFalse=forceFalse@entry=0x8218b1074) at ../src/backend/optimizer/util/clauses.c:3964 [01:32:52.447] arg = 0x14dd9ce3880 [01:32:52.447] newargs = 0x14dd9ce3a90 [01:32:52.447] unprocessed_args = 0x0 [01:32:52.447] #9 0x000000000085d283 in eval_const_expressions_mutator (node=0x14dd9ce36c0, context=) at ../src/backend/optimizer/util/clauses.c:2877 [01:32:52.447] haveNull = false [01:32:52.447] forceFalse = false [01:32:52.447] newargs = [01:32:52.447] expr = 0x14dd9ce36c0 [01:32:52.447] #10 0x000000000085c2bb in eval_const_expressions (root=root@entry=0x14dd949f478, node=0x0, node@entry=0x14dd9ce36c0) at ../src/backend/optimizer/util/clauses.c:2272 [01:32:52.447] context = {boundParams = , root = 0x14dd949f478, active_fns = 0x0, case_val = 0x0, estimate = false} [01:32:52.447] #11 0x000000000084ccbf in convert_EXISTS_sublink_to_join (root=0x14dd949f478, sublink=, under_not=false, available_rels=available_rels@entry=0x14dd949fa58) at ../src/backend/optimizer/plan/subselect.c:1541 [01:32:52.447] je = [01:32:52.447] lc__state = {l = 0x14dd9ce3670, i = 0} [01:32:52.447] subroot = {type = T_Invalid, parse = 0xae9c19 , glob = 0x2d9a28, query_level = 0, parent_root = 0x14dd951c100, plan_params = 0x14dd951da48, outer_params = 0x200c1c640, simple_rel_array = 0x0, simple_rel_array_size = -648953600, simple_rte_array = 0x14dd951c190, append_rel_array = 0x200000014, all_baserels = 0x0, outer_join_rels = 0x195f4b2b218b1240, all_query_rels = 0x14dd951c190, join_rel_list = 0x14, join_rel_hash = 0x14dd951da48, join_rel_level = 0x8218b1260, join_cur_level = 1037057192, init_plans = 0x1, cte_plan_ids = 0x1, multiexpr_params = 0x8218b11d0, join_domains = 0xabdbb8 , eq_classes = 0xc1c6b0 , ec_merging_done = false, canon_pathkeys = 0x14dd949f8d8, left_join_clauses = 0x0, right_join_clauses = 0x8218b11f0, full_join_clauses = 0x53, join_info_list = 0x8218b1250, last_rinfo_serial = 11420980, all_result_relids = 0x6181b0 , leaf_result_relids = 0xae9eae , append_rel_list = 0x2, row_identity_vars = 0x0, rowMarks = 0x14dd9430c00, placeholder_list = 0x14dd95d5410, placeholder_array = 0x14dd95d5928, placeholder_array_size = 562762400, fkey_list = 0x14dd9520100, query_pathkeys = 0x53, group_pathkeys = 0x1218b1290, num_groupby_pathkeys = 0, window_pathkeys = 0x1d29cbb0218b1270, distinct_pathkeys = 0x0, sort_pathkeys = 0x4, setop_pathkeys = 0x14dd95d53c8, part_schemes = 0x14dd949f8d8, initial_rels = 0x0, upper_rels = {0xa9c6, 0x0, 0x8218b1420, 0xacc290 , 0x3000100000000, 0x3b600000000, 0xa3f9f0 , 0x10002000000b8}, upper_targets = {0x2, 0x0, 0x14dd9430c00, 0x0, 0xa9c6, 0x5000500000000, 0x3b600000000, 0x9f2f40 }, processed_groupClause = 0x1000200000092, processed_distinctClause = 0x2, processed_tlist = 0x0, update_colnos = 0x14dd9430c00, grouping_map = 0x0, minmax_aggs = 0x0, planner_cxt = 0x3000900000000, total_table_pages = 5.6537043501316985e-317, tuple_fraction = 5.3094033413173715e-317, limit_tuples = 1.3907136014837293e-309, qual_security_level = 562762498, hasJoinRTEs = 8, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 25, placeholdersFrozen = 156, hasRecursion = 174, group_rtindex = 0, agginfos = 0x14dd9430c00, aggtransinfos = 0x0, numOrderedAggs = -648953600, hasNonPartialAggs = 77, hasNonSerialAggs = true, wt_param_id = 562762868, non_recursive_path = 0x0, curOuterRels = 0x8218b1408, curOuterParams = 0x14dd9c25100, isAltSubplan = 0x14dd951c190, isUsedSubplan = 0x100000014, join_search_private = 0x0, partColsUpdated = 2, partPruneInfos = 0x14dd9c25190} [01:32:52.447] parse = 0x14dd9cd6e48 [01:32:52.447] subselect = 0x14dd94790c8 [01:32:52.447] newWhere = 0x0 [01:32:52.447] all_clauses = 0x14dd9ce3670 [01:32:52.447] upper_reference_exists = false [01:32:52.447] whereClause = 0x14dd9ce36c0 [01:32:52.447] lc = [01:32:52.447] rtoffset = [01:32:52.447] clause_varnos = [01:32:52.447] upper_varnos = [01:32:52.447] varno = [01:32:52.447] result = [01:32:52.447] #12 0x00000000008545c2 in pull_up_sublinks_qual_recurse (root=0x18dc3, node=0x6, jtlink1=0x14dd9474e20, available_rels1=0x14dd949fa58, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [01:32:52.447] child_rels = 0xb0284f [01:32:52.447] sublink = 0x6 [01:32:52.447] j = [01:32:52.447] #13 0x00000000008513b9 in pull_up_sublinks_jointree_recurse (root=root@entry=0x14dd949f478, jtnode=, relids=relids@entry=0x8218b1510) at ../src/backend/optimizer/prep/prepjointree.c:787 [01:32:52.447] leftrelids = 0x14dd949f928 [01:32:52.447] rightrelids = 0x14dd949fa58 [01:32:52.447] jtlink = 0x14dd9474e08 [01:32:52.447] j = 0x14dd9474e08 [01:32:52.447] #14 0x0000000000851265 in pull_up_sublinks_jointree_recurse (root=root@entry=0x14dd949f478, jtnode=0x14dd9cd7e58, relids=relids@entry=0x8218b1550) at ../src/backend/optimizer/prep/prepjointree.c:706 [01:32:52.447] childrelids = 0x3 [01:32:52.447] newchild = [01:32:52.447] l__state = {l = 0x14dd9d11f40, i = 0} [01:32:52.447] jtlink = 0x3 [01:32:52.447] frelids = 0x0 [01:32:52.447] newf = [01:32:52.447] f = 0x14dd9cd7e58 [01:32:52.447] newfromlist = 0x0 [01:32:52.447] l = 0x82e85719a [01:32:52.447] #15 0x000000000085119a in pull_up_sublinks (root=0x18dc3, root@entry=0x14dd949f478) at ../src/backend/optimizer/prep/prepjointree.c:653 [01:32:52.447] relids = 0x14dd9cd7e58 [01:32:52.447] jtnode = [01:32:52.447] #16 0x000000000083cd9a in subquery_planner (glob=glob@entry=0x14dd94792d8, parse=parse@entry=0x14dd9cd6e48, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:751 [01:32:52.447] root = 0x14dd949f478 [01:32:52.447] hasOuterJoins = [01:32:52.447] hasResultRTEs = [01:32:52.447] l = [01:32:52.447] newWithCheckOptions = [01:32:52.447] newHaving = [01:32:52.447] final_rel = [01:32:52.447] #17 0x000000000083c512 in standard_planner (parse=0x14dd9cd6e48, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:436 [01:32:52.447] glob = 0x14dd94792d8 [01:32:52.447] tuple_fraction = [01:32:52.447] root = [01:32:52.447] final_rel = [01:32:52.447] best_path = [01:32:52.447] top_plan = [01:32:52.447] lp = [01:32:52.447] lr = [01:32:52.447] result = [01:32:52.447] #18 0x000000000083c39e in planner (parse=0x18dc3, parse@entry=0x14dd9cd6e48, query_string=0x6 , query_string@entry=0x14dd9422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=0, cursorOptions@entry=2048, boundParams=0x82e85719a , boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:295 [01:32:52.447] result = [01:32:52.447] #19 0x0000000000977874 in pg_plan_query (querytree=querytree@entry=0x14dd9cd6e48, query_string=query_string@entry=0x14dd9422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [01:32:52.447] plan = [01:32:52.447] #20 0x0000000000700d1a in standard_ExplainOneQuery (query=0x14dd9cd6e48, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x14dd9479038, queryString=0x14dd9422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [01:32:52.447] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 1433870881736, shared_blks_dirtied = 1433870881736, shared_blks_written = 11544655, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 1433870881736, temp_blks_read = 2, temp_blks_written = 1433878229824, shared_blk_read_time = {ticks = 34922501968}, shared_blk_write_time = {ticks = 6087146}, local_blk_read_time = {ticks = 70381629123014}, local_blk_write_time = {ticks = 1433878229744}, temp_blk_read_time = {ticks = 34922502144}, temp_blk_write_time = {ticks = 9531722}} [01:32:52.447] bufusage = {shared_blks_hit = 281, shared_blks_read = 93326516, shared_blks_dirtied = 4294967288, shared_blks_written = 1433878471937, local_blks_hit = 1433878472072, local_blks_read = 0, local_blks_dirtied = 34922501888, local_blks_written = 7325316, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 1433869159976}, local_blk_read_time = {ticks = 1433878228552}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34922502112}, temp_blk_write_time = {ticks = 11582912}} [01:32:52.447] mem_counters = {nblocks = 34922501888, freechunks = 11544655, totalspace = 240, freespace = 1433870881736} [01:32:52.447] planduration = {ticks = 8355684} [01:32:52.447] planner_ctx = 0x0 [01:32:52.447] saved_ctx = [01:32:52.447] planstart = {ticks = -281093326516} [01:32:52.447] plan = [01:32:52.447] #21 0x00000000007009d2 in ExplainOneQuery (query=0x18dc3, cursorOptions=2048, into=0x0, es=0x14dd9479038, pstate=0x14dd9430eb8, params=0x0) at ../src/backend/commands/explain.c:309 [01:32:52.447] No locals. [01:32:52.447] #22 ExplainQuery (pstate=pstate@entry=0x14dd9430eb8, stmt=stmt@entry=0x14dd9cd6e18, params=params@entry=0x0, dest=0x14dd9430e28) at ../src/backend/commands/explain.c:223 [01:32:52.447] l__state = {l = , i = 0} [01:32:52.447] l = 0x14dd9474cb0 [01:32:52.447] es = 0x14dd9479038 [01:32:52.447] jstate = [01:32:52.447] query = [01:32:52.447] rewritten = 0x14dd9474c98 [01:32:52.447] tstate = [01:32:52.447] #23 0x000000000097eae0 in standard_ProcessUtility (pstmt=0x14dd9d12660, queryString=0x14dd9422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x14dd9430e28, qc=0x8218b19a8) at ../src/backend/tcop/utility.c:866 [01:32:52.447] isAtomicContext = false [01:32:52.447] parsetree = 0x14dd9cd6e18 [01:32:52.447] readonly_flags = [01:32:52.447] pstate = 0x14dd9430eb8 [01:32:52.447] isTopLevel = [01:32:52.447] #24 0x000000000097e778 in ProcessUtility (pstmt=0x18dc3, queryString=0x6 , readOnlyTree=, context=780497306, params=0x0, queryEnv=0x0, dest=0x14dd9430e28, qc=0x8218b19a8) at ../src/backend/tcop/utility.c:523 [01:32:52.447] No locals. [01:32:52.447] #25 0x000000000097e2ac in PortalRunUtility (portal=portal@entry=0x14dd9524100, pstmt=0x14dd9d12660, isTopLevel=, setHoldSnapshot=true, dest=dest@entry=0x14dd9430e28, qc=qc@entry=0x8218b19a8) at ../src/backend/tcop/pquery.c:1153 [01:32:52.447] No locals. [01:32:52.447] #26 0x000000000097d4ea in FillPortalStore (portal=portal@entry=0x14dd9524100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [01:32:52.447] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:32:52.447] treceiver = 0x14dd9430e28 [01:32:52.447] #27 0x000000000097d224 in PortalRun (portal=portal@entry=0x14dd9524100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x14dd9d127c0, altdest=altdest@entry=0x14dd9d127c0, qc=qc@entry=0x8218b1ae0) at ../src/backend/tcop/pquery.c:760 [01:32:52.447] _local_sigjmp_buf = {{_sjb = {9949637, 1433870156032, 34922502616, 34922502864, 34922502624, 12690440, 34922502880, 12617384, 12583807, 0, 1433870140287, 1430224109568}}} [01:32:52.447] _save_exception_stack = 0x8218b1b90 [01:32:52.447] _save_context_stack = 0x0 [01:32:52.447] _do_rethrow = false [01:32:52.447] saveTopTransactionResourceOwner = 0x14dd958cfd8 [01:32:52.447] saveTopTransactionContext = 0x14dd95e6000 [01:32:52.447] saveActivePortal = 0x0 [01:32:52.447] saveResourceOwner = 0x14dd958cfd8 [01:32:52.447] savePortalContext = 0x0 [01:32:52.447] saveMemoryContext = 0x14dd95e6000 [01:32:52.447] result = [01:32:52.447] nprocessed = [01:32:52.447] #28 0x000000000097c089 in exec_simple_query (query_string=query_string@entry=0x14dd9422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [01:32:52.447] cmdtaglen = 7 [01:32:52.447] snapshot_set = [01:32:52.447] per_parsetree_context = 0x0 [01:32:52.447] plantree_list = [01:32:52.447] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:32:52.447] format = 0 [01:32:52.447] parsetree = 0x14dd957fc48 [01:32:52.447] commandTag = [01:32:52.447] cmdtagname = [01:32:52.447] querytree_list = [01:32:52.447] portal = 0x14dd9524100 [01:32:52.447] receiver = 0x14dd9d127c0 [01:32:52.447] parsetree_item__state = {l = 0x14dd9580c00, i = 0} [01:32:52.447] msec_str = "\000\000\000\000\b", '\000' , "0\033\213!\b\000\000\000U:\205.\b\000\000" [01:32:52.447] dest = DestRemote [01:32:52.447] was_logged = [01:32:52.447] oldcontext = 0x14dd95e6000 [01:32:52.447] parsetree_list = 0x14dd9580c00 [01:32:52.447] use_implicit_block = false [01:32:52.447] parsetree_item = 0x14dd9580c18 [01:32:52.447] save_log_statement_stats = [01:32:52.447] #29 0x0000000000979ad5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4763 [01:32:52.447] query_string = 0x14dd9422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [01:32:52.447] input_message = {data = 0x14dd9422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [01:32:52.447] firstchar = [01:32:52.447] local_sigjmp_buf = {{_sjb = {9932491, 34922503056, 34922503048, 34922503648, 12491620, 12491352, 12699224, 12693156, 895, 0, 0, 1430224109569}}} [01:32:52.447] send_ready_for_query = false [01:32:52.447] idle_in_transaction_timeout_enabled = false [01:32:52.447] idle_session_timeout_enabled = false [01:32:52.447] #30 0x0000000000973f79 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [01:32:52.447] bsdata = [01:32:52.447] #31 0x00000000008c100b in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x8218b2848, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x8218b2860) at ../src/backend/postmaster/launch_backend.c:290 [01:32:52.447] pid = [01:32:52.447] #32 0x00000000008c5978 in BackendStartup (client_sock=0x8218b2860) at ../src/backend/postmaster/postmaster.c:3587 [01:32:52.447] startup_data = {canAcceptConnections = CAC_OK, socket_created = 808536451599888, fork_started = } [01:32:52.447] bn = 0x14dd955b278 [01:32:52.447] cac = CAC_OK [01:32:52.447] pid = [01:32:52.447] __error = [01:32:52.447] save_errno = [01:32:52.447] __error = [01:32:52.447] __error = [01:32:52.447] #33 ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [01:32:52.447] 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 = "\r", '\000' , "\300(\213!\b\000\000\000Xvo+\b\000\000\000\006\001\000\000\000\000\000\000\276\376o+\b", '\000' , ")\213!\b\000\000\000T\r\214\000\000\000\000\000\020)\213!\b", '\000' }, salen = 16}} [01:32:52.447] i = 0 [01:32:52.447] now = [01:32:52.447] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 780121484, user_data = 0x0}, {pos = 562767888, events = 8, fd = -649464360, user_data = 0x8218b26a0}, {pos = 0, events = 0, fd = 0, user_data = 0xb4b5de4ecf31f0ab}, {pos = 781233664, events = 8, fd = 562766608, user_data = 0x2fa1d1432cd}, {pos = 779279288, events = 8, fd = 779354268, user_data = 0x8218b2328}, {pos = 562766752, events = 8, fd = 562766656, user_data = 0x2fa1d1432cd}, {pos = 779276144, events = 8, fd = 779354268, user_data = 0x8218b2358}, {pos = 562766800, events = 8, fd = 779324868, user_data = 0x82e738dc4}, {pos = 562766720, events = 8, fd = 487862989, user_data = 0x82e731410}, {pos = 779354268, events = 8, fd = 562766744, user_data = 0x8218b2410}, {pos = 779327796, events = 8, fd = 779327796, user_data = 0x14dd900a408}, {pos = 3, events = 0, fd = 562766848, user_data = 0x2fa1d13e4fb}, {pos = 562766864, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 562766936, user_data = 0x8218b2618}, {pos = 562766912, events = 8, fd = 487861330, user_data = 0x29609b}, {pos = -654249336, events = 333, fd = 779293712, user_data = 0x14dd900a408}, {pos = 562767000, events = 8, fd = 562767448, user_data = 0x8218b2480}, {pos = 487861330, events = 762, fd = 2735915, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = -654245808, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x8218b2758}, {pos = -650050112, events = 3, fd = 562767528, user_data = 0x14dd900fac8}, {pos = 656, events = 0, fd = 562767448, user_data = 0x8218b2498}, {pos = 562767104, events = 8, fd = 487860939, user_data = 0x8218b2718}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -654245808, events = 333, fd = 1, user_data = 0x14dd900a408}, {pos = 779293712, events = 8, fd = 562767704, user_data = 0x8218b26a8}, {pos = 562767120, events = 8, fd = 0, user_data = 0x14dd9003008}, {pos = 32, events = 0, fd = 562767504, user_data = 0x2fa1d13cc77}, {pos = -654299128, events = 333, fd = -654298104, user_data = 0x14dd9003808}, {pos = -654296056, events = 333, fd = -654282744, user_data = 0x14dd9007408}, {pos = -654280696, events = 333, fd = -654279672, user_data = 0x14dd9008008}, {pos = -654277624, events = 333, fd = -654276600, user_data = 0x14dd9008c08}, {pos = -654274552, events = 333, fd = -654273528, user_data = 0x14dd9009808}, {pos = -654271480, events = 333, fd = -654270456, user_data = 0x14dd900a408}, {pos = -654268408, events = 333, fd = -654267384, user_data = 0x14dd900b008}, {pos = -654265336, events = 333, fd = -654264312, user_data = 0x14dd900bc08}, {pos = -654262264, events = 333, fd = -654261240, user_data = 0x14dd900c808}, {pos = -654259192, events = 333, fd = -654254072, user_data = 0x14dd900e408}, {pos = -654252024, events = 333, fd = -654251000, user_data = 0x14dd9003008}, {pos = 2735915, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -654245808, events = 333, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 562767704, user_data = 0x8218b2510}, {pos = 32, events = 32, fd = -654299128, user_data = 0x378}, {pos = 2113896, events = 0, fd = 296, user_data = 0x14dd9010050}, {pos = 562767680, events = 8, fd = 487835521, user_data = 0x14dd9431000}, {pos = 2735915, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -654245808, events = 333, fd = 1, user_data = 0x14dd900a408}, {pos = 12579040, events = 0, fd = 780488464, user_data = 0x14dd9003008}, {pos = 2840000, events = 0, fd = 728757433, user_data = 0x1}, {pos = -650043392, events = 333, fd = 562767680, user_data = 0x82b6fe642}, {pos = 780488464, events = 8, fd = 12579040, user_data = 0x82e854f10 }, {pos = -654269432, events = 333, fd = 562767904, user_data = 0x2fa1d13c574}, {pos = 562767760, events = 8, fd = 1, user_data = 0x2fa1d13c3ee}, {pos = -654299128, events = 333, fd = 562767688, user_data = 0x8218b2820}, {pos = 6792, events = 0, fd = 12, user_data = 0x2fa1d1503a0}, {pos = 0, events = 0, fd = -649985153, user_data = 0xc1c650 }, {pos = 562767824, events = 8, fd = 728716640, user_data = 0x82e8f94b0 <__thr_jtable>}, {pos = 781170592, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 562767872, events = 8, fd = 728716640, user_data = 0x82e8f94b0 <__thr_jtable>}, {pos = 781170592, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 562767920, events = 8, fd = 728759037, user_data = 0x14dd9412000}, {pos = 6446, events = 0, fd = 562768016, user_data = 0x82b6f79ea}} [01:32:52.447] last_touch_time = 1755221054 [01:32:52.447] last_lockfile_recheck_time = 1755221234 [01:32:52.447] nevents = 1 [01:32:52.447] #34 0x00000000008c381a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8218b2ea0) at ../src/backend/postmaster/postmaster.c:1400 [01:32:52.447] userDoption = [01:32:52.447] listen_addr_saved = false [01:32:52.447] output_config_variable = [01:32:52.447] opt = [01:32:52.447] status = [01:32:52.447] #35 0x00000000007f5630 in main (argc=4, argv=0x8218b2ea0) at ../src/backend/main/main.c:231 [01:32:52.447] do_check_root = [01:32:52.447] dispatch_option = DISPATCH_POSTMASTER [01:32:52.456] [01:32:52.456] [01:32:52.456] [01:32:52.510] dumping /tmp/cores/postgres.8859.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:32:52.634] [New LWP 101802] [01:32:52.701] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN'. [01:32:52.701] Program terminated with signal SIGABRT, Aborted. [01:32:52.701] Sent by thr_kill() from pid 8859 and user 1002. [01:32:52.701] #0 0x000000082b5171ba in thr_kill () from /lib/libc.so.7 [01:32:52.772] [01:32:52.772] Thread 1 (LWP 101802): [01:32:52.772] #0 0x000000082b5171ba in thr_kill () from /lib/libc.so.7 [01:32:52.772] No symbol table info available. [01:32:52.772] #1 0x000000082b4905d4 in raise () from /lib/libc.so.7 [01:32:52.772] No symbol table info available. [01:32:52.772] #2 0x000000082b543b59 in abort () from /lib/libc.so.7 [01:32:52.772] No symbol table info available. [01:32:52.772] #3 0x0000000000ada325 in ExceptionalCondition (conditionName=0x3683d9 "n >= 0 && n < list->length", fileName=, lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [01:32:52.772] No locals. [01:32:52.772] #4 0x000000000085dab6 in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [01:32:52.772] No locals. [01:32:52.772] #5 list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [01:32:52.772] No locals. [01:32:52.772] #6 0x000000000085da0b in var_is_nonnullable (root=0x381a68e98ad8, var=var@entry=0x381a696c2f68, use_rel_info=false) at ../src/backend/optimizer/util/clauses.c:4235 [01:32:52.772] rte = [01:32:52.772] notnullattnums = 0x0 [01:32:52.772] #7 0x000000000085d37d in eval_const_expressions_mutator (node=0x381a696c2ee8, context=) at ../src/backend/optimizer/util/clauses.c:3556 [01:32:52.772] varg = 0x381a696c2f68 [01:32:52.772] result = [01:32:52.772] ntest = 0x381a696c2ee8 [01:32:52.772] arg = 0x381a696c2f68 [01:32:52.772] newntest = [01:32:52.772] #8 0x000000000085fa68 in simplify_and_arguments (args=, context=context@entry=0x821940d08, haveNull=haveNull@entry=0x821940cb0, forceFalse=forceFalse@entry=0x821940cc4) at ../src/backend/optimizer/util/clauses.c:3964 [01:32:52.772] arg = 0x381a696c2ee8 [01:32:52.772] newargs = 0x381a696c30f8 [01:32:52.772] unprocessed_args = 0x0 [01:32:52.772] #9 0x000000000085d283 in eval_const_expressions_mutator (node=0x381a696c2d28, context=) at ../src/backend/optimizer/util/clauses.c:2877 [01:32:52.772] haveNull = false [01:32:52.772] forceFalse = false [01:32:52.772] newargs = [01:32:52.772] expr = 0x381a696c2d28 [01:32:52.772] #10 0x000000000085c2bb in eval_const_expressions (root=root@entry=0x381a68e98ad8, node=0x0, node@entry=0x381a696c2d28) at ../src/backend/optimizer/util/clauses.c:2272 [01:32:52.772] context = {boundParams = , root = 0x381a68e98ad8, active_fns = 0x0, case_val = 0x0, estimate = false} [01:32:52.772] #11 0x000000000084ccbf in convert_EXISTS_sublink_to_join (root=0x381a68e98ad8, sublink=, under_not=false, available_rels=available_rels@entry=0x381a696c2148) at ../src/backend/optimizer/plan/subselect.c:1541 [01:32:52.772] je = [01:32:52.772] lc__state = {l = 0x381a696c2cd8, i = 0} [01:32:52.772] subroot = {type = T_Invalid, parse = 0xae9c19 , glob = 0x2d9a28, query_level = 0, parent_root = 0x381a68f1a100, plan_params = 0x381a68f1ba48, outer_params = 0x200c1c640, simple_rel_array = 0x0, simple_rel_array_size = 1760665856, simple_rte_array = 0x381a68f1a190, append_rel_array = 0x200000014, all_baserels = 0x0, outer_join_rels = 0x637ad65521940e90, all_query_rels = 0x381a68f1a190, join_rel_list = 0x14, join_rel_hash = 0x381a68f1ba48, join_rel_level = 0x821940eb0, join_cur_level = 861882376, init_plans = 0x1, cte_plan_ids = 0x1, multiexpr_params = 0x821940e20, join_domains = 0xabdbb8 , eq_classes = 0xc1c6b0 , ec_merging_done = false, canon_pathkeys = 0x381a68e98f38, left_join_clauses = 0x0, right_join_clauses = 0x821940e40, full_join_clauses = 0x53, join_info_list = 0x821940ea0, last_rinfo_serial = 11420980, all_result_relids = 0x6181b0 , leaf_result_relids = 0xae9eae , append_rel_list = 0x2, row_identity_vars = 0x0, rowMarks = 0x381a68e30c00, placeholder_list = 0x381a68fb18d0, placeholder_array = 0x381a68fb1de8, placeholder_array_size = 563351280, fkey_list = 0x381a68f1e100, query_pathkeys = 0x53, group_pathkeys = 0x121940ee0, num_groupby_pathkeys = 0, window_pathkeys = 0xa548f4221940ec0, distinct_pathkeys = 0x0, sort_pathkeys = 0x4, setop_pathkeys = 0x381a68fb1888, part_schemes = 0x381a68e98f38, initial_rels = 0x0, upper_rels = {0xa970, 0x0, 0x821941070, 0xacc290 , 0x3000100000000, 0x3b600000000, 0xa3f9f0 , 0x10002000000b8}, upper_targets = {0x2, 0x0, 0x381a68e30c00, 0x0, 0xa970, 0x5000500000000, 0x3b600000000, 0x9f2f40 }, processed_groupClause = 0x1000200000092, processed_distinctClause = 0x2, processed_tlist = 0x0, update_colnos = 0x381a68e30c00, grouping_map = 0x0, minmax_aggs = 0x0, planner_cxt = 0x3000900000000, total_table_pages = 5.6537043501316985e-317, tuple_fraction = 5.3094033413173715e-317, limit_tuples = 1.3907136014837293e-309, qual_security_level = 563351554, hasJoinRTEs = 8, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 25, placeholdersFrozen = 156, hasRecursion = 174, group_rtindex = 0, agginfos = 0x381a68e30c00, aggtransinfos = 0x0, numOrderedAggs = 1760665856, hasNonPartialAggs = 26, hasNonSerialAggs = 56, wt_param_id = 563351748, non_recursive_path = 0x0, curOuterRels = 0x821941058, curOuterParams = 0x381a69695100, isAltSubplan = 0x381a68f1a190, isUsedSubplan = 0x100000014, join_search_private = 0x0, partColsUpdated = 2, partPruneInfos = 0x381a69695190} [01:32:52.772] parse = 0x381a696bab18 [01:32:52.772] subselect = 0x381a6961d0c8 [01:32:52.772] newWhere = 0x0 [01:32:52.772] all_clauses = 0x381a696c2cd8 [01:32:52.772] upper_reference_exists = false [01:32:52.772] whereClause = 0x381a696c2d28 [01:32:52.772] lc = [01:32:52.772] rtoffset = [01:32:52.772] clause_varnos = [01:32:52.772] upper_varnos = [01:32:52.772] varno = [01:32:52.772] result = [01:32:52.772] #12 0x00000000008545c2 in pull_up_sublinks_qual_recurse (root=0x18daa, node=0x6, jtlink1=0x381a68e985d0, available_rels1=0x381a696c2148, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [01:32:52.772] child_rels = 0xb0284f [01:32:52.772] sublink = 0x6 [01:32:52.772] j = [01:32:52.772] #13 0x00000000008513b9 in pull_up_sublinks_jointree_recurse (root=root@entry=0x381a68e98ad8, jtnode=, relids=relids@entry=0x821941160) at ../src/backend/optimizer/prep/prepjointree.c:787 [01:32:52.772] leftrelids = 0x381a68e98f88 [01:32:52.772] rightrelids = 0x381a696c2148 [01:32:52.772] jtlink = 0x381a68e985b8 [01:32:52.772] j = 0x381a68e985b8 [01:32:52.772] #14 0x0000000000851265 in pull_up_sublinks_jointree_recurse (root=root@entry=0x381a68e98ad8, jtnode=0x381a696bb858, relids=relids@entry=0x8219411a0) at ../src/backend/optimizer/prep/prepjointree.c:706 [01:32:52.772] childrelids = 0x3 [01:32:52.772] newchild = [01:32:52.772] l__state = {l = 0x381a696d7f98, i = 0} [01:32:52.772] jtlink = 0x3 [01:32:52.772] frelids = 0x0 [01:32:52.772] newf = [01:32:52.772] f = 0x381a696bb858 [01:32:52.772] newfromlist = 0x0 [01:32:52.772] l = 0x82b51719a [01:32:52.772] #15 0x000000000085119a in pull_up_sublinks (root=0x18daa, root@entry=0x381a68e98ad8) at ../src/backend/optimizer/prep/prepjointree.c:653 [01:32:52.772] relids = 0x381a696bb858 [01:32:52.772] jtnode = [01:32:52.772] #16 0x000000000083cd9a in subquery_planner (glob=glob@entry=0x381a68e6e6a8, parse=parse@entry=0x381a696bab18, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:751 [01:32:52.772] root = 0x381a68e98ad8 [01:32:52.772] hasOuterJoins = [01:32:52.772] hasResultRTEs = [01:32:52.772] l = [01:32:52.772] newWithCheckOptions = [01:32:52.772] newHaving = [01:32:52.772] final_rel = [01:32:52.772] #17 0x000000000083c512 in standard_planner (parse=parse@entry=0x381a696bab18, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:436 [01:32:52.772] glob = 0x381a68e6e6a8 [01:32:52.772] tuple_fraction = [01:32:52.772] root = [01:32:52.772] final_rel = [01:32:52.772] best_path = [01:32:52.772] top_plan = [01:32:52.772] lp = [01:32:52.772] lr = [01:32:52.772] result = [01:32:52.772] #18 0x0000000832cbfa07 in pgss_planner (parse=0x381a696bab18, query_string=0x381a68e22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:983 [01:32:52.772] _local_sigjmp_buf = {{_sjb = {35211966583, 12690440, 34923090600, 34923091104, 0, 12697245, 12690432, 34923092048, 61686080930687, 83, 4858319760, 0}}} [01:32:52.772] _save_exception_stack = 0x821941850 [01:32:52.772] _save_context_stack = 0x0 [01:32:52.772] _do_rethrow = false [01:32:52.772] result = [01:32:52.772] #19 0x000000000083c397 in planner (parse=0x18daa, parse@entry=0x381a696bab18, query_string=0x6 , query_string@entry=0x381a68e22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=0, cursorOptions@entry=2048, boundParams=0x82b51719a , boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:293 [01:32:52.772] result = [01:32:52.772] #20 0x0000000000977874 in pg_plan_query (querytree=querytree@entry=0x381a696bab18, query_string=query_string@entry=0x381a68e22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [01:32:52.772] plan = [01:32:52.772] #21 0x0000000000700d1a in standard_ExplainOneQuery (query=0x381a696bab18, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x381a6961d038, queryString=0x381a68e22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [01:32:52.772] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 61686081591432, shared_blks_dirtied = 61686081591432, shared_blks_written = 11544655, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 61686081591432, temp_blks_read = 2, temp_blks_written = 61686088970256, shared_blk_read_time = {ticks = 34923091360}, shared_blk_write_time = {ticks = 6087146}, local_blk_read_time = {ticks = 70368744221040}, local_blk_write_time = {ticks = 61686088970176}, temp_blk_read_time = {ticks = 34923091536}, temp_blk_write_time = {ticks = 9531722}} [01:32:52.772] bufusage = {shared_blks_hit = 356, shared_blks_read = 535901694, shared_blks_dirtied = 34923091440, shared_blks_written = 61686080267336, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 61686088968960, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 61686088968984}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34923091504}, temp_blk_write_time = {ticks = 11582912}} [01:32:52.772] mem_counters = {nblocks = 34923091280, freechunks = 11544655, totalspace = 240, freespace = 61686081591432} [01:32:52.772] planduration = {ticks = 8355684} [01:32:52.772] planner_ctx = 0x0 [01:32:52.772] saved_ctx = [01:32:52.772] planstart = {ticks = -356535901694} [01:32:52.772] plan = [01:32:52.772] #22 0x00000000007009d2 in ExplainOneQuery (query=0x18daa, cursorOptions=2048, into=0x0, es=0x381a6961d038, pstate=0x381a68e30eb8, params=0x0) at ../src/backend/commands/explain.c:309 [01:32:52.772] No locals. [01:32:52.772] #23 ExplainQuery (pstate=pstate@entry=0x381a68e30eb8, stmt=stmt@entry=0x381a696baae8, params=params@entry=0x0, dest=0x381a68e30e28) at ../src/backend/commands/explain.c:223 [01:32:52.772] l__state = {l = , i = 0} [01:32:52.772] l = 0x381a68e98460 [01:32:52.772] es = 0x381a6961d038 [01:32:52.772] jstate = [01:32:52.772] query = [01:32:52.772] rewritten = 0x381a68e98448 [01:32:52.772] tstate = [01:32:52.772] #24 0x000000000097eae0 in standard_ProcessUtility (pstmt=pstmt@entry=0x381a696d86b8, queryString=queryString@entry=0x381a68e22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x381a68e30e28, qc=0x8219419b8) at ../src/backend/tcop/utility.c:866 [01:32:52.772] isAtomicContext = false [01:32:52.772] parsetree = 0x381a696baae8 [01:32:52.772] readonly_flags = [01:32:52.772] pstate = 0x381a68e30eb8 [01:32:52.772] isTopLevel = [01:32:52.772] #25 0x0000000832cc018f in pgss_ProcessUtility (pstmt=0x381a696d86b8, queryString=0x381a68e22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x381a68e30e28, qc=0x8219419b8) at ../contrib/pg_stat_statements/pg_stat_statements.c:1181 [01:32:52.772] _local_sigjmp_buf = {{_sjb = {35211968695, 34923092048, 34923091848, 34923092304, 0, 34923092464, 12690440, 356, 12583807, 12699400, 34923092288, 0}}} [01:32:52.772] _save_exception_stack = 0x8219419f0 [01:32:52.772] _save_context_stack = 0x0 [01:32:52.772] _do_rethrow = false [01:32:52.772] bufusage = {shared_blks_hit = 35211968695, shared_blks_read = 34923092048, shared_blks_dirtied = 34923091848, shared_blks_written = 34923092304, local_blks_hit = 0, local_blks_read = 34923092464, local_blks_dirtied = 12690440, local_blks_written = 356, temp_blks_read = 12583807, temp_blks_written = 12699400, shared_blk_read_time = {ticks = 34923092288}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 12699712}, local_blk_write_time = {ticks = 12576248}, temp_blk_read_time = {ticks = 61686089090744}, temp_blk_write_time = {ticks = 1}} [01:32:52.772] walusage_start = {wal_records = 61, wal_fpi = 0, wal_bytes = 6375, wal_buffers_full = 0} [01:32:52.772] duration = [01:32:52.772] bufusage_start = {shared_blks_hit = 6598, shared_blks_read = 100, shared_blks_dirtied = 25, shared_blks_written = 17, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [01:32:52.772] walusage = {wal_records = 0, wal_fpi = 34923092084, wal_bytes = 34923092128, wal_buffers_full = 8399722} [01:32:52.772] start = {ticks = -356535526094} [01:32:52.772] rows = [01:32:52.772] saved_queryId = 2174664879250974619 [01:32:52.772] parsetree = [01:32:52.772] saved_stmt_location = 0 [01:32:52.772] saved_stmt_len = 204 [01:32:52.772] enabled = [01:32:52.772] #26 0x000000000097e2ac in PortalRunUtility (portal=portal@entry=0x381a68f22100, pstmt=0x381a696d86b8, isTopLevel=, setHoldSnapshot=true, dest=dest@entry=0x381a68e30e28, qc=qc@entry=0x8219419b8) at ../src/backend/tcop/pquery.c:1153 [01:32:52.772] No locals. [01:32:52.772] #27 0x000000000097d4ea in FillPortalStore (portal=portal@entry=0x381a68f22100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [01:32:52.772] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:32:52.772] treceiver = 0x381a68e30e28 [01:32:52.772] #28 0x000000000097d224 in PortalRun (portal=portal@entry=0x381a68f22100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x381a696d8818, altdest=altdest@entry=0x381a696d8818, qc=qc@entry=0x821941af0) at ../src/backend/tcop/pquery.c:760 [01:32:52.772] _local_sigjmp_buf = {{_sjb = {9949637, 61686081003776, 34923092456, 34923092704, 34923092464, 12690440, 34923092720, 12617384, 12583807, 0, 61686080996223, 61684320305152}}} [01:32:52.772] _save_exception_stack = 0x821941ba0 [01:32:52.772] _save_context_stack = 0x0 [01:32:52.772] _do_rethrow = false [01:32:52.772] saveTopTransactionResourceOwner = 0x381a68f6fe18 [01:32:52.772] saveTopTransactionContext = 0x381a68f6b000 [01:32:52.772] saveActivePortal = 0x0 [01:32:52.772] saveResourceOwner = 0x381a68f6fe18 [01:32:52.772] savePortalContext = 0x0 [01:32:52.772] saveMemoryContext = 0x381a68f6b000 [01:32:52.772] result = [01:32:52.772] nprocessed = [01:32:52.772] #29 0x000000000097c089 in exec_simple_query (query_string=query_string@entry=0x381a68e22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [01:32:52.772] cmdtaglen = 7 [01:32:52.772] snapshot_set = [01:32:52.772] per_parsetree_context = 0x0 [01:32:52.772] plantree_list = [01:32:52.772] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:32:52.772] format = 0 [01:32:52.772] parsetree = 0x381a68f5c808 [01:32:52.772] commandTag = [01:32:52.772] cmdtagname = [01:32:52.772] querytree_list = [01:32:52.772] portal = 0x381a68f22100 [01:32:52.772] receiver = 0x381a696d8818 [01:32:52.772] parsetree_item__state = {l = 0x381a68f5d7c0, i = 0} [01:32:52.772] msec_str = "\000\000\000\000\b", '\000' , "@\033\224!\b\000\000\000U:Q+\b\000\000" [01:32:52.772] dest = DestRemote [01:32:52.772] was_logged = [01:32:52.772] oldcontext = 0x381a68f6b000 [01:32:52.772] parsetree_list = 0x381a68f5d7c0 [01:32:52.772] use_implicit_block = false [01:32:52.772] parsetree_item = 0x381a68f5d7d8 [01:32:52.772] save_log_statement_stats = [01:32:52.772] #30 0x0000000000979ad5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4763 [01:32:52.772] query_string = 0x381a68e22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [01:32:52.772] input_message = {data = 0x381a68e22100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [01:32:52.772] firstchar = [01:32:52.772] local_sigjmp_buf = {{_sjb = {9932491, 34923092896, 34923092888, 34923093488, 12491620, 12491352, 12699224, 12693156, 895, 0, 0, 34359738369}}} [01:32:52.772] send_ready_for_query = false [01:32:52.772] idle_in_transaction_timeout_enabled = false [01:32:52.772] idle_session_timeout_enabled = false [01:32:52.772] #31 0x0000000000973f79 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [01:32:52.772] bsdata = [01:32:52.772] #32 0x00000000008c100b in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x821942858, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x821942870) at ../src/backend/postmaster/launch_backend.c:290 [01:32:52.772] pid = [01:32:52.772] #33 0x00000000008c5978 in BackendStartup (client_sock=0x821942870) at ../src/backend/postmaster/postmaster.c:3587 [01:32:52.772] startup_data = {canAcceptConnections = CAC_OK, socket_created = 808536527054733, fork_started = } [01:32:52.772] bn = 0x381a68f5b918 [01:32:52.772] cac = CAC_OK [01:32:52.772] pid = [01:32:52.772] __error = [01:32:52.772] save_errno = [01:32:52.772] __error = [01:32:52.772] __error = [01:32:52.772] #34 ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [01:32:52.772] 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 = "\r", '\000' , "\320(\224!\b\000\000\000X\246\037)\b\000\000\000w\000\000\000\000\000\000\000\276. )\b", '\000' , "\020)\224!\b\000\000\000T\r\214\000\000\000\000\000 )\224!\b", '\000' }, salen = 16}} [01:32:52.772] i = 0 [01:32:52.772] now = [01:32:52.772] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 726381964, user_data = 0x0}, {pos = 563357728, events = 8, fd = 1760134616, user_data = 0x8219426b0}, {pos = 0, events = 0, fd = 0, user_data = 0x821942310}, {pos = -538451251, events = 12581, fd = 725539768, user_data = 0x82b40009c}, {pos = 563356456, events = 8, fd = 563356576, user_data = 0x821942340}, {pos = -538451251, events = 12581, fd = 725536624, user_data = 0x82b40009c}, {pos = 563356504, events = 8, fd = 563356624, user_data = 0x82b3f8dc4}, {pos = 725585348, events = 8, fd = 563356544, user_data = 0x3125dfe7e2cd}, {pos = 725554192, events = 8, fd = 725614748, user_data = 0x821942398}, {pos = 563356688, events = 8, fd = 725588276, user_data = 0x82b3f9934}, {pos = 1755358216, events = 14362, fd = 3, user_data = 0x821942400}, {pos = -538471173, events = 12581, fd = 563356688, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821942458}, {pos = 563357224, events = 8, fd = 563356736, user_data = 0x3125dfe7dc52}, {pos = 2711707, events = 0, fd = 1755379656, user_data = 0x0}, {pos = 0, events = 0, fd = 563356824, user_data = 0x821942668}, {pos = 563356800, events = 8, fd = -538452910, user_data = 0x29bf2b}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x381a68a10050}, {pos = 1, events = 8, fd = 0, user_data = 0x0}, {pos = 563357544, events = 8, fd = 1, user_data = 0x8219426b8}, {pos = 1755379752, events = 14362, fd = 656, user_data = 0x821942668}, {pos = 563356824, events = 8, fd = 563356928, user_data = 0x3125dfe7dacb}, {pos = 563357480, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1755381840, user_data = 0x1}, {pos = 1755358216, events = 14362, fd = 725554192, user_data = 0x821942768}, {pos = 563357368, events = 8, fd = 563356944, user_data = 0x0}, {pos = 1755328520, events = 14362, fd = 33, user_data = 0x8219426a0}, {pos = -538477449, events = 12581, fd = 1755328520, user_data = 0x381a68a03408}, {pos = 1755330568, events = 14362, fd = 1755331592, user_data = 0x381a68a07008}, {pos = 1755345928, events = 14362, fd = 1755346952, user_data = 0x381a68a07c08}, {pos = 1755349000, events = 14362, fd = 1755350024, user_data = 0x381a68a08808}, {pos = 1755352072, events = 14362, fd = 1755353096, user_data = 0x381a68a09408}, {pos = 1755355144, events = 14362, fd = 1755356168, user_data = 0x381a68a0a008}, {pos = 1755358216, events = 14362, fd = 1755359240, user_data = 0x381a68a0ac08}, {pos = 1755361288, events = 14362, fd = 1755362312, user_data = 0x381a68a0b808}, {pos = 1755364360, events = 14362, fd = 1755365384, user_data = 0x381a68a0c408}, {pos = 1755367432, events = 14362, fd = 1755368456, user_data = 0x381a68a0e008}, {pos = 1755374600, events = 14362, fd = 1755375624, user_data = 0x381a68a0ec08}, {pos = 1755386888, events = 14362, fd = 332352000, user_data = 0x381a68a03008}, {pos = 2735915, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1755381840, events = 14362, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 563357544, user_data = 0x821942510}, {pos = 33, events = 33, fd = 1755328520, user_data = 0x378}, {pos = 2113896, events = 0, fd = 296, user_data = 0x381a68a10050}, {pos = 563357520, events = 8, fd = -538478719, user_data = 0x381a68e31000}, {pos = 2735915, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1755381840, events = 14362, fd = 1, user_data = 0x381a68a0a408}, {pos = 12579040, events = 0, fd = 726748944, user_data = 0x381a68a03008}, {pos = 2840000, events = 0, fd = 689972409, user_data = 0x1}, {pos = 1759584256, events = 14362, fd = 563357520, user_data = 0x829201642}, {pos = 726748944, events = 8, fd = 12579040, user_data = 0x82b514f10 }, {pos = 1755358216, events = 14362, fd = 563357744, user_data = 0x3125dfe77574}, {pos = 563357600, events = 8, fd = 1, user_data = 0x3125dfe773ee}, {pos = 1755328520, events = 14362, fd = 563357528, user_data = 0x821942830}, {pos = 6792, events = 0, fd = 12, user_data = 0x3125dfe8b3a0}, {pos = 0, events = 0, fd = 1759642495, user_data = 0xc1c650 }, {pos = 563357664, events = 8, fd = 689931616, user_data = 0x82b5b94b0 <__thr_jtable>}, {pos = 727431072, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 563357712, events = 8, fd = 689931616, user_data = 0x82b5b94b0 <__thr_jtable>}, {pos = 727431072, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 563357760, events = 8, fd = 689974013, user_data = 0x381a68e12000}, {pos = 27238, events = 0, fd = 563357856, user_data = 0x8291fa9ea}} [01:32:52.772] last_touch_time = 1755221101 [01:32:52.772] last_lockfile_recheck_time = 1755221281 [01:32:52.772] nevents = 1 [01:32:52.772] #35 0x00000000008c381a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821942eb8) at ../src/backend/postmaster/postmaster.c:1400 [01:32:52.772] userDoption = [01:32:52.772] listen_addr_saved = false [01:32:52.772] output_config_variable = [01:32:52.772] opt = [01:32:52.772] status = [01:32:52.772] #36 0x00000000007f5630 in main (argc=4, argv=0x821942eb8) at ../src/backend/main/main.c:231 [01:32:52.772] do_check_root = [01:32:52.772] dispatch_option = DISPATCH_POSTMASTER