# Events: 9K cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ............................... # 8.16% 734 postgres postgres [.] slot_getattr | --- slot_getattr | |--74.77%-- ExecMakeFunctionResultNoSets | | | |--79.05%-- ExecQual | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--14.39%-- ExecMakeFunctionResultNoSets | | | | | |--78.48%-- ExecProject | | | advance_aggregates | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --21.52%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --6.56%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--18.39%-- execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.67%-- TupleHashTableHash | hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--1.50%-- TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--0.54%-- hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main --0.14%-- [...] 7.80% 702 postgres postgres [.] ExecProject | --- ExecProject | |--97.15%-- advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.85%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 6.73% 606 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple | |--99.17%-- slot_getattr | | | |--52.41%-- ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --47.59%-- execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main --0.83%-- [...] 6.09% 548 postgres libc-2.11.3.so [.] __GI___isinf | --- __GI___isinf | |--53.48%-- advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --46.52%-- ExecMakeFunctionResultNoSets | |--65.10%-- ExecMakeFunctionResultNoSets | | | |--76.51%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --23.49%-- ExecMakeFunctionResultNoSets | ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --34.90%-- ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 5.75% 518 postgres postgres [.] ExecMakeFunctionResultNoSets | --- ExecMakeFunctionResultNoSets | |--50.58%-- ExecMakeFunctionResultNoSets | | | |--78.25%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --21.75%-- ExecMakeFunctionResultNoSets | ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--35.13%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--11.97%-- ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--1.16%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.16%-- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 3.78% 340 postgres postgres [.] advance_aggregates | --- advance_aggregates | |--98.82%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.18%-- ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 3.49% 314 postgres postgres [.] bpchareq | --- bpchareq | |--95.86%-- FunctionCall2Coll | execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.14%-- execTuplesMatch TupleHashTableMatch hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 3.45% 311 postgres postgres [.] ExecClearTuple | --- ExecClearTuple | |--92.60%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.40%-- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 3.00% 270 postgres postgres [.] advance_transition_function | --- advance_transition_function | |--92.59%-- advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.41%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.50% 225 postgres postgres [.] float4_accum | --- float4_accum | |--76.89%-- advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --23.11%-- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.13% 192 postgres postgres [.] hash_search_with_hash_value | --- hash_search_with_hash_value | |--96.87%-- LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.13%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.01% 181 postgres postgres [.] float84mi | --- float84mi ExecMakeFunctionResultNoSets | |--77.90%-- ExecMakeFunctionResultNoSets | | | |--69.51%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --30.49%-- ExecMakeFunctionResultNoSets | ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --22.10%-- ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.91% 172 postgres postgres [.] bcTruelen | --- bcTruelen | |--50.58%-- bpchareq | FunctionCall2Coll | execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--29.65%-- hashbpchar | FunctionCall1Coll | TupleHashTableHash | hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--10.47%-- FunctionCall2Coll | execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.30%-- FunctionCall1Coll TupleHashTableHash hash_search LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.88% 169 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600186 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60018e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600191 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60018c 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600180 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60019e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600183 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.82% 164 postgres postgres [.] DatumGetFloat4 | --- DatumGetFloat4 | |--25.61%-- advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--19.51%-- ExecMakeFunctionResultNoSets | | | |--53.12%-- ExecMakeFunctionResultNoSets | | | | | |--76.47%-- ExecProject | | | advance_aggregates | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --23.53%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --46.88%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--18.29%-- float4pl | advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--17.68%-- float84mi | ExecMakeFunctionResultNoSets | ExecMakeFunctionResultNoSets | | | |--55.17%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --44.83%-- ExecMakeFunctionResultNoSets | ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.15%-- float4_accum | advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--7.93%-- float48mul | ExecMakeFunctionResultNoSets | | | |--84.61%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --15.39%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.83%-- float84pl ExecMakeFunctionResultNoSets ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.81% 1 postgres [vdso] [.] 0x7fffe8fff8c1 | --- 0x7fffe8fff8f5 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff662 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8d1 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8c1 __gettimeofday_internal | |--98.00%-- ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.00%-- BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main | --- 0x7fffe8fff8b0 ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff657 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff6a5 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff677 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8c4 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8e1 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff90a __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8f9 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff665 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff640 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff6ae 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8b6 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff636 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff61e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff648 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff900 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8fc __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff626 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8ee __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff601 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff606 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff619 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff604 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8d8 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff631 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8b4 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.79% 161 postgres postgres [.] float48mul | --- float48mul | |--80.12%-- ExecMakeFunctionResultNoSets | | | |--67.44%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --32.56%-- ExecMakeFunctionResultNoSets | ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.88%-- ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.78% 160 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast | |--63.58%-- ExecMakeFunctionResultNoSets | | | |--47.06%-- ExecMakeFunctionResultNoSets | | | | | |--81.25%-- ExecProject | | | advance_aggregates | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --18.75%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--42.15%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --10.78%-- ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.05%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.36%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.42% 128 postgres postgres [.] check_stack_depth | --- check_stack_depth | |--87.50%-- ExecMakeFunctionResultNoSets | | | |--59.81%-- ExecMakeFunctionResultNoSets | | | | | |--79.10%-- ExecProject | | | advance_aggregates | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --20.90%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--32.15%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --8.03%-- ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--8.59%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.91%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.31% 118 postgres postgres [.] DatumGetFloat8 | --- DatumGetFloat8 | |--31.36%-- ExecMakeFunctionResultNoSets | | | |--91.89%-- ExecMakeFunctionResultNoSets | | | | | |--67.65%-- ExecProject | | | advance_aggregates | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --32.35%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --8.11%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--15.25%-- float8mul | ExecMakeFunctionResultNoSets | ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--14.41%-- float84mi | ExecMakeFunctionResultNoSets | ExecMakeFunctionResultNoSets | | | |--58.82%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --41.18%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--11.86%-- float84pl | ExecMakeFunctionResultNoSets | ExecMakeFunctionResultNoSets | ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--10.17%-- advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--8.47%-- float48mul | ExecMakeFunctionResultNoSets | | | |--80.00%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --20.00%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.47%-- float8pl advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.26% 113 postgres postgres [.] ExecAgg | --- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.26% 113 postgres postgres [.] CHashBucketScan | --- CHashBucketScan | |--98.23%-- CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.77%-- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.19% 107 postgres postgres [.] float84pl | --- float84pl ExecMakeFunctionResultNoSets | |--52.34%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --47.66%-- ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.19% 107 postgres postgres [.] float8mul | --- float8mul | |--58.88%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --41.12%-- ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.18% 106 postgres postgres [.] slot_getsomeattrs | --- slot_getsomeattrs | |--57.55%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--32.07%-- advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.43%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --0.94%-- ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.17% 1 postgres postgres [.] hash_any | --- hash_any | |--93.12%-- hashbpchar | FunctionCall1Coll | TupleHashTableHash | hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.75%-- FunctionCall1Coll | TupleHashTableHash | hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--1.90%-- CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main --0.23%-- [...] 1.16% 104 postgres postgres [.] ExecEvalConst | --- ExecEvalConst | |--95.19%-- ExecMakeFunctionResultNoSets | | | |--53.53%-- ExecMakeFunctionResultNoSets | | | | | |--81.13%-- ExecProject | | | advance_aggregates | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --18.87%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--31.31%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --15.15%-- ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.81%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.13% 102 postgres postgres [.] pgstat_end_function_usage | --- pgstat_end_function_usage | |--77.45%-- ExecMakeFunctionResultNoSets | | | |--54.43%-- ExecMakeFunctionResultNoSets | | | | | |--81.39%-- ExecProject | | | advance_aggregates | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --18.61%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--34.18%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --11.39%-- ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--15.69%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.86%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.01% 91 postgres postgres [.] float4pl | --- float4pl | |--61.54%-- advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --38.46%-- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.98% 88 postgres postgres [.] execTuplesMatch | --- execTuplesMatch | |--93.18%-- TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.82%-- hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.97% 87 postgres postgres [.] InstrStopNode | --- InstrStopNode | |--98.85%-- ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.15%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.96% 86 postgres postgres [.] pgstat_init_function_usage | --- pgstat_init_function_usage | |--94.19%-- ExecMakeFunctionResultNoSets | | | |--51.85%-- ExecMakeFunctionResultNoSets | | | | | |--64.28%-- ExecProject | | | advance_aggregates | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --35.72%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--34.57%-- ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --13.58%-- ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--3.49%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.33%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.88% 79 postgres postgres [.] float8pl | --- float8pl | |--97.47%-- advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.53%-- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.86% 77 postgres postgres [.] heapgettup_pagemode | --- heapgettup_pagemode | |--92.21%-- heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.79%-- SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.77% 69 postgres postgres [.] TupleHashTableHash | --- TupleHashTableHash | |--92.75%-- hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.25%-- LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.73% 66 postgres postgres [.] FunctionCall2Coll | --- FunctionCall2Coll | |--87.88%-- execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.12%-- TupleHashTableMatch hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.73% 66 postgres postgres [.] Float8GetDatum | --- Float8GetDatum | |--66.67%-- ExecMakeFunctionResultNoSets | | | |--56.82%-- ExecMakeFunctionResultNoSets | | ExecProject | | advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --43.18%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--12.12%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--10.61%-- advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --10.60%-- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.64% 58 postgres postgres [.] ExecStoreVirtualTuple | --- ExecStoreVirtualTuple | |--67.24%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --32.76%-- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.58% 52 postgres postgres [.] pg_detoast_datum_packed | --- pg_detoast_datum_packed | |--34.62%-- FunctionCall2Coll | execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--32.69%-- bpchareq | FunctionCall2Coll | execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.00%-- FunctionCall1Coll | TupleHashTableHash | hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.69%-- hashbpchar FunctionCall1Coll TupleHashTableHash hash_search LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.56% 2 postgres [kernel.kallsyms] [k] page_fault | --- page_fault | |--83.20%-- 0x46f444 | slot_getattr | | | |--92.86%-- ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--4.76%-- heapgetpage | | | | | |--50.01%-- 0x7fb66e18b600 | | | 0xc98e10 | | | 0xc98e58 | | | | | --49.99%-- 0x7fb66f761f80 | | 0xc98e10 | | 0xc98e58 | | | --2.38%-- LWLockAcquire | heapgetpage | 0x7fb66e61dc80 | 0xc98e10 | 0xc98e58 | |--5.95%-- 0x49f6c7 | heap_page_prune_opt | | | |--33.33%-- 0x30103 | | 0x12800f800040000 | | | |--33.33%-- 0x40419 | | 0x17000f800040000 | | | --33.33%-- 0xc3cd | 0x13000f800040000 | |--3.96%-- 0x674c50 | PinBuffer | | | |--50.00%-- 0x46bec | | 0x16000f400040000 | | | --50.00%-- 0x36494 | 0x14000f800040000 | |--3.60%-- 0x783272 | CHashInsert | CHashSearch | BufTableInsert | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--1.98%-- 0x68ef14 | LWLockAttemptLock | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main --1.31%-- [...] 0.49% 44 postgres libc-2.11.3.so [.] __GI___isinff | --- __GI___isinff advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.49% 44 postgres postgres [.] FunctionCall1Coll | --- FunctionCall1Coll | |--88.63%-- TupleHashTableHash | hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.37%-- hash_search LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.47% 42 postgres postgres [.] check_float8_array | --- check_float8_array | |--85.71%-- float4_accum | advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.29%-- advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.47% 42 postgres postgres [.] ExecProcNode | --- ExecProcNode | |--76.19%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --23.81%-- ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.46% 41 postgres postgres [.] ExecScan | --- ExecScan | |--95.12%-- ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.88%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.43% 39 postgres postgres [.] heapgetpage | --- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.41% 37 postgres postgres [.] MemoryContextReset | --- MemoryContextReset | |--29.73%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--29.73%-- execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--18.92%-- ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--10.81%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --10.81%-- TupleHashTableMatch hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 36 postgres postgres [.] InstrStartNode | --- InstrStartNode | |--91.67%-- ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.33%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 36 postgres postgres [.] heap_getnext | --- heap_getnext | |--91.67%-- SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.33%-- ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 36 postgres postgres [.] ExecQual | --- ExecQual | |--94.44%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --5.56%-- ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.39% 35 postgres postgres [.] hashbpchar | --- hashbpchar | |--77.15%-- FunctionCall1Coll | TupleHashTableHash | hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --22.85%-- TupleHashTableHash hash_search LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.39% 35 postgres libc-2.11.3.so [.] __gettimeofday_internal | --- __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.36% 32 postgres postgres [.] LookupTupleHashEntry | --- LookupTupleHashEntry | |--78.12%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --21.88%-- ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 30 postgres postgres [.] date_le_timestamp | --- date_le_timestamp | |--56.67%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --43.33%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 30 postgres postgres [.] AggCheckCallContext | --- AggCheckCallContext | |--56.67%-- float4_accum | advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --43.33%-- advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.32% 25 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat | |--85.70%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--88.00%-- 0x46f444 | | slot_getattr | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --12.00%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.30%-- zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.32% 29 postgres postgres [.] pg_detoast_datum | --- pg_detoast_datum | |--75.86%-- advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.14%-- float4_accum advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.32% 29 postgres postgres [.] TupleHashTableMatch | --- TupleHashTableMatch | |--51.72%-- hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --48.28%-- LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.31% 28 postgres postgres [.] date2timestamp | --- date2timestamp | |--71.43%-- date_le_timestamp | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --28.57%-- ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.29% 26 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--69.23%-- SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --30.77%-- ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.28% 25 postgres postgres [.] ExecStoreMinimalTuple | --- ExecStoreMinimalTuple | |--72.00%-- TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --28.00%-- hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.23% 21 postgres [kernel.kallsyms] [k] find_get_page | --- find_get_page find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--71.42%-- 0x46f444 | slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--19.05%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.77%-- 0x782d0f | CHashBucketScan | CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.76%-- 0x68ef14 LWLockAttemptLock LWLockAcquire heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.23% 21 postgres postgres [.] hash_search | --- hash_search | |--52.38%-- LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --47.62%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 19 postgres postgres [.] SeqNext | --- SeqNext | |--73.69%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --26.31%-- ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 18 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock LWLockAcquire heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 15 postgres postgres [.] heap_page_prune_opt | --- heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 13 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut | |--76.92%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --23.08%-- heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 13 postgres [kernel.kallsyms] [k] radix_tree_lookup_slot | --- radix_tree_lookup_slot find_get_page find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--92.32%-- 0x46f444 | slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.68%-- 0x782d0f CHashBucketScan CHashSearch BufTableLookup ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 12 postgres postgres [.] PinBuffer | --- PinBuffer ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 12 postgres [kernel.kallsyms] [k] copy_user_generic_string | --- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.12% 11 postgres postgres [.] Float4GetDatum | --- Float4GetDatum | |--72.73%-- advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --27.27%-- advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 11 postgres postgres [.] timestamp_cmp_internal | --- timestamp_cmp_internal | |--63.63%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --36.37%-- date_le_timestamp ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 11 postgres postgres [.] int8inc | --- int8inc | |--54.54%-- advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --45.46%-- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 10 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] 0xffffffff81128dcc | --- page_remove_rmap zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.08% 7 postgres [kernel.kallsyms] [k] zap_pte_range | --- zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.08% 7 postgres [mmfs26] [k] 0x26727 | --- 0xffffffffa0536727 0xffffffffa055411b 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560b28 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05ba691 0xffffffffa05341d7 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b0bd 0xffffffffa0541341 0xffffffffa0560b7f 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d84b7 0xffffffffa05f5a49 0xffffffffa056f3f6 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553bf0 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e1d4d __GI___read 0.07% 6 postgres postgres [.] ExecSeqScan | --- ExecSeqScan | |--66.66%-- ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.34%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 3 swapper [kernel.kallsyms] [k] save_args | --- save_args intel_idle cpuidle_idle_call cpu_idle 0.06% 1 mmfsd [kernel.kallsyms] [k] try_to_wake_up | --- try_to_wake_up up 0xffffffffa04a8b20 0xffffffffa05c07e5 0xffffffffa05c0bbf 0xffffffffa0605bc1 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0.06% 1 postgres [mmfslinux] [k] 0xea5e | --- 0xffffffffa04c0066 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa6dc 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0075 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa676 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aea5e 0xffffffffa04bd305 d_alloc_and_lookup do_last path_openat do_filp_open do_sys_open system_call_fastpath 0x7fb873db51e0 __GI___open64 0x626f6c672f706d74 | --- 0xffffffffa04a2d30 0xffffffffa05470e2 0xffffffffa055508c 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0x573266008d3100 0.06% 5 postgres [kernel.kallsyms] [k] __do_fault | --- __do_fault handle_pte_fault do_page_fault page_fault | |--80.00%-- 0x46f444 | slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- 0x68ef14 LWLockAttemptLock LWLockAcquire heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.06% 5 postgres [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock | |--80.01%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | 0x46f444 | slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.99%-- __pte_alloc handle_mm_fault do_page_fault page_fault 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 82 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.05% 4 postgres [kernel.kallsyms] [k] set_page_dirty | --- set_page_dirty zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.04% 4 postgres [kernel.kallsyms] [k] shmem_getpage_gfp | --- shmem_getpage_gfp | |--74.99%-- shmem_fault | __do_fault | handle_pte_fault | do_page_fault | page_fault | 0x46f444 | slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.01%-- 0xc981c0 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 4 postgres postgres [.] CHashSearch | --- CHashSearch BufTableLookup ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 4 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry | |--50.01%-- ReleaseBuffer | ExecStoreTuple | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.99%-- UnpinBuffer ExecStoreTuple SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 3 postgres [kernel.kallsyms] [k] __tlb_remove_page | --- __tlb_remove_page zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.04% 1 perf [kernel.kallsyms] [k] kmem_cache_alloc | --- kmem_cache_alloc getname_flags do_sys_open system_call_fastpath 0x7f89993971e0 __GI___open64 0.03% 1 watchdog/5 [kernel.kallsyms] [k] find_next_bit | --- find_next_bit cpumask_next_and find_busiest_group load_balance idle_balance thread_return watchdog kthread kernel_thread_helper 0.03% 3 postgres [kernel.kallsyms] [k] unlock_page | --- unlock_page __do_fault handle_pte_fault do_page_fault page_fault 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 3 postgres postgres [.] gettimeofday@plt | --- gettimeofday@plt ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 3 postgres postgres [.] ResourceOwnerForgetBuffer | --- ResourceOwnerForgetBuffer ReleaseBuffer heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 3 postgres [kernel.kallsyms] [k] down_read_trylock | --- down_read_trylock do_page_fault page_fault | |--66.69%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.31%-- 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 3 postgres postgres [.] CHashInsert | --- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 2 kworker/1:1 [kernel.kallsyms] [k] queue_delayed_work_on | --- queue_delayed_work_on | |--94.45%-- do_dbs_timer | process_one_work | worker_thread | kthread | kernel_thread_helper | --5.55%-- process_one_work worker_thread kthread kernel_thread_helper 0.03% 25 fail2ban-server [unknown] [.] 0x7f4657d50ab0 | --- 0x7f4657d6a52f | --- 0x7f4657cdbe10 | --- 0x7f4657d50a70 | --- 0x7f4657d44e00 0x7f4658007d80 | --- 0x7f4657d682a0 0x7f46581e4d70 | --- 0x7f4657d8eff0 | --- 0x7f4657d80b3f | --- 0x7f4657d49192 0x7f4657ffe8c0 | --- 0x7f4657d5cb30 | --- 0x7f4657d4887c 0x7f4657fff300 | --- 0x7f4657d5f4ba | --- 0x7f4657d7ff50 0x602010 0x602010 0x602010 0x602010 0x602010 | --- 0x7f4657173298 0x602010 0x602010 0x602010 0x602010 0x602010 0x602010 | --- 0x7f4657cde040 0x602010 0x602010 0x602010 0x602010 0x602010 | --- 0x7f4657d5f4af | --- 0x7f465710f754 0x6567617373656d2f | --- 0x7f4657d80afd | --- 0x7f4657103ea1 0x6567617373656d2f | --- 0x7f4657d50c8a 0x602010 0x602010 0x602010 0x602010 0x602010 0x602010 | --- 0x7f4657d80cdb 0.02% 2 postgres [kernel.kallsyms] [k] page_remove_rmap | --- page_remove_rmap zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.02% 1 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault | |--49.49%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--49.49%-- 0x46f444 | slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.02%-- 0x63fd10 pgstat_send AutoVacWorkerMain StartAutoVacWorker sigusr1_handler __restore_rt PostmasterMain main __libc_start_main 0.02% 2 postgres [kernel.kallsyms] [k] page_add_file_rmap | --- page_add_file_rmap __do_fault handle_pte_fault do_page_fault page_fault 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres [kernel.kallsyms] [k] handle_pte_fault | --- handle_pte_fault do_page_fault page_fault 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres postgres [.] LWLockRelease | --- LWLockRelease heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres [kernel.kallsyms] [k] error_exit | --- error_exit 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres postgres [.] LockBuffer | --- LockBuffer | |--50.00%-- heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres [kernel.kallsyms] [k] up_read | --- up_read do_page_fault page_fault 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres [kernel.kallsyms] [k] lookup_page_cgroup | --- lookup_page_cgroup mem_cgroup_update_page_stat __do_fault handle_pte_fault do_page_fault page_fault | |--50.02%-- 0x46f444 | slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres postgres [.] UnpinBuffer | --- UnpinBuffer ExecStoreTuple SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres [kernel.kallsyms] [k] find_lock_page | --- find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres [kernel.kallsyms] [k] native_apic_msr_write | --- native_apic_msr_write smp_apic_timer_interrupt apic_timer_interrupt | |--50.00%-- 0x6d3bf8 | float84mi | ExecMakeFunctionResultNoSets | ExecMakeFunctionResultNoSets | ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- 0x7fb873d19dd7 __GI___isinf ExecMakeFunctionResultNoSets ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres postgres [.] ss_report_location | --- ss_report_location | |--50.00%-- heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 2 postgres [kernel.kallsyms] [k] apic_timer_interrupt | --- apic_timer_interrupt | |--50.00%-- 0x784051 | hash_search_with_hash_value | ExecMakeFunctionResultNoSets | TupleHashTableHash | hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- 0x7fb873d19de7 __GI___isinf ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 4 irqbalance [unknown] [.] 0x7f398aaea9c6 | --- 0x7f398aae6915 | --- 0x7f398a140aa2 (nil) | --- 0x7f398aaea9c6 0x7f398aadf082 | --- 0x7f398aaea708 0.02% 1 postgres [kernel.kallsyms] [k] scheduler_tick | --- scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt | |--52.07%-- 0x5b98cc | advance_transition_function | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --47.93%-- 0x7fb873d1ce50 __GI_getenv ServerLoop PostmasterMain main __libc_start_main 0.02% 8 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer | |--83.96%-- BgBufferSync | BackgroundWriterMain | AuxiliaryProcessMain | StartChildProcess | reaper | __restore_rt | PostmasterMain | main | __libc_start_main | --16.04%-- BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.02% 14 mmfsd [unknown] [.] 0x92eda0 | --- 0x74eaa0 0x43 | --- 0x5af0a5 0x14a0a48 | --- 0x92ff1f | --- 0x6d5f99 | --- 0x7ffb7cb536a0 (nil) | --- 0x757057 0x180488d2e88 0x757050 0x2f00000000 0x1803ba56a70 0x184a4c | --- 0x5add90 0x8900000000 | --- 0x5b6859 | --100.00%-- 0x1300000000 0x18033e6ab28 0x328bb8d482d74 | --- 0x10e3067 (nil) | --- 0x5a893f | --- 0x92eda0 (nil) | --- 0x7fffe2dff600 0x7ffb7c0e53aa | --- 0x5b09f0 0x91d18825 0xffffc900341c0f10 0.02% 1 irqbalance [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock evict d_kill dput __fput filp_close sys_close system_call_fastpath 0x7f398a196570 0x7f398a196570 0.01% 1 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy | |--79.06%-- BufTableLookup | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--11.90%-- 0x7fb66646b010 | --9.03%-- 0x7fb66646ee48 0.01% 1 postgres [kernel.kallsyms] [k] release_pages | --- release_pages free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.01% 1 postgres [kernel.kallsyms] [k] clear_page_c | --- clear_page_c prep_new_page get_page_from_freelist __alloc_pages_nodemask | |--93.23%-- alloc_pages_current | pte_alloc_one | __pte_alloc | handle_mm_fault | do_page_fault | page_fault | 0x46f444 | slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.77%-- alloc_pages_vma do_anonymous_page do_page_fault page_fault 0x474b40 CreateTemplateTupleDesc load_relcache_init_file RelationCacheInitializePhase3 InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 kworker/4:1 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.01% 1 postgres [kernel.kallsyms] [k] next_zones_zonelist | --- next_zones_zonelist __alloc_pages_nodemask alloc_pages_vma do_anonymous_page do_page_fault page_fault 0x798fd8 palloc0 makeNumericAggState int8_avg_accum advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode standard_ExecutorRun DoCopyTo DoCopy standard_ProcessUtility PortalRunUtility PortalRunMulti PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--95.72%-- down | 0xffffffffa04a89cf | 0xffffffffa051f54e | 0xffffffffa0541346 | 0xffffffffa0560b7f | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--3.24%-- 0xffffffffa04a8b85 | 0xffffffffa05bf0f1 | 0xffffffffa05bfd6f | 0xffffffffa051298d | 0xffffffffa054b145 | 0xffffffffa05587b5 | 0xffffffffa056884a | 0xffffffffa04bcb0b | vfs_create | do_last | path_openat | do_filp_open | do_sys_open | system_call_fastpath | 0x7fb873db51e0 | __GI___open64 | 0x315f62642f706d74 | --1.04%-- remove_wait_queue poll_freewait do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.01% 1 postgres [kernel.kallsyms] [k] vm_normal_page | --- vm_normal_page zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.01% 1 postgres [kernel.kallsyms] [k] __set_page_dirty_no_writeback | --- __set_page_dirty_no_writeback zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.01% 1 postgres [kernel.kallsyms] [k] shmem_fault | --- shmem_fault __do_fault handle_pte_fault do_page_fault page_fault 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] restore_args | --- restore_args 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres postgres [.] RecoveryInProgress | --- RecoveryInProgress heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres postgres [.] ReadBuffer_common | --- ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres postgres [.] isTempToastNamespace | --- isTempToastNamespace IsCatalogClass heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] __inc_zone_page_state | --- __inc_zone_page_state page_add_file_rmap __do_fault handle_pte_fault do_page_fault page_fault 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres postgres [.] IncrBufferRefCount | --- IncrBufferRefCount SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] error_entry | --- error_entry 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] zone_statistics | --- zone_statistics get_page_from_freelist __alloc_pages_nodemask alloc_pages_current pte_alloc_one __pte_alloc handle_mm_fault do_page_fault page_fault 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres postgres [.] IsCatalogRelation | --- IsCatalogRelation heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] mem_cgroup_count_vm_event | --- mem_cgroup_count_vm_event handle_mm_fault do_page_fault page_fault 0x46f444 slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres postgres [.] _mdfd_getseg | --- _mdfd_getseg mdread ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres postgres [.] ResourceOwnerRememberBuffer | --- ResourceOwnerRememberBuffer ExecStoreTuple SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 kworker/9:2 [kernel.kallsyms] [k] wq_worker_sleeping | --- wq_worker_sleeping thread_return worker_thread kthread kernel_thread_helper 0.01% 1 postgres postgres [.] BufTableLookup | --- BufTableLookup ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] enqueue_sleeper | --- enqueue_sleeper enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt 0x5a9539 TupleHashTableMatch hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] update_group_power | --- update_group_power find_busiest_group load_balance rebalance_domains run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt 0x5b9859 advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.01% 2 swapper [kernel.kallsyms] [k] enqueue_entity | --- enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 1 postgres libc-2.11.3.so [.] _int_malloc | --- _int_malloc MemoryContextAllocZeroAligned CreateExecutorState standard_ExecutorStart BeginCopy DoCopy standard_ProcessUtility PortalRunUtility PortalRunMulti PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 kworker/2:1 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.01% 1 postgres libc-2.11.3.so [.] _IO_fread | --- _IO_fread RelationCacheInitializePhase3 InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 6 swapper [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance rebalance_domains | |--89.41%-- nohz_idle_balance | __do_softirq | call_softirq | do_softirq | irq_exit | reschedule_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --10.59%-- run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt | |--85.82%-- intel_idle | cpuidle_idle_call | cpu_idle | --14.18%-- finish_task_switch thread_return cpu_idle 0.01% 1 psql [kernel.kallsyms] [k] clear_page_c | --- clear_page_c prep_new_page get_page_from_freelist __alloc_pages_nodemask alloc_pages_vma do_anonymous_page do_page_fault page_fault 0x7f373d8416a3 _dl_map_object_deps dl_main _dl_sysdep_start 0x40 0.01% 1 swapper [kernel.kallsyms] [k] run_posix_cpu_timers | --- run_posix_cpu_timers tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] load_balance | --- load_balance idle_balance thread_return do_nanosleep hrtimer_nanosleep sys_nanosleep system_call_fastpath 0x7ffb7c0f466d 0x7ffb7c0f466d 0.00% 8 swapper [kernel.kallsyms] [k] rcu_needs_cpu | --- rcu_needs_cpu | --100.00%-- tick_nohz_stop_sched_tick | |--53.72%-- cpu_idle | --46.28%-- irq_exit | |--85.24%-- do_IRQ | ret_from_intr | intel_idle | cpuidle_idle_call | cpu_idle | --14.76%-- smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] dev_pick_tx | --- dev_pick_tx dev_queue_xmit ip_finish_output ip_queue_xmit tcp_transmit_skb tcp_write_xmit __tcp_push_pending_frames tcp_sendmsg sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.00% 1 postgres ld-2.11.3.so [.] strcmp | --- strcmp 0.00% 2 postgres libc-2.11.3.so [.] __GI___read | --- __GI___read BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.00% 1 postgres [kernel.kallsyms] [k] __schedule | --- __schedule schedule_hrtimeout_range_clock poll_schedule_timeout do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.00% 1 psql libc-2.11.3.so [.] _IO_getline_info | --- _IO_getline_info 0x5320776f646e6957 0.00% 4 swapper [kernel.kallsyms] [k] tick_nohz_stop_sched_tick | --- tick_nohz_stop_sched_tick | |--70.55%-- cpu_idle | --29.45%-- irq_exit | |--66.63%-- do_IRQ | ret_from_intr | intel_idle | cpuidle_idle_call | cpu_idle | --33.37%-- smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] exit_creds | --- exit_creds __put_task_struct rcu_do_batch rcu_process_callbacks __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 postgres postgres [.] palloc | --- palloc ExecInitExpr ExecInitSeqScan ExecInitNode ExecInitHashJoin ExecInitNode ExecInitSort ExecInitNode standard_ExecutorStart BeginCopy DoCopy standard_ProcessUtility PortalRunUtility PortalRunMulti PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.00% 1 sleep [kernel.kallsyms] [k] page_fault | --- page_fault 0x7f120cfb9f50 __GI__IO_file_open (nil) 0.00% 2 swapper [kernel.kallsyms] [k] apic_timer_interrupt | --- apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] pm_qos_request | --- pm_qos_request menu_select cpuidle_idle_call cpu_idle 0.00% 1 kworker/8:1 [kernel.kallsyms] [k] drain_array | --- drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 sadc [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc delay_tsc igb_read_phy_reg_mdic igb_read_phy_reg_82580 igb_update_stats igb_get_stats64 dev_get_stats dev_seq_show seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fc5013625d0 __GI___read 0.00% 1 mmfsd [kernel.kallsyms] [k] sys_epoll_wait | --- sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 1 swapper [kernel.kallsyms] [k] read_tsc | --- read_tsc getnstimeofday ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 2 irqbalance [kernel.kallsyms] [k] proc_lookup_de | --- proc_lookup_de d_alloc_and_lookup do_lookup link_path_walk path_openat do_filp_open do_sys_open system_call_fastpath 0x7f398a1961e0 0x7f398a1961e0 0xffffd374ffffd374 0.00% 1 swapper [kernel.kallsyms] [k] add_interrupt_randomness | --- add_interrupt_randomness handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] this_cpu_load | --- this_cpu_load menu_select cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] update_rq_clock | --- update_rq_clock enqueue_task ttwu_activate ttwu_do_activate try_to_wake_up hrtimer_wakeup __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 postgres postgres [.] BgBufferSync | --- BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.00% 1 swapper [kernel.kallsyms] [k] tick_nohz_restart_sched_tick | --- tick_nohz_restart_sched_tick cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] __hrtimer_start_range_ns | --- __hrtimer_start_range_ns | |--96.65%-- tick_nohz_restart | tick_nohz_restart_sched_tick | cpu_idle | --3.35%-- tick_nohz_stop_sched_tick cpu_idle 0.00% 1 perf [ext3] [k] ext3_dirty_inode | --- ext3_dirty_inode __mark_inode_dirty ext3_new_blocks ext3_alloc_branch ext3_get_blocks_handle ext3_get_block __block_write_begin ext3_write_begin generic_perform_write generic_file_buffered_write __generic_file_aio_write generic_file_aio_write do_sync_write vfs_write sys_write system_call_fastpath 0x7f899b1d8730 __write_nocancel 0.00% 6 kworker/0:0 [ixgbe] [k] ixgbe_update_stats | --- ixgbe_update_stats ixgbe_watchdog_subtask ixgbe_service_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] __switch_to | --- __switch_to thread_return 0xffff881f909d2000 0.00% 1 postgres [kernel.kallsyms] [k] __percpu_counter_add | --- __percpu_counter_add __vm_enough_memory mmap_region sys_mmap_pgoff system_call_fastpath 0x7fb873dbfc5a __GI_mmap64 0.00% 1 swapper [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc native_sched_clock sched_clock tick_nohz_stop_sched_tick cpu_idle 0.00% 1 irqbalance [kernel.kallsyms] [k] inode_init_always | --- inode_init_always alloc_inode iget_locked proc_get_inode proc_lookup_de proc_root_lookup d_alloc_and_lookup do_lookup link_path_walk path_openat do_filp_open do_sys_open system_call_fastpath 0x7f398a1961e0 0x7f398a1961e0 0xffffd374ffffd374 0.00% 1 irqbalance [kernel.kallsyms] [k] sysret_check | --- sysret_check 0x7f398a1961e0 0xffffd374ffffd374 0.00% 1 perf [ext3] [k] ext3_do_update_inode | --- ext3_do_update_inode ext3_mark_iloc_dirty ext3_mark_inode_dirty ext3_dirty_inode __mark_inode_dirty update_time file_update_time __generic_file_aio_write generic_file_aio_write do_sync_write vfs_write sys_write system_call_fastpath 0x7f899b1d8730 __write_nocancel 0.00% 2 swapper [kernel.kallsyms] [k] enqueue_sleeper | --- enqueue_sleeper enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up hrtimer_wakeup __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] _raw_spin_lock_irq | --- _raw_spin_lock_irq __schedule cpu_idle 0.00% 6 swapper [kernel.kallsyms] [k] cpuidle_idle_call | --- cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 2 mmfsd [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return | |--80.22%-- 0xffffffffa04a8b7d | 0xffffffffa05bf0f1 | 0xffffffffa05c0478 | 0xffffffffa0605afe | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0x7ffb64012300 | --19.78%-- schedule_hrtimeout_range_clock ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 2 swapper [kernel.kallsyms] [k] get_next_timer_interrupt | --- get_next_timer_interrupt tick_nohz_stop_sched_tick cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 1 irqbalance [kernel.kallsyms] [k] find_next_bit | --- find_next_bit kstat_irqs show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0x7f398ad0a730 0.00% 3 swapper [kernel.kallsyms] [k] native_write_msr_safe | --- native_write_msr_safe native_apic_msr_write | |--72.35%-- smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --27.65%-- lapic_next_event tick_dev_program_event | |--82.41%-- hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --17.59%-- __remove_hrtimer __hrtimer_start_range_ns tick_nohz_stop_sched_tick irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 psql [kernel.kallsyms] [k] zap_pte_range | --- zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exec_mmap flush_old_exec load_elf_binary search_binary_handler do_execve_common sys_execve stub_execve 0x7ffa11853a57 __execve 0.00% 1 irqbalance [kernel.kallsyms] [k] vsnprintf | --- vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0x7f398ad0a730 0.00% 1 irqbalance [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave show_interrupts seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0.00% 1 mmfsd [kernel.kallsyms] [k] __schedule | --- __schedule schedule_hrtimeout_range_clock ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 1 mmfsd [mmfslinux] [k] 0x589 | --- 0xffffffffa04a0589 0xffffffffa05bf44d 0xffffffffa0605aa3 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 (nil) 0.00% 1 swapper [kernel.kallsyms] [k] strnlen | --- strnlen string vsnprintf sb_add ipt_log_packet log_tg ipt_do_table nf_iterate nf_hook_slow ip_local_deliver __netif_receive_skb netif_receive_skb napi_skb_finish igb_clean_rx_irq igb_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 sadc [kernel.kallsyms] [k] radix_tree_lookup | --- radix_tree_lookup kstat_irqs show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fc5013625d0 __GI___read 0.00% 1 swapper [kernel.kallsyms] [k] atomic_notifier_call_chain | --- atomic_notifier_call_chain cpu_idle start_kernel x86_64_start_kernel 0.00% 1 psql [kernel.kallsyms] [k] find_get_page | --- find_get_page filemap_fault __do_fault handle_pte_fault do_page_fault page_fault 0x7fc93783d8a0 __strcpy_ssse3 connectDBStart PQconnectStartParams PQconnectdbParams main __libc_start_main 0.00% 2 irqbalance [kernel.kallsyms] [k] strnlen | --- strnlen string vsnprintf seq_printf | |--50.06%-- show_interrupts | seq_read | proc_reg_read | vfs_read | sys_read | system_call_fastpath | 0x7f398a1965d0 | 0x7f398a1965d0 | --49.94%-- arch_show_interrupts seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0.00% 1 flush-8:0 [kernel.kallsyms] [k] __lookup_tag | --- __lookup_tag radix_tree_gang_lookup_tag_slot find_get_pages_tag pagevec_lookup_tag write_cache_pages generic_writepages writeback_single_inode writeback_sb_inodes writeback_inodes_wb wb_writeback wb_do_writeback bdi_writeback_thread kthread kernel_thread_helper 0.00% 3 swapper [kernel.kallsyms] [k] native_sched_clock | --- native_sched_clock sched_clock | |--66.53%-- update_rq_clock | enqueue_task | ttwu_activate | ttwu_do_activate | try_to_wake_up | | | |--88.26%-- hrtimer_wakeup | | __run_hrtimer | | hrtimer_interrupt | | smp_apic_timer_interrupt | | apic_timer_interrupt | | intel_idle | | cpuidle_idle_call | | cpu_idle | | | --11.74%-- __queue_work | call_timer_fn | run_timer_softirq | __do_softirq | call_softirq | do_softirq | irq_exit | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --33.47%-- idle_balance thread_return cpu_idle 0.00% 2 haveged [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7fbf388b4373 0x7fbf388b4373 0.00% 5 kworker/2:1 [igb] [k] igb_update_stats | --- igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] kmem_cache_free | --- kmem_cache_free rcu_do_batch rcu_process_callbacks __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] pollwake | --- pollwake __wake_up_common __wake_up credit_entropy_bits add_interrupt_randomness handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [ip_tables] [k] ipt_do_table | --- ipt_do_table nf_iterate nf_hook_slow ip_rcv __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 5 swapper [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--43.11%-- hrtimer_get_next_event | get_next_timer_interrupt | tick_nohz_stop_sched_tick | irq_exit | do_IRQ | ret_from_intr | intel_idle | cpuidle_idle_call | cpu_idle | |--36.31%-- __wake_up | credit_entropy_bits | add_interrupt_randomness | handle_irq_event_percpu | handle_irq_event | handle_edge_irq | handle_irq | do_IRQ | ret_from_intr | intel_idle | cpuidle_idle_call | cpu_idle | --20.58%-- try_to_wake_up | |--65.70%-- hrtimer_wakeup | __run_hrtimer | hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --34.30%-- pollwake __wake_up_common __wake_up credit_entropy_bits add_interrupt_randomness handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 postgres [kernel.kallsyms] [k] kmem_cache_free | --- kmem_cache_free unlink_anon_vmas free_pgtables unmap_region do_munmap sys_munmap system_call_fastpath 0x7fb873dbfc87 __munmap (nil) 0.00% 1 psql [kernel.kallsyms] [k] check_preempt_wakeup | --- check_preempt_wakeup check_preempt_curr ttwu_do_wakeup try_to_wake_up autoremove_wake_function __wake_up_common __wake_up_sync_key sock_def_readable unix_stream_sendmsg sock_sendmsg sys_sendto system_call_fastpath 0x7f348c9f9075 __GI___send 0.00% 1 watchdog/11 [kernel.kallsyms] [k] kthread_should_stop | --- kthread_should_stop watchdog kthread kernel_thread_helper 0.00% 1 irqbalance [kernel.kallsyms] [k] number | --- number vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0x7f398ad0a730 0.00% 1 postgres [kernel.kallsyms] [k] do_last | --- do_last path_openat do_filp_open do_sys_open system_call_fastpath 0x7fb873db51e0 __GI___open64 0x305f62642f706d74 0.00% 1 kworker/15:1 [kernel.kallsyms] [k] refresh_cpu_vm_stats | --- refresh_cpu_vm_stats vmstat_update process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 psql [kernel.kallsyms] [k] get_unmapped_area | --- get_unmapped_area do_mmap_pgoff elf_map load_elf_binary search_binary_handler do_execve_common sys_execve stub_execve 0x7ffa11853a57 0x7ffa11853a57 0.00% 2 swapper [kernel.kallsyms] [k] rcu_enter_nohz | --- rcu_enter_nohz | |--66.53%-- tick_nohz_stop_sched_tick | cpu_idle | --33.47%-- irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] cfq_scaled_cfqq_slice | --- cfq_scaled_cfqq_slice cfq_completed_request __blk_put_request blk_end_bidi_request scsi_end_request scsi_io_completion blk_done_softirq __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] rebalance_domains | --- rebalance_domains run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday ktime_get_real intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 1 fail2ban-server [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x310000002e 0.00% 1 mmfsd [kernel.kallsyms] [k] tcp_recvmsg | --- tcp_recvmsg inet_recvmsg sock_recvmsg sys_recvfrom system_call_fastpath 0x7ffb7cb55bb1 0x7ffb7cb55bb1 0x5518da38 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 psql bash [.] quote_string | --- quote_string 0x2c656d616e746164 0.00% 1 mmfsd [kernel.kallsyms] [k] find_next_bit | --- find_next_bit cpumask_next_and find_busiest_group load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x7ffb748ac7f0 0.00% 2 swapper [kernel.kallsyms] [k] timerqueue_del | --- timerqueue_del __remove_hrtimer | |--54.34%-- __hrtimer_start_range_ns | tick_nohz_stop_sched_tick | cpu_idle | --45.66%-- hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 2 kworker/2:1 [kernel.kallsyms] [k] delay_tsc | --- delay_tsc igb_read_phy_reg_mdic igb_read_phy_reg_82580 igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 haveged [kernel.kallsyms] [k] do_select | --- do_select core_sys_select sys_select system_call_fastpath 0x7fbf388b4373 0x7fbf388b4373 0.00% 1 haveged [kernel.kallsyms] [k] find_next_bit | --- find_next_bit cpumask_next_and find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7fbf388b4373 0x7fbf388b4373 0.00% 3 swapper [kernel.kallsyms] [k] rcu_exit_nohz | --- rcu_exit_nohz irq_enter | |--87.55%-- do_IRQ | ret_from_intr | intel_idle | cpuidle_idle_call | cpu_idle | --12.45%-- smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 irqbalance [kernel.kallsyms] [k] kmem_cache_free | --- kmem_cache_free unlink_anon_vmas free_pgtables unmap_region do_munmap sys_munmap system_call_fastpath 0x7f398a1a0c87 0x7f398a1a0c87 (nil) 0.00% 1 fail2ban-server [kernel.kallsyms] [k] core_sys_select | --- core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x310000002e 0.00% 1 watchdog/11 [kernel.kallsyms] [k] sched_avg_update | --- sched_avg_update update_curr_rt dequeue_task_rt __schedule watchdog kthread kernel_thread_helper 0.00% 1 irqbalance [kernel.kallsyms] [k] call_rcu_sched | --- call_rcu_sched __fput filp_close sys_close system_call_fastpath 0x7f398a196570 0x7f398a196570 0.00% 1 irqbalance [kernel.kallsyms] [k] put_dec_trunc | --- put_dec_trunc number vsnprintf seq_printf show_interrupts seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0.00% 1 psql libc-2.11.3.so [.] __GI__dl_addr | --- __GI__dl_addr 0x4ce02464894cd824 0.00% 1 psql [kernel.kallsyms] [k] flush_tlb_page | --- flush_tlb_page ptep_clear_flush do_wp_page handle_pte_fault do_page_fault page_fault 0x7fc938188938 _dl_map_object_from_fd _dl_map_object 0x746164655f00322e 0.00% 2 kworker/0:0 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.00% 2 swapper [kernel.kallsyms] [k] perf_rotate_context | --- perf_rotate_context perf_event_task_tick scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock get_next_timer_interrupt tick_nohz_stop_sched_tick irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 gpfsSwapdKproc [kernel.kallsyms] [k] try_to_wake_up | --- try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be269 0xffffffffa05beb58 0xffffffffa05123d9 0xffffffffa054b51f 0xffffffffa0585074 0xffffffffa04b4857 0xffffffffa04b4879 evict 0xffffffffa0607f4a 0xffffffffa0608076 0xffffffffa04ad990 kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] end_bio_bh_io_sync | --- end_bio_bh_io_sync blk_update_request blk_update_bidi_request blk_end_bidi_request scsi_end_request scsi_io_completion blk_done_softirq __do_softirq call_softirq do_softirq irq_exit call_function_single_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 postgres ld-2.11.3.so [.] do_lookup_x | --- do_lookup_x 0.00% 1 mmfsd [mmfs26] [k] 0xf5ad4 | --- 0xffffffffa0605ad4 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x7ffb74169340 0.00% 1 swapper [kernel.kallsyms] [k] __local_bh_enable | --- __local_bh_enable irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 sadc [kernel.kallsyms] [k] find_next_bit | --- find_next_bit kstat_irqs show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fc5013625d0 __GI___read 0.00% 1 swapper [scsi_mod] [k] scsi_softirq_done | --- scsi_softirq_done blk_done_softirq __do_softirq call_softirq do_softirq irq_exit call_function_single_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 kworker/4:1 [kernel.kallsyms] [k] cache_reap | --- cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 dbt3-pgsql-dbst [kernel.kallsyms] [k] enqueue_entity | --- enqueue_entity enqueue_task_fair wake_up_new_task do_fork stub_clone 0x7ffa1185375f __libc_fork make_child 0x6aae50 0x6aae90 0x6aaf20 0.00% 1 dbt3-pgsql-dbst [kernel.kallsyms] [k] copy_pte_range | --- copy_pte_range copy_page_range dup_mmap dup_mm copy_process do_fork stub_clone 0x7ffa1185375f __libc_fork make_child 0x6aa510 0x6aa2a0 0x6a9920 0.00% 1 swapper [kernel.kallsyms] [k] raise_softirq | --- raise_softirq update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [ixgbe] [k] ixgbe_msix_clean_rings | --- ixgbe_msix_clean_rings handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc native_sched_clock sched_clock idle_balance thread_return worker_thread kthread kernel_thread_helper 0.00% 1 sadc [kernel.kallsyms] [k] vsnprintf | --- vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fc5013625d0 __GI___read 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] __bitmap_weight | --- __bitmap_weight do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] leave_mm | --- leave_mm intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc delay_tsc igb_read_phy_reg_mdic igb_read_phy_reg_82580 igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] ttwu_stat | --- ttwu_stat try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] enqueue_task_fair | --- enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] ns_to_timeval | --- ns_to_timeval get_cpu_iowait_time_us dbs_check_cpu do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 kjournald [jbd] [k] __journal_temp_unlink_buffer | --- __journal_temp_unlink_buffer __journal_unfile_buffer journal_commit_transaction kjournald kthread kernel_thread_helper 0.00% 1 mmfsd [kernel.kallsyms] [k] task_waking_fair | --- task_waking_fair try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be300 0xffffffffa05c064a 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 postgres [kernel.kallsyms] [k] find_vma | --- find_vma do_page_fault page_fault 0x7fb873d908dd __libc_fork fork_process StartAutoVacWorker sigusr1_handler __restore_rt PostmasterMain main __libc_start_main 0.00% 1 swapper [kernel.kallsyms] [k] enqueue_task | --- enqueue_task ttwu_activate ttwu_do_activate sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] ktime_get | --- ktime_get tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] run_timer_softirq | --- run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] ret_from_intr | --- ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] tick_dev_program_event | --- tick_dev_program_event __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] clear_buddies | --- clear_buddies pick_next_task_fair __schedule cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] rb_insert_color | --- rb_insert_color timerqueue_add enqueue_hrtimer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/3:1 [kernel.kallsyms] [k] load_balance | --- load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] update_curr | --- update_curr enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up sync_supers_timer_fn call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] hrtimer_get_next_event | --- hrtimer_get_next_event get_next_timer_interrupt tick_nohz_stop_sched_tick cpu_idle 0.00% 1 postgres [kernel.kallsyms] [k] flush_tlb_page | --- flush_tlb_page ptep_clear_flush do_wp_page handle_pte_fault do_page_fault page_fault 0x78c22c set_extra_field set_config_option SetConfigOption AutoVacWorkerMain StartAutoVacWorker sigusr1_handler __restore_rt PostmasterMain main __libc_start_main 0.00% 1 mmfsd [kernel.kallsyms] [k] thread_return | --- thread_return schedule_hrtimeout_range_clock ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 1 irqbalance [kernel.kallsyms] [k] show_interrupts | --- show_interrupts seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 (nil) 0.00% 1 irqbalance [kernel.kallsyms] [k] put_dec | --- put_dec number vsnprintf seq_printf show_interrupts seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0.00% 1 haveged [kernel.kallsyms] [k] _raw_spin_lock_irq | --- _raw_spin_lock_irq __schedule schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7fbf388b4373 0x7fbf388b4373 0.00% 1 swapper [kernel.kallsyms] [k] check_for_new_grace_period | --- check_for_new_grace_period __rcu_process_callbacks rcu_process_callbacks __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 psql [kernel.kallsyms] [k] filemap_fault | --- filemap_fault __do_fault handle_pte_fault do_page_fault page_fault 0x46dd40 xstrchr 0x6aac40 0x6aac80 0x6aad10 0.00% 1 psql [kernel.kallsyms] [k] link_path_walk | --- link_path_walk path_lookupat do_path_lookup user_path_at_empty vfs_fstatat sys_newstat system_call_fastpath 0x7ffa11877765 _xstat 0x6f6974617475706d 0.00% 1 mmfsd [kernel.kallsyms] [k] do_vfs_ioctl | --- do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c0f10 0.00% 1 irqbalance [kernel.kallsyms] [k] radix_tree_lookup | --- radix_tree_lookup kstat_irqs_cpu show_interrupts seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0.00% 1 cron [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return do_nanosleep hrtimer_nanosleep sys_nanosleep system_call_fastpath 0x7f67791d5650 0x7f67791d5650 0.00% 2 swapper [kernel.kallsyms] [k] rb_next | --- rb_next timerqueue_del __remove_hrtimer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] menu_select | --- menu_select cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] timerqueue_add | --- timerqueue_add enqueue_hrtimer __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] irq_entries_start | --- irq_entries_start intel_idle cpuidle_idle_call cpu_idle 0.00% 1 psql libc-2.11.3.so [.] __gconv_transform_utf8_internal | --- __gconv_transform_utf8_internal 0x40 0.00% 1 psql libc-2.11.3.so [.] _int_malloc | --- _int_malloc 0x7ffa11b1f348 0x7ffa11b1f338 0x7ffa11b1f328 0x7ffa11b1f318 0x7ffa11b1f308 0x7ffa11b1f2f8 0x7ffa11b1f2e8 0x7ffa11b1f2d8 0x7ffa11b1f2c8 0x7ffa11b1f2b8 0x7ffa11b1f2a8 0x7ffa11b1f298 0x7ffa11b1f288 0x7ffa11b1f278 0x7ffa11b1f268 0x7ffa11b1f258 0x7ffa11b1f248 0x7ffa11b1f238 0x7ffa11b1f228 0x7ffa11b1f218 0x7ffa11b1f208 0x7ffa11b1f1f8 0x7ffa11b1f1e8 0x7ffa11b1f1d8 0x7ffa11b1f1c8 0x7ffa11b1f1b8 0x7ffa11b1f1a8 0x7ffa11b1f198 0x7ffa11b1f188 0x7ffa11b1f178 0x7ffa11b1f168 0x7ffa11b1f158 0x7ffa11b1f148 0x7ffa11b1f138 0x7ffa11b1f128 0x7ffa11b1f118 0x7ffa11b1f108 0x7ffa11b1f0f8 0x7ffa11b1f0e8 0x7ffa11b1f0d8 0x7ffa11b1f0c8 0x7ffa11b1f0b8 0x7ffa11b1f0a8 0x7ffa11b1f098 0x7ffa11b1f088 0x7ffa11b1f078 0x7ffa11b1f068 0x7ffa11b1f058 0x7ffa11b1f048 0x7ffa11b1f038 0x7ffa11b1f028 0x7ffa11b1f018 0x7ffa11b1f008 0x7ffa11b1eff8 0x7ffa11b1efe8 0x7ffa11b1efd8 0x7ffa11b1efc8 0x7ffa11b1efb8 0x7ffa11b1efa8 0x7ffa11b1ef98 0x7ffa11b1ef88 0x6a6530 0x91 0.00% 1 swapper [kernel.kallsyms] [k] tick_program_event | --- tick_program_event hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] ktime_get_real | --- ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 2 kworker/1:1 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] sched_needs_cpu | --- sched_needs_cpu tick_nohz_stop_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] hrtimer_try_to_cancel | --- hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 postgres postgres [.] BackgroundWriterMain | --- BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.00% 1 mmfsd [kernel.kallsyms] [k] rcu_note_context_switch | --- rcu_note_context_switch __schedule schedule_hrtimeout_range_clock ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 1 mmfsd [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave down 0xffffffffa04a89cf 0xffffffffa05c06e1 0xffffffffa05c0bbf 0xffffffffa0605bc1 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0.00% 1 swapper [kernel.kallsyms] [k] nr_iowait_cpu | --- nr_iowait_cpu update_ts_time_stats tick_nohz_stop_idle tick_nohz_restart_sched_tick cpu_idle 0.00% 1 irqbalance [kernel.kallsyms] [k] kstat_irqs_cpu | --- kstat_irqs_cpu 0xffff883fc1db463c 0x7f398a1965d0 0.00% 1 irqbalance [kernel.kallsyms] [k] find_vma | --- find_vma arch_get_unmapped_area_topdown get_unmapped_area do_mmap_pgoff sys_mmap_pgoff system_call_fastpath 0x7f398a1a0c5a 0x7f398a1a0c5a (nil) 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore mod_timer queue_delayed_work_on process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] __remove_hrtimer | --- __remove_hrtimer __hrtimer_start_range_ns tick_nohz_stop_sched_tick cpu_idle 0.00% 1 kworker/10:1 [kernel.kallsyms] [k] refresh_cpu_vm_stats | --- refresh_cpu_vm_stats vmstat_update process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] update_cfs_load | --- update_cfs_load enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] try_to_wake_up | --- try_to_wake_up hrtimer_wakeup __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] native_write_msr_safe | --- native_write_msr_safe native_apic_msr_write handle_edge_irq handle_irq do_IRQ ret_from_intr __task_pid_nr_ns 0xffffffffa04c2645 0xffffffffa0605a88 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x2300000000 0xd00000000011c22 0.00% 1 swapper [kernel.kallsyms] [k] idle_cpu | --- idle_cpu irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 postgres [kernel.kallsyms] [k] ip_setup_cork | --- ip_setup_cork ip_make_skb udp_sendmsg sock_sendmsg sys_sendto system_call_fastpath 0x7fb873dc4075 __GI___send 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] find_next_bit | --- find_next_bit next_online_pgdat next_zone refresh_cpu_vm_stats vmstat_update process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 haveged [kernel.kallsyms] [k] update_shares | --- update_shares idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7fbf388b4373 0x7fbf388b4373 0.00% 1 swapper [kernel.kallsyms] [k] __rcu_pending | --- __rcu_pending rcu_check_callbacks update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] dequeue_entity | --- dequeue_entity dequeue_task_fair __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x7ffb6412f570 0.00% 1 fail2ban-server [kernel.kallsyms] [k] timerqueue_add | --- timerqueue_add 0xf423e 0x7f465715f393 0x7f4657ff0b30 0x7f4658007d80 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] worker_thread | --- worker_thread kthread kernel_thread_helper 0.00% 1 psql [kernel.kallsyms] [k] finish_task_switch | --- finish_task_switch schedule_tail ret_from_fork 0x7ffa1185375f __libc_fork make_child 0x6aaa30 0x6aaa70 0x6aab00 0.00% 1 psql [kernel.kallsyms] [k] page_fault | --- page_fault 0x4528d0 list_reverse 0x6aaa70 0x6aab00 0.00% 1 swapper [kernel.kallsyms] [k] load_balance | --- load_balance rebalance_domains run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] handle_edge_irq | --- handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] hrtimer_interrupt | --- hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] native_sched_clock | --- native_sched_clock sched_clock update_rq_clock dequeue_task __schedule worker_thread kthread kernel_thread_helper 0.00% 1 kworker/1:1 [kernel.kallsyms] [k] dbs_check_cpu | --- dbs_check_cpu do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] scheduler_tick | --- scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle # # (For a higher level overview, try: perf report --sort comm,dso) #