select3.trace

application/octet-stream

Filename: select3.trace
Type: application/octet-stream
Part: 7
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=0x7ffa08c717b8) at ../sysdeps/nptl/futex-internal.h:323
#0  futex_abstimed_wait_cancelable (private=128, abstime=0x0, clockid=0, expected=0, futex_word=0x7ffa08c717b8) at ../sysdeps/nptl/futex-internal.h:323
#1  do_futex_wait (sem=sem@entry=0x7ffa08c717b8, abstime=0x0, clockid=0) at sem_waitcommon.c:112
#2  0x00007ffa1431f278 in __new_sem_wait_slow (sem=sem@entry=0x7ffa08c717b8, abstime=0x0, clockid=0) at sem_waitcommon.c:184
#3  0x00007ffa1431f2f1 in __new_sem_wait (sem=sem@entry=0x7ffa08c717b8) at sem_wait.c:42
#4  0x0000559d61cfe5a0 in PGSemaphoreLock (sema=0x7ffa08c717b8) 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=0x559d63013568, lockMethodTable=lockMethodTable@entry=0x559d621f0ca0 <default_lockmethod>) at proc.c:1292
#8  0x0000559d61d90dae in WaitOnLock (locallock=locallock@entry=0x559d63013568, owner=owner@entry=0x559d6307a968) at lock.c:1819
#9  0x0000559d61d927fa in LockAcquireExtended (locktag=locktag@entry=0x7ffec414b8e0, lockmode=lockmode@entry=1, sessionLock=sessionLock@entry=false, dontWait=dontWait@entry=false, reportMemoryError=reportMemoryError@entry=true, locallockp=locallockp@entry=0x7ffec414b8d8) at lock.c:1083
#10 0x0000559d61d8ee6e in LockRelationOid (relid=1259, lockmode=1) at lmgr.c:117
#11 0x0000559d619b21c0 in relation_open (relationId=1259, lockmode=lockmode@entry=1) at relation.c:56
#12 0x0000559d61a52bd3 in table_open (relationId=<optimized out>, lockmode=lockmode@entry=1) at table.c:44
#13 0x0000559d61ed4c24 in SearchCatCacheMiss (cache=cache@entry=0x559d6305ac80, nkeys=nkeys@entry=2, hashValue=hashValue@entry=3450859423, hashIndex=hashIndex@entry=31, v1=v1@entry=94134459093744, v2=v2@entry=11, v3=0, v4=0) at catcache.c:1355
#14 0x0000559d61ed4f3c in SearchCatCacheInternal (cache=0x559d6305ac80, nkeys=2, v1=v1@entry=94134459093744, v2=11, v3=v3@entry=0, v4=v4@entry=0) at catcache.c:1297
#15 0x0000559d61ed5a27 in SearchCatCache (cache=<optimized out>, v1=v1@entry=94134459093744, v2=<optimized out>, v3=v3@entry=0, v4=v4@entry=0) at catcache.c:1151
#16 0x0000559d61ee98f1 in SearchSysCache (cacheId=cacheId@entry=54, key1=key1@entry=94134459093744, key2=<optimized out>, key3=key3@entry=0, key4=key4@entry=0) at syscache.c:816
#17 0x0000559d61ee9af5 in GetSysCacheOid (cacheId=cacheId@entry=54, oidcol=oidcol@entry=1, key1=key1@entry=94134459093744, key2=<optimized out>, key3=key3@entry=0, key4=key4@entry=0) at syscache.c:940
#18 0x0000559d61ed9913 in get_relname_relid (relname=relname@entry=0x559d62fed2f0 "pg_trigger", relnamespace=<optimized out>) at lsyscache.c:1891
#19 0x0000559d61aa7c2a in RelnameGetRelid (relname=0x559d62fed2f0 "pg_trigger") at namespace.c:676
#20 0x0000559d61aa91c2 in RangeVarGetRelidExtended (relation=relation@entry=0x559d62fed310, lockmode=lockmode@entry=1, flags=flags@entry=1, callback=callback@entry=0x0, callback_arg=callback_arg@entry=0x0) at namespace.c:319
#21 0x0000559d619b23ea in relation_openrv_extended (relation=relation@entry=0x559d62fed310, lockmode=lockmode@entry=1, missing_ok=missing_ok@entry=true) at relation.c:186
#22 0x0000559d61a52d97 in table_openrv_extended (relation=relation@entry=0x559d62fed310, lockmode=lockmode@entry=1, missing_ok=missing_ok@entry=true) at table.c:108
#23 0x0000559d61b086af in parserOpenTable (pstate=pstate@entry=0x559d62feda80, relation=relation@entry=0x559d62fed310, lockmode=lockmode@entry=1) at parse_relation.c:1424
#24 0x0000559d61b0c5ec in addRangeTableEntry (pstate=pstate@entry=0x559d62feda80, relation=relation@entry=0x559d62fed310, alias=0x0, inh=<optimized out>, inFromCl=inFromCl@entry=true) at parse_relation.c:1501
#25 0x0000559d61aeb716 in transformTableEntry (pstate=pstate@entry=0x559d62feda80, r=r@entry=0x559d62fed310) at parse_clause.c:402
#26 0x0000559d61aee3a2 in transformFromClauseItem (pstate=pstate@entry=0x559d62feda80, n=0x559d62fed310, top_nsitem=top_nsitem@entry=0x7ffec414bef0, namespace=namespace@entry=0x7ffec414bef8) at parse_clause.c:1073
#27 0x0000559d61aef43e in transformFromClause (pstate=pstate@entry=0x559d62feda80, frmList=0x559d62fed360) at parse_clause.c:135
#28 0x0000559d61acd7d9 in transformSelectStmt (pstate=0x559d62feda80, stmt=stmt@entry=0x559d62fed8f0) at analyze.c:1358
#29 0x0000559d61ace2c2 in transformStmt (pstate=pstate@entry=0x559d62feda80, parseTree=parseTree@entry=0x559d62fed8f0) at analyze.c:371
#30 0x0000559d61acf59a in transformOptionalSelectInto (pstate=pstate@entry=0x559d62feda80, parseTree=0x559d62fed8f0) at analyze.c:306
#31 0x0000559d61acf5d2 in transformTopLevelStmt (pstate=pstate@entry=0x559d62feda80, parseTree=parseTree@entry=0x559d62feda00) at analyze.c:256
#32 0x0000559d61acf640 in parse_analyze_fixedparams (parseTree=parseTree@entry=0x559d62feda00, sourceText=sourceText@entry=0x559d62fec600 "SELECT pg_get_triggerdef(oid, true) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a';", paramTypes=paramTypes@entry=0x0, numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0) at analyze.c:124
#33 0x0000559d61daa5dc in pg_analyze_and_rewrite_fixedparams (parsetree=parsetree@entry=0x559d62feda00, query_string=query_string@entry=0x559d62fec600 "SELECT pg_get_triggerdef(oid, true) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a';", paramTypes=paramTypes@entry=0x0, numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0) at postgres.c:689
#34 0x0000559d61daad61 in exec_simple_query (query_string=query_string@entry=0x559d62fec600 "SELECT pg_get_triggerdef(oid, true) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a';") at postgres.c:1191
#35 0x0000559d61dacd28 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4641
#36 0x0000559d61d083e0 in BackendRun (port=port@entry=0x559d63016fd0) at postmaster.c:4435
#37 0x0000559d61d0b385 in BackendStartup (port=port@entry=0x559d63016fd0) at postmaster.c:4163
#38 0x0000559d61d0b524 in ServerLoop () at postmaster.c:1777
#39 0x0000559d61d0ca1d in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x559d62fe5bb0) at postmaster.c:1461
#40 0x0000559d61c2a03c in main (argc=8, argv=0x559d62fe5bb0) at main.c:198
[Inferior 1 (process 3243655) detached]