22591 / startup waiting

(gdb) bt
#0  0x00007f99d73fa673 in epoll_wait () from /lib/x86_64-linux-gnu/libc.so.6
#1  0x0000561c55fa8739 in WaitEventSetWaitBlock (nevents=1, occurred_events=0x7fff06f56a00, cur_timeout=-1, set=0x561c5751b338)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/latch.c:1048
#2  WaitEventSetWait (set=set@entry=0x561c5751b338, timeout=timeout@entry=-1, occurred_events=occurred_events@entry=0x7fff06f56a00, nevents=nevents@entry=1,
    wait_event_info=wait_event_info@entry=50331648) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/latch.c:1000
#3  0x0000561c55fa8bb1 in WaitLatchOrSocket (latch=0x7f99cb0dc494, wakeEvents=wakeEvents@entry=1, sock=sock@entry=-1, timeout=-1, timeout@entry=0, wait_event_info=50331648)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/latch.c:385
#4  0x0000561c55fa8c45 in WaitLatch (latch=<optimized out>, wakeEvents=wakeEvents@entry=1, timeout=timeout@entry=0, wait_event_info=<optimized out>)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/latch.c:339
#5  0x0000561c55fb9011 in ProcWaitForSignal (wait_event_info=<optimized out>) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/lmgr/proc.c:1768
#6  0x0000561c55fafe2c in ResolveRecoveryConflictWithLock (locktag=...) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/standby.c:395
#7  0x0000561c55fb8467 in ProcSleep (locallock=locallock@entry=0x561c5754a058, lockMethodTable=lockMethodTable@entry=0x561c56522d80 <default_lockmethod>)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/lmgr/proc.c:1251
#8  0x0000561c55fb309a in WaitOnLock (locallock=locallock@entry=0x561c5754a058, owner=owner@entry=0x0) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/lmgr/lock.c:1702
#9  0x0000561c55fb452a in LockAcquireExtended (locktag=locktag@entry=0x7fff06f56e00, lockmode=lockmode@entry=8, sessionLock=sessionLock@entry=1 '\001', dontWait=dontWait@entry=0 '\000',
    reportMemoryError=reportMemoryError@entry=0 '\000') at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/lmgr/lock.c:998
#10 0x0000561c55fb00d2 in StandbyAcquireAccessExclusiveLock (xid=1065072121, dbOid=16400, relOid=20670) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/standby.c:627
#11 0x0000561c55fb050c in standby_redo (record=<optimized out>) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/standby.c:809
#12 0x0000561c55d9278b in StartupXLOG () at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/access/transam/xlog.c:7183
#13 0x0000561c55f5d473 in StartupProcessMain () at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/postmaster/startup.c:217
#14 0x0000561c55da15f5 in AuxiliaryProcessMain (argc=argc@entry=2, argv=argv@entry=0x7fff06f5a640) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/bootstrap/bootstrap.c:426
#15 0x0000561c55f5a1e9 in StartChildProcess (type=StartupProcess) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/postmaster/postmaster.c:5361
#16 0x0000561c55f5cc8a in PostmasterMain (argc=5, argv=<optimized out>) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/postmaster/postmaster.c:1355
#17 0x0000561c55d100c6 in main (argc=5, argv=0x561c574be1f0) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/main/main.c:228


22607 / SELECT waiting

(gdb) bt
#0  0x00007f99d73fa673 in epoll_wait () from /lib/x86_64-linux-gnu/libc.so.6
#1  0x0000561c55fa8739 in WaitEventSetWaitBlock (nevents=1, occurred_events=0x7fff06f58ac0, cur_timeout=-1, set=0x561c5755ca80)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/latch.c:1048
#2  WaitEventSetWait (set=set@entry=0x561c5755ca80, timeout=timeout@entry=-1, occurred_events=occurred_events@entry=0x7fff06f58ac0, nevents=nevents@entry=1,
    wait_event_info=wait_event_info@entry=50331648) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/latch.c:1000
#3  0x0000561c55fa8bb1 in WaitLatchOrSocket (latch=0x7f99cb0d97f4, wakeEvents=wakeEvents@entry=1, sock=sock@entry=-1, timeout=-1, timeout@entry=0, wait_event_info=50331648)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/latch.c:385
#4  0x0000561c55fa8c45 in WaitLatch (latch=<optimized out>, wakeEvents=wakeEvents@entry=1, timeout=timeout@entry=0, wait_event_info=<optimized out>)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/ipc/latch.c:339
#5  0x0000561c55fb8511 in ProcSleep (locallock=locallock@entry=0x561c57505958, lockMethodTable=lockMethodTable@entry=0x561c56522d80 <default_lockmethod>)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/lmgr/proc.c:1255
#6  0x0000561c55fb309a in WaitOnLock (locallock=locallock@entry=0x561c57505958, owner=owner@entry=0x561c574c01b8)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/lmgr/lock.c:1702
#7  0x0000561c55fb452a in LockAcquireExtended (locktag=locktag@entry=0x7fff06f58e50, lockmode=lockmode@entry=1, sessionLock=sessionLock@entry=0 '\000', dontWait=dontWait@entry=0 '\000',
    reportMemoryError=reportMemoryError@entry=1 '\001') at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/lmgr/lock.c:998
#8  0x0000561c55fb4b86 in LockAcquire (locktag=locktag@entry=0x7fff06f58e50, lockmode=lockmode@entry=1, sessionLock=sessionLock@entry=0 '\000', dontWait=dontWait@entry=0 '\000')
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/lmgr/lock.c:688
#9  0x0000561c55fb1eff in LockRelationOid (relid=19187, lockmode=1) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/storage/lmgr/lmgr.c:112
#10 0x0000561c55daf0e5 in RangeVarGetRelidExtended (relation=0x561c57561268, lockmode=1, missing_ok=1 '\001', nowait=nowait@entry=0 '\000', callback=callback@entry=0x0,
    callback_arg=callback_arg@entry=0x0) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/catalog/namespace.c:365
#11 0x0000561c55d4757c in relation_openrv_extended (relation=<optimized out>, lockmode=<optimized out>, missing_ok=<optimized out>)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/access/heap/heapam.c:1240
#12 0x0000561c55d47761 in heap_openrv_extended (relation=relation@entry=0x561c57561268, lockmode=lockmode@entry=1, missing_ok=missing_ok@entry=1 '\001')
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/access/heap/heapam.c:1346
#13 0x0000561c55e0837a in parserOpenTable (pstate=pstate@entry=0x561c5755c350, relation=relation@entry=0x561c57561268, lockmode=1)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_relation.c:1152
#14 0x0000561c55e09cba in addRangeTableEntry (pstate=pstate@entry=0x561c5755c350, relation=relation@entry=0x561c57561268, alias=0x561c575612b8, inh=<optimized out>, inFromCl=inFromCl@entry=1 '\001')
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_relation.c:1217
#15 0x0000561c55df5059 in transformTableEntry (r=0x561c57561268, pstate=0x561c5755c350) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_clause.c:428
#16 transformFromClauseItem (pstate=pstate@entry=0x561c5755c350, n=0x561c57561268, top_rte=top_rte@entry=0x7fff06f591c8, top_rti=top_rti@entry=0x7fff06f591b4, namespace=namespace@entry=0x7fff06f591d8)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_clause.c:1114
#17 0x0000561c55df4727 in transformFromClauseItem (pstate=pstate@entry=0x561c5755c350, n=0x561c57561570, top_rte=top_rte@entry=0x7fff06f592f0, top_rti=top_rti@entry=0x7fff06f592e0,
    namespace=namespace@entry=0x7fff06f59300) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_clause.c:1260
#18 0x0000561c55df46ac in transformFromClauseItem (pstate=pstate@entry=0x561c5755c350, n=0x561c57561c28, top_rte=top_rte@entry=0x7fff06f59420, top_rti=top_rti@entry=0x7fff06f59410,
    namespace=namespace@entry=0x7fff06f59430) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_clause.c:1233
#19 0x0000561c55df46ac in transformFromClauseItem (pstate=pstate@entry=0x561c5755c350, n=0x561c5755b0c8, top_rte=top_rte@entry=0x7fff06f59550, top_rti=top_rti@entry=0x7fff06f59540,
    namespace=namespace@entry=0x7fff06f59560) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_clause.c:1233
#20 0x0000561c55df46ac in transformFromClauseItem (pstate=pstate@entry=0x561c5755c350, n=0x561c5755b490, top_rte=top_rte@entry=0x7fff06f59680, top_rti=top_rti@entry=0x7fff06f59670,
    namespace=namespace@entry=0x7fff06f59690) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_clause.c:1233
#21 0x0000561c55df46ac in transformFromClauseItem (pstate=pstate@entry=0x561c5755c350, n=0x561c5755b878, top_rte=top_rte@entry=0x7fff06f59720, top_rti=top_rti@entry=0x7fff06f5971c,
    namespace=namespace@entry=0x7fff06f59728) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_clause.c:1233
#22 0x0000561c55df6665 in transformFromClause (pstate=pstate@entry=0x561c5755c350, frmList=<optimized out>)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/parse_clause.c:132
#23 0x0000561c55dd5962 in transformSelectStmt (stmt=0x561c5755c010, pstate=0x561c5755c350) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/analyze.c:1211
#24 transformStmt (pstate=pstate@entry=0x561c5755c350, parseTree=0x561c5755c010) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/analyze.c:297
#25 0x0000561c55dd7683 in transformOptionalSelectInto (pstate=pstate@entry=0x561c5755c350, parseTree=<optimized out>)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/analyze.c:242
#26 0x0000561c55dd76f5 in transformTopLevelStmt (pstate=pstate@entry=0x561c5755c350, parseTree=parseTree@entry=0x561c5755c2d0)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/analyze.c:192
#27 0x0000561c55dd7768 in parse_analyze (parseTree=0x561c5755c2d0,
    sourceText=0x561c5755ff88 "\n\t\tSELECT\n\t\t  s.storage,\n\t\t  fm.path AS filepath,\n\t\t  s.url AS serverurl,\n\t\t  cf.title AS type\n\t\tFROM kaltura_file_meta\n\t\tJOIN files fi ON file_id = fi.
id\n\t\tJOIN content_format ci on ci.id = fi.format"..., paramTypes=0x0, numParams=0, queryEnv=0x0) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/parser/analyze.c:112
#28 0x0000561c55fc928c in pg_analyze_and_rewrite (parsetree=parsetree@entry=0x561c5755c2d0,
    query_string=query_string@entry=0x561c5755ff88 "\n\t\tSELECT\n\t\t  s.storage,\n\t\t  fm.path AS filepath,\n\t\t  s.url AS serverurl,\n\t\t  cf.title AS type\n\t\tFROM kaltura_file_meta\n\t\tJOIN file
s fi ON file_id = fi.id\n\t\tJOIN content_format ci on ci.id = fi.format"..., paramTypes=paramTypes@entry=0x0, numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/tcop/postgres.c:653
#29 0x0000561c55fc99e8 in exec_simple_query (
    query_string=0x561c5755ff88 "\n\t\tSELECT\n\t\t  s.storage,\n\t\t  fm.path AS filepath,\n\t\t  s.url AS serverurl,\n\t\t  cf.title AS type\n\t\tFROM kaltura_file_meta\n\t\tJOIN files fi ON file_id = f
i.id\n\t\tJOIN content_format ci on ci.id = fi.format"...) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/tcop/postgres.c:1024
#30 0x0000561c55fcac48 in PostgresMain (argc=<optimized out>, argv=argv@entry=0x561c5750a9f0, dbname=0x561c5750a9d8 "da", username=<optimized out>)
    at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/tcop/postgres.c:4088
#31 0x0000561c55d0f16f in BackendRun (port=0x561c57502fe0) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/postmaster/postmaster.c:4405
#32 BackendStartup (port=0x561c57502fe0) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/postmaster/postmaster.c:4077
#33 ServerLoop () at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/postmaster/postmaster.c:1755
#34 0x0000561c55f5ccae in PostmasterMain (argc=5, argv=<optimized out>) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/postmaster/postmaster.c:1363
#35 0x0000561c55d100c6 in main (argc=5, argv=0x561c574be1f0) at /build/postgresql-10-VFJB0R/postgresql-10-10.4/build/../src/backend/main/main.c:228