# Events: 30K cycles # # Overhead Parent symbol # ........ ............. # 100.00% [other] | --- (nil) | --97.69%-- __libc_start_main generic_start_main.isra.0 | --97.57%-- main PostmasterMain | --97.30%-- PostgresMain | --97.29%-- PortalRun PortalRunMulti | --97.23%-- ProcessQuery | --97.22%-- standard_ExecutorRun ExecProcNode | --97.17%-- ExecModifyTable | |--92.51%-- ExecBRInsertTriggers | | | --92.03%-- ExecCallTriggerFunc | | | --91.25%-- plpgsql_call_handler | | | |--85.72%-- plpgsql_exec_trigger | | | | | |--73.30%-- exec_stmt_block | | | | | | | --72.82%-- exec_stmts | | | | | | | |--66.68%-- exec_stmt_execsql | | | | | | | | | |--64.78%-- SPI_execute_plan_with_paramlist | | | | | | | | | | | --64.06%-- _SPI_execute_plan | | | | | | | | | | | |--32.27%-- standard_ExecutorRun | | | | | | | | | | | | | --32.01%-- ExecProcNode | | | | | | | | | | | | | --31.83%-- ExecModifyTable | | | | | | | | | | | | | |--16.83%-- ExecConstraints | | | | | | | | | | | | | | | |--11.69%-- ExecPrepareExpr | | | | | | | | | | | | | | | | | |--7.51%-- expression_planner | | | | | | | | | | | | | | | | | | | |--6.21%-- eval_const_expressions | | | | | | | | | | | | | | | | | | | | | --6.14%-- eval_const_expressions_mutator | | | | | | | | | | | | | | | | | | | | | --6.02%-- expression_tree_mutator | | | | | | | | | | | | | | | | | | | | | --5.08%-- eval_const_expressions_mutator | | | | | | | | | | | | | | | | | | | | | --4.43%-- simplify_function | | | | | | | | | | | | | | | | | | | | | |--2.32%-- expression_tree_mutator | | | | | | | | | | | | | | | | | | | | | | | --1.11%-- eval_const_expressions_mutator | | | | | | | | | | | | | | | | | | | | | --1.25%-- SearchSysCache | | | | | | | | | | | | | | | | | | | | | --1.13%-- SearchCatCache | | | | | | | | | | | | | | | | | | | --1.14%-- fix_opfuncids_walker | | | | | | | | | | | | | | | | | | | --1.09%-- expression_tree_walker | | | | | | | | | | | | | | | | | --4.09%-- ExecInitExpr | | | | | | | | | | | | | | | | | --3.66%-- ExecInitExpr | | | | | | | | | | | | | | | | | |--1.74%-- ExecInitExpr | | | | | | | | | | | | | | | | | --1.68%-- MemoryContextAllocZero | | | | | | | | | | | | | | | |--3.29%-- ExecQual | | | | | | | | | | | | | | | | | |--1.65%-- ExecMakeFunctionResult | | | | | | | | | | | | | | | | | --1.48%-- ExecEvalOper | | | | | | | | | | | | | | | | | --1.33%-- init_fcache | | | | | | | | | | | | | | | --1.21%-- MakePerTupleExprContext | | | | | | | | | | | | | | | --1.09%-- CreateExprContext | | | | | | | | | | | | | |--7.83%-- heap_insert | | | | | | | | | | | | | | | |--3.04%-- RelationGetBufferForTuple | | | | | | | | | | | | | | | | | --2.32%-- ReadBufferBI | | | | | | | | | | | | | | | | | --2.23%-- ReadBufferExtended | | | | | | | | | | | | | | | | | --2.15%-- ReadBuffer_common | | | | | | | | | | | | | | | --2.60%-- XLogInsert | | | | | | | | | | | | | | | --2.01%-- XLogInsert | | | | | | | | | | | | | |--4.44%-- ExecProcNode | | | | | | | | | | | | | | | --4.30%-- ExecResult | | | | | | | | | | | | | | | --4.07%-- ExecProject | | | | | | | | | | | | | | | --3.74%-- ExecEvalFieldSelect | | | | | | | | | | | | | | | |--2.30%-- ExecEvalParamExtern | | | | | | | | | | | | | | | | | --2.17%-- plpgsql_param_fetch | | | | | | | | | | | | | | | | | --1.89%-- exec_eval_datum | | | | | | | | | | | | | | | | | --1.53%-- heap_copytuple_with_tuple | | | | | | | | | | | | | | | | | --1.25%-- palloc | | | | | | | | | | | | | | | | | --1.09%-- AllocSetAlloc | | | | | | | | | | | | | | | --1.05%-- get_cached_rowtype | | | | | | | | | | | | | --1.11%-- ExecMaterializeSlot | | | | | | | | | | | | | --1.04%-- ExecCopySlotTuple | | | | | | | | | | | |--17.34%-- standard_ExecutorStart | | | | | | | | | | | | | |--10.87%-- ExecInitNode | | | | | | | | | | | | | | | --10.71%-- ExecInitModifyTable | | | | | | | | | | | | | | | --7.73%-- ExecInitNode | | | | | | | | | | | | | | | --7.64%-- ExecInitResult | | | | | | | | | | | | | | | |--2.49%-- ExecAssignResultTypeFromTL | | | | | | | | | | | | | | | | | --1.99%-- ExecTypeFromTLInternal | | | | | | | | | | | | | | | | | --1.18%-- TupleDescInitEntry | | | | | | | | | | | | | | | |--1.45%-- ExecInitExpr | | | | | | | | | | | | | | | | | --1.14%-- ExecInitExpr | | | | | | | | | | | | | | | |--1.29%-- ExecAssignExprContext | | | | | | | | | | | | | | | | | --1.22%-- CreateExprContext | | | | | | | | | | | | | | | --1.25%-- ExecAssignProjectionInfo | | | | | | | | | | | | | | | --1.18%-- ExecBuildProjectionInfo | | | | | | | | | | | | | |--1.89%-- CreateExecutorState | | | | | | | | | | | | | | | --1.12%-- MemoryContextAllocZeroAligned | | | | | | | | | | | | | |--1.65%-- ExecCheckRTPerms | | | | | | | | | | | | | | | --1.54%-- pg_class_aclmask | | | | | | | | | | | | | --1.63%-- heap_open | | | | | | | | | | | | | --1.52%-- relation_open | | | | | | | | | | | |--5.23%-- GetCachedPlan | | | | | | | | | | | | | --3.82%-- RevalidateCachedQuery | | | | | | | | | | | | | |--2.30%-- OverrideSearchPathMatchesCurrent | | | | | | | | | | | | | | | --1.57%-- GetOverrideSearchPath | | | | | | | | | | | | | --1.39%-- AcquirePlannerLocks | | | | | | | | | | | | | --1.28%-- ScanQueryForLocks | | | | | | | | | | | | | --1.25%-- LockRelationOid | | | | | | | | | | | | | --1.02%-- LockAcquireExtended | | | | | | | | | | | --4.66%-- standard_ExecutorEnd | | | | | | | | | | | --3.12%-- FreeExecutorState | | | | | | | | | | | |--1.62%-- FreeExprContext | | | | | | | | | | | --1.43%-- MemoryContextDelete | | | | | | | | | | | --1.25%-- AllocSetDelete | | | | | | | | | | | --1.02%-- AllocSetDelete | | | | | | | | | --1.31%-- setup_param_list | | | | | | | --5.41%-- exec_eval_expr | | | | | | | --2.69%-- SPI_plan_get_cached_plan | | | | | | | --2.59%-- GetCachedPlan | | | | | | | --2.18%-- RevalidateCachedQuery | | | | | | | --1.85%-- OverrideSearchPathMatchesCurrent | | | | | |--2.59%-- copy_plpgsql_datum | | | | | | | --1.04%-- memcpy | | | | | |--2.44%-- plpgsql_estate_setup | | | | | | | --1.36%-- plpgsql_create_econtext | | | | | | | --1.08%-- CreateExprContext | | | | | |--1.77%-- DirectFunctionCall1Coll | | | | | | | --1.58%-- namein | | | | | |--1.74%-- plpgsql_destroy_econtext | | | | | | | --1.22%-- FreeExprContext | | | | | |--1.63%-- plpgsql_exec_trigger | | | | | --1.02%-- get_namespace_name | | | |--1.88%-- plpgsql_compile | | | | | --1.26%-- SearchSysCache | | | | | --1.09%-- SearchCatCache | | | |--1.41%-- SPI_finish | | | | | --1.25%-- MemoryContextDelete | | | --1.31%-- SPI_connect | | | --1.17%-- AllocSetContextCreate | | | --1.07%-- MemoryContextCreate | --3.58%-- ExecProcNode | --3.55%-- ExecFunctionScan | --3.45%-- ExecScan | --3.22%-- FunctionNext | |--1.93%-- tuplestore_gettupleslot | | | --1.33%-- tuplestore_gettuple | --1.21%-- ExecMakeTableFunctionResult | --- .start_secondary_prolog .start_secondary | --1.55%-- .cpu_idle | --1.28%-- .pseries_dedicated_idle_sleep | --1.23%-- .pseries_dedicated_idle_sleep