Created
January 28, 2024 19:12
-
-
Save mdcallag/1ee2b5972732efa6f588db82ae100dd4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Hierarchical profiling with perf, top 5 stacks | |
Postgres 13.13 | |
58.36% 2054 postgres postgres [.] _bt_readpage | |
58.36% _bt_readpage;_bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity;clauselist_selectivity_simple;clauselist_selectivity;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
13.70% 478 postgres postgres [.] hash_search_with_hash_value | |
13.62% hash_search_with_hash_value;BufTableLookup;ReadBuffer_common;ReadBufferExtended;_bt_getbuf;_bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity;clauselist_selectivity_simple;clauselist_selectivity;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
4.08% 142 postgres postgres [.] _bt_readnextpage | |
4.08% _bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity;clauselist_selectivity_simple;clauselist_selectivity;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
3.38% 121 postgres postgres [.] LWLockAttemptLock | |
3.05% LWLockAttemptLock;ReadBuffer_common;ReadBufferExtended;_bt_getbuf;_bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity;clauselist_selectivity_simple;clauselist_selectivity;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
3.35% 117 postgres postgres [.] _bt_checkpage | |
3.31% _bt_checkpage;_bt_getbuf;_bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity;clauselist_selectivity_simple;clauselist_selectivity;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
Postgres 14.10 | |
60.49% 3382 postgres postgres [.] _bt_readpage | |
60.49% _bt_readpage;_bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity_ext;clauselist_selectivity_ext;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
16.59% 929 postgres postgres [.] hash_search_with_hash_value | |
16.55% hash_search_with_hash_value;BufTableLookup;ReadBuffer_common;ReadBufferExtended;_bt_getbuf;_bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity_ext;clauselist_selectivity_ext;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
3.58% 199 postgres postgres [.] LWLockAttemptLock | |
3.17% LWLockAttemptLock;ReadBuffer_common;ReadBufferExtended;_bt_getbuf;_bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity_ext;clauselist_selectivity_ext;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
3.19% 178 postgres postgres [.] _bt_readnextpage | |
3.19% _bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity_ext;clauselist_selectivity_ext;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
2.05% 115 postgres postgres [.] LWLockRelease | |
1.14% LWLockRelease;ReadBuffer_common;ReadBufferExtended;_bt_getbuf;_bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity_ext;clauselist_selectivity_ext;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main | |
0.77% LWLockRelease;_bt_relbuf;_bt_readnextpage;_bt_steppage;_bt_first;btgettuple;index_getnext_tid;get_actual_variable_endpoint;get_actual_variable_range;ineq_histogram_selectivity.part.0;scalarineqsel;scalarineqsel_wrapper;FunctionCall4Coll;OidFunctionCall4Coll;restriction_selectivity;clause_selectivity_ext;clauselist_selectivity_ext;set_baserel_size_estimates;make_one_rel;query_planner;grouping_planner;subquery_planner;standard_planner;pg_plan_query;pg_plan_queries;exec_simple_query;PostgresMain;ServerLoop;PostmasterMain;main;__libc_start_call_main |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment