[07:57:13.328] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [07:57:13.605] dumping /tmp/cores/postgres.79133.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:57:13.725] [New LWP 101976] [07:57:13.806] Core was generated by `postgres: postgres regression [local] EXPLAIN'. [07:57:13.806] Program terminated with signal SIGABRT, Aborted. [07:57:13.806] Sent by thr_kill() from pid 79133 and user 1002. [07:57:13.806] #0 0x000000082b6b91ba in thr_kill () from /lib/libc.so.7 [07:57:13.883] [07:57:13.883] Thread 1 (LWP 101976): [07:57:13.883] #0 0x000000082b6b91ba in thr_kill () from /lib/libc.so.7 [07:57:13.883] No symbol table info available. [07:57:13.883] #1 0x000000082b6325d4 in raise () from /lib/libc.so.7 [07:57:13.883] No symbol table info available. [07:57:13.883] #2 0x000000082b6e5b59 in abort () from /lib/libc.so.7 [07:57:13.883] No symbol table info available. [07:57:13.883] #3 0x0000000000ad9a15 in ExceptionalCondition (conditionName=0x368371 "n >= 0 && n < list->length", fileName=, lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [07:57:13.883] No locals. [07:57:13.883] #4 0x000000000085d4c6 in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [07:57:13.883] No locals. [07:57:13.883] #5 list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [07:57:13.883] No locals. [07:57:13.883] #6 0x000000000085d41b in var_is_nonnullable (root=0x183ddf496478, var=var@entry=0x183ddfcd9900, use_rel_info=false) at ../src/backend/optimizer/util/clauses.c:4235 [07:57:13.883] rte = [07:57:13.883] notnullattnums = 0x0 [07:57:13.883] #7 0x000000000085cd8d in eval_const_expressions_mutator (node=0x183ddfcd9880, context=) at ../src/backend/optimizer/util/clauses.c:3556 [07:57:13.883] varg = 0x183ddfcd9900 [07:57:13.883] result = [07:57:13.883] ntest = 0x183ddfcd9880 [07:57:13.883] arg = 0x183ddfcd9900 [07:57:13.883] newntest = [07:57:13.883] #8 0x000000000085f478 in simplify_and_arguments (args=, context=context@entry=0x8212c0228, haveNull=haveNull@entry=0x8212c01d0, forceFalse=forceFalse@entry=0x8212c01e4) at ../src/backend/optimizer/util/clauses.c:3964 [07:57:13.883] arg = 0x183ddfcd9880 [07:57:13.883] newargs = 0x183ddfcd9a90 [07:57:13.883] unprocessed_args = 0x0 [07:57:13.883] #9 0x000000000085cc93 in eval_const_expressions_mutator (node=0x183ddfcd96c0, context=) at ../src/backend/optimizer/util/clauses.c:2877 [07:57:13.883] haveNull = false [07:57:13.883] forceFalse = false [07:57:13.883] newargs = [07:57:13.883] expr = 0x183ddfcd96c0 [07:57:13.883] #10 0x000000000085bccb in eval_const_expressions (root=root@entry=0x183ddf496478, node=0x0, node@entry=0x183ddfcd96c0) at ../src/backend/optimizer/util/clauses.c:2272 [07:57:13.883] context = {boundParams = , root = 0x183ddf496478, active_fns = 0x0, case_val = 0x0, estimate = false} [07:57:13.883] #11 0x000000000084c6cf in convert_EXISTS_sublink_to_join (root=0x183ddf496478, sublink=, under_not=false, available_rels=available_rels@entry=0x183ddf496a58) at ../src/backend/optimizer/plan/subselect.c:1541 [07:57:13.883] je = [07:57:13.883] lc__state = {l = 0x183ddfcd9670, i = 0} [07:57:13.883] subroot = {type = T_Invalid, parse = 0xae9309 , glob = 0x2d9a65, query_level = 0, parent_root = 0x183ddf56f100, plan_params = 0x183ddf570a48, outer_params = 0x200c1bb20, simple_rel_array = 0x0, simple_rel_array_size = -547950336, simple_rte_array = 0x183ddf56f190, append_rel_array = 0x200000014, all_baserels = 0x0, outer_join_rels = 0x637ad655212c03b0, all_query_rels = 0x183ddf56f190, join_rel_list = 0x14, join_rel_hash = 0x183ddf570a48, join_rel_level = 0x8212c03d0, join_cur_level = 1024636392, init_plans = 0x1, cte_plan_ids = 0x1, multiexpr_params = 0x8212c0340, join_domains = 0xabd288 , eq_classes = 0xc1bb90 , ec_merging_done = false, canon_pathkeys = 0x183ddf4968d8, left_join_clauses = 0x0, right_join_clauses = 0x8212c0360, full_join_clauses = 0x53, join_info_list = 0x8212c03c0, last_rinfo_serial = 11418660, all_result_relids = 0x618260 , leaf_result_relids = 0xae959e , append_rel_list = 0x2, row_identity_vars = 0x0, rowMarks = 0x183ddf430c00, placeholder_list = 0x183ddf5cca90, placeholder_array = 0x183ddf5ccfa8, placeholder_array_size = 556532752, fkey_list = 0x183ddf573100, query_pathkeys = 0x53, group_pathkeys = 0x1212c0400, num_groupby_pathkeys = 0, window_pathkeys = 0x80c3fad5212c03e0, distinct_pathkeys = 0x0, sort_pathkeys = 0x4, setop_pathkeys = 0x183ddf5cca48, part_schemes = 0x183ddf4968d8, initial_rels = 0x0, upper_rels = {0xa9ef, 0x0, 0x8212c0590, 0xacb960 , 0x3000100000000, 0x3b600000000, 0xa3f0c0 , 0x10002000000b8}, upper_targets = {0x2, 0x0, 0x183ddf430c00, 0x0, 0xa9ef, 0x5000500000000, 0x3b600000000, 0x9f2430 }, processed_groupClause = 0x1000200000092, processed_distinctClause = 0x2, processed_tlist = 0x0, update_colnos = 0x183ddf430c00, grouping_map = 0x0, minmax_aggs = 0x0, planner_cxt = 0x3000900000000, total_table_pages = 5.6525581178333468e-317, tuple_fraction = 5.3082412989183529e-317, limit_tuples = 1.3907136014837293e-309, qual_security_level = 556532994, hasJoinRTEs = 8, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 9, placeholdersFrozen = 147, hasRecursion = 174, group_rtindex = 0, agginfos = 0x183ddf430c00, aggtransinfos = 0x0, numOrderedAggs = -547950336, hasNonPartialAggs = 61, hasNonSerialAggs = 24, wt_param_id = 556533220, non_recursive_path = 0x0, curOuterRels = 0x8212c0578, curOuterParams = 0x183ddfca0100, isAltSubplan = 0x183ddf56f190, isUsedSubplan = 0x100000014, join_search_private = 0x0, partColsUpdated = 2, partPruneInfos = 0x183ddfca0190} [07:57:13.883] parse = 0x183ddfcc7248 [07:57:13.883] subselect = 0x183ddfc390c8 [07:57:13.883] newWhere = 0x0 [07:57:13.883] all_clauses = 0x183ddfcd9670 [07:57:13.883] upper_reference_exists = false [07:57:13.883] whereClause = 0x183ddfcd96c0 [07:57:13.883] lc = [07:57:13.883] rtoffset = [07:57:13.883] clause_varnos = [07:57:13.883] upper_varnos = [07:57:13.883] varno = [07:57:13.883] result = [07:57:13.883] #12 0x0000000000853fd2 in pull_up_sublinks_qual_recurse (root=0x18e58, node=0x6, jtlink1=0x183ddf46be20, available_rels1=0x183ddf496a58, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [07:57:13.883] child_rels = 0xb01f3f [07:57:13.883] sublink = 0x6 [07:57:13.883] j = [07:57:13.883] #13 0x0000000000850dc9 in pull_up_sublinks_jointree_recurse (root=root@entry=0x183ddf496478, jtnode=, relids=relids@entry=0x8212c0680) at ../src/backend/optimizer/prep/prepjointree.c:787 [07:57:13.883] leftrelids = 0x183ddf496928 [07:57:13.883] rightrelids = 0x183ddf496a58 [07:57:13.883] jtlink = 0x183ddf46be08 [07:57:13.883] j = 0x183ddf46be08 [07:57:13.883] #14 0x0000000000850c75 in pull_up_sublinks_jointree_recurse (root=root@entry=0x183ddf496478, jtnode=0x183ddfcc8258, relids=relids@entry=0x8212c06c0) at ../src/backend/optimizer/prep/prepjointree.c:706 [07:57:13.883] childrelids = 0x3 [07:57:13.883] newchild = [07:57:13.883] l__state = {l = 0x183ddfd03940, i = 0} [07:57:13.883] jtlink = 0x3 [07:57:13.883] frelids = 0x0 [07:57:13.883] newf = [07:57:13.883] f = 0x183ddfcc8258 [07:57:13.883] newfromlist = 0x0 [07:57:13.883] l = 0x82b6b919a [07:57:13.883] #15 0x0000000000850baa in pull_up_sublinks (root=0x18e58, root@entry=0x183ddf496478) at ../src/backend/optimizer/prep/prepjointree.c:653 [07:57:13.883] relids = 0x183ddfcc8258 [07:57:13.883] jtnode = [07:57:13.883] #16 0x000000000083bdba in subquery_planner (glob=glob@entry=0x183ddfc392d8, parse=parse@entry=0x183ddfcc7248, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:757 [07:57:13.883] root = 0x183ddf496478 [07:57:13.883] hasOuterJoins = [07:57:13.883] hasResultRTEs = [07:57:13.883] l = [07:57:13.883] newWithCheckOptions = [07:57:13.883] newHaving = [07:57:13.883] final_rel = [07:57:13.883] #17 0x000000000083b532 in standard_planner (parse=0x183ddfcc7248, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:442 [07:57:13.883] glob = 0x183ddfc392d8 [07:57:13.883] tuple_fraction = [07:57:13.883] root = [07:57:13.883] final_rel = [07:57:13.883] best_path = [07:57:13.883] top_plan = [07:57:13.883] lp = [07:57:13.883] lr = [07:57:13.883] result = [07:57:13.883] #18 0x000000000083b3be in planner (parse=0x18e58, parse@entry=0x183ddfcc7248, query_string=0x6 , query_string@entry=0x183ddf422100 "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=0x82b6b919a , boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:301 [07:57:13.883] result = [07:57:13.883] #19 0x0000000000976d54 in pg_plan_query (querytree=querytree@entry=0x183ddfcc7248, query_string=query_string@entry=0x183ddf422100 "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 [07:57:13.883] plan = [07:57:13.883] #20 0x0000000000700a5a in standard_ExplainOneQuery (query=0x183ddfcc7248, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x183ddfc39038, queryString=0x183ddf422100 "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 [07:57:13.883] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 26654019471944, shared_blks_dirtied = 26654019471944, shared_blks_written = 11542335, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 26654019471944, temp_blks_read = 2, temp_blks_written = 26654026790720, shared_blk_read_time = {ticks = 34916272320}, shared_blk_write_time = {ticks = 6087130}, local_blk_read_time = {ticks = 70368744221167}, local_blk_write_time = {ticks = 26654026790640}, temp_blk_read_time = {ticks = 34916272496}, temp_blk_write_time = {ticks = 9528874}} [07:57:13.883] bufusage = {shared_blks_hit = 266, shared_blks_read = 879904029, shared_blks_dirtied = 4294967288, shared_blks_written = 26654027038465, local_blks_hit = 26654027038600, local_blks_read = 0, local_blks_dirtied = 34916272384, local_blks_written = 7324612, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 26654017785384}, local_blk_read_time = {ticks = 26654026789448}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34916272464}, temp_blk_write_time = {ticks = 11580592}} [07:57:13.883] mem_counters = {nblocks = 34916272240, freechunks = 11542335, totalspace = 240, freespace = 26654019471944} [07:57:13.883] planduration = {ticks = 8355236} [07:57:13.883] planner_ctx = 0x0 [07:57:13.883] saved_ctx = [07:57:13.883] planstart = {ticks = -266879904029} [07:57:13.883] plan = [07:57:13.883] #21 0x0000000000700712 in ExplainOneQuery (query=0x18e58, cursorOptions=2048, into=0x0, es=0x183ddfc39038, pstate=0x183ddf430eb8, params=0x0) at ../src/backend/commands/explain.c:309 [07:57:13.883] No locals. [07:57:13.883] #22 ExplainQuery (pstate=pstate@entry=0x183ddf430eb8, stmt=stmt@entry=0x183ddfcc7218, params=params@entry=0x0, dest=0x183ddf430e28) at ../src/backend/commands/explain.c:223 [07:57:13.883] l__state = {l = , i = 0} [07:57:13.883] l = 0x183ddf46bcb0 [07:57:13.883] es = 0x183ddfc39038 [07:57:13.883] jstate = [07:57:13.883] query = [07:57:13.883] rewritten = 0x183ddf46bc98 [07:57:13.883] tstate = [07:57:13.883] #23 0x000000000097dfc0 in standard_ProcessUtility (pstmt=0x183ddfd04060, queryString=0x183ddf422100 "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=0x183ddf430e28, qc=0x8212c0b18) at ../src/backend/tcop/utility.c:866 [07:57:13.883] isAtomicContext = false [07:57:13.883] parsetree = 0x183ddfcc7218 [07:57:13.883] readonly_flags = [07:57:13.883] pstate = 0x183ddf430eb8 [07:57:13.883] isTopLevel = [07:57:13.883] #24 0x000000000097dc58 in ProcessUtility (pstmt=0x18e58, queryString=0x6 , readOnlyTree=, context=728469914, params=0x0, queryEnv=0x0, dest=0x183ddf430e28, qc=0x8212c0b18) at ../src/backend/tcop/utility.c:523 [07:57:13.883] No locals. [07:57:13.883] #25 0x000000000097d78c in PortalRunUtility (portal=portal@entry=0x183ddf578100, pstmt=0x183ddfd04060, isTopLevel=, setHoldSnapshot=true, dest=dest@entry=0x183ddf430e28, qc=qc@entry=0x8212c0b18) at ../src/backend/tcop/pquery.c:1153 [07:57:13.883] No locals. [07:57:13.883] #26 0x000000000097c9ca in FillPortalStore (portal=portal@entry=0x183ddf578100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [07:57:13.883] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:13.883] treceiver = 0x183ddf430e28 [07:57:13.883] #27 0x000000000097c704 in PortalRun (portal=portal@entry=0x183ddf578100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x183ddfd041c0, altdest=altdest@entry=0x183ddfd041c0, qc=qc@entry=0x8212c0c50) at ../src/backend/tcop/pquery.c:760 [07:57:13.883] _local_sigjmp_buf = {{_sjb = {9946789, 26654019125504, 34916272968, 34916273216, 34916272976, 12687592, 34916273232, 12614536, 12583807, 0, 26654019093375, 26650272071680}}} [07:57:13.883] _save_exception_stack = 0x8212c0d00 [07:57:13.883] _save_context_stack = 0x0 [07:57:13.883] _do_rethrow = false [07:57:13.883] saveTopTransactionResourceOwner = 0x183ddf587708 [07:57:13.883] saveTopTransactionContext = 0x183ddf5e8000 [07:57:13.883] saveActivePortal = 0x0 [07:57:13.883] saveResourceOwner = 0x183ddf587708 [07:57:13.883] savePortalContext = 0x0 [07:57:13.883] saveMemoryContext = 0x183ddf5e8000 [07:57:13.883] result = [07:57:13.883] nprocessed = [07:57:13.883] #28 0x000000000097b569 in exec_simple_query (query_string=query_string@entry=0x183ddf422100 "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 [07:57:13.883] cmdtaglen = 7 [07:57:13.883] snapshot_set = [07:57:13.883] per_parsetree_context = 0x0 [07:57:13.883] plantree_list = [07:57:13.883] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:13.883] format = 0 [07:57:13.883] parsetree = 0x183ddf57f408 [07:57:13.883] commandTag = [07:57:13.883] cmdtagname = [07:57:13.883] querytree_list = [07:57:13.883] portal = 0x183ddf578100 [07:57:13.883] receiver = 0x183ddfd041c0 [07:57:13.883] parsetree_item__state = {l = 0x183ddf5803c0, i = 0} [07:57:13.883] msec_str = "\000\000\000\000\b", '\000' , "\240\f,!\b\000\000\000UZk+\b\000\000" [07:57:13.883] dest = DestRemote [07:57:13.883] was_logged = [07:57:13.883] oldcontext = 0x183ddf5e8000 [07:57:13.883] parsetree_list = 0x183ddf5803c0 [07:57:13.883] use_implicit_block = false [07:57:13.883] parsetree_item = 0x183ddf5803d8 [07:57:13.883] save_log_statement_stats = [07:57:13.883] #29 0x0000000000978fb5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4763 [07:57:13.883] query_string = 0x183ddf422100 "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"... [07:57:13.883] input_message = {data = 0x183ddf422100 "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} [07:57:13.883] firstchar = [07:57:13.883] local_sigjmp_buf = {{_sjb = {9929643, 34916273408, 34916273400, 34916274000, 12488772, 12488504, 12696376, 12690308, 895, 0, 0, 34359738369}}} [07:57:13.883] send_ready_for_query = false [07:57:13.883] idle_in_transaction_timeout_enabled = false [07:57:13.883] idle_session_timeout_enabled = false [07:57:13.883] #30 0x0000000000973459 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [07:57:13.883] bsdata = [07:57:13.883] #31 0x00000000008c046b in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x8212c19b8, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x8212c19d0) at ../src/backend/postmaster/launch_backend.c:290 [07:57:13.883] pid = [07:57:13.883] #32 0x00000000008c4e38 in BackendStartup (client_sock=0x8212c19d0) at ../src/backend/postmaster/postmaster.c:3590 [07:57:13.883] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809250722930019, fork_started = } [07:57:13.883] bn = 0x183ddf546278 [07:57:13.883] cac = CAC_OK [07:57:13.883] pid = [07:57:13.883] __error = [07:57:13.883] save_errno = [07:57:13.883] __error = [07:57:13.883] __error = [07:57:13.883] #33 ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [07:57:13.883] 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\032,!\b\000\000\000XF\325)\b\000\000\000\032\001\000\000\000\000\000\000\276\316\325)\b", '\000' , "p\032,!\b\000\000\000\264\001\214\000\000\000\000\000\200\032,!\b", '\000' }, salen = 16}} [07:57:13.883] i = 0 [07:57:13.883] now = [07:57:13.883] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 728094092, user_data = 0x0}, {pos = 556538240, events = 8, fd = -548837928, user_data = 0x8212c1810}, {pos = 0, events = 0, fd = 0, user_data = 0x458c4adf2f4fb661}, {pos = 729206272, events = 8, fd = 556536960, user_data = 0x28313b8372cd}, {pos = 727251896, events = 8, fd = 727326876, user_data = 0x8212c1498}, {pos = 556537104, events = 8, fd = 556537008, user_data = 0x28313b8372cd}, {pos = 727248752, events = 8, fd = 727326876, user_data = 0x8212c14c8}, {pos = 556537152, events = 8, fd = 727297476, user_data = 0x82b59adc4}, {pos = 556537072, events = 8, fd = 998470349, user_data = 0x82b593410}, {pos = 727326876, events = 8, fd = 556537096, user_data = 0x8212c1580}, {pos = 727300404, events = 8, fd = 727300404, user_data = 0x183ddf00a408}, {pos = 3, events = 0, fd = 556537200, user_data = 0x28313b8324fb}, {pos = 556537216, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 556537288, user_data = 0x8212c1788}, {pos = 556537264, events = 8, fd = 998468690, user_data = 0x2960ca}, {pos = -553586040, events = 6205, fd = 727266320, user_data = 0x183ddf00a408}, {pos = 556537352, events = 8, fd = 556537800, user_data = 0x8212c15f0}, {pos = 998468690, events = 10289, fd = 2735927, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = -553582512, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x8212c18c8}, {pos = -549386912, events = 3, fd = 556537880, user_data = 0x183ddf00fac8}, {pos = 656, events = 0, fd = 556537800, user_data = 0x8212c1608}, {pos = 556537456, events = 8, fd = 998468299, user_data = 0x8212c1888}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -553582512, events = 6205, fd = 1, user_data = 0x183ddf00a408}, {pos = 727266320, events = 8, fd = 556538056, user_data = 0x8212c1818}, {pos = 556537472, events = 8, fd = 0, user_data = 0x183ddf003008}, {pos = 32, events = 0, fd = 556537856, user_data = 0x28313b830c77}, {pos = -553635832, events = 6205, fd = -553634808, user_data = 0x183ddf003808}, {pos = -553632760, events = 6205, fd = -553619448, user_data = 0x183ddf007408}, {pos = -553617400, events = 6205, fd = -553616376, user_data = 0x183ddf008008}, {pos = -553614328, events = 6205, fd = -553613304, user_data = 0x183ddf008c08}, {pos = -553611256, events = 6205, fd = -553610232, user_data = 0x183ddf009808}, {pos = -553608184, events = 6205, fd = -553607160, user_data = 0x183ddf00a408}, {pos = -553605112, events = 6205, fd = -553604088, user_data = 0x183ddf00b008}, {pos = -553602040, events = 6205, fd = -553601016, user_data = 0x183ddf00bc08}, {pos = -553598968, events = 6205, fd = -553597944, user_data = 0x183ddf00c808}, {pos = -553595896, events = 6205, fd = -553590776, user_data = 0x183ddf00e408}, {pos = -553588728, events = 6205, fd = -553587704, user_data = 0x183ddf003008}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -553582512, events = 6205, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 556538056, user_data = 0x8212c1680}, {pos = 32, events = 32, fd = -553635832, user_data = 0x378}, {pos = 2113896, events = 0, fd = 296, user_data = 0x183ddf010050}, {pos = 556538032, events = 8, fd = 998442881, user_data = 0x183ddf431000}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -553582512, events = 6205, fd = 1, user_data = 0x183ddf00a408}, {pos = 12576192, events = 0, fd = 728461072, user_data = 0x183ddf003008}, {pos = 2840040, events = 0, fd = 701875385, user_data = 0x1}, {pos = -549380096, events = 6205, fd = 556538032, user_data = 0x829d5b642}, {pos = 728461072, events = 8, fd = 12576192, user_data = 0x82b6b6f10 }, {pos = -553606136, events = 6205, fd = 556538256, user_data = 0x28313b830574}, {pos = 556538112, events = 8, fd = 1, user_data = 0x28313b8303ee}, {pos = -553635832, events = 6205, fd = 556538040, user_data = 0x8212c1990}, {pos = 6792, events = 0, fd = 12, user_data = 0x28313b8443a0}, {pos = 0, events = 0, fd = -549321857, user_data = 0xc1bb30 }, {pos = 556538176, events = 8, fd = 701834592, user_data = 0x82b75b4b0 <__thr_jtable>}, {pos = 729143200, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 556538224, events = 8, fd = 701834592, user_data = 0x82b75b4b0 <__thr_jtable>}, {pos = 729143200, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 556538272, events = 8, fd = 701876989, user_data = 0x183ddf412000}, {pos = 7017, events = 0, fd = 556538368, user_data = 0x829d549ea}} [07:57:13.884] last_touch_time = 1755935351 [07:57:13.884] last_lockfile_recheck_time = 1755935471 [07:57:13.884] nevents = 1 [07:57:13.884] #34 0x00000000008c2bef in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8212c2010) at ../src/backend/postmaster/postmaster.c:1403 [07:57:13.884] userDoption = [07:57:13.884] listen_addr_saved = false [07:57:13.884] output_config_variable = [07:57:13.884] opt = [07:57:13.884] status = [07:57:13.884] #35 0x00000000007f5430 in main (argc=8, argv=0x8212c2010) at ../src/backend/main/main.c:231 [07:57:13.884] do_check_root = [07:57:13.884] dispatch_option = DISPATCH_POSTMASTER [07:57:13.891] [07:57:13.891] [07:57:13.891] [07:57:13.938] dumping /tmp/cores/postgres.83581.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:57:14.050] [New LWP 102027] [07:57:14.110] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN'. [07:57:14.110] Program terminated with signal SIGABRT, Aborted. [07:57:14.110] Sent by thr_kill() from pid 83581 and user 1002. [07:57:14.110] #0 0x000000082bdf71ba in thr_kill () from /lib/libc.so.7 [07:57:14.168] [07:57:14.168] Thread 1 (LWP 102027): [07:57:14.168] #0 0x000000082bdf71ba in thr_kill () from /lib/libc.so.7 [07:57:14.168] No symbol table info available. [07:57:14.168] #1 0x000000082bd705d4 in raise () from /lib/libc.so.7 [07:57:14.168] No symbol table info available. [07:57:14.168] #2 0x000000082be23b59 in abort () from /lib/libc.so.7 [07:57:14.168] No symbol table info available. [07:57:14.168] #3 0x0000000000ad9a15 in ExceptionalCondition (conditionName=0x368371 "n >= 0 && n < list->length", fileName=, lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [07:57:14.168] No locals. [07:57:14.168] #4 0x000000000085d4c6 in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [07:57:14.168] No locals. [07:57:14.168] #5 list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [07:57:14.168] No locals. [07:57:14.168] #6 0x000000000085d41b in var_is_nonnullable (root=0x3aab7b69f478, var=var@entry=0x3aab7bee3900, use_rel_info=false) at ../src/backend/optimizer/util/clauses.c:4235 [07:57:14.168] rte = [07:57:14.168] notnullattnums = 0x0 [07:57:14.168] #7 0x000000000085cd8d in eval_const_expressions_mutator (node=0x3aab7bee3880, context=) at ../src/backend/optimizer/util/clauses.c:3556 [07:57:14.168] varg = 0x3aab7bee3900 [07:57:14.168] result = [07:57:14.168] ntest = 0x3aab7bee3880 [07:57:14.168] arg = 0x3aab7bee3900 [07:57:14.168] newntest = [07:57:14.168] #8 0x000000000085f478 in simplify_and_arguments (args=, context=context@entry=0x820ecb5f8, haveNull=haveNull@entry=0x820ecb5a0, forceFalse=forceFalse@entry=0x820ecb5b4) at ../src/backend/optimizer/util/clauses.c:3964 [07:57:14.168] arg = 0x3aab7bee3880 [07:57:14.168] newargs = 0x3aab7bee3a90 [07:57:14.168] unprocessed_args = 0x0 [07:57:14.168] #9 0x000000000085cc93 in eval_const_expressions_mutator (node=0x3aab7bee36c0, context=) at ../src/backend/optimizer/util/clauses.c:2877 [07:57:14.168] haveNull = false [07:57:14.168] forceFalse = false [07:57:14.168] newargs = [07:57:14.168] expr = 0x3aab7bee36c0 [07:57:14.168] #10 0x000000000085bccb in eval_const_expressions (root=root@entry=0x3aab7b69f478, node=0x0, node@entry=0x3aab7bee36c0) at ../src/backend/optimizer/util/clauses.c:2272 [07:57:14.168] context = {boundParams = , root = 0x3aab7b69f478, active_fns = 0x0, case_val = 0x0, estimate = false} [07:57:14.168] #11 0x000000000084c6cf in convert_EXISTS_sublink_to_join (root=0x3aab7b69f478, sublink=, under_not=false, available_rels=available_rels@entry=0x3aab7b69fa58) at ../src/backend/optimizer/plan/subselect.c:1541 [07:57:14.168] je = [07:57:14.168] lc__state = {l = 0x3aab7bee3670, i = 0} [07:57:14.168] subroot = {type = T_Invalid, parse = 0xae9309 , glob = 0x2d9a65, query_level = 0, parent_root = 0x3aab7b71c100, plan_params = 0x3aab7b71da48, outer_params = 0x200c1bb20, simple_rel_array = 0x0, simple_rel_array_size = 2071052544, simple_rte_array = 0x3aab7b71c190, append_rel_array = 0x200000014, all_baserels = 0x0, outer_join_rels = 0x195f4b2b20ecb780, all_query_rels = 0x3aab7b71c190, join_rel_list = 0x14, join_rel_hash = 0x3aab7b71da48, join_rel_level = 0x820ecb7a0, join_cur_level = 1052240224, init_plans = 0x1, cte_plan_ids = 0x1, multiexpr_params = 0x820ecb710, join_domains = 0xabd288 , eq_classes = 0xc1bb90 , ec_merging_done = false, canon_pathkeys = 0x3aab7b69f8d8, left_join_clauses = 0x0, right_join_clauses = 0x820ecb730, full_join_clauses = 0x53, join_info_list = 0x820ecb790, last_rinfo_serial = 11418660, all_result_relids = 0x618260 , leaf_result_relids = 0xae959e , append_rel_list = 0x2, row_identity_vars = 0x0, rowMarks = 0x3aab7b630c00, placeholder_list = 0x3aab7b7d5010, placeholder_array = 0x3aab7b7d5528, placeholder_array_size = 552384480, fkey_list = 0x3aab7b720100, query_pathkeys = 0x53, group_pathkeys = 0x120ecb7d0, num_groupby_pathkeys = 0, window_pathkeys = 0x6e0654b420ecb7b0, distinct_pathkeys = 0x0, sort_pathkeys = 0x4, setop_pathkeys = 0x3aab7b7d4fc8, part_schemes = 0x3aab7b69f8d8, initial_rels = 0x0, upper_rels = {0xa9f6, 0x0, 0x820ecb960, 0xacb960 , 0x3000100000000, 0x3b600000000, 0xa3f0c0 , 0x10002000000b8}, upper_targets = {0x2, 0x0, 0x3aab7b630c00, 0x0, 0xa9f6, 0x5000500000000, 0x3b600000000, 0x9f2430 }, processed_groupClause = 0x1000200000092, processed_distinctClause = 0x2, processed_tlist = 0x0, update_colnos = 0x3aab7b630c00, grouping_map = 0x0, minmax_aggs = 0x0, planner_cxt = 0x3000900000000, total_table_pages = 5.6525581178333468e-317, tuple_fraction = 5.3082412989183529e-317, limit_tuples = 1.3907136014837293e-309, qual_security_level = 552384770, hasJoinRTEs = 8, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 9, placeholdersFrozen = 147, hasRecursion = 174, group_rtindex = 0, agginfos = 0x3aab7b630c00, aggtransinfos = 0x0, numOrderedAggs = 2071052544, hasNonPartialAggs = 171, hasNonSerialAggs = 58, wt_param_id = 552384948, non_recursive_path = 0x0, curOuterRels = 0x820ecb948, curOuterParams = 0x3aab7be25100, isAltSubplan = 0x3aab7b71c190, isUsedSubplan = 0x100000014, join_search_private = 0x0, partColsUpdated = 2, partPruneInfos = 0x3aab7be25190} [07:57:14.168] parse = 0x3aab7bed7148 [07:57:14.168] subselect = 0x3aab7b6790c8 [07:57:14.168] newWhere = 0x0 [07:57:14.168] all_clauses = 0x3aab7bee3670 [07:57:14.168] upper_reference_exists = false [07:57:14.168] whereClause = 0x3aab7bee36c0 [07:57:14.168] lc = [07:57:14.168] rtoffset = [07:57:14.168] clause_varnos = [07:57:14.168] upper_varnos = [07:57:14.168] varno = [07:57:14.168] result = [07:57:14.168] #12 0x0000000000853fd2 in pull_up_sublinks_qual_recurse (root=0x18e8b, node=0x6, jtlink1=0x3aab7b674e20, available_rels1=0x3aab7b69fa58, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [07:57:14.168] child_rels = 0xb01f3f [07:57:14.168] sublink = 0x6 [07:57:14.168] j = [07:57:14.168] #13 0x0000000000850dc9 in pull_up_sublinks_jointree_recurse (root=root@entry=0x3aab7b69f478, jtnode=, relids=relids@entry=0x820ecba50) at ../src/backend/optimizer/prep/prepjointree.c:787 [07:57:14.168] leftrelids = 0x3aab7b69f928 [07:57:14.168] rightrelids = 0x3aab7b69fa58 [07:57:14.168] jtlink = 0x3aab7b674e08 [07:57:14.168] j = 0x3aab7b674e08 [07:57:14.168] #14 0x0000000000850c75 in pull_up_sublinks_jointree_recurse (root=root@entry=0x3aab7b69f478, jtnode=0x3aab7bed8158, relids=relids@entry=0x820ecba90) at ../src/backend/optimizer/prep/prepjointree.c:706 [07:57:14.168] childrelids = 0x3 [07:57:14.168] newchild = [07:57:14.168] l__state = {l = 0x3aab7bf124c0, i = 0} [07:57:14.168] jtlink = 0x3 [07:57:14.168] frelids = 0x0 [07:57:14.168] newf = [07:57:14.168] f = 0x3aab7bed8158 [07:57:14.168] newfromlist = 0x0 [07:57:14.168] l = 0x82bdf719a [07:57:14.168] #15 0x0000000000850baa in pull_up_sublinks (root=0x18e8b, root@entry=0x3aab7b69f478) at ../src/backend/optimizer/prep/prepjointree.c:653 [07:57:14.168] relids = 0x3aab7bed8158 [07:57:14.168] jtnode = [07:57:14.168] #16 0x000000000083bdba in subquery_planner (glob=glob@entry=0x3aab7b6792d8, parse=parse@entry=0x3aab7bed7148, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:757 [07:57:14.168] root = 0x3aab7b69f478 [07:57:14.168] hasOuterJoins = [07:57:14.168] hasResultRTEs = [07:57:14.168] l = [07:57:14.168] newWithCheckOptions = [07:57:14.168] newHaving = [07:57:14.168] final_rel = [07:57:14.168] #17 0x000000000083b532 in standard_planner (parse=0x3aab7bed7148, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:442 [07:57:14.168] glob = 0x3aab7b6792d8 [07:57:14.168] tuple_fraction = [07:57:14.168] root = [07:57:14.168] final_rel = [07:57:14.168] best_path = [07:57:14.168] top_plan = [07:57:14.168] lp = [07:57:14.168] lr = [07:57:14.168] result = [07:57:14.168] #18 0x000000000083b3be in planner (parse=0x18e8b, parse@entry=0x3aab7bed7148, query_string=0x6 , query_string@entry=0x3aab7b622100 "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=0x82bdf719a , boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:301 [07:57:14.168] result = [07:57:14.168] #19 0x0000000000976d54 in pg_plan_query (querytree=querytree@entry=0x3aab7bed7148, query_string=query_string@entry=0x3aab7b622100 "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 [07:57:14.168] plan = [07:57:14.168] #20 0x0000000000700a5a in standard_ExplainOneQuery (query=0x3aab7bed7148, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x3aab7b679038, queryString=0x3aab7b622100 "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 [07:57:14.168] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 64508185628616, shared_blks_dirtied = 64508185628616, shared_blks_written = 11542335, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 64508185628616, temp_blks_read = 2, temp_blks_written = 64508192978496, shared_blk_read_time = {ticks = 34912124048}, shared_blk_write_time = {ticks = 6087130}, local_blk_read_time = {ticks = 70381629123062}, local_blk_write_time = {ticks = 64508192978416}, temp_blk_read_time = {ticks = 34912124224}, temp_blk_write_time = {ticks = 9528874}} [07:57:14.168] bufusage = {shared_blks_hit = 281, shared_blks_read = 662409179, shared_blks_dirtied = 4294967288, shared_blks_written = 64508193221121, local_blks_hit = 64508193221384, local_blks_read = 0, local_blks_dirtied = 34912124160, local_blks_written = 7324612, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 64508183907880}, local_blk_read_time = {ticks = 64508192977224}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34912124192}, temp_blk_write_time = {ticks = 11580592}} [07:57:14.168] mem_counters = {nblocks = 34912123968, freechunks = 11542335, totalspace = 240, freespace = 64508185628616} [07:57:14.168] planduration = {ticks = 8355236} [07:57:14.168] planner_ctx = 0x0 [07:57:14.168] saved_ctx = [07:57:14.168] planstart = {ticks = -281662409179} [07:57:14.168] plan = [07:57:14.168] #21 0x0000000000700712 in ExplainOneQuery (query=0x18e8b, cursorOptions=2048, into=0x0, es=0x3aab7b679038, pstate=0x3aab7b630eb8, params=0x0) at ../src/backend/commands/explain.c:309 [07:57:14.168] No locals. [07:57:14.168] #22 ExplainQuery (pstate=pstate@entry=0x3aab7b630eb8, stmt=stmt@entry=0x3aab7bed7118, params=params@entry=0x0, dest=0x3aab7b630e28) at ../src/backend/commands/explain.c:223 [07:57:14.168] l__state = {l = , i = 0} [07:57:14.168] l = 0x3aab7b674cb0 [07:57:14.168] es = 0x3aab7b679038 [07:57:14.168] jstate = [07:57:14.168] query = [07:57:14.168] rewritten = 0x3aab7b674c98 [07:57:14.168] tstate = [07:57:14.168] #23 0x000000000097dfc0 in standard_ProcessUtility (pstmt=0x3aab7bf12be0, queryString=0x3aab7b622100 "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=0x3aab7b630e28, qc=0x820ecbee8) at ../src/backend/tcop/utility.c:866 [07:57:14.168] isAtomicContext = false [07:57:14.168] parsetree = 0x3aab7bed7118 [07:57:14.168] readonly_flags = [07:57:14.168] pstate = 0x3aab7b630eb8 [07:57:14.168] isTopLevel = [07:57:14.168] #24 0x000000000097dc58 in ProcessUtility (pstmt=0x18e8b, queryString=0x6 , readOnlyTree=, context=736063898, params=0x0, queryEnv=0x0, dest=0x3aab7b630e28, qc=0x820ecbee8) at ../src/backend/tcop/utility.c:523 [07:57:14.168] No locals. [07:57:14.168] #25 0x000000000097d78c in PortalRunUtility (portal=portal@entry=0x3aab7b724100, pstmt=0x3aab7bf12be0, isTopLevel=, setHoldSnapshot=true, dest=dest@entry=0x3aab7b630e28, qc=qc@entry=0x820ecbee8) at ../src/backend/tcop/pquery.c:1153 [07:57:14.168] No locals. [07:57:14.168] #26 0x000000000097c9ca in FillPortalStore (portal=portal@entry=0x3aab7b724100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [07:57:14.168] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:14.168] treceiver = 0x3aab7b630e28 [07:57:14.168] #27 0x000000000097c704 in PortalRun (portal=portal@entry=0x3aab7b724100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x3aab7bf12d40, altdest=altdest@entry=0x3aab7bf12d40, qc=qc@entry=0x820ecc020) at ../src/backend/tcop/pquery.c:760 [07:57:14.168] _local_sigjmp_buf = {{_sjb = {9946789, 64508184903936, 34912124696, 34912124944, 34912124704, 12687592, 34912124960, 12614536, 12583807, 0, 64508184888191, 64506113818624}}} [07:57:14.168] _save_exception_stack = 0x820ecc0d0 [07:57:14.168] _save_context_stack = 0x0 [07:57:14.168] _do_rethrow = false [07:57:14.168] saveTopTransactionResourceOwner = 0x3aab7b78c958 [07:57:14.168] saveTopTransactionContext = 0x3aab7b7e6000 [07:57:14.168] saveActivePortal = 0x0 [07:57:14.168] saveResourceOwner = 0x3aab7b78c958 [07:57:14.168] savePortalContext = 0x0 [07:57:14.168] saveMemoryContext = 0x3aab7b7e6000 [07:57:14.168] result = [07:57:14.168] nprocessed = [07:57:14.168] #28 0x000000000097b569 in exec_simple_query (query_string=query_string@entry=0x3aab7b622100 "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 [07:57:14.168] cmdtaglen = 7 [07:57:14.168] snapshot_set = [07:57:14.168] per_parsetree_context = 0x0 [07:57:14.168] plantree_list = [07:57:14.168] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:14.168] format = 0 [07:57:14.168] parsetree = 0x3aab7b77f848 [07:57:14.168] commandTag = [07:57:14.168] cmdtagname = [07:57:14.168] querytree_list = [07:57:14.168] portal = 0x3aab7b724100 [07:57:14.168] receiver = 0x3aab7bf12d40 [07:57:14.168] parsetree_item__state = {l = 0x3aab7b780800, i = 0} [07:57:14.168] msec_str = "\000\000\000\000\b", '\000' , "p\300\354 \b\000\000\000U:\337+\b\000\000" [07:57:14.168] dest = DestRemote [07:57:14.168] was_logged = [07:57:14.168] oldcontext = 0x3aab7b7e6000 [07:57:14.168] parsetree_list = 0x3aab7b780800 [07:57:14.168] use_implicit_block = false [07:57:14.168] parsetree_item = 0x3aab7b780818 [07:57:14.168] save_log_statement_stats = [07:57:14.168] #29 0x0000000000978fb5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4763 [07:57:14.168] query_string = 0x3aab7b622100 "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"... [07:57:14.168] input_message = {data = 0x3aab7b622100 "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} [07:57:14.168] firstchar = [07:57:14.168] local_sigjmp_buf = {{_sjb = {9929643, 34912125136, 34912125128, 34912125728, 12488772, 12488504, 12696376, 12690308, 895, 0, 0, 64506113818625}}} [07:57:14.168] send_ready_for_query = false [07:57:14.168] idle_in_transaction_timeout_enabled = false [07:57:14.168] idle_session_timeout_enabled = false [07:57:14.168] #30 0x0000000000973459 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [07:57:14.168] bsdata = [07:57:14.168] #31 0x00000000008c046b in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x820eccd88, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x820eccda0) at ../src/backend/postmaster/launch_backend.c:290 [07:57:14.168] pid = [07:57:14.168] #32 0x00000000008c4e38 in BackendStartup (client_sock=0x820eccda0) at ../src/backend/postmaster/postmaster.c:3590 [07:57:14.168] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809250737642164, fork_started = } [07:57:14.168] bn = 0x3aab7b75b128 [07:57:14.168] cac = CAC_OK [07:57:14.168] pid = [07:57:14.168] __error = [07:57:14.168] save_errno = [07:57:14.168] __error = [07:57:14.168] __error = [07:57:14.168] #33 ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [07:57:14.168] 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' , "\316\354 \b\000\000\000Xf\230+\b\000\000\000\006\001\000\000\000\000\000\000\276\356\230+\b", '\000' , "@\316\354 \b\000\000\000\264\001\214\000\000\000\000\000P\316\354 \b", '\000' }, salen = 16}} [07:57:14.168] i = 0 [07:57:14.168] now = [07:57:14.168] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 735688076, user_data = 0x0}, {pos = 552389968, events = 8, fd = 2070541784, user_data = 0x820eccbe0}, {pos = 0, events = 0, fd = 0, user_data = 0xc22ba19bed070091}, {pos = 736800256, events = 8, fd = 552388688, user_data = 0x2b4e999472cd}, {pos = 734845880, events = 8, fd = 734920860, user_data = 0x820ecc868}, {pos = 552388832, events = 8, fd = 552388736, user_data = 0x2b4e999472cd}, {pos = 734842736, events = 8, fd = 734920860, user_data = 0x820ecc898}, {pos = 552388880, events = 8, fd = 734891460, user_data = 0x82bcd8dc4}, {pos = 552388800, events = 8, fd = -1718324531, user_data = 0x82bcd1410}, {pos = 734920860, events = 8, fd = 552388824, user_data = 0x820ecc950}, {pos = 734894388, events = 8, fd = 734894388, user_data = 0x3aab7b20a408}, {pos = 3, events = 0, fd = 552388928, user_data = 0x2b4e999424fb}, {pos = 552388944, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 552389016, user_data = 0x820eccb58}, {pos = 552388992, events = 8, fd = -1718326190, user_data = 0x2960ca}, {pos = 2065756808, events = 15019, fd = 734860304, user_data = 0x3aab7b20a408}, {pos = 552389080, events = 8, fd = 552389528, user_data = 0x820ecc9c0}, {pos = -1718326190, events = 11086, fd = 2735927, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 2065760336, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x820eccc98}, {pos = 2069956032, events = 3, fd = 552389608, user_data = 0x3aab7b20fac8}, {pos = 656, events = 0, fd = 552389528, user_data = 0x820ecc9d8}, {pos = 552389184, events = 8, fd = -1718326581, user_data = 0x820eccc58}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 2065760336, events = 15019, fd = 1, user_data = 0x3aab7b20a408}, {pos = 734860304, events = 8, fd = 552389784, user_data = 0x820eccbe8}, {pos = 552389200, events = 8, fd = 0, user_data = 0x3aab7b203008}, {pos = 32, events = 0, fd = 552389584, user_data = 0x2b4e99940c77}, {pos = 2065707016, events = 15019, fd = 2065708040, user_data = 0x3aab7b203808}, {pos = 2065710088, events = 15019, fd = 2065723400, user_data = 0x3aab7b207408}, {pos = 2065725448, events = 15019, fd = 2065726472, user_data = 0x3aab7b208008}, {pos = 2065728520, events = 15019, fd = 2065729544, user_data = 0x3aab7b208c08}, {pos = 2065731592, events = 15019, fd = 2065732616, user_data = 0x3aab7b209808}, {pos = 2065734664, events = 15019, fd = 2065735688, user_data = 0x3aab7b20a408}, {pos = 2065737736, events = 15019, fd = 2065738760, user_data = 0x3aab7b20b008}, {pos = 2065740808, events = 15019, fd = 2065741832, user_data = 0x3aab7b20bc08}, {pos = 2065743880, events = 15019, fd = 2065744904, user_data = 0x3aab7b20c808}, {pos = 2065746952, events = 15019, fd = 2065752072, user_data = 0x3aab7b20e408}, {pos = 2065754120, events = 15019, fd = 2065755144, user_data = 0x3aab7b203008}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 2065760336, events = 15019, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 552389784, user_data = 0x820ecca50}, {pos = 32, events = 32, fd = 2065707016, user_data = 0x378}, {pos = 2113896, events = 0, fd = 296, user_data = 0x3aab7b210050}, {pos = 552389760, events = 8, fd = -1718351999, user_data = 0x3aab7b631000}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 2065760336, events = 15019, fd = 1, user_data = 0x3aab7b20a408}, {pos = 12576192, events = 0, fd = 736055056, user_data = 0x3aab7b203008}, {pos = 2840040, events = 0, fd = 731440313, user_data = 0x1}, {pos = 2069962752, events = 15019, fd = 552389760, user_data = 0x82b98d642}, {pos = 736055056, events = 8, fd = 12576192, user_data = 0x82bdf4f10 }, {pos = 2065736712, events = 15019, fd = 552389984, user_data = 0x2b4e99940574}, {pos = 552389840, events = 8, fd = 1, user_data = 0x2b4e999403ee}, {pos = 2065707016, events = 15019, fd = 552389768, user_data = 0x820eccd60}, {pos = 6792, events = 0, fd = 12, user_data = 0x2b4e999543a0}, {pos = 0, events = 0, fd = 2070020991, user_data = 0xc1bb30 }, {pos = 552389904, events = 8, fd = 731399520, user_data = 0x82be994b0 <__thr_jtable>}, {pos = 736737184, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 552389952, events = 8, fd = 731399520, user_data = 0x82be994b0 <__thr_jtable>}, {pos = 736737184, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 552390000, events = 8, fd = 731441917, user_data = 0x3aab7b612000}, {pos = 7347, events = 0, fd = 552390096, user_data = 0x82b9869ea}} [07:57:14.168] last_touch_time = 1755935353 [07:57:14.168] last_lockfile_recheck_time = 1755935533 [07:57:14.168] nevents = 1 [07:57:14.168] #34 0x00000000008c2bef in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820ecd3e0) at ../src/backend/postmaster/postmaster.c:1403 [07:57:14.168] userDoption = [07:57:14.168] listen_addr_saved = false [07:57:14.168] output_config_variable = [07:57:14.168] opt = [07:57:14.168] status = [07:57:14.168] #35 0x00000000007f5430 in main (argc=4, argv=0x820ecd3e0) at ../src/backend/main/main.c:231 [07:57:14.168] do_check_root = [07:57:14.168] dispatch_option = DISPATCH_POSTMASTER [07:57:14.175] [07:57:14.175] [07:57:14.175] [07:57:14.224] dumping /tmp/cores/postgres.9168.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:57:14.337] [New LWP 101962] [07:57:14.399] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN'. [07:57:14.399] Program terminated with signal SIGABRT, Aborted. [07:57:14.399] Sent by thr_kill() from pid 9168 and user 1002. [07:57:14.399] #0 0x00000008293d61ba in thr_kill () from /lib/libc.so.7 [07:57:14.464] [07:57:14.464] Thread 1 (LWP 101962): [07:57:14.464] #0 0x00000008293d61ba in thr_kill () from /lib/libc.so.7 [07:57:14.464] No symbol table info available. [07:57:14.464] #1 0x000000082934f5d4 in raise () from /lib/libc.so.7 [07:57:14.464] No symbol table info available. [07:57:14.464] #2 0x0000000829402b59 in abort () from /lib/libc.so.7 [07:57:14.464] No symbol table info available. [07:57:14.464] #3 0x0000000000ad9a15 in ExceptionalCondition (conditionName=0x368371 "n >= 0 && n < list->length", fileName=, lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [07:57:14.464] No locals. [07:57:14.464] #4 0x000000000085d4c6 in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [07:57:14.464] No locals. [07:57:14.464] #5 list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [07:57:14.464] No locals. [07:57:14.464] #6 0x000000000085d41b in var_is_nonnullable (root=0x3e6cde098ad8, var=var@entry=0x3e6cde8c2f68, use_rel_info=false) at ../src/backend/optimizer/util/clauses.c:4235 [07:57:14.464] rte = [07:57:14.464] notnullattnums = 0x0 [07:57:14.464] #7 0x000000000085cd8d in eval_const_expressions_mutator (node=0x3e6cde8c2ee8, context=) at ../src/backend/optimizer/util/clauses.c:3556 [07:57:14.464] varg = 0x3e6cde8c2f68 [07:57:14.464] result = [07:57:14.464] ntest = 0x3e6cde8c2ee8 [07:57:14.464] arg = 0x3e6cde8c2f68 [07:57:14.464] newntest = [07:57:14.464] #8 0x000000000085f478 in simplify_and_arguments (args=, context=context@entry=0x820ebba48, haveNull=haveNull@entry=0x820ebb9f0, forceFalse=forceFalse@entry=0x820ebba04) at ../src/backend/optimizer/util/clauses.c:3964 [07:57:14.464] arg = 0x3e6cde8c2ee8 [07:57:14.464] newargs = 0x3e6cde8c30f8 [07:57:14.464] unprocessed_args = 0x0 [07:57:14.464] #9 0x000000000085cc93 in eval_const_expressions_mutator (node=0x3e6cde8c2d28, context=) at ../src/backend/optimizer/util/clauses.c:2877 [07:57:14.464] haveNull = false [07:57:14.464] forceFalse = false [07:57:14.464] newargs = [07:57:14.464] expr = 0x3e6cde8c2d28 [07:57:14.464] #10 0x000000000085bccb in eval_const_expressions (root=root@entry=0x3e6cde098ad8, node=0x0, node@entry=0x3e6cde8c2d28) at ../src/backend/optimizer/util/clauses.c:2272 [07:57:14.464] context = {boundParams = , root = 0x3e6cde098ad8, active_fns = 0x0, case_val = 0x0, estimate = false} [07:57:14.464] #11 0x000000000084c6cf in convert_EXISTS_sublink_to_join (root=0x3e6cde098ad8, sublink=, under_not=false, available_rels=available_rels@entry=0x3e6cde8c2148) at ../src/backend/optimizer/plan/subselect.c:1541 [07:57:14.464] je = [07:57:14.464] lc__state = {l = 0x3e6cde8c2cd8, i = 0} [07:57:14.464] subroot = {type = T_Invalid, parse = 0xae9309 , glob = 0x2d9a65, query_level = 0, parent_root = 0x3e6cde11a100, plan_params = 0x3e6cde11b9f0, outer_params = 0x200c1bb20, simple_rel_array = 0x0, simple_rel_array_size = -569270016, simple_rte_array = 0x3e6cde11a190, append_rel_array = 0x200000014, all_baserels = 0x0, outer_join_rels = 0x637ad65520ebbbd0, all_query_rels = 0x3e6cde11a190, join_rel_list = 0x14, join_rel_hash = 0x3e6cde11b9f0, join_rel_level = 0x820ebbbf0, join_cur_level = 892442400, init_plans = 0x1, cte_plan_ids = 0x1, multiexpr_params = 0x820ebbb60, join_domains = 0xabd288 , eq_classes = 0xc1bb90 , ec_merging_done = false, canon_pathkeys = 0x3e6cde098f38, left_join_clauses = 0x0, right_join_clauses = 0x820ebbb80, full_join_clauses = 0x53, join_info_list = 0x820ebbbe0, last_rinfo_serial = 11418660, all_result_relids = 0x618260 , leaf_result_relids = 0xae959e , append_rel_list = 0x2, row_identity_vars = 0x0, rowMarks = 0x3e6cde030c00, placeholder_list = 0x3e6cde1b1950, placeholder_array = 0x3e6cde1b1e68, placeholder_array_size = 552320048, fkey_list = 0x3e6cde11e100, query_pathkeys = 0x53, group_pathkeys = 0x120ebbc20, num_groupby_pathkeys = 0, window_pathkeys = 0xf228e3ba20ebbc00, distinct_pathkeys = 0x0, sort_pathkeys = 0x4, setop_pathkeys = 0x3e6cde1b1908, part_schemes = 0x3e6cde098f38, initial_rels = 0x0, upper_rels = {0xa999, 0x0, 0x820ebbdb0, 0xacb960 , 0x3000100000000, 0x3b600000000, 0xa3f0c0 , 0x10002000000b8}, upper_targets = {0x2, 0x0, 0x3e6cde030c00, 0x0, 0xa999, 0x5000500000000, 0x3b600000000, 0x9f2430 }, processed_groupClause = 0x1000200000092, processed_distinctClause = 0x2, processed_tlist = 0x0, update_colnos = 0x3e6cde030c00, grouping_map = 0x0, minmax_aggs = 0x0, planner_cxt = 0x3000900000000, total_table_pages = 5.6525581178333468e-317, tuple_fraction = 5.3082412989183529e-317, limit_tuples = 1.3907136014837293e-309, qual_security_level = 552320258, hasJoinRTEs = 8, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 9, placeholdersFrozen = 147, hasRecursion = 174, group_rtindex = 0, agginfos = 0x3e6cde030c00, aggtransinfos = 0x0, numOrderedAggs = -569270016, hasNonPartialAggs = 108, hasNonSerialAggs = 62, wt_param_id = 552320516, non_recursive_path = 0x0, curOuterRels = 0x820ebbd98, curOuterParams = 0x3e6cde895100, isAltSubplan = 0x3e6cde11a190, isUsedSubplan = 0x100000014, join_search_private = 0x0, partColsUpdated = 2, partPruneInfos = 0x3e6cde895190} [07:57:14.464] parse = 0x3e6cde8bae58 [07:57:14.464] subselect = 0x3e6cde81d0c8 [07:57:14.464] newWhere = 0x0 [07:57:14.464] all_clauses = 0x3e6cde8c2cd8 [07:57:14.464] upper_reference_exists = false [07:57:14.464] whereClause = 0x3e6cde8c2d28 [07:57:14.464] lc = [07:57:14.464] rtoffset = [07:57:14.464] clause_varnos = [07:57:14.464] upper_varnos = [07:57:14.464] varno = [07:57:14.464] result = [07:57:14.464] #12 0x0000000000853fd2 in pull_up_sublinks_qual_recurse (root=0x18e4a, node=0x6, jtlink1=0x3e6cde0985d0, available_rels1=0x3e6cde8c2148, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [07:57:14.464] child_rels = 0xb01f3f [07:57:14.464] sublink = 0x6 [07:57:14.464] j = [07:57:14.464] #13 0x0000000000850dc9 in pull_up_sublinks_jointree_recurse (root=root@entry=0x3e6cde098ad8, jtnode=, relids=relids@entry=0x820ebbea0) at ../src/backend/optimizer/prep/prepjointree.c:787 [07:57:14.464] leftrelids = 0x3e6cde098f88 [07:57:14.464] rightrelids = 0x3e6cde8c2148 [07:57:14.464] jtlink = 0x3e6cde0985b8 [07:57:14.464] j = 0x3e6cde0985b8 [07:57:14.464] #14 0x0000000000850c75 in pull_up_sublinks_jointree_recurse (root=root@entry=0x3e6cde098ad8, jtnode=0x3e6cde8bbb98, relids=relids@entry=0x820ebbee0) at ../src/backend/optimizer/prep/prepjointree.c:706 [07:57:14.464] childrelids = 0x3 [07:57:14.464] newchild = [07:57:14.464] l__state = {l = 0x3e6cde8d79d8, i = 0} [07:57:14.464] jtlink = 0x3 [07:57:14.464] frelids = 0x0 [07:57:14.464] newf = [07:57:14.464] f = 0x3e6cde8bbb98 [07:57:14.464] newfromlist = 0x0 [07:57:14.464] l = 0x8293d619a [07:57:14.464] #15 0x0000000000850baa in pull_up_sublinks (root=0x18e4a, root@entry=0x3e6cde098ad8) at ../src/backend/optimizer/prep/prepjointree.c:653 [07:57:14.464] relids = 0x3e6cde8bbb98 [07:57:14.464] jtnode = [07:57:14.464] #16 0x000000000083bdba in subquery_planner (glob=glob@entry=0x3e6cde06eea8, parse=parse@entry=0x3e6cde8bae58, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:757 [07:57:14.464] root = 0x3e6cde098ad8 [07:57:14.464] hasOuterJoins = [07:57:14.464] hasResultRTEs = [07:57:14.464] l = [07:57:14.464] newWithCheckOptions = [07:57:14.464] newHaving = [07:57:14.464] final_rel = [07:57:14.464] #17 0x000000000083b532 in standard_planner (parse=parse@entry=0x3e6cde8bae58, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:442 [07:57:14.464] glob = 0x3e6cde06eea8 [07:57:14.464] tuple_fraction = [07:57:14.464] root = [07:57:14.464] final_rel = [07:57:14.464] best_path = [07:57:14.464] top_plan = [07:57:14.464] lp = [07:57:14.464] lr = [07:57:14.464] result = [07:57:14.464] #18 0x0000000834254a07 in pgss_planner (parse=0x3e6cde8bae58, query_string=0x3e6cde022100 "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 [07:57:14.464] _local_sigjmp_buf = {{_sjb = {35234596983, 12687592, 34912059368, 34912059872, 0, 12694397, 12687584, 34912060816, 68637303047039, 83, 4847288528, 0}}} [07:57:14.464] _save_exception_stack = 0x820ebc590 [07:57:14.464] _save_context_stack = 0x0 [07:57:14.464] _do_rethrow = false [07:57:14.464] result = [07:57:14.464] #19 0x000000000083b3b7 in planner (parse=0x18e4a, parse@entry=0x3e6cde8bae58, query_string=0x6 , query_string@entry=0x3e6cde022100 "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=0x8293d619a , boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:299 [07:57:14.464] result = [07:57:14.464] #20 0x0000000000976d54 in pg_plan_query (querytree=querytree@entry=0x3e6cde8bae58, query_string=query_string@entry=0x3e6cde022100 "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 [07:57:14.464] plan = [07:57:14.464] #21 0x0000000000700a5a in standard_ExplainOneQuery (query=0x3e6cde8bae58, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x3e6cde81d038, queryString=0x3e6cde022100 "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 [07:57:14.464] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 68637303707912, shared_blks_dirtied = 68637303707912, shared_blks_written = 11542335, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 68637303707912, temp_blks_read = 2, temp_blks_written = 68637311087440, shared_blk_read_time = {ticks = 34912060128}, shared_blk_write_time = {ticks = 6087130}, local_blk_read_time = {ticks = 70368744221081}, local_blk_write_time = {ticks = 68637311087360}, temp_blk_read_time = {ticks = 34912060304}, temp_blk_write_time = {ticks = 9528874}} [07:57:14.464] bufusage = {shared_blks_hit = 351, shared_blks_read = 695844815, shared_blks_dirtied = 34912060208, shared_blks_written = 68637302385736, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 68637311086080, 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 = 68637311086168}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34912060272}, temp_blk_write_time = {ticks = 11580592}} [07:57:14.464] mem_counters = {nblocks = 34912060048, freechunks = 11542335, totalspace = 240, freespace = 68637303707912} [07:57:14.464] planduration = {ticks = 8355236} [07:57:14.464] planner_ctx = 0x0 [07:57:14.464] saved_ctx = [07:57:14.464] planstart = {ticks = -351695844815} [07:57:14.464] plan = [07:57:14.464] #22 0x0000000000700712 in ExplainOneQuery (query=0x18e4a, cursorOptions=2048, into=0x0, es=0x3e6cde81d038, pstate=0x3e6cde030eb8, params=0x0) at ../src/backend/commands/explain.c:309 [07:57:14.464] No locals. [07:57:14.464] #23 ExplainQuery (pstate=pstate@entry=0x3e6cde030eb8, stmt=stmt@entry=0x3e6cde8bae28, params=params@entry=0x0, dest=0x3e6cde030e28) at ../src/backend/commands/explain.c:223 [07:57:14.464] l__state = {l = , i = 0} [07:57:14.464] l = 0x3e6cde098460 [07:57:14.464] es = 0x3e6cde81d038 [07:57:14.464] jstate = [07:57:14.464] query = [07:57:14.464] rewritten = 0x3e6cde098448 [07:57:14.464] tstate = [07:57:14.464] #24 0x000000000097dfc0 in standard_ProcessUtility (pstmt=pstmt@entry=0x3e6cde8d80f8, queryString=queryString@entry=0x3e6cde022100 "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=0x3e6cde030e28, qc=0x820ebc6f8) at ../src/backend/tcop/utility.c:866 [07:57:14.464] isAtomicContext = false [07:57:14.464] parsetree = 0x3e6cde8bae28 [07:57:14.464] readonly_flags = [07:57:14.464] pstate = 0x3e6cde030eb8 [07:57:14.464] isTopLevel = [07:57:14.464] #25 0x000000083425518f in pgss_ProcessUtility (pstmt=0x3e6cde8d80f8, queryString=0x3e6cde022100 "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=0x3e6cde030e28, qc=0x820ebc6f8) at ../contrib/pg_stat_statements/pg_stat_statements.c:1181 [07:57:14.464] _local_sigjmp_buf = {{_sjb = {35234599095, 34912060816, 34912060616, 34912061072, 0, 34912061232, 12687592, 351, 12583807, 12696560, 34912061056, 0}}} [07:57:14.464] _save_exception_stack = 0x820ebc730 [07:57:14.464] _save_context_stack = 0x0 [07:57:14.464] _do_rethrow = false [07:57:14.464] bufusage = {shared_blks_hit = 35234599095, shared_blks_read = 34912060816, shared_blks_dirtied = 34912060616, shared_blks_written = 34912061072, local_blks_hit = 0, local_blks_read = 34912061232, local_blks_dirtied = 12687592, local_blks_written = 351, temp_blks_read = 12583807, temp_blks_written = 12696560, shared_blk_read_time = {ticks = 34912061056}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 12696864}, local_blk_write_time = {ticks = 12573400}, temp_blk_read_time = {ticks = 68637311205624}, temp_blk_write_time = {ticks = 1}} [07:57:14.464] walusage_start = {wal_records = 60, wal_fpi = 0, wal_bytes = 6335, wal_buffers_full = 0} [07:57:14.464] duration = [07:57:14.464] bufusage_start = {shared_blks_hit = 6764, shared_blks_read = 131, shared_blks_dirtied = 34, shared_blks_written = 22, 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}} [07:57:14.464] walusage = {wal_records = 0, wal_fpi = 34912060852, wal_bytes = 34912060896, wal_buffers_full = 8399274} [07:57:14.464] start = {ticks = -351695435044} [07:57:14.464] rows = [07:57:14.464] saved_queryId = 3938666771540382425 [07:57:14.464] parsetree = [07:57:14.464] saved_stmt_location = 0 [07:57:14.464] saved_stmt_len = 204 [07:57:14.464] enabled = [07:57:14.464] #26 0x000000000097d78c in PortalRunUtility (portal=portal@entry=0x3e6cde122100, pstmt=0x3e6cde8d80f8, isTopLevel=, setHoldSnapshot=true, dest=dest@entry=0x3e6cde030e28, qc=qc@entry=0x820ebc6f8) at ../src/backend/tcop/pquery.c:1153 [07:57:14.464] No locals. [07:57:14.464] #27 0x000000000097c9ca in FillPortalStore (portal=portal@entry=0x3e6cde122100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [07:57:14.464] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:14.464] treceiver = 0x3e6cde030e28 [07:57:14.464] #28 0x000000000097c704 in PortalRun (portal=portal@entry=0x3e6cde122100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x3e6cde8d8258, altdest=altdest@entry=0x3e6cde8d8258, qc=qc@entry=0x820ebc830) at ../src/backend/tcop/pquery.c:760 [07:57:14.464] _local_sigjmp_buf = {{_sjb = {9946789, 68637303120128, 34912061224, 34912061472, 34912061232, 12687592, 34912061488, 12614536, 12583807, 0, 68637303112575, 68633577390080}}} [07:57:14.464] _save_exception_stack = 0x820ebc8e0 [07:57:14.464] _save_context_stack = 0x0 [07:57:14.464] _do_rethrow = false [07:57:14.464] saveTopTransactionResourceOwner = 0x3e6cde16fb58 [07:57:14.464] saveTopTransactionContext = 0x3e6cde16b000 [07:57:14.464] saveActivePortal = 0x0 [07:57:14.464] saveResourceOwner = 0x3e6cde16fb58 [07:57:14.464] savePortalContext = 0x0 [07:57:14.464] saveMemoryContext = 0x3e6cde16b000 [07:57:14.464] result = [07:57:14.464] nprocessed = [07:57:14.464] #29 0x000000000097b569 in exec_simple_query (query_string=query_string@entry=0x3e6cde022100 "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 [07:57:14.464] cmdtaglen = 7 [07:57:14.464] snapshot_set = [07:57:14.464] per_parsetree_context = 0x0 [07:57:14.464] plantree_list = [07:57:14.464] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:14.464] format = 0 [07:57:14.464] parsetree = 0x3e6cde15cc48 [07:57:14.464] commandTag = [07:57:14.464] cmdtagname = [07:57:14.464] querytree_list = [07:57:14.464] portal = 0x3e6cde122100 [07:57:14.464] receiver = 0x3e6cde8d8258 [07:57:14.464] parsetree_item__state = {l = 0x3e6cde15dc00, i = 0} [07:57:14.464] msec_str = "\000\000\000\000\b", '\000' , "\200\310\353 \b\000\000\000U*=)\b\000\000" [07:57:14.464] dest = DestRemote [07:57:14.464] was_logged = [07:57:14.464] oldcontext = 0x3e6cde16b000 [07:57:14.464] parsetree_list = 0x3e6cde15dc00 [07:57:14.464] use_implicit_block = false [07:57:14.464] parsetree_item = 0x3e6cde15dc18 [07:57:14.464] save_log_statement_stats = [07:57:14.464] #30 0x0000000000978fb5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4763 [07:57:14.464] query_string = 0x3e6cde022100 "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"... [07:57:14.464] input_message = {data = 0x3e6cde022100 "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} [07:57:14.464] firstchar = [07:57:14.464] local_sigjmp_buf = {{_sjb = {9929643, 34912061664, 34912061656, 34912062256, 12488772, 12488504, 12696376, 12690308, 895, 0, 0, 34359738369}}} [07:57:14.464] send_ready_for_query = false [07:57:14.464] idle_in_transaction_timeout_enabled = false [07:57:14.464] idle_session_timeout_enabled = false [07:57:14.464] #31 0x0000000000973459 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [07:57:14.464] bsdata = [07:57:14.464] #32 0x00000000008c046b in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x820ebd598, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x820ebd5b0) at ../src/backend/postmaster/launch_backend.c:290 [07:57:14.464] pid = [07:57:14.464] #33 0x00000000008c4e38 in BackendStartup (client_sock=0x820ebd5b0) at ../src/backend/postmaster/postmaster.c:3590 [07:57:14.464] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809250807756116, fork_started = } [07:57:14.464] bn = 0x3e6cde15bfc8 [07:57:14.464] cac = CAC_OK [07:57:14.464] pid = [07:57:14.464] __error = [07:57:14.464] save_errno = [07:57:14.464] __error = [07:57:14.464] __error = [07:57:14.464] #34 ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [07:57:14.464] 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' , "\020\326\353 \b\000\000\000Xff(\b\000\000\000w\000\000\000\000\000\000\000\276\356f(\b", '\000' , "P\326\353 \b\000\000\000\264\001\214\000\000\000\000\000`\326\353 \b", '\000' }, salen = 16}} [07:57:14.464] i = 0 [07:57:14.464] now = [07:57:14.464] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 691512716, user_data = 0x0}, {pos = 552326496, events = 8, fd = -569801256, user_data = 0x820ebd3f0}, {pos = 0, events = 0, fd = 0, user_data = 0x820ebd050}, {pos = -555908403, events = 15954, fd = 690670520, user_data = 0x8292bf09c}, {pos = 552325224, events = 8, fd = 552325344, user_data = 0x820ebd080}, {pos = -555908403, events = 15954, fd = 690667376, user_data = 0x8292bf09c}, {pos = 552325272, events = 8, fd = 552325392, user_data = 0x8292b7dc4}, {pos = 690716100, events = 8, fd = 552325312, user_data = 0x3e52dedd82cd}, {pos = 690684944, events = 8, fd = 690745500, user_data = 0x820ebd0d8}, {pos = 552325456, events = 8, fd = 690719028, user_data = 0x8292b8934}, {pos = -574577656, events = 15980, fd = 3, user_data = 0x820ebd140}, {pos = -555928325, events = 15954, fd = 552325456, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x820ebd198}, {pos = 552325992, events = 8, fd = 552325504, user_data = 0x3e52dedd7c52}, {pos = 2711754, events = 0, fd = -574556216, user_data = 0x0}, {pos = 0, events = 0, fd = 552325592, user_data = 0x820ebd3a8}, {pos = 552325568, events = 8, fd = -555910062, user_data = 0x29bf37}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x3e6cddc10050}, {pos = 1, events = 8, fd = 0, user_data = 0x0}, {pos = 552326312, events = 8, fd = 1, user_data = 0x820ebd3f8}, {pos = -574556120, events = 15980, fd = 656, user_data = 0x820ebd3a8}, {pos = 552325592, events = 8, fd = 552325696, user_data = 0x3e52dedd7acb}, {pos = 552326248, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -574554032, user_data = 0x1}, {pos = -574577656, events = 15980, fd = 690684944, user_data = 0x820ebd4a8}, {pos = 552326136, events = 8, fd = 552325712, user_data = 0x0}, {pos = -574607352, events = 15980, fd = 33, user_data = 0x820ebd3e0}, {pos = -555934601, events = 15954, fd = -574607352, user_data = 0x3e6cddc03408}, {pos = -574605304, events = 15980, fd = -574604280, user_data = 0x3e6cddc07008}, {pos = -574589944, events = 15980, fd = -574588920, user_data = 0x3e6cddc07c08}, {pos = -574586872, events = 15980, fd = -574585848, user_data = 0x3e6cddc08808}, {pos = -574583800, events = 15980, fd = -574582776, user_data = 0x3e6cddc09408}, {pos = -574580728, events = 15980, fd = -574579704, user_data = 0x3e6cddc0a008}, {pos = -574577656, events = 15980, fd = -574576632, user_data = 0x3e6cddc0ac08}, {pos = -574574584, events = 15980, fd = -574573560, user_data = 0x3e6cddc0b808}, {pos = -574571512, events = 15980, fd = -574570488, user_data = 0x3e6cddc0c408}, {pos = -574568440, events = 15980, fd = -574567416, user_data = 0x3e6cddc0e008}, {pos = -574561272, events = 15980, fd = -574560248, user_data = 0x3e6cddc0ec08}, {pos = -574548984, events = 15980, fd = 447970000, user_data = 0x3e6cddc03008}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -574554032, events = 15980, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 552326312, user_data = 0x820ebd250}, {pos = 33, events = 33, fd = -574607352, user_data = 0x378}, {pos = 2113896, events = 0, fd = 296, user_data = 0x3e6cddc10050}, {pos = 552326288, events = 8, fd = -555935871, user_data = 0x3e6cde031000}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -574554032, events = 15980, fd = 1, user_data = 0x3e6cddc0a408}, {pos = 12576192, events = 0, fd = 691879696, user_data = 0x3e6cddc03008}, {pos = 2840040, events = 0, fd = 677831865, user_data = 0x1}, {pos = -570351616, events = 15980, fd = 552326288, user_data = 0x82866d642}, {pos = 691879696, events = 8, fd = 12576192, user_data = 0x8293d3f10 }, {pos = -574577656, events = 15980, fd = 552326512, user_data = 0x3e52dedd1574}, {pos = 552326368, events = 8, fd = 1, user_data = 0x3e52dedd13ee}, {pos = -574607352, events = 15980, fd = 552326296, user_data = 0x820ebd570}, {pos = 6792, events = 0, fd = 12, user_data = 0x3e52dede53a0}, {pos = 0, events = 0, fd = -570293377, user_data = 0xc1bb30 }, {pos = 552326432, events = 8, fd = 677791072, user_data = 0x8294784b0 <__thr_jtable>}, {pos = 692561824, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 552326480, events = 8, fd = 677791072, user_data = 0x8294784b0 <__thr_jtable>}, {pos = 692561824, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 552326528, events = 8, fd = 677833469, user_data = 0x3e6cde012000}, {pos = 27792, events = 0, fd = 552326624, user_data = 0x8286669ea}} [07:57:14.464] last_touch_time = 1755935397 [07:57:14.464] last_lockfile_recheck_time = 1755935577 [07:57:14.464] nevents = 1 [07:57:14.464] #35 0x00000000008c2bef in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820ebdbf8) at ../src/backend/postmaster/postmaster.c:1403 [07:57:14.464] userDoption = [07:57:14.464] listen_addr_saved = false [07:57:14.464] output_config_variable = [07:57:14.464] opt = [07:57:14.464] status = [07:57:14.464] #36 0x00000000007f5430 in main (argc=4, argv=0x820ebdbf8) at ../src/backend/main/main.c:231 [07:57:14.464] do_check_root = [07:57:14.464] dispatch_option = DISPATCH_POSTMASTER