# 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) #