select2.trace

application/octet-stream

Filename: select2.trace
Type: application/octet-stream
Part: 9
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=0x7ffa08c71cb8) at ../sysdeps/nptl/futex-internal.h:323
#0  futex_abstimed_wait_cancelable (private=128, abstime=0x0, clockid=0, expected=0, futex_word=0x7ffa08c71cb8) at ../sysdeps/nptl/futex-internal.h:323
#1  do_futex_wait (sem=sem@entry=0x7ffa08c71cb8, abstime=0x0, clockid=0) at sem_waitcommon.c:112
#2  0x00007ffa1431f278 in __new_sem_wait_slow (sem=sem@entry=0x7ffa08c71cb8, abstime=0x0, clockid=0) at sem_waitcommon.c:184
#3  0x00007ffa1431f2f1 in __new_sem_wait (sem=sem@entry=0x7ffa08c71cb8) at sem_wait.c:42
#4  0x0000559d61cfe5a0 in PGSemaphoreLock (sema=0x7ffa08c71cb8) at pg_sema.c:327
#5  0x0000559d61d96ee1 in LWLockAcquire (lock=0x7ffa08c7aa00, mode=mode@entry=LW_EXCLUSIVE) at lwlock.c:1314
#6  0x0000559d61d9e83c in CheckDeadLock () at proc.c:1700
#7  0x0000559d61da02b2 in ProcSleep (locallock=locallock@entry=0x559d63013720, lockMethodTable=lockMethodTable@entry=0x559d621f0ca0 <default_lockmethod>) at proc.c:1292
#8  0x0000559d61d90dae in WaitOnLock (locallock=locallock@entry=0x559d63013720, owner=owner@entry=0x559d6307a968) at lock.c:1819
#9  0x0000559d61d927fa in LockAcquireExtended (locktag=locktag@entry=0x7ffec414bc10, lockmode=lockmode@entry=1, sessionLock=sessionLock@entry=false, dontWait=dontWait@entry=false, reportMemoryError=reportMemoryError@entry=true, locallockp=locallockp@entry=0x7ffec414bc08) at lock.c:1083
#10 0x0000559d61d8ee6e in LockRelationOid (relid=relid@entry=1259, lockmode=lockmode@entry=1) at lmgr.c:117
#11 0x0000559d61aa920a in RangeVarGetRelidExtended (relation=relation@entry=0x559d62fed450, lockmode=lockmode@entry=1, flags=flags@entry=1, callback=callback@entry=0x0, callback_arg=callback_arg@entry=0x0) at namespace.c:372
#12 0x0000559d619b23ea in relation_openrv_extended (relation=relation@entry=0x559d62fed450, lockmode=lockmode@entry=1, missing_ok=missing_ok@entry=true) at relation.c:186
#13 0x0000559d61a52d97 in table_openrv_extended (relation=relation@entry=0x559d62fed450, lockmode=lockmode@entry=1, missing_ok=missing_ok@entry=true) at table.c:108
#14 0x0000559d61b086af in parserOpenTable (pstate=pstate@entry=0x559d62fee290, relation=relation@entry=0x559d62fed450, lockmode=lockmode@entry=1) at parse_relation.c:1424
#15 0x0000559d61b0c5ec in addRangeTableEntry (pstate=pstate@entry=0x559d62fee290, relation=relation@entry=0x559d62fed450, alias=0x559d62fed4a0, inh=<optimized out>, inFromCl=inFromCl@entry=true) at parse_relation.c:1501
#16 0x0000559d61aeb716 in transformTableEntry (pstate=pstate@entry=0x559d62fee290, r=r@entry=0x559d62fed450) at parse_clause.c:402
#17 0x0000559d61aee3a2 in transformFromClauseItem (pstate=pstate@entry=0x559d62fee290, n=0x559d62fed450, top_nsitem=top_nsitem@entry=0x7ffec414bef0, namespace=namespace@entry=0x7ffec414bef8) at parse_clause.c:1073
#18 0x0000559d61aef43e in transformFromClause (pstate=pstate@entry=0x559d62fee290, frmList=0x559d62fed4d0) at parse_clause.c:135
#19 0x0000559d61acd7d9 in transformSelectStmt (pstate=0x559d62fee290, stmt=stmt@entry=0x559d62fedfa0) at analyze.c:1358
#20 0x0000559d61ace2c2 in transformStmt (pstate=pstate@entry=0x559d62fee290, parseTree=parseTree@entry=0x559d62fedfa0) at analyze.c:371
#21 0x0000559d61acf59a in transformOptionalSelectInto (pstate=pstate@entry=0x559d62fee290, parseTree=0x559d62fedfa0) at analyze.c:306
#22 0x0000559d61acf5d2 in transformTopLevelStmt (pstate=pstate@entry=0x559d62fee290, parseTree=parseTree@entry=0x559d62fee210) at analyze.c:256
#23 0x0000559d61acf640 in parse_analyze_fixedparams (parseTree=parseTree@entry=0x559d62fee210, sourceText=sourceText@entry=0x559d62fec600 "SELECT c.oid::pg_catalog.regclass\nFROM pg_catalog.pg_class c, pg_catalog.pg_inherits i\nWHERE c.oid = i.inhparent AND i.inhrelid = '21111'\n  AND c.relkind != 'p' AND c.relkind != 'I'\nORDER BY inhseqno;", paramTypes=paramTypes@entry=0x0, numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0) at analyze.c:124
#24 0x0000559d61daa5dc in pg_analyze_and_rewrite_fixedparams (parsetree=parsetree@entry=0x559d62fee210, query_string=query_string@entry=0x559d62fec600 "SELECT c.oid::pg_catalog.regclass\nFROM pg_catalog.pg_class c, pg_catalog.pg_inherits i\nWHERE c.oid = i.inhparent AND i.inhrelid = '21111'\n  AND c.relkind != 'p' AND c.relkind != 'I'\nORDER BY inhseqno;", paramTypes=paramTypes@entry=0x0, numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0) at postgres.c:689
#25 0x0000559d61daad61 in exec_simple_query (query_string=query_string@entry=0x559d62fec600 "SELECT c.oid::pg_catalog.regclass\nFROM pg_catalog.pg_class c, pg_catalog.pg_inherits i\nWHERE c.oid = i.inhparent AND i.inhrelid = '21111'\n  AND c.relkind != 'p' AND c.relkind != 'I'\nORDER BY inhseqno;") at postgres.c:1191
#26 0x0000559d61dacd28 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4641
#27 0x0000559d61d083e0 in BackendRun (port=port@entry=0x559d63016fd0) at postmaster.c:4435
#28 0x0000559d61d0b385 in BackendStartup (port=port@entry=0x559d63016fd0) at postmaster.c:4163
#29 0x0000559d61d0b524 in ServerLoop () at postmaster.c:1777
#30 0x0000559d61d0ca1d in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x559d62fe5bb0) at postmaster.c:1461
#31 0x0000559d61c2a03c in main (argc=8, argv=0x559d62fe5bb0) at main.c:198
[Inferior 1 (process 3243645) detached]