rep2_.out
text/plain
Filename: rep2_.out
Type: text/plain
Part: 0
# Samples: 877890
#
# Overhead Command Shared Object Symbol
# ........ ........ .................... ......
#
38.39% postgres ./pg9.2/bin/postgres [.] tas
|
|--99.62%-- s_lock
| |
| |--53.31%-- UnpinBuffer
| | ReleaseAndReadBuffer
| | _bt_relandgetbuf
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--46.56%-- PinBuffer
| | BufferAlloc
| | ReadBuffer_common
| | ReadBufferExtended
| | ReadBuffer
| | |
| | |--99.91%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.09%-- [...]
| --0.14%-- [...]
--0.38%-- [...]
6.96% postgres ./pg9.2/bin/postgres [.] PinBuffer
|
|--99.84%-- BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| |
| |--99.90%-- ReadBuffer
| | |
| | |--82.96%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --17.04%-- _bt_getbuf
| | |
| | |--99.96%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.04%-- [...]
| --0.10%-- [...]
--0.16%-- [...]
6.14% postgres ./pg9.2/bin/postgres [.] tas
|
|--54.76%-- PinBuffer
| BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| |
| |--99.96%-- ReadBuffer
| | |
| | |--60.85%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --39.15%-- _bt_getbuf
| | |
| | |--99.98%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.02%-- [...]
| --0.04%-- [...]
|
|--37.96%-- UnpinBuffer
| |
| |--98.95%-- ReleaseAndReadBuffer
| | _bt_relandgetbuf
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --1.05%-- ReleaseBuffer
| |
| |--94.39%-- UnlockReleaseBuffer
| | _bt_relbuf
| | _bt_steppage
| | _bt_next
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --5.61%-- ExecStoreTuple
| SeqNext
| ExecScanFetch
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--6.53%-- FlushRelationBuffers
| heap_sync
| intorel_shutdown
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.75%-- [...]
5.52% postgres ./pg9.2/bin/postgres [.] tas
|
|--53.64%-- LWLockRelease
| |
| |--83.96%-- BufferAlloc
| | ReadBuffer_common
| | ReadBufferExtended
| | |
| | |--99.60%-- ReadBuffer
| | | |
| | | |--93.71%-- ReleaseAndReadBuffer
| | | | _bt_relandgetbuf
| | | | _bt_search
| | | | _bt_first
| | | | btgettuple
| | | | FunctionCall2Coll
| | | | index_getnext_tid
| | | | IndexOnlyNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecIndexOnlyScan
| | | | ExecProcNode
| | | | ExecScanSubPlan
| | | | ExecSubPlan
| | | | ExecTargetList
| | | | ExecProject
| | | | ExecScan
| | | | ExecSeqScan
| | | | ExecProcNode
| | | | ExecLimit
| | | | ExecProcNode
| | | | SubqueryNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecSubqueryScan
| | | | ExecProcNode
| | | | ExecSort
| | | | ExecProcNode
| | | | ExecutePlan
| | | | standard_ExecutorRun
| | | | ExecutorRun
| | | | ExecCreateTableAs
| | | | standard_ProcessUtility
| | | | ProcessUtility
| | | | PortalRunUtility
| | | | PortalRunMulti
| | | | PortalRun
| | | | exec_simple_query
| | | | PostgresMain
| | | | BackendRun
| | | | BackendStartup
| | | | ServerLoop
| | | | PostmasterMain
| | | | main
| | | | __libc_start_main
| | | |
| | | --6.29%-- _bt_getbuf
| | | |
| | | |--99.20%-- _bt_getroot
| | | | _bt_search
| | | | _bt_first
| | | | btgettuple
| | | | FunctionCall2Coll
| | | | index_getnext_tid
| | | | IndexOnlyNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecIndexOnlyScan
| | | | ExecProcNode
| | | | ExecScanSubPlan
| | | | ExecSubPlan
| | | | ExecTargetList
| | | | ExecProject
| | | | ExecScan
| | | | ExecSeqScan
| | | | ExecProcNode
| | | | ExecLimit
| | | | ExecProcNode
| | | | SubqueryNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecSubqueryScan
| | | | ExecProcNode
| | | | ExecSort
| | | | ExecProcNode
| | | | ExecutePlan
| | | | standard_ExecutorRun
| | | | ExecutorRun
| | | | ExecCreateTableAs
| | | | standard_ProcessUtility
| | | | ProcessUtility
| | | | PortalRunUtility
| | | | PortalRunMulti
| | | | PortalRun
| | | | exec_simple_query
| | | | PostgresMain
| | | | BackendRun
| | | | BackendStartup
| | | | ServerLoop
| | | | PostmasterMain
| | | | main
| | | | __libc_start_main
| | | |
| | | --0.80%-- _bt_steppage
| | | |
| | | |--72.73%-- _bt_next
| | | | btgettuple
| | | | FunctionCall2Coll
| | | | index_getnext_tid
| | | | IndexOnlyNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecIndexOnlyScan
| | | | ExecProcNode
| | | | ExecScanSubPlan
| | | | ExecSubPlan
| | | | ExecTargetList
| | | | ExecProject
| | | | ExecScan
| | | | ExecSeqScan
| | | | ExecProcNode
| | | | ExecLimit
| | | | ExecProcNode
| | | | SubqueryNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecSubqueryScan
| | | | ExecProcNode
| | | | ExecSort
| | | | ExecProcNode
| | | | ExecutePlan
| | | | standard_ExecutorRun
| | | | ExecutorRun
| | | | ExecCreateTableAs
| | | | standard_ProcessUtility
| | | | ProcessUtility
| | | | PortalRunUtility
| | | | PortalRunMulti
| | | | PortalRun
| | | | exec_simple_query
| | | | PostgresMain
| | | | BackendRun
| | | | BackendStartup
| | | | ServerLoop
| | | | PostmasterMain
| | | | main
| | | | __libc_start_main
| | | |
| | | --27.27%-- _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.40%-- [...]
| |
| |--15.99%-- LockBuffer
| | |
| | |--89.56%-- _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | |--5.22%-- UnlockReleaseBuffer
| | | |
| | | |--95.85%-- _bt_relbuf
| | | | _bt_steppage
| | | | _bt_next
| | | | btgettuple
| | | | FunctionCall2Coll
| | | | index_getnext_tid
| | | | IndexOnlyNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecIndexOnlyScan
| | | | ExecProcNode
| | | | ExecScanSubPlan
| | | | ExecSubPlan
| | | | ExecTargetList
| | | | ExecProject
| | | | ExecScan
| | | | ExecSeqScan
| | | | ExecProcNode
| | | | ExecLimit
| | | | ExecProcNode
| | | | SubqueryNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecSubqueryScan
| | | | ExecProcNode
| | | | ExecSort
| | | | ExecProcNode
| | | | ExecutePlan
| | | | standard_ExecutorRun
| | | | ExecutorRun
| | | | ExecCreateTableAs
| | | | standard_ProcessUtility
| | | | ProcessUtility
| | | | PortalRunUtility
| | | | PortalRunMulti
| | | | PortalRun
| | | | exec_simple_query
| | | | PostgresMain
| | | | BackendRun
| | | | BackendStartup
| | | | ServerLoop
| | | | PostmasterMain
| | | | main
| | | | __libc_start_main
| | | |
| | | --4.15%-- heap_insert
| | | intorel_receive
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | |--4.98%-- _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.24%-- [...]
| --0.04%-- [...]
|
|--45.37%-- LWLockAcquire
| |
| |--63.02%-- BufferAlloc
| | ReadBuffer_common
| | ReadBufferExtended
| | |
| | |--98.43%-- ReadBuffer
| | | |
| | | |--77.02%-- ReleaseAndReadBuffer
| | | | _bt_relandgetbuf
| | | | _bt_search
| | | | _bt_first
| | | | btgettuple
| | | | FunctionCall2Coll
| | | | index_getnext_tid
| | | | IndexOnlyNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecIndexOnlyScan
| | | | ExecProcNode
| | | | ExecScanSubPlan
| | | | ExecSubPlan
| | | | ExecTargetList
| | | | ExecProject
| | | | ExecScan
| | | | ExecSeqScan
| | | | ExecProcNode
| | | | ExecLimit
| | | | ExecProcNode
| | | | SubqueryNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecSubqueryScan
| | | | ExecProcNode
| | | | ExecSort
| | | | ExecProcNode
| | | | ExecutePlan
| | | | standard_ExecutorRun
| | | | ExecutorRun
| | | | ExecCreateTableAs
| | | | standard_ProcessUtility
| | | | ProcessUtility
| | | | PortalRunUtility
| | | | PortalRunMulti
| | | | PortalRun
| | | | exec_simple_query
| | | | PostgresMain
| | | | BackendRun
| | | | BackendStartup
| | | | ServerLoop
| | | | PostmasterMain
| | | | main
| | | | __libc_start_main
| | | |
| | | --22.98%-- _bt_getbuf
| | | |
| | | |--99.20%-- _bt_getroot
| | | | _bt_search
| | | | _bt_first
| | | | btgettuple
| | | | FunctionCall2Coll
| | | | index_getnext_tid
| | | | IndexOnlyNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecIndexOnlyScan
| | | | ExecProcNode
| | | | ExecScanSubPlan
| | | | ExecSubPlan
| | | | ExecTargetList
| | | | ExecProject
| | | | ExecScan
| | | | ExecSeqScan
| | | | ExecProcNode
| | | | ExecLimit
| | | | ExecProcNode
| | | | SubqueryNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecSubqueryScan
| | | | ExecProcNode
| | | | ExecSort
| | | | ExecProcNode
| | | | ExecutePlan
| | | | standard_ExecutorRun
| | | | ExecutorRun
| | | | ExecCreateTableAs
| | | | standard_ProcessUtility
| | | | ProcessUtility
| | | | PortalRunUtility
| | | | PortalRunMulti
| | | | PortalRun
| | | | exec_simple_query
| | | | PostgresMain
| | | | BackendRun
| | | | BackendStartup
| | | | ServerLoop
| | | | PostmasterMain
| | | | main
| | | | __libc_start_main
| | | |
| | | --0.80%-- _bt_steppage
| | | |
| | | |--56.00%-- _bt_next
| | | | btgettuple
| | | | FunctionCall2Coll
| | | | index_getnext_tid
| | | | IndexOnlyNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecIndexOnlyScan
| | | | ExecProcNode
| | | | ExecScanSubPlan
| | | | ExecSubPlan
| | | | ExecTargetList
| | | | ExecProject
| | | | ExecScan
| | | | ExecSeqScan
| | | | ExecProcNode
| | | | ExecLimit
| | | | ExecProcNode
| | | | SubqueryNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecSubqueryScan
| | | | ExecProcNode
| | | | ExecSort
| | | | ExecProcNode
| | | | ExecutePlan
| | | | standard_ExecutorRun
| | | | ExecutorRun
| | | | ExecCreateTableAs
| | | | standard_ProcessUtility
| | | | ProcessUtility
| | | | PortalRunUtility
| | | | PortalRunMulti
| | | | PortalRun
| | | | exec_simple_query
| | | | PostgresMain
| | | | BackendRun
| | | | BackendStartup
| | | | ServerLoop
| | | | PostmasterMain
| | | | main
| | | | __libc_start_main
| | | |
| | | --44.00%-- _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | |--1.48%-- heapgetpage
| | | heapgettup_pagemode
| | | heap_getnext
| | | SeqNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.09%-- [...]
| |
| |--36.91%-- LockBuffer
| | |
| | |--58.65%-- _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | |--38.10%-- _bt_getbuf
| | | |
| | | |--99.94%-- _bt_getroot
| | | | _bt_search
| | | | _bt_first
| | | | btgettuple
| | | | FunctionCall2Coll
| | | | index_getnext_tid
| | | | IndexOnlyNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecIndexOnlyScan
| | | | ExecProcNode
| | | | ExecScanSubPlan
| | | | ExecSubPlan
| | | | ExecTargetList
| | | | ExecProject
| | | | ExecScan
| | | | ExecSeqScan
| | | | ExecProcNode
| | | | ExecLimit
| | | | ExecProcNode
| | | | SubqueryNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecSubqueryScan
| | | | ExecProcNode
| | | | ExecSort
| | | | ExecProcNode
| | | | ExecutePlan
| | | | standard_ExecutorRun
| | | | ExecutorRun
| | | | ExecCreateTableAs
| | | | standard_ProcessUtility
| | | | ProcessUtility
| | | | PortalRunUtility
| | | | PortalRunMulti
| | | | PortalRun
| | | | exec_simple_query
| | | | PostgresMain
| | | | BackendRun
| | | | BackendStartup
| | | | ServerLoop
| | | | PostmasterMain
| | | | main
| | | | __libc_start_main
| | | --0.06%-- [...]
| | |
| | |--2.43%-- _bt_next
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | |--0.71%-- heapgetpage
| | | heapgettup_pagemode
| | | heap_getnext
| | | SeqNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.10%-- [...]
| --0.07%-- [...]
|
|--0.63%-- BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| |
| |--99.02%-- ReadBuffer
| | |
| | |--89.14%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --10.86%-- _bt_getbuf
| | _bt_getroot
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --0.98%-- heapgetpage
| heapgettup_pagemode
| heap_getnext
| SeqNext
| ExecScanFetch
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.35%-- [...]
5.06% postgres ./pg9.2/bin/postgres [.] slot_deform_tuple
|
|--99.96%-- slot_getsomeattrs
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.04%-- [...]
4.15% postgres ./pg9.2/bin/postgres [.] BufferAlloc
|
|--99.85%-- ReadBuffer_common
| ReadBufferExtended
| |
| |--99.93%-- ReadBuffer
| | |
| | |--98.92%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --1.08%-- _bt_getbuf
| | |
| | |--99.75%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.25%-- [...]
| --0.07%-- [...]
--0.15%-- [...]
4.14% postgres ./pg9.2/bin/postgres [.] UnpinBuffer
|
|--99.02%-- ReleaseAndReadBuffer
| _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.65%-- ReleaseBuffer
| |
| |--88.14%-- UnlockReleaseBuffer
| | _bt_relbuf
| | _bt_steppage
| | |
| | |--99.52%-- _bt_next
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.48%-- [...]
| |
| |--11.44%-- ExecStoreTuple
| | SeqNext
| | ExecScanFetch
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.42%-- [...]
--0.33%-- [...]
3.93% postgres ./pg9.2/bin/postgres [.] ExecProject
|
|--99.84%-- ExecScan
| |
| |--97.69%-- ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --2.31%-- ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.16%-- [...]
3.51% postgres ./pg9.2/bin/postgres [.] LockBuffer
|
|--94.03%-- _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--3.00%-- _bt_getbuf
| |
| |--99.57%-- _bt_getroot
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.43%-- [...]
|
|--0.86%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.76%-- UnlockReleaseBuffer
| |
| |--98.72%-- _bt_relbuf
| | _bt_steppage
| | _bt_next
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --1.28%-- heap_insert
| intorel_receive
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.71%-- _bt_next
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.64%-- [...]
2.92% postgres ./pg9.2/bin/postgres [.] _bt_compare
|
|--88.97%-- _bt_binsrch
| |
| |--67.83%-- _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --32.17%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--8.19%-- _bt_moveright
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.02%-- _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.83%-- _bt_first
btgettuple
FunctionCall2Coll
index_getnext_tid
IndexOnlyNext
ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
1.87% postgres ./pg9.2/bin/postgres [.] ReadBuffer_common
|
|--99.12%-- ReadBufferExtended
| |
| |--99.90%-- ReadBuffer
| | |
| | |--53.51%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --46.49%-- _bt_getbuf
| | |
| | |--99.96%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.04%-- [...]
| --0.10%-- [...]
|
--0.88%-- ReadBuffer
|
|--88.19%-- ReleaseAndReadBuffer
| _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--11.81%-- _bt_getbuf
_bt_getroot
_bt_search
_bt_first
btgettuple
FunctionCall2Coll
index_getnext_tid
IndexOnlyNext
ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
1.36% postgres ./pg9.2/bin/postgres [.] ReleaseAndReadBuffer
|
|--99.25%-- _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.75%-- _bt_search
_bt_first
btgettuple
FunctionCall2Coll
index_getnext_tid
IndexOnlyNext
ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
1.24% postgres ./pg9.2/bin/postgres [.] BufferGetBlockNumber
|
|--95.81%-- _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.07%-- visibilitymap_test
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--1.68%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.44%-- [...]
1.07% postgres ./pg9.2/bin/postgres [.] spin_delay
|
|--55.92%-- s_lock
| |
| |--51.16%-- UnpinBuffer
| | ReleaseAndReadBuffer
| | _bt_relandgetbuf
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--48.65%-- PinBuffer
| | BufferAlloc
| | ReadBuffer_common
| | ReadBufferExtended
| | ReadBuffer
| | |
| | |--99.77%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.23%-- [...]
| --0.19%-- [...]
|
|--22.24%-- UnpinBuffer
| ReleaseAndReadBuffer
| _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--21.71%-- PinBuffer
| BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| ReadBuffer
| |
| |--99.95%-- ReleaseAndReadBuffer
| | _bt_relandgetbuf
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.05%-- [...]
--0.13%-- [...]
0.95% postgres ./pg9.2/bin/postgres [.] s_lock
|
|--50.43%-- UnpinBuffer
| ReleaseAndReadBuffer
| _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--48.33%-- PinBuffer
| BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| ReadBuffer
| |
| |--99.85%-- ReleaseAndReadBuffer
| | _bt_relandgetbuf
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.15%-- [...]
|
|--0.60%-- BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| ReadBuffer
| ReleaseAndReadBuffer
| _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.64%-- [...]
0.72% postgres ./pg9.2/bin/postgres [.] _bt_binsrch
|
|--68.83%-- _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--30.93%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.24%-- [...]
0.46% postgres ./pg9.2/bin/postgres [.] FunctionCall2Coll
|
|--77.72%-- _bt_compare
| |
| |--91.89%-- _bt_binsrch
| | |
| | |--69.36%-- _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --30.64%-- _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --8.11%-- _bt_moveright
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--7.45%-- _bt_checkkeys
| _bt_readpage
| |
| |--99.33%-- _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --0.67%-- _bt_steppage
| |
| |--50.00%-- _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --50.00%-- _bt_next
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--7.05%-- index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--5.76%-- _bt_binsrch
| |
| |--76.62%-- _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --23.38%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.92%-- _bt_moveright
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.57%-- _bt_readpage
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.52%-- IndexOnlyNext
ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.43% postgres ./pg9.2/bin/postgres [.] btint8cmp
|
|--82.55%-- FunctionCall2Coll
| _bt_compare
| |
| |--93.36%-- _bt_binsrch
| | |
| | |--67.87%-- _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --32.13%-- _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --6.64%-- _bt_moveright
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--17.45%-- _bt_compare
|
|--94.97%-- _bt_binsrch
| |
| |--63.08%-- _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --36.92%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--5.03%-- _bt_moveright
_bt_search
_bt_first
btgettuple
FunctionCall2Coll
index_getnext_tid
IndexOnlyNext
ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.42% postgres ./pg9.2/bin/postgres [.] slot_getsomeattrs
|
|--99.23%-- ExecProject
| ExecScan
| |
| |--96.78%-- ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --3.22%-- ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.77%-- ExecScan
|
|--50.00%-- ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--50.00%-- ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.36% postgres ./pg9.2/bin/postgres [.] hash_search_with_hash_value
|
|--95.61%-- BufTableLookup
| BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| |
| |--79.67%-- ReadBuffer
| | |
| | |--76.75%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --23.25%-- _bt_getbuf
| | |
| | |--92.74%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --7.26%-- _bt_steppage
| | |
| | |--95.12%-- _bt_next
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --4.88%-- _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--19.70%-- heapgetpage
| | heapgettup_pagemode
| | heap_getnext
| | SeqNext
| | ExecScanFetch
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --0.62%-- ReadBufferBI
| RelationGetBufferForTuple
| heap_insert
| intorel_receive
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--3.76%-- BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| |
| |--97.50%-- ReadBuffer
| | |
| | |--79.49%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --20.51%-- _bt_getbuf
| | _bt_getroot
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --2.50%-- heapgetpage
| heapgettup_pagemode
| heap_getnext
| SeqNext
| ExecScanFetch
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.63%-- [...]
0.34% postgres ./pg9.2/bin/postgres [.] _bt_search
|
|--98.41%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--1.59%-- btgettuple
FunctionCall2Coll
index_getnext_tid
IndexOnlyNext
ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.31% postgres ./pg9.2/bin/postgres [.] _bt_first
|
|--98.01%-- btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--1.99%-- FunctionCall2Coll
index_getnext_tid
IndexOnlyNext
ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.30% postgres ./pg9.2/bin/postgres [.] hash_any
|
|--85.51%-- tag_hash
| get_hash_value
| BufTableHashCode
| BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| |
| |--97.86%-- ReadBuffer
| | |
| | |--67.00%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --33.00%-- _bt_getbuf
| | |
| | |--99.31%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --0.69%-- _bt_steppage
| | |
| | |--80.00%-- _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --20.00%-- _bt_next
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--1.83%-- heapgetpage
| | heapgettup_pagemode
| | heap_getnext
| | SeqNext
| | ExecScanFetch
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.31%-- [...]
|
--14.49%-- get_hash_value
BufTableHashCode
BufferAlloc
ReadBuffer_common
ReadBufferExtended
|
|--98.95%-- ReadBuffer
| |
| |--86.70%-- _bt_getbuf
| | |
| | |--99.39%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --0.61%-- _bt_steppage
| | |
| | |--50.00%-- _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --50.00%-- _bt_next
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --13.30%-- ReleaseAndReadBuffer
| _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--1.05%-- heapgetpage
heapgettup_pagemode
heap_getnext
SeqNext
ExecScanFetch
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.29% postgres ./pg9.2/bin/postgres [.] LWLockAcquire
|
|--49.17%-- BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| |
| |--99.29%-- ReadBuffer
| | |
| | |--81.81%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --18.19%-- _bt_getbuf
| | |
| | |--95.63%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --4.37%-- _bt_steppage
| | |
| | |--60.00%-- _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --40.00%-- _bt_next
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --0.71%-- heapgetpage
| heapgettup_pagemode
| heap_getnext
| SeqNext
| ExecScanFetch
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--42.69%-- LockBuffer
| |
| |--58.31%-- _bt_relandgetbuf
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--20.62%-- _bt_getbuf
| | |
| | |--99.12%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --0.88%-- _bt_steppage
| | _bt_next
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--19.35%-- _bt_next
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--1.36%-- RelationGetBufferForTuple
| | heap_insert
| | intorel_receive
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.36%-- [...]
|
|--4.03%-- ReadBuffer_common
| ReadBufferExtended
| |
| |--98.08%-- ReadBuffer
| | |
| | |--58.82%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --41.18%-- _bt_getbuf
| | _bt_getroot
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --1.92%-- heapgetpage
| heapgettup_pagemode
| heap_getnext
| SeqNext
| ExecScanFetch
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.02%-- _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.78%-- _bt_next
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.62%-- _bt_getbuf
| _bt_getroot
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.70%-- [...]
0.29% postgres ./pg9.2/bin/postgres [.] ExecMakeFunctionResultNoSets
|
|--51.51%-- ExecMakeFunctionResultNoSets
| ExecQual
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--46.39%-- ExecQual
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.10%-- ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.29% postgres ./pg9.2/bin/postgres [.] LWLockRelease
|
|--50.04%-- BufferAlloc
| ReadBuffer_common
| ReadBufferExtended
| |
| |--97.93%-- ReadBuffer
| | |
| | |--73.09%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --26.91%-- _bt_getbuf
| | |
| | |--99.40%-- _bt_getroot
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --0.60%-- _bt_steppage
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--1.83%-- heapgetpage
| | heapgettup_pagemode
| | heap_getnext
| | SeqNext
| | ExecScanFetch
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.24%-- [...]
|
|--43.15%-- LockBuffer
| |
| |--61.22%-- _bt_relandgetbuf
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--20.22%-- UnlockReleaseBuffer
| | |
| | |--96.35%-- _bt_relbuf
| | | _bt_steppage
| | | |
| | | |--99.53%-- _bt_next
| | | | btgettuple
| | | | FunctionCall2Coll
| | | | index_getnext_tid
| | | | IndexOnlyNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecIndexOnlyScan
| | | | ExecProcNode
| | | | ExecScanSubPlan
| | | | ExecSubPlan
| | | | ExecTargetList
| | | | ExecProject
| | | | ExecScan
| | | | ExecSeqScan
| | | | ExecProcNode
| | | | ExecLimit
| | | | ExecProcNode
| | | | SubqueryNext
| | | | ExecScanFetch
| | | | ExecScan
| | | | ExecSubqueryScan
| | | | ExecProcNode
| | | | ExecSort
| | | | ExecProcNode
| | | | ExecutePlan
| | | | standard_ExecutorRun
| | | | ExecutorRun
| | | | ExecCreateTableAs
| | | | standard_ProcessUtility
| | | | ProcessUtility
| | | | PortalRunUtility
| | | | PortalRunMulti
| | | | PortalRun
| | | | exec_simple_query
| | | | PostgresMain
| | | | BackendRun
| | | | BackendStartup
| | | | ServerLoop
| | | | PostmasterMain
| | | | main
| | | | __libc_start_main
| | | --0.47%-- [...]
| | |
| | --3.65%-- heap_insert
| | intorel_receive
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--16.71%-- _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --1.85%-- heapgetpage
| heapgettup_pagemode
| heap_getnext
| SeqNext
| ExecScanFetch
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--3.19%-- ReadBuffer_common
| ReadBufferExtended
| |
| |--96.25%-- ReadBuffer
| | |
| | |--72.73%-- ReleaseAndReadBuffer
| | | _bt_relandgetbuf
| | | _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --27.27%-- _bt_getbuf
| | _bt_getroot
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--2.50%-- heapgetpage
| | heapgettup_pagemode
| | heap_getnext
| | SeqNext
| | ExecScanFetch
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --1.25%-- ReadBufferBI
| RelationGetBufferForTuple
| heap_insert
| intorel_receive
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.11%-- _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.92%-- UnlockReleaseBuffer
| _bt_relbuf
| _bt_steppage
| _bt_next
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.60%-- [...]
0.26% postgres ./pg9.2/bin/postgres [.] _bt_checkkeys
|
|--98.51%-- _bt_readpage
| |
| |--99.51%-- _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.49%-- [...]
|
--1.49%-- _bt_first
btgettuple
FunctionCall2Coll
index_getnext_tid
IndexOnlyNext
ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.24% postgres ./pg9.2/bin/postgres [.] heap_compute_data_size
|
|--53.04%-- heap_form_minimal_tuple
| ExecCopySlotMinimalTuple
| copytup_heap
| tuplesort_puttupleslot
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--37.31%-- heap_form_tuple
| ExecCopySlotTuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--9.61%-- ExecCopySlotTuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.05%-- [...]
0.23% postgres ./pg9.2/bin/postgres [.] ExecScanSubPlan
|
|--99.36%-- ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.64%-- ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.20% postgres ./pg9.2/bin/postgres [.] ExecProcNode
|
|--40.72%-- ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--29.81%-- SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--23.59%-- ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.26%-- ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--1.47%-- ExecProcNode
| |
| |--92.31%-- SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --7.69%-- ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--1.02%-- ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.79%-- ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.34%-- [...]
0.20% postgres ./pg9.2/bin/postgres [.] heap_fill_tuple
|
|--68.90%-- heap_form_minimal_tuple
| ExecCopySlotMinimalTuple
| copytup_heap
| tuplesort_puttupleslot
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--30.42%-- heap_form_tuple
| ExecCopySlotTuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.57%-- ExecCopySlotTuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.11%-- [...]
0.20% postgres ./pg9.2/bin/postgres [.] ExecScan
|
|--48.32%-- ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--25.98%-- ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--23.03%-- ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.66%-- ExecProcNode
|
|--65.22%-- ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--32.61%-- ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.17%-- ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.19% postgres ./pg9.2/bin/postgres [.] AllocSetAlloc
|
|--54.40%-- MemoryContextAlloc
| |
| |--97.53%-- _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--2.36%-- heap_tuple_from_minimal_tuple
| | ExecCopySlotTuple
| | ExecMaterializeSlot
| | intorel_receive
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.11%-- [...]
|
|--42.54%-- MemoryContextAllocZero
| |
| |--49.28%-- heap_form_tuple
| | ExecCopySlotTuple
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--46.98%-- bms_make_singleton
| | bms_add_member
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --3.74%-- heap_form_minimal_tuple
| ExecCopySlotMinimalTuple
| copytup_heap
| tuplesort_puttupleslot
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--1.89%-- _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.55%-- bms_make_singleton
| bms_add_member
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.55%-- heap_form_tuple
| ExecCopySlotTuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.06%-- [...]
0.18% postgres ./pg9.2/bin/postgres [.] pfree
|
|--52.16%-- _bt_freestack
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--20.71%-- heap_freetuple
| |
| |--97.24%-- ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --2.76%-- ExecStoreMinimalTuple
| tuplesort_gettupleslot
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--16.07%-- bms_free
| ExecReScan
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--5.40%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--4.64%-- ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.83%-- ExecReScan
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.19%-- [...]
0.18% postgres ./pg9.2/bin/postgres [.] ExecClearTuple
|
|--44.69%-- ExecProject
| ExecScan
| |
| |--51.74%-- ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --48.26%-- ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--22.15%-- ExecScan
| |
| |--94.44%-- ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --5.56%-- ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--19.43%-- IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--11.92%-- StoreIndexTuple
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--1.04%-- ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.78%-- ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.17% postgres ./pg9.2/bin/postgres [.] MemoryContextAllocZero
|
|--57.90%-- heap_form_tuple
| ExecCopySlotTuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--23.33%-- bms_make_singleton
| bms_add_member
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--14.01%-- heap_form_minimal_tuple
| ExecCopySlotMinimalTuple
| copytup_heap
| tuplesort_puttupleslot
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.45%-- bms_add_member
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.25%-- ExecCopySlotTuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.07%-- [...]
0.17% postgres ./pg9.2/bin/postgres [.] heap_form_tuple
|
|--93.52%-- ExecCopySlotTuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--6.48%-- ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.17% postgres ./pg9.2/bin/postgres [.] _bt_moveright
|
|--97.15%-- _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.85%-- _bt_first
btgettuple
FunctionCall2Coll
index_getnext_tid
IndexOnlyNext
ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.17% postgres ./pg9.2/bin/postgres [.] ExecTargetList
|
|--96.66%-- ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--3.34%-- ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.16% postgres ./pg9.2/bin/postgres [.] _bt_readpage
|
|--96.97%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.61%-- btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.42%-- [...]
0.16% postgres ./pg9.2/bin/postgres [.] AllocSetFreeIndex
|
|--47.19%-- AllocSetAlloc
| |
| |--56.86%-- MemoryContextAlloc
| | |
| | |--99.73%-- _bt_search
| | | _bt_first
| | | btgettuple
| | | FunctionCall2Coll
| | | index_getnext_tid
| | | IndexOnlyNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecIndexOnlyScan
| | | ExecProcNode
| | | ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | --0.27%-- [...]
| |
| --43.14%-- MemoryContextAllocZero
| |
| |--51.59%-- heap_form_tuple
| | ExecCopySlotTuple
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--44.52%-- bms_make_singleton
| | bms_add_member
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --3.89%-- heap_form_minimal_tuple
| ExecCopySlotMinimalTuple
| copytup_heap
| tuplesort_puttupleslot
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--40.72%-- AllocSetFree
| pfree
| |
| |--67.14%-- _bt_freestack
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--27.03%-- heap_freetuple
| | |
| | |--95.42%-- ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --4.58%-- ExecStoreMinimalTuple
| | tuplesort_gettupleslot
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --5.83%-- bms_free
| ExecReScan
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--6.62%-- pfree
| |
| |--53.26%-- _bt_freestack
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--29.35%-- bms_free
| | ExecReScan
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --17.39%-- heap_freetuple
| |
| |--93.75%-- ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --6.25%-- ExecStoreMinimalTuple
| tuplesort_gettupleslot
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--3.02%-- MemoryContextAllocZero
| |
| |--64.29%-- bms_make_singleton
| | bms_add_member
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --35.71%-- heap_form_tuple
| ExecCopySlotTuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.45%-- MemoryContextAlloc
|
|--97.06%-- _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.94%-- heap_tuple_from_minimal_tuple
ExecCopySlotTuple
ExecMaterializeSlot
intorel_receive
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.13% postgres ./pg9.2/bin/postgres [.] heapgettup_pagemode
|
|--88.20%-- heap_getnext
| SeqNext
| ExecScanFetch
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--11.80%-- SeqNext
ExecScanFetch
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.13% postgres ./pg9.2/bin/postgres [.] ReadBufferExtended
|
|--89.21%-- ReadBuffer
| |
| |--64.88%-- ReleaseAndReadBuffer
| | _bt_relandgetbuf
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --35.12%-- _bt_getbuf
| |
| |--99.44%-- _bt_getroot
| | _bt_search
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --0.56%-- _bt_steppage
| _bt_next
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--4.18%-- heapgetpage
| heapgettup_pagemode
| heap_getnext
| SeqNext
| ExecScanFetch
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--3.31%-- ReleaseAndReadBuffer
| _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.96%-- _bt_getbuf
| _bt_getroot
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.35%-- [...]
0.12% postgres /lib/libc-2.11.1.so [.] memcpy
|
|--40.49%-- _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--23.97%-- ExecCopySlotTuple
| ExecMaterializeSlot
| intorel_receive
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--17.26%-- ScanKeyEntryInitializeWithInfo
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--15.02%-- _bt_readpage
| |
| |--98.76%-- _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --1.24%-- _bt_steppage
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--3.26%-- RelationPutHeapTuple
heap_insert
intorel_receive
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.12% postgres ./pg9.2/bin/postgres [.] AllocSetFree
|
|--91.66%-- pfree
| |
| |--63.50%-- _bt_freestack
| | _bt_first
| | btgettuple
| | FunctionCall2Coll
| | index_getnext_tid
| | IndexOnlyNext
| | ExecScanFetch
| | ExecScan
| | ExecIndexOnlyScan
| | ExecProcNode
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--21.41%-- heap_freetuple
| | |
| | |--95.17%-- ExecScanSubPlan
| | | ExecSubPlan
| | | ExecTargetList
| | | ExecProject
| | | ExecScan
| | | ExecSeqScan
| | | ExecProcNode
| | | ExecLimit
| | | ExecProcNode
| | | SubqueryNext
| | | ExecScanFetch
| | | ExecScan
| | | ExecSubqueryScan
| | | ExecProcNode
| | | ExecSort
| | | ExecProcNode
| | | ExecutePlan
| | | standard_ExecutorRun
| | | ExecutorRun
| | | ExecCreateTableAs
| | | standard_ProcessUtility
| | | ProcessUtility
| | | PortalRunUtility
| | | PortalRunMulti
| | | PortalRun
| | | exec_simple_query
| | | PostgresMain
| | | BackendRun
| | | BackendStartup
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --4.83%-- ExecStoreMinimalTuple
| | tuplesort_gettupleslot
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--14.99%-- bms_free
| | ExecReScan
| | ExecScanSubPlan
| | ExecSubPlan
| | ExecTargetList
| | ExecProject
| | ExecScan
| | ExecSeqScan
| | ExecProcNode
| | ExecLimit
| | ExecProcNode
| | SubqueryNext
| | ExecScanFetch
| | ExecScan
| | ExecSubqueryScan
| | ExecProcNode
| | ExecSort
| | ExecProcNode
| | ExecutePlan
| | standard_ExecutorRun
| | ExecutorRun
| | ExecCreateTableAs
| | standard_ProcessUtility
| | ProcessUtility
| | PortalRunUtility
| | PortalRunMulti
| | PortalRun
| | exec_simple_query
| | PostgresMain
| | BackendRun
| | BackendStartup
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.10%-- [...]
|
|--6.07%-- _bt_freestack
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--1.42%-- heap_freetuple
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.85%-- bms_free
ExecReScan
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.12% postgres ./pg9.2/bin/postgres [.] index_getnext_tid
|
|--97.32%-- IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.68%-- ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.12% postgres ./pg9.2/bin/postgres [.] StoreIndexTuple
|
|--97.14%-- IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun
| BackendStartup
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.86%-- ExecScanFetch
ExecScan
ExecIndexOnlyScan
ExecProcNode
ExecScanSubPlan
ExecSubPlan
ExecTargetList
ExecProject
ExecScan
ExecSeqScan
ExecProcNode
ExecLimit
ExecProcNode
SubqueryNext
ExecScanFetch
ExecScan
ExecSubqueryScan
ExecProcNode
ExecSort
ExecProcNode
ExecutePlan
standard_ExecutorRun
ExecutorRun
ExecCreateTableAs
standard_ProcessUtility
ProcessUtility
PortalRunUtility
PortalRunMulti
PortalRun
exec_simple_query
PostgresMain
BackendRun
BackendStartup
ServerLoop
PostmasterMain
main
__libc_start_main
0.12% postgres ./pg9.2/bin/postgres [.] ResourceOwnerForgetBuffer
|
|--54.94%-- UnpinBuffer
| ReleaseAndReadBuffer
| _bt_relandgetbuf
| _bt_search
| _bt_first
| btgettuple
| FunctionCall2Coll
| index_getnext_tid
| IndexOnlyNext
| ExecScanFetch
| ExecScan
| ExecIndexOnlyScan
| ExecProcNode
| ExecScanSubPlan
| ExecSubPlan
| ExecTargetList
| ExecProject
| ExecScan
| ExecSeqScan
| ExecProcNode
| ExecLimit
| ExecProcNode
| SubqueryNext
| ExecScanFetch
| ExecScan
| ExecSubqueryScan
| ExecProcNode
| ExecSort
| ExecProcNode
| ExecutePlan
| standard_ExecutorRun
| ExecutorRun
| ExecCreateTableAs
| standard_ProcessUtility
| ProcessUtility
| PortalRunUtility
| PortalRunMulti
| PortalRun
| exec_simple_query
| PostgresMain
| BackendRun