analyze.trace

application/octet-stream

Filename: analyze.trace
Type: application/octet-stream
Part: 3
Message: Re: RFC: Logging plan of the running query
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
futex_abstimed_wait_cancelable (private=128, abstime=0x0, clockid=0, expected=0, futex_word=0x7ffa08c716b8) at ../sysdeps/nptl/futex-internal.h:323
#0  futex_abstimed_wait_cancelable (private=128, abstime=0x0, clockid=0, expected=0, futex_word=0x7ffa08c716b8) at ../sysdeps/nptl/futex-internal.h:323
#1  do_futex_wait (sem=sem@entry=0x7ffa08c716b8, abstime=0x0, clockid=0) at sem_waitcommon.c:112
#2  0x00007ffa1431f278 in __new_sem_wait_slow (sem=sem@entry=0x7ffa08c716b8, abstime=0x0, clockid=0) at sem_waitcommon.c:184
#3  0x00007ffa1431f2f1 in __new_sem_wait (sem=sem@entry=0x7ffa08c716b8) at sem_wait.c:42
#4  0x0000559d61cfe5a0 in PGSemaphoreLock (sema=0x7ffa08c716b8) at pg_sema.c:327
#5  0x0000559d61d96ee1 in LWLockAcquire (lock=0x7ffa08c7a980, mode=mode@entry=LW_EXCLUSIVE) at lwlock.c:1314
#6  0x0000559d61d9e83c in CheckDeadLock () at proc.c:1700
#7  0x0000559d61da02b2 in ProcSleep (locallock=locallock@entry=0x559d63013880, lockMethodTable=lockMethodTable@entry=0x559d621f0ca0 <default_lockmethod>) at proc.c:1292
#8  0x0000559d61d90dae in WaitOnLock (locallock=locallock@entry=0x559d63013880, owner=owner@entry=0x559d6307b718) at lock.c:1819
#9  0x0000559d61d927fa in LockAcquireExtended (locktag=locktag@entry=0x7ffec414b870, lockmode=lockmode@entry=3, sessionLock=sessionLock@entry=false, dontWait=dontWait@entry=false, reportMemoryError=reportMemoryError@entry=true, locallockp=locallockp@entry=0x7ffec414b868) at lock.c:1083
#10 0x0000559d61d8ee6e in LockRelationOid (relid=1259, lockmode=3) at lmgr.c:117
#11 0x0000559d619b21c0 in relation_open (relationId=relationId@entry=1259, lockmode=lockmode@entry=3) at relation.c:56
#12 0x0000559d61a52bd3 in table_open (relationId=relationId@entry=1259, lockmode=lockmode@entry=3) at table.c:44
#13 0x0000559d61bb4c17 in vac_update_relstats (relation=relation@entry=0x7ffa08aa1bf8, num_pages=num_pages@entry=35, num_tuples=1000, num_all_visible_pages=35, hasindex=hasindex@entry=true, frozenxid=frozenxid@entry=0, minmulti=minmulti@entry=0, frozenxid_updated=0x0, minmulti_updated=0x0, in_outer_xact=false) at vacuum.c:1438
#14 0x0000559d61b240d8 in do_analyze_rel (onerel=onerel@entry=0x7ffa08aa1bf8, params=params@entry=0x7ffec414bd40, va_cols=va_cols@entry=0x0, acquirefunc=<optimized out>, relpages=35, inh=inh@entry=false, in_outer_xact=false, elevel=13) at analyze.c:640
#15 0x0000559d61b247e3 in analyze_rel (relid=<optimized out>, relation=0x559d62fecfd0, params=params@entry=0x7ffec414bd40, va_cols=0x0, in_outer_xact=<optimized out>, bstrategy=bstrategy@entry=0x559d630db2f0) at analyze.c:262
#16 0x0000559d61bb581d in vacuum (relations=0x559d630db480, params=params@entry=0x7ffec414bd40, bstrategy=0x559d630db2f0, vac_context=vac_context@entry=0x559d630db1f0, isTopLevel=isTopLevel@entry=true) at vacuum.c:639
#17 0x0000559d61bb61fb in ExecVacuum (pstate=pstate@entry=0x559d630daee0, vacstmt=vacstmt@entry=0x559d62fed0a0, isTopLevel=isTopLevel@entry=true) at vacuum.c:449
#18 0x0000559d61db0bde in standard_ProcessUtility (pstmt=0x559d62fed150, queryString=0x559d62fec600 "ANALYZE onek2;", readOnlyTree=<optimized out>, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x559d62fed410, qc=0x7ffec414c0c0) at utility.c:866
#19 0x0000559d61db109a in ProcessUtility (pstmt=pstmt@entry=0x559d62fed150, queryString=<optimized out>, readOnlyTree=<optimized out>, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=<optimized out>, queryEnv=<optimized out>, dest=0x559d62fed410, qc=0x7ffec414c0c0) at utility.c:530
#20 0x0000559d61dae5bd in PortalRunUtility (portal=portal@entry=0x559d630660e0, pstmt=pstmt@entry=0x559d62fed150, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x559d62fed410, qc=qc@entry=0x7ffec414c0c0) at pquery.c:1158
#21 0x0000559d61dae8ae in PortalRunMulti (portal=portal@entry=0x559d630660e0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x559d62fed410, altdest=altdest@entry=0x559d62fed410, qc=qc@entry=0x7ffec414c0c0) at pquery.c:1315
#22 0x0000559d61daec9f in PortalRun (portal=portal@entry=0x559d630660e0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x559d62fed410, altdest=altdest@entry=0x559d62fed410, qc=0x7ffec414c0c0) at pquery.c:791
#23 0x0000559d61daae6d in exec_simple_query (query_string=query_string@entry=0x559d62fec600 "ANALYZE onek2;") at postgres.c:1275
#24 0x0000559d61dacd28 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4641
#25 0x0000559d61d083e0 in BackendRun (port=port@entry=0x559d63016fd0) at postmaster.c:4435
#26 0x0000559d61d0b385 in BackendStartup (port=port@entry=0x559d63016fd0) at postmaster.c:4163
#27 0x0000559d61d0b524 in ServerLoop () at postmaster.c:1777
#28 0x0000559d61d0ca1d in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x559d62fe5bb0) at postmaster.c:1461
#29 0x0000559d61c2a03c in main (argc=8, argv=0x559d62fe5bb0) at main.c:198
[Inferior 1 (process 3243658) detached]