minmax-locktuple-is-expensive-profile
text/plain
Filename: minmax-locktuple-is-expensive-profile
Type: text/plain
Part: 0
Message:
Re: Minmax indexes
# To display the perf.data header info, please use --header/--header-only options.
#
# Samples: 3K of event 'cycles'
# Event count (approx.): 2332550418
#
# Overhead Command Shared Object Symbol
# ........ .......... ................. ...............................
#
24.15% postmaster postgres [.] hash_search_with_hash_value
|
--- hash_search_with_hash_value
|
|--32.37%-- SetupLockInTable.isra.2
| LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--24.37%-- CleanUpLock
| LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--21.89%-- LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--11.39%-- LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--8.79%-- RemoveLocalLock
| |
| |--98.51%-- LockRelease
| | UnlockTuple
| | mmgetbitmap
| | FunctionCall2Coll
| | index_getbitmap
| | MultiExecBitmapIndexScan
| | BitmapHeapNext
| | ExecScan
| | ExecProcNode
| | standard_ExecutorRun
| | ExplainOnePlan
| | ExplainOneQuery
| | ExplainQuery
| | standard_ProcessUtility
| | PortalRunUtility
| | FillPortalStore
| | PortalRun
| | PostgresMain
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --1.49%-- LockReleaseAll
| ProcReleaseLocks
| ResourceOwnerReleaseInternal
| ResourceOwnerRelease
| CommitTransaction
| CommitTransactionCommand
| finish_xact_command.part.4
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--1.20%-- [...]
10.55% postmaster postgres [.] LWLockAcquireCommon
|
--- LWLockAcquireCommon
|
|--26.75%-- LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--26.16%-- LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--23.09%-- mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--22.16%-- rm_get_phys_blkno.part.1
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.62%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.62%-- LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.59%-- UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
7.12% postmaster postgres [.] hash_any
|
--- hash_any
|
|--94.00%-- tag_hash
| |
| |--82.07%-- hash_search
| | |
| | |--38.43%-- LockAcquireExtended
| | | LockTuple
| | | mmGetHeapBlockItemptr
| | | mmgetbitmap
| | | FunctionCall2Coll
| | | index_getbitmap
| | | MultiExecBitmapIndexScan
| | | BitmapHeapNext
| | | ExecScan
| | | ExecProcNode
| | | standard_ExecutorRun
| | | ExplainOnePlan
| | | ExplainOneQuery
| | | ExplainQuery
| | | standard_ProcessUtility
| | | PortalRunUtility
| | | FillPortalStore
| | | PortalRun
| | | PostgresMain
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | |--37.48%-- LockRelease
| | | UnlockTuple
| | | mmgetbitmap
| | | FunctionCall2Coll
| | | index_getbitmap
| | | MultiExecBitmapIndexScan
| | | BitmapHeapNext
| | | ExecScan
| | | ExecProcNode
| | | standard_ExecutorRun
| | | ExplainOnePlan
| | | ExplainOneQuery
| | | ExplainQuery
| | | standard_ProcessUtility
| | | PortalRunUtility
| | | FillPortalStore
| | | PortalRun
| | | PostgresMain
| | | ServerLoop
| | | PostmasterMain
| | | main
| | | __libc_start_main
| | |
| | --24.09%-- RemoveLocalLock
| | LockRelease
| | UnlockTuple
| | mmgetbitmap
| | FunctionCall2Coll
| | index_getbitmap
| | MultiExecBitmapIndexScan
| | BitmapHeapNext
| | ExecScan
| | ExecProcNode
| | standard_ExecutorRun
| | ExplainOnePlan
| | ExplainOneQuery
| | ExplainQuery
| | standard_ProcessUtility
| | PortalRunUtility
| | FillPortalStore
| | PortalRun
| | PostgresMain
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--17.43%-- LockAcquireExtended
| | LockTuple
| | mmGetHeapBlockItemptr
| | mmgetbitmap
| | FunctionCall2Coll
| | index_getbitmap
| | MultiExecBitmapIndexScan
| | BitmapHeapNext
| | ExecScan
| | ExecProcNode
| | standard_ExecutorRun
| | ExplainOnePlan
| | ExplainOneQuery
| | ExplainQuery
| | standard_ProcessUtility
| | PortalRunUtility
| | FillPortalStore
| | PortalRun
| | PostgresMain
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| --0.49%-- [...]
|
|--4.34%-- hash_search
| |
| |--50.11%-- LockAcquireExtended
| | LockTuple
| | mmGetHeapBlockItemptr
| | mmgetbitmap
| | FunctionCall2Coll
| | index_getbitmap
| | MultiExecBitmapIndexScan
| | BitmapHeapNext
| | ExecScan
| | ExecProcNode
| | standard_ExecutorRun
| | ExplainOnePlan
| | ExplainOneQuery
| | ExplainQuery
| | standard_ProcessUtility
| | PortalRunUtility
| | FillPortalStore
| | PortalRun
| | PostgresMain
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| |--39.26%-- RemoveLocalLock
| | LockRelease
| | UnlockTuple
| | mmgetbitmap
| | FunctionCall2Coll
| | index_getbitmap
| | MultiExecBitmapIndexScan
| | BitmapHeapNext
| | ExecScan
| | ExecProcNode
| | standard_ExecutorRun
| | ExplainOnePlan
| | ExplainOneQuery
| | ExplainQuery
| | standard_ProcessUtility
| | PortalRunUtility
| | FillPortalStore
| | PortalRun
| | PostgresMain
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --10.63%-- LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--1.66%-- LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
6.77% postmaster postgres [.] minmax_deform_tuple
|
--- minmax_deform_tuple
|
|--99.28%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.72%-- FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
6.67% postmaster postgres [.] LWLockRelease
|
--- LWLockRelease
|
|--29.76%-- rm_get_phys_blkno.part.1
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--24.17%-- LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--20.60%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--20.28%-- LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.46%-- UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--1.41%-- LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--0.82%-- ReadBuffer_common
| ReadBufferExtended
| |
| |--50.90%-- mmGetHeapBlockItemptr
| | mmgetbitmap
| | FunctionCall2Coll
| | index_getbitmap
| | MultiExecBitmapIndexScan
| | BitmapHeapNext
| | ExecScan
| | ExecProcNode
| | standard_ExecutorRun
| | ExplainOnePlan
| | ExplainOneQuery
| | ExplainQuery
| | standard_ProcessUtility
| | PortalRunUtility
| | FillPortalStore
| | PortalRun
| | PostgresMain
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --49.10%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
--0.49%-- [...]
5.55% postmaster postgres [.] AllocSetAlloc
|
--- AllocSetAlloc
|
|--66.88%-- minmax_deform_tuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--15.03%-- palloc0
| minmax_new_dtuple
| minmax_deform_tuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--12.87%-- LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.92%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--1.43%-- minmax_new_dtuple
| minmax_deform_tuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--0.87%-- LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
4.37% postmaster postgres [.] SetupLockInTable.isra.2
|
--- SetupLockInTable.isra.2
LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
2.79% postmaster postgres [.] LockRelease
|
--- LockRelease
|
|--98.82%-- UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--1.18%-- mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
2.67% postmaster postgres [.] LockAcquireExtended
|
--- LockAcquireExtended
|
|--96.32%-- LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--2.45%-- mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--1.23%-- LockRelationOid
relation_open
set_relation_column_names
set_simple_column_names
deparse_context_for_planstate
show_expression
ExplainNode
ExplainNode
ExplainPrintPlan
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
2.54% postmaster postgres [.] mmgetbitmap
|
--- mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
2.49% postmaster postgres [.] AllocSetFree
|
--- AllocSetFree
|
|--42.28%-- minmax_deform_tuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--33.76%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--15.65%-- RemoveLocalLock
| LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--5.85%-- FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--1.32%-- pq_endmessage
| printtup
| RunFromStore
| PortalRunSelect
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--1.15%-- LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
2.03% postmaster postgres [.] rm_get_phys_blkno.part.1
|
--- rm_get_phys_blkno.part.1
|
|--97.80%-- mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.20%-- mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
1.93% postmaster postgres [.] mmGetHeapBlockItemptr
|
--- mmGetHeapBlockItemptr
|
|--94.32%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--5.68%-- FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
1.53% postmaster postgres [.] pfree
|
--- pfree
|
|--47.13%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--25.50%-- FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--18.00%-- minmax_deform_tuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--9.37%-- LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
1.44% postmaster libc-2.19.so [.] __memcmp_sse4_1
|
--- __memcmp_sse4_1
|
|--44.42%-- LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--32.41%-- CleanUpLock
| LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--23.17%-- RemoveLocalLock
LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
1.41% postmaster postgres [.] mmSortableConsistent
|
--- mmSortableConsistent
|
|--97.91%-- FunctionCall3Coll
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.09%-- mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
1.20% postmaster postgres [.] hash_search
|
--- hash_search
|
|--36.63%-- RemoveLocalLock
| LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--35.89%-- LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--27.48%-- LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
1.14% postmaster libc-2.19.so [.] __memcpy_sse2_unaligned
|
--- __memcpy_sse2_unaligned
|
|--55.81%-- LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--44.19%-- SetupLockInTable.isra.2
LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
1.09% postmaster postgres [.] palloc
|
--- palloc
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
1.01% postmaster postgres [.] FunctionCall3Coll
|
--- FunctionCall3Coll
|
|--94.27%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--5.73%-- FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.82% postmaster postgres [.] UnlockTuple
|
--- UnlockTuple
|
|--61.35%-- FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--38.65%-- mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.78% postmaster postgres [.] minmax_new_dtuple
|
--- minmax_new_dtuple
|
|--88.20%-- minmax_deform_tuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--11.80%-- mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.77% postmaster postgres [.] CleanUpLock
|
--- CleanUpLock
|
|--80.98%-- LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--19.02%-- UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.67% postmaster postgres [.] LockBuffer
|
--- LockBuffer
|
|--64.62%-- mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--24.01%-- FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--11.37%-- mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.65% postmaster postgres [.] GrantLockLocal
|
--- GrantLockLocal
|
|--50.16%-- LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--49.84%-- LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.60% postmaster postgres [.] palloc0
|
--- palloc0
|
|--89.18%-- minmax_new_dtuple
| minmax_deform_tuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--10.82%-- minmax_deform_tuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.60% postmaster postgres [.] SHMQueueDelete
|
--- SHMQueueDelete
|
|--63.28%-- LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--36.72%-- CleanUpLock
LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.50% postmaster postgres [.] FunctionCall2Coll
|
--- FunctionCall2Coll
|
|--93.57%-- mmSortableConsistent
| FunctionCall3Coll
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--6.43%-- FunctionCall3Coll
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.48% postmaster postgres [.] mmsrt_get_procinfo
|
--- mmsrt_get_procinfo
|
|--84.13%-- mmSortableConsistent
| FunctionCall3Coll
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--15.87%-- FunctionCall3Coll
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.47% postmaster postgres [.] tag_hash
|
--- tag_hash
|
|--34.78%-- hash_search
| |
| |--89.55%-- RemoveLocalLock
| | LockRelease
| | UnlockTuple
| | mmgetbitmap
| | FunctionCall2Coll
| | index_getbitmap
| | MultiExecBitmapIndexScan
| | BitmapHeapNext
| | ExecScan
| | ExecProcNode
| | standard_ExecutorRun
| | ExplainOnePlan
| | ExplainOneQuery
| | ExplainQuery
| | standard_ProcessUtility
| | PortalRunUtility
| | FillPortalStore
| | PortalRun
| | PostgresMain
| | ServerLoop
| | PostmasterMain
| | main
| | __libc_start_main
| |
| --10.45%-- LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--21.19%-- LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--16.97%-- RemoveLocalLock
| LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--13.71%-- LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--13.34%-- LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.46% postmaster postgres [.] UnGrantLock.isra.1
|
--- UnGrantLock.isra.1
|
|--50.58%-- UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--49.42%-- LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.46% postmaster postgres [.] BufferGetBlockNumber
|
--- BufferGetBlockNumber
|
|--49.05%-- rm_get_phys_blkno.part.1
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--33.70%-- mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--14.31%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--2.93%-- FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.45% postmaster postgres [.] SHMQueueInsertBefore
|
--- SHMQueueInsertBefore
|
|--61.10%-- SetupLockInTable.isra.2
| LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--38.90%-- LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.39% postmaster postgres [.] ResourceOwnerForgetLock
|
--- ResourceOwnerForgetLock
|
|--91.57%-- LockRelease
| UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--8.43%-- UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.38% postmaster postgres [.] RemoveLocalLock
|
--- RemoveLocalLock
|
|--52.14%-- UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--47.86%-- LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.31% postmaster postgres [.] LWLockAcquire
|
--- LWLockAcquire
|
|--31.69%-- mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--21.39%-- mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--20.91%-- UnlockTuple
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
|--15.38%-- rm_get_phys_blkno.part.1
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--10.64%-- LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.27% postmaster postgres [.] ProcQueueInit
|
--- ProcQueueInit
|
|--76.16%-- SetupLockInTable.isra.2
| LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--23.84%-- LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.27% postmaster postgres [.] memcpy@plt
|
--- memcpy@plt
|
|--94.95%-- SetupLockInTable.isra.2
| LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--5.05%-- LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.24% postmaster postgres [.] ResourceOwnerRememberLock
|
--- ResourceOwnerRememberLock
|
|--65.78%-- LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--34.22%-- LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.23% postmaster postgres [.] RecoveryInProgress
|
--- RecoveryInProgress
|
|--57.39%-- LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--42.61%-- LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.22% postmaster postgres [.] LockTuple
|
--- LockTuple
|
|--64.73%-- mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--35.27%-- mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.20% postmaster postgres [.] SHMQueueInit
|
--- SHMQueueInit
|
|--70.81%-- SetupLockInTable.isra.2
| LockAcquireExtended
| LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--29.19%-- LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.20% postmaster postgres [.] MemoryContextAlloc
|
--- MemoryContextAlloc
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.16% postmaster postgres [.] LockAcquire
|
--- LockAcquire
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.14% postmaster postgres [.] LockCheckConflicts
|
--- LockCheckConflicts
|
|--89.94%-- LockTuple
| mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--10.06%-- LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.07% postmaster postgres [.] ReadBufferExtended
|
--- ReadBufferExtended
|
|--50.05%-- mmGetHeapBlockItemptr
| mmgetbitmap
| FunctionCall2Coll
| index_getbitmap
| MultiExecBitmapIndexScan
| BitmapHeapNext
| ExecScan
| ExecProcNode
| standard_ExecutorRun
| ExplainOnePlan
| ExplainOneQuery
| ExplainQuery
| standard_ProcessUtility
| PortalRunUtility
| FillPortalStore
| PortalRun
| PostgresMain
| ServerLoop
| PostmasterMain
| main
| __libc_start_main
|
--49.95%-- mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.07% postmaster postgres [.] get_hash_value
|
--- get_hash_value
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.05% postmaster postgres [.] PortalRun
|
--- PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.04% postmaster postgres [.] PostgresMain
|
--- PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster postgres [.] core_yylex
|
--- core_yylex
base_yylex
base_yyparse
raw_parser
pg_parse_query
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster postgres [.] errstart
|
--- errstart
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster libc-2.19.so [.] _itoa_word
|
--- _itoa_word
_IO_vsnprintf
0x2e2e30302e353832
0.03% postmaster postgres [.] int4le
|
--- int4le
mmSortableConsistent
FunctionCall3Coll
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster postgres [.] process_equivalence
|
--- process_equivalence
deconstruct_recurse
deconstruct_jointree
query_planner
grouping_planner
subquery_planner
standard_planner
pg_plan_query
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster postgres [.] initStringInfo
|
--- initStringInfo
show_expression
ExplainNode
ExplainPrintPlan
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster postgres [.] SearchCatCache
|
--- SearchCatCache
TupleDescInitEntry
ExplainResultDesc
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster [kernel.kallsyms] [k] update_curr
|
--- update_curr
__libc_recv
0.03% postmaster [kvm] [k] pvclock_gtod_notify
|
--- pvclock_gtod_notify
hash_search_with_hash_value
LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster [kernel.kallsyms] [k] cpuacct_charge
|
--- cpuacct_charge
hash_any
tag_hash
hash_search
RemoveLocalLock
LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster postgres [.] LockReleaseAll
|
--- LockReleaseAll
ResourceOwnerReleaseInternal
ResourceOwnerRelease
CommitTransaction
CommitTransactionCommand
finish_xact_command.part.4
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster libc-2.19.so [.] _int_free
|
--- _int_free
0.03% postmaster [kernel.kallsyms] [k] note_gp_changes
|
--- note_gp_changes
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster postgres [.] base_yyparse
|
--- base_yyparse
raw_parser
pg_parse_query
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster postgres [.] pg_ltoa
|
--- pg_ltoa
FunctionCall1Coll
OutputFunctionCall
OidOutputFunctionCall
get_const_expr
get_rule_expr
get_rule_expr
deparse_expression_pretty.constprop.24
show_expression
ExplainNode
ExplainPrintPlan
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster [kernel.kallsyms] [k] __internal_add_timer
|
--- __internal_add_timer
hash_search_with_hash_value
SetupLockInTable.isra.2
LockAcquireExtended
LockTuple
mmGetHeapBlockItemptr
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.03% postmaster [kernel.kallsyms] [k] idle_cpu
|
--- idle_cpu
FunctionCall3Coll
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.02% postmaster [kernel.kallsyms] [k] intel_pstate_timer_func
|
--- intel_pstate_timer_func
hash_search_with_hash_value
LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.02% postmaster [libata] [k] ata_scsi_qc_complete
|
--- ata_scsi_qc_complete
hash_search_with_hash_value
CleanUpLock
LockRelease
UnlockTuple
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.02% postmaster postgres [.] mmtuple_disk_tupdesc
|
--- mmtuple_disk_tupdesc
mmgetbitmap
FunctionCall2Coll
index_getbitmap
MultiExecBitmapIndexScan
BitmapHeapNext
ExecScan
ExecProcNode
standard_ExecutorRun
ExplainOnePlan
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.01% postmaster postgres [.] lappend
|
--- lappend
distribute_restrictinfo_to_rels
generate_base_implied_equalities
query_planner
grouping_planner
subquery_planner
standard_planner
pg_plan_query
ExplainOneQuery
ExplainQuery
standard_ProcessUtility
PortalRunUtility
FillPortalStore
PortalRun
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.01% postmaster libc-2.19.so [.] __GI___strcmp_ssse3
|
--- __GI___strcmp_ssse3
core_yylex
base_yylex
base_yyparse
raw_parser
pg_parse_query
PostgresMain
ServerLoop
PostmasterMain
main
__libc_start_main
0.00% postmaster [kernel.kallsyms] [k] kmem_cache_free
|
--- kmem_cache_free
__libc_recv
0.00% postmaster [kernel.kallsyms] [k] finish_task_switch
|
--- finish_task_switch
__libc_recv
0.00% postmaster [kernel.kallsyms] [k] native_write_msr_safe
|
--- native_write_msr_safe
__libc_recv
#
# (For a higher level overview, try: perf report --sort comm,dso)
#