[Switching to LWP 100397 of process 94545] _poll () at _poll.S:4 #0 _poll () at _poll.S:4 No locals. #1 0x0000000088ef6850 in __thr_poll (fds=0x4, nfds=1, timeout=-1) at /usr/src/lib/libthr/thread/thr_syscalls.c:338 curthread = 0x8f09b000 ret = #2 0x00000000007d3318 in WaitEventSetWaitBlock (set=0x9c1c7a60, cur_timeout=-1, occurred_events=0x80dcac48, nevents=1) at latch.c:1171 returned_events = 0 rc = cur_pollfd = cur_event = errflags = #3 WaitEventSetWait (set=set@entry=0x9c1c7a60, timeout=, timeout@entry=-1, occurred_events=, occurred_events@entry=0x80dcac48, nevents=nevents@entry=1, wait_event_info=, wait_event_info@entry=134217731) at latch.c:1000 rc = start_time = {tv_sec = 24, tv_nsec = 65001} cur_time = {tv_sec = 2161945616, tv_nsec = 8235108} cur_timeout = -1 returned_events = #4 0x00000000007d2f88 in WaitLatchOrSocket (latch=0x9a2dc658, wakeEvents=wakeEvents@entry=1, sock=-1, timeout=-1, wait_event_info=134217731) at latch.c:385 event = {pos = 0, events = 0, fd = -1666879800, user_data = 0x0} ret = 0 set = 0x9c1c7a60 rc = #5 0x00000000007d2e74 in WaitLatch (latch=0x4, wakeEvents=wakeEvents@entry=1, timeout=2297391124, wait_event_info=134217731) at latch.c:339 No locals. #6 0x00000000006b067c in gather_readnext (gatherstate=) at nodeGather.c:367 readerdone = reader = tup = nvisited = 2 readerdone = reader = tup = #7 gather_getnext (gatherstate=0x9c1280b0) at nodeGather.c:256 outerPlan = 0x9c128288 fslot = 0x9ca56ec8 outerTupleSlot = tup = estate = #8 ExecGather (pstate=0x9c1280b0) at nodeGather.c:207 node = 0x9c1280b0 econtext = 0x9c1281c8 slot = #9 0x00000000006a193c in ExecProcNodeInstr (node=0x9c1280b0) at execProcnode.c:462 result = #10 0x00000000006bfd78 in ExecProcNode (node=0x9c1280b0) at ../../../src/include/executor/executor.h:248 No locals. #11 ExecNestLoop (pstate=0x9c127818) at nodeNestloop.c:160 node = 0x9c127818 joinqual = 0x9ca57748 econtext = 0x9c127930 nl = 0x9c142a50 innerPlan = 0x9c1280b0 otherqual = 0x0 outerPlan = 0x9c1279f0 outerTupleSlot = lc = innerTupleSlot = #12 0x00000000006a193c in ExecProcNodeInstr (node=0x9c127818) at execProcnode.c:462 result = #13 0x00000000006ac818 in ExecProcNode (node=0x9c127818) at ../../../src/include/executor/executor.h:248 No locals. #14 fetch_input_tuple (aggstate=aggstate@entry=0x9c127368) at nodeAgg.c:407 slot = #15 0x00000000006aba70 in agg_retrieve_direct (aggstate=0x9c127368) at nodeAgg.c:1843 node = 0x9c142bc0 numGroupingSets = econtext = tmpcontext = 0x9c1275a0 peragg = pergroups = 0x9c1c26d8 firstSlot = 0x9ca590c0 i = numReset = nextSetSize = outerslot = currentSet = result = hasGroupingSets = #16 ExecAgg (pstate=0x9c127368) at nodeAgg.c:1561 node = 0x9c127368 result = 0x0 #17 0x00000000006a193c in ExecProcNodeInstr (node=0x9c127368) at execProcnode.c:462 result = #18 0x000000000069a60c in ExecProcNode (node=0x9c127368) at ../../../src/include/executor/executor.h:248 No locals. #19 ExecutePlan (estate=0x9c127118, use_parallel_mode=, operation=CMD_SELECT, numberTuples=0, direction=, dest=0x97fb18 , planstate=, sendTuples=, execute_once=) at execMain.c:1712 current_tuple_count = 0 slot = #20 standard_ExecutorRun (queryDesc=0x8f163540, direction=, count=0, execute_once=) at execMain.c:353 estate = 0x9c127118 oldcontext = 0x8f22a800 operation = CMD_SELECT dest = 0x97fb18 sendTuples = #21 0x00000000006347ac in ExplainOnePlan (plannedstmt=plannedstmt@entry=0x8f163428, into=into@entry=0x0, es=es@entry=0x8f128130, queryString=queryString@entry=0x8f22a918 "explain (analyze, format 'json') \n select count(*) from join_foo\n left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss\n on join_foo.id < ss.id + 1 and join_foo.id > ss"..., params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, planduration=planduration@entry=0x80dcaff0) at explain.c:536 dir = ForwardScanDirection starttime = {tv_sec = 395092, tv_nsec = 68500214} instrument_option = 1 totaltime = 0 dest = 0x97fb18 queryDesc = 0x8f163540 eflags = #22 0x00000000006341bc in ExplainOneQuery (query=, cursorOptions=256, into=0x0, es=0x8f128130, queryString=0x8f22a918 "explain (analyze, format 'json') \n select count(*) from join_foo\n left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss\n on join_foo.id < ss.id + 1 and join_foo.id > ss"..., params=0x0, queryEnv=0x0) at explain.c:372 planstart = {tv_sec = 395092, tv_nsec = 68233291} planduration = {tv_sec = 0, tv_nsec = 266330} plan = 0x8f163428 #23 0x0000000000633cb4 in ExplainQuery (pstate=, pstate@entry=0x8f128018, stmt=stmt@entry=0x8f22aba8, queryString=queryString@entry=0x8f22a918 "explain (analyze, format 'json') \n select count(*) from join_foo\n left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss\n on join_foo.id < ss.id + 1 and join_foo.id > ss"..., params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=dest@entry=0x8f127f80) at explain.c:255 l = 0x8f13dea0 es = 0x8f128130 summary_set = timing_set = lc = rewritten = tstate = #24 0x0000000000800244 in standard_ProcessUtility (pstmt=0x8f22aa90, queryString=0x8f22a918 "explain (analyze, format 'json') \n select count(*) from join_foo\n left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss\n on join_foo.id < ss.id + 1 and join_foo.id > ss"..., context=PROCESS_UTILITY_QUERY, params=0x0, queryEnv=0x0, dest=0x8f127f80, completionTag=0x80dcb1a0 "") at utility.c:675 parsetree = 0x8f22aba8 isAtomicContext = true pstate = 0x8f128018 isTopLevel = #25 0x00000000007ff924 in PortalRunUtility (portal=portal@entry=0x8f1bb230, pstmt=0x8f22aa90, isTopLevel=false, setHoldSnapshot=true, dest=dest@entry=0x8f127f80, completionTag=completionTag@entry=0x80dcb1a0 "") at pquery.c:1174 No locals. #26 0x00000000007fec5c in FillPortalStore (portal=portal@entry=0x8f1bb230, isTopLevel=false) at pquery.c:1047 completionTag = "\000\263܀\000\000\000\000P\272܀\000\000\000\000\000\220\235\000\000\000\000\000\000@\233\000\000\000\000\000p\263܀\000\000\000\000\374\343\177", '\000' treceiver = 0x8f127f80 #27 0x00000000007ff2d8 in PortalRunFetch (portal=portal@entry=0x8f1bb230, fdirection=fdirection@entry=FETCH_FORWARD, count=count@entry=10, dest=dest@entry=0x97fb98 ) at pquery.c:1463 local_sigjmp_buf = {{_sjb = {39880885831941917714438682368, 39880924773352726868382167600, 10, 39880918575246718101733814816, 190330258725578183311320752, 183735916654108490191290368, 154678752963153796313953328, 0, 0, 0, 0, 43989270866949539691517689856, -34707997198133280150621247941514362848, 41942739273203203019210797888, 43989270866949539689117253632, 44280232689389733756228800640, 2400436224, -34707997198133280150621247945809330176, 177865941328925228504232816, 44289838868259606152884289752, 48275430291761179521354809344, 178356624721285902577218480, 178355148981760005813089368, 44289838868259606152668686896, 48275430291761179518964381272, 131622167545424227749114864, 0, 39880918575246718102190223640, 44271074249892018435664963944, 131637736597422438610678928, 184738976809860520770113536, 0}}} save_exception_stack = 0x80dcba50 save_context_stack = 0x80dcb900 saveActivePortal = 0x8f1bb118 saveResourceOwner = 0x9c1366b0 savePortalContext = 0x8f0c4000 oldContext = 0x9bfc8000 result = #28 0x00000000006ce4e8 in _SPI_cursor_operation (portal=0x8f1bb230, portal@entry=0x1, direction=FETCH_FORWARD, direction@entry=FETCH_BACKWARD, count=10, count@entry=2161948952, dest=0x97fb98 ) at spi.c:2711 nfetched = #29 0x00000000006ce46c in SPI_cursor_fetch (portal=0x4, portal@entry=0x8f1bb230, forward=, count=4294967295) at spi.c:1611 No locals. #30 0x00000000a2b1cd38 in exec_for_query (estate=estate@entry=0x80dcb918, stmt=stmt@entry=0x8f122820, portal=portal@entry=0x8f1bb230, prefetch_ok=) at pl_exec.c:5979 tupdescs_match = true previous_id = 1 rc = 0 found = false var = 0x8f122878 n = tuptab = #31 0x00000000a2b19580 in exec_stmt_dynfors (estate=0x80dcb918, stmt=0x8f122820) at pl_exec.c:4547 portal = 0x8f1bb230 rc = #32 exec_stmt (estate=estate@entry=0x80dcb918, stmt=0x8f122820) at pl_exec.c:2029 rc = -1 save_estmt = 0x8f1735a0 #33 0x00000000a2b15844 in exec_stmts (estate=0x80dcb918, stmts=) at pl_exec.c:1912 stmt = 0x1 rc = s = #34 exec_stmt_block (estate=estate@entry=0x80dcb918, block=0x8f1735a0) at pl_exec.c:1853 rc = -1 i = #35 0x00000000a2b14358 in plpgsql_exec_function (func=func@entry=0x9c133980, fcinfo=fcinfo@entry=0x80dcbd80, simple_eval_estate=, atomic=) at pl_exec.c:597 estate = {func = 0x9c133980, trigdata = 0x0, evtrigdata = 0x0, retval = 0, retisnull = true, rettype = 0, fn_rettype = 2249, retistuple = true, retisset = true, readonly_func = false, atomic = true, exitlabel = 0x0, cur_error = 0x0, tuple_store = 0x0, tuple_store_desc = 0x0, tuple_store_cxt = 0x8f22b000, tuple_store_owner = 0x9c1366b0, rsi = 0x80dcbd10, found_varno = 4, ndatums = 8, datums = 0x8f221170, datum_context = 0x8f221000, paramLI = 0x8f221118, simple_eval_estate = 0x9c0af118, cast_hash = 0x9bfcf118, cast_hash_context = 0x8f27b000, stmt_mcontext = 0x9c10f000, stmt_mcontext_parent = 0x8f221000, eval_tuptable = 0x0, eval_processed = 0, eval_lastoid = 0, eval_econtext = 0x9c0af330, err_stmt = 0x8f122820, err_text = 0x0, plugin_info = 0x0} plerrcontext = {previous = 0x0, callback = 0xa2b149b0 , arg = 0x80dcb918} i = rc = #36 0x00000000a2b0ffcc in plpgsql_call_handler (fcinfo=0x80dcbd80) at pl_handler.c:263 local_sigjmp_buf = {{_sjb = {39880924791465401389011695360, 48302902658775273682146999680, 39880924773352726865981210624, 190341179198069816747360256, 190341031624117227070947328, 39880967864946883051493785600, 50350549173733425359515073632, 0, 0, 0, 0, 171769808921398285562592048, 44269124060108545861860982964, 44269124060108545861860982960, 175619201687723699955613456, 44269124060108545864260818840, 44269124060108545861860982809, 39880947794889330855501627394, 0, 44269124060109390286791114752, 41948354462099240206722710832, 53458707922886809687, 41937478942441387481939531863, 41937468300551581251932044688, 190330258725578180703121408, 39880945138558184243726144104, 18243829888353285701584, -34707997198133280150621247943647380160, 41943067846608643933744184784, 43989270866949539691518675624, 127179601276664609014332560, 190362060912361258121739648}}} save_exception_stack = 0x80dcc370 save_context_stack = 0x0 nonatomic = false rc = func = 0x9c133980 save_cur_estate = 0x0 retval = #37 0x00000000006a2fd4 in ExecMakeTableFunctionResult (setexpr=0x8f22b598, econtext=0x8f22b448, argContext=, expectedDesc=0x8f22c5a0, randomAccess=false) at execSRF.c:231 result = fcinfo = {flinfo = 0x8f22b5b8, context = 0x0, resultinfo = 0x80dcbd10, fncollation = 100, isnull = false, nargs = 1, arg = {2399836504, 2400316024, 2400317744, 2161950728, 2401048280, 16565219775467706455, 2161950288, 2273753640, 2401421992, 2, 2618185728, 16565219775467706455, 2161950288, 2273753680, 2401421992, 2161950432, 2384662656, 2161950376, 2161950320, 7237744, 0, 16565219775467706455, 2161950512, 2273715716, 2618185728, 147, 2161950512, 2273715752, 2400317288, 8192, 936, 8192, 2161950416, 2161950472, 2161950560, 6874480, 2161950832, 2401421992, 18446744067281567488, 4294967295, 4311744512, 0, 2272496949, 2272532888, 1, 2401421992, 8192, 0, 6, 2400510048, 2400510848, 98784247809, 0, 0, 0, 0, 2161950656, 6893288, 2401421992, 2, 2400510016, 2400510848, 2401423184, 2400510048, 0, 2400317248, 2161950832, 2401421992, 2161950896, 6875144, 2400321448, 2401779496, 2618185728, 2400317472, 2401421997, 2401422000, 2161950864, 2616705072, 2161950864, 9379024, 2616705008, 2616705072, 2401096016, 260099453208, 0, 0, 0, 1, 6456918176, 16, 16, 0, 0, 2616705072, 2161950896, 9690020, 2618517168, 2616705072, 2161950928, 9379360}, argnull = {false, 202, 34, 143, false, false, false, false, 240, 191, 247, 155, false, false, false, false, 240, 192, 220, 128, false, false, false, false, 120, 119, 143, false, false, false, false, false, 112, 193, 220, 128, false, false, false, false, 48, 192, 247, 155, false, false, false, false, 112, 193, 220, 128, false, false, false, false, 208, 28, 143, false, false, false, false, false, 240, 191, 247, 155, false, false, false, false, 48, 192, 247, 155, false, false, false, false, 80, 209, 29, 143, false, false, false, false, 184, 198, 34, 143, 60, false, false, false, false, false, false, false}} fcusage = {fs = 0x0, save_f_total_time = {tv_sec = 0, tv_nsec = 2384662656}, save_total = {tv_sec = 2161950096, tv_nsec = 7237244}, f_start = {tv_sec = 2400317744, tv_nsec = 2161950728}} rsinfo = {type = T_ReturnSetInfo, econtext = 0x8f22b448, expectedDesc = 0x8f22c5a0, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} tmptup = {t_len = 2399823208, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 25960}, t_tableOid = 0, t_data = 0x3c8} first_time = returnsSet = tupdesc = 0x0 tupstore = 0x0 callerContext = 0x8f22b000 funcrettype = 2249 oldcontext = returnsTuple = #38 0x00000000006b00e8 in FunctionNext (node=0x8f22b330) at nodeFunctionscan.c:95 tstore = 0x0 estate = scanslot = 0x8f22c7d0 direction = ForwardScanDirection oldpos = funcno = att = alldone = #39 0x00000000006a27b4 in ExecScan (node=0x8f22b330, accessMtd=0x6b008c , recheckMtd=0x6b0320 ) at execScan.c:162 slot = econtext = 0x8f22b448 projInfo = 0x8f22caa0 qual = 0x0 #40 0x000000000069a60c in ExecProcNode (node=0x8f22b330) at ../../../src/include/executor/executor.h:248 No locals. #41 ExecutePlan (estate=0x8f22b118, use_parallel_mode=, operation=CMD_SELECT, numberTuples=0, direction=, dest=0x9c0e5ac0, planstate=, sendTuples=, execute_once=) at execMain.c:1712 current_tuple_count = 0 slot = #42 standard_ExecutorRun (queryDesc=0x8f0c4118, direction=, count=0, execute_once=) at execMain.c:353 estate = 0x8f22b118 oldcontext = 0x8f0c4000 operation = CMD_SELECT dest = 0x9c0e5ac0 sendTuples = #43 0x00000000007fedb8 in PortalRunSelect (portal=portal@entry=0x8f1bb118, forward=, count=0, count@entry=9223372036854775807, dest=dest@entry=0x9c0e5ac0) at pquery.c:941 queryDesc = 0x8f0c4118 direction = nprocessed = #44 0x00000000007fe9ac in PortalRun (portal=portal@entry=0x8f1bb118, count=, isTopLevel=, run_once=, dest=dest@entry=0x9c0e5ac0, altdest=, altdest@entry=0x9c0e5ac0, completionTag=completionTag@entry=0x80dcc600 "") at pquery.c:782 local_sigjmp_buf = {{_sjb = {39880966407320031677760141056, 39880979966010995407360602392, 187685733495171179383451648, 190481374453030011741065216, 190481374453030011501593456, 190481374453030011958158488, 154633964268542829522634112, 0, 0, 0, 0, 190481374453030009349963776, 44278112641986830462506340352, 44278015390752073865739895040, 44278112641986830462496014336, 44278015390752073865750220800, 44278112641986830462506340352, 178417203828823964744729792, 44278112641986830462506340352, 44278112641986830462496014336, 2508757194026898849792, 139742645647600056885101824, 44278112641986830462496014336, 44269156378804163003395729888, 178433289389656239473739056, 178409161048407827380225344, 79418643888717367602887016960, 44289987917951721725845295384, 178402815368446471294469488, 36893488149820526592, 178439708856593890397701520, 18446744076110974976}}} save_exception_stack = 0x80dcc790 save_context_stack = 0x0 saveTopTransactionResourceOwner = 0x8f1a15d8 saveTopTransactionContext = 0x8f0e6000 saveResourceOwner = 0x9c136498 savePortalContext = 0x0 saveActivePortal = 0x0 saveMemoryContext = 0x8f22d000 result = nprocessed = #45 0x00000000007fd9a0 in exec_simple_query (query_string=query_string@entry=0x8f0a8118 "select final > 1 as multibatch\n from hash_join_batches(\n$$\n select count(*) from join_foo\n left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss\n on join_foo.id < ss.i"...) at postgres.c:1144 parsetree = 0x8f0a94d0 portal = 0x8f1bb118 completionTag = "\000\306܀\000\000\000\000p\306܀\000\000\000\000\000@\233\000\000\000\000\000f\"\313c\000\000\000\000`\306܀\000\000\000\000\324\v\222\000\000\000\000\000\000\220\235\000\000\000\000\000XI\233\000\000\000\000" format = 0 commandTag = 0x2d0a4c "SELECT" snapshot_set = querytree_list = plantree_list = receiver = 0x9c0e5ac0 msec_str = "\000\306܀\000\000\000\000p\306܀\000\000\000\000\000@\233\000\000\000\000\000f\"\313c\000\000\000" dest = DestRemote was_logged = oldcontext = 0x8f22d000 parsetree_list = 0x8f0a9530 parsetree_item = 0x8f0a9508 save_log_statement_stats = use_implicit_block = #46 0x00000000007fb804 in PostgresMain (argc=, argv=, dbname=, username=) at postgres.c:4225 query_string = 0x8f0a8118 "select final > 1 as multibatch\n from hash_join_batches(\n$$\n select count(*) from join_foo\n left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss\n on join_foo.id < ss.i"... input_message = {data = 0x8f0a8118 "select final > 1 as multibatch\n from hash_join_batches(\n$$\n select count(*) from join_foo\n left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss\n on join_foo.id < ss.i"..., len = 240, maxlen = 1024, cursor = 240} local_sigjmp_buf = {{_sjb = {39880982935602721721518388993, 151115727451830808790928, 190330258725578180701192192, 190481374453030009349967872, 39880996937015543217747132417, 2158269056626417435296, 154354828137219456587582000, 0, 0, 0, 0, 0, 18446744076094214272, 44270271447589930598356161136, 1, 39880992952518823296483983360, 44287198179951966482935153624, 44287201279004970866139825112, -5321102661161709925256572094123735246, 0, 0, 0, 0, 0, 0, 0, 44270271447589930595971497985, 18446744076109447888, 28074974518220166074500006954603847445, 39880995903997875092174195120, -10061976640049440637326301804240, 41938377208525581068969260040}}} send_ready_for_query = false disable_idle_in_transaction_timeout = firstchar = #47 0x000000000077987c in BackendRun (port=port@entry=0x8f0d01c0) at postmaster.c:4422 usecs = secs = maxac = ac = 4 av = 0x8f19d500 i = #48 0x0000000000778eb0 in BackendStartup (port=0x8f0d01c0) at postmaster.c:4086 bn = 0x8f0b82a0 pid = save_errno = #49 ServerLoop () at postmaster.c:1728 port = 0x8f0d01c0 i = 0 rmask = {__fds_bits = {8, 0 }} selres = now = readmask = {__fds_bits = {8, 0 }} last_lockfile_recheck_time = 1674256910 last_touch_time = 1674256850 nSockets = 4 #50 0x0000000000776444 in PostmasterMain (argc=, argc@entry=3, argv=, argv@entry=0x80dcd580) at postmaster.c:1401 output_config_variable = listen_addr_saved = userDoption = opt = i = status = #51 0x00000000006e57c4 in main (argc=3, argv=0x80dcd580) at main.c:228 do_check_root = A debugging session is active. Inferior 1 [process 94545] will be detached. Quit anyway? (y or n) [answered Y; input not from terminal] [Inferior 1 (process 94545) detached]