-------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 551 132,069,390,199 2,017,790,984 2,015,810,085 1,980,899 0 99.90% (2,015,810,085B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc. ->51.25% (1,034,182,656B) 0x7DA482: new_list (list.c:137) | ->41.93% (846,036,992B) 0x7DA944: lappend (list.c:344) | | ->12.55% (253,272,064B) 0x8819FA: find_mergeclauses_for_outer_pathkeys (pathkeys.c:1611) | | | ->10.42% (210,223,104B) 0x879C9F: sort_inner_and_outer (joinpath.c:1526) | | | | ->10.42% (210,223,104B) 0x877DA3: add_paths_to_joinrel (joinpath.c:315) | | | | ->05.22% (105,283,584B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | | ->05.22% (105,283,584B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | ->05.06% (102,146,048B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | | ->05.06% (102,146,048B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | ->05.06% (102,146,048B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | ->05.06% (102,146,048B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | ->05.06% (102,146,048B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | ->05.06% (102,146,048B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | ->05.06% (102,146,048B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | ->05.06% (102,146,048B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | ->05.06% (102,146,048B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | ->05.06% (102,146,048B) 0x89E46B: planner (planner.c:342) | | | | | | ->05.06% (102,146,048B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | ->05.06% (102,146,048B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | ->05.06% (102,146,048B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | ->05.06% (102,146,048B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | ->05.06% (102,146,048B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | ->05.06% (102,146,048B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | ->05.06% (102,146,048B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | ->05.06% (102,146,048B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | ->05.06% (102,146,048B) 0xA215E0: PortalRun (pquery.c:756) | | | | | | ->05.06% (102,146,048B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | | ->05.06% (102,146,048B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | | ->05.06% (102,146,048B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | | ->05.06% (102,146,048B) 0x918651: postmaster_child_launch (launch_backend.c:268) | | | | | | | | | | | ->00.16% (3,137,536B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->05.20% (104,939,520B) 0x87D033: populate_joinrel_with_paths (joinrels.c:1108) | | | | ->05.20% (104,939,520B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | ->05.06% (102,006,784B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | ->05.06% (102,006,784B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | ->05.06% (102,006,784B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | ->05.06% (102,006,784B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | ->05.06% (102,006,784B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | ->05.06% (102,006,784B) 0x89DFF4: query_planner (planmain.c:297) | | | | | ->05.06% (102,006,784B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | ->05.06% (102,006,784B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | ->05.06% (102,006,784B) 0x89E9C8: standard_planner (planner.c:537) | | | | | ->05.06% (102,006,784B) 0x89E46B: planner (planner.c:342) | | | | | ->05.06% (102,006,784B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | ->05.06% (102,006,784B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | ->05.06% (102,006,784B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | ->05.06% (102,006,784B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | ->05.06% (102,006,784B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | ->05.06% (102,006,784B) 0xA23705: ProcessUtility (utility.c:528) | | | | | ->05.06% (102,006,784B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | ->05.06% (102,006,784B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | ->05.06% (102,006,784B) 0xA215E0: PortalRun (pquery.c:756) | | | | | ->05.06% (102,006,784B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | ->05.06% (102,006,784B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | ->05.06% (102,006,784B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | ->05.06% (102,006,784B) 0x918651: postmaster_child_launch (launch_backend.c:268) | | | | | | | | | ->00.15% (2,932,736B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->02.13% (43,048,960B) 0x879E6B: generate_mergejoin_paths (joinpath.c:1615) | | | ->02.13% (43,048,960B) 0x87A68D: match_unsorted_outer (joinpath.c:2001) | | | ->02.13% (43,048,960B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | | ->01.07% (21,585,920B) 0x87D033: populate_joinrel_with_paths (joinrels.c:1108) | | | | ->01.07% (21,585,920B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | ->01.02% (20,602,880B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | ->01.02% (20,602,880B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | ->01.02% (20,602,880B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | ->01.02% (20,602,880B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | ->01.02% (20,602,880B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | ->01.02% (20,602,880B) 0x89DFF4: query_planner (planmain.c:297) | | | | | ->01.02% (20,602,880B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | ->01.02% (20,602,880B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | ->01.02% (20,602,880B) 0x89E9C8: standard_planner (planner.c:537) | | | | | ->01.02% (20,602,880B) 0x89E46B: planner (planner.c:342) | | | | | ->01.02% (20,602,880B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | ->01.02% (20,602,880B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | ->01.02% (20,602,880B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | ->01.02% (20,602,880B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | ->01.02% (20,602,880B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | ->01.02% (20,602,880B) 0xA23705: ProcessUtility (utility.c:528) | | | | | ->01.02% (20,602,880B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | ->01.02% (20,602,880B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | ->01.02% (20,602,880B) 0xA215E0: PortalRun (pquery.c:756) | | | | | ->01.02% (20,602,880B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | ->01.02% (20,602,880B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | ->01.02% (20,602,880B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | | | | | ->00.05% (983,040B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.06% (21,463,040B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | ->01.06% (21,463,040B) 0x87C92C: make_join_rel (joinrels.c:774) | | | ->01.01% (20,332,544B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | ->01.01% (20,332,544B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | ->01.01% (20,332,544B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | ->01.01% (20,332,544B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | ->01.01% (20,332,544B) 0x853D60: make_one_rel (allpaths.c:240) | | | | ->01.01% (20,332,544B) 0x89DFF4: query_planner (planmain.c:297) | | | | ->01.01% (20,332,544B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | ->01.01% (20,332,544B) 0x8A0975: subquery_planner (planner.c:1373) | | | | ->01.01% (20,332,544B) 0x89E9C8: standard_planner (planner.c:537) | | | | ->01.01% (20,332,544B) 0x89E46B: planner (planner.c:342) | | | | ->01.01% (20,332,544B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | ->01.01% (20,332,544B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | ->01.01% (20,332,544B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | ->01.01% (20,332,544B) 0x64C86A: ExplainQuery (explain.c:228) | | | | ->01.01% (20,332,544B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | ->01.01% (20,332,544B) 0xA23705: ProcessUtility (utility.c:528) | | | | ->01.01% (20,332,544B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | ->01.01% (20,332,544B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | ->01.01% (20,332,544B) 0xA215E0: PortalRun (pquery.c:756) | | | | ->01.01% (20,332,544B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | ->01.01% (20,332,544B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | ->01.01% (20,332,544B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | | | ->00.06% (1,130,496B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->07.75% (156,418,048B) 0x86BCDB: generate_join_implied_equalities_normal (equivclass.c:1754) | | | ->05.78% (116,572,160B) 0x86B992: generate_join_implied_equalities (equivclass.c:1619) | | | | ->04.85% (97,894,400B) 0x8EFA98: get_joinrel_parampathinfo (relnode.c:1883) | | | | | ->03.79% (76,406,784B) 0x8DEE6F: create_nestloop_path (pathnode.c:2408) | | | | | | ->03.79% (76,406,784B) 0x878F1E: try_nestloop_path (joinpath.c:975) | | | | | | ->03.24% (65,421,312B) 0x87A538: match_unsorted_outer (joinpath.c:1957) | | | | | | | ->03.24% (65,421,312B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | | | | | | ->02.28% (46,055,424B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | | | | | ->02.28% (46,055,424B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | | | | ->01.23% (24,764,416B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | | | | | ->01.23% (24,764,416B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | | | | ->01.23% (24,764,416B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | | | | ->01.23% (24,764,416B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | | | | ->01.23% (24,764,416B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | | | | ->01.23% (24,764,416B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | | | | ->01.23% (24,764,416B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | | | | ->01.23% (24,764,416B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | | | | ->01.23% (24,764,416B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | | | | ->01.23% (24,764,416B) 0x89E46B: planner (planner.c:342) | | | | | | | | | ->01.23% (24,764,416B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | | | | ->01.23% (24,764,416B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | | | | ->01.23% (24,764,416B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | | | | ->01.23% (24,764,416B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | | | | ->01.23% (24,764,416B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | | | | ->01.23% (24,764,416B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | | | | ->01.23% (24,764,416B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | | | | ->01.23% (24,764,416B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | | | | ->01.23% (24,764,416B) 0xA215E0: PortalRun (pquery.c:756) | | | | | | | | | | | | | | | | | ->01.06% (21,291,008B) 0x87BE2E: make_rels_by_clause_joins (joinrels.c:300) | | | | | | | | ->01.06% (21,291,008B) 0x87B978: join_search_one_level (joinrels.c:123) | | | | | | | | ->01.06% (21,291,008B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | | | ->01.06% (21,291,008B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | | | ->01.06% (21,291,008B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | | | ->01.06% (21,291,008B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | | | ->01.06% (21,291,008B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | | | ->01.06% (21,291,008B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | | | ->01.06% (21,291,008B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | | | ->01.06% (21,291,008B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | | | ->01.06% (21,291,008B) 0x89E46B: planner (planner.c:342) | | | | | | | | ->01.06% (21,291,008B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | | | ->01.06% (21,291,008B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | | | ->01.06% (21,291,008B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | | | ->01.06% (21,291,008B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | | | ->01.06% (21,291,008B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | | | ->01.06% (21,291,008B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | | | ->01.06% (21,291,008B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | | | ->01.06% (21,291,008B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | | | | | | | | | | ->00.96% (19,365,888B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | | | ->00.54% (10,985,472B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->01.06% (21,487,616B) 0x8DF13B: create_hashjoin_path (pathnode.c:2539) | | | | | ->01.06% (21,487,616B) 0x879812: try_hashjoin_path (joinpath.c:1322) | | | | | ->01.06% (21,487,616B) 0x87B182: hash_inner_and_outer (joinpath.c:2309) | | | | | ->01.06% (21,487,616B) 0x877E2A: add_paths_to_joinrel (joinpath.c:354) | | | | | ->01.06% (21,487,616B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.93% (18,677,760B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.97% (39,845,888B) 0x86BB5D: generate_join_implied_equalities_for_ecs (equivclass.c:1695) | | | ->01.97% (39,845,888B) 0x8EFC81: get_joinrel_parampathinfo (relnode.c:1950) | | | ->01.55% (31,236,096B) 0x8DEE6F: create_nestloop_path (pathnode.c:2408) | | | | ->01.55% (31,236,096B) 0x878F1E: try_nestloop_path (joinpath.c:975) | | | | ->01.55% (31,236,096B) 0x87A538: match_unsorted_outer (joinpath.c:1957) | | | | ->01.55% (31,236,096B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | | | ->01.55% (31,236,096B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.43% (8,609,792B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->06.89% (139,124,736B) 0x86C004: generate_join_implied_equalities_normal (equivclass.c:1835) | | | ->06.86% (138,371,072B) 0x86B992: generate_join_implied_equalities (equivclass.c:1619) | | | | ->05.70% (115,105,792B) 0x8EFA98: get_joinrel_parampathinfo (relnode.c:1883) | | | | | ->04.44% (89,604,096B) 0x8DEE6F: create_nestloop_path (pathnode.c:2408) | | | | | | ->04.44% (89,604,096B) 0x878F1E: try_nestloop_path (joinpath.c:975) | | | | | | ->03.77% (76,087,296B) 0x87A538: match_unsorted_outer (joinpath.c:1957) | | | | | | | ->03.77% (76,087,296B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | | | | | | ->02.63% (53,133,312B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | | | | | ->02.63% (53,133,312B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | | | | ->01.46% (29,499,392B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | | | | | ->01.46% (29,499,392B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | | | | ->01.46% (29,499,392B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | | | | ->01.46% (29,499,392B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | | | | ->01.46% (29,499,392B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | | | | ->01.46% (29,499,392B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | | | | ->01.46% (29,499,392B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | | | | ->01.46% (29,499,392B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | | | | ->01.46% (29,499,392B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | | | | ->01.46% (29,499,392B) 0x89E46B: planner (planner.c:342) | | | | | | | | | ->01.46% (29,499,392B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | | | | ->01.46% (29,499,392B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | | | | ->01.46% (29,499,392B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | | | | ->01.46% (29,499,392B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | | | | ->01.46% (29,499,392B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | | | | ->01.46% (29,499,392B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | | | | ->01.46% (29,499,392B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | | | | ->01.46% (29,499,392B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | | | | ->01.46% (29,499,392B) 0xA215E0: PortalRun (pquery.c:756) | | | | | | | | | | | | | | | | | ->01.17% (23,633,920B) 0x87BE2E: make_rels_by_clause_joins (joinrels.c:300) | | | | | | | | ->01.17% (23,633,920B) 0x87B978: join_search_one_level (joinrels.c:123) | | | | | | | | ->01.17% (23,633,920B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | | | ->01.17% (23,633,920B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | | | ->01.17% (23,633,920B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | | | ->01.17% (23,633,920B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | | | ->01.17% (23,633,920B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | | | ->01.17% (23,633,920B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | | | ->01.17% (23,633,920B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | | | ->01.17% (23,633,920B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | | | ->01.17% (23,633,920B) 0x89E46B: planner (planner.c:342) | | | | | | | | ->01.17% (23,633,920B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | | | ->01.17% (23,633,920B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | | | ->01.17% (23,633,920B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | | | ->01.17% (23,633,920B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | | | ->01.17% (23,633,920B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | | | ->01.17% (23,633,920B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | | | ->01.17% (23,633,920B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | | | ->01.17% (23,633,920B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | | | | | | | | | | ->01.14% (22,953,984B) 0x87D033: populate_joinrel_with_paths (joinrels.c:1108) | | | | | | | ->01.14% (22,953,984B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | | | ->01.14% (22,953,984B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | | | ->00.67% (13,516,800B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->01.26% (25,501,696B) 0x8DF13B: create_hashjoin_path (pathnode.c:2539) | | | | | ->01.26% (25,501,696B) 0x879812: try_hashjoin_path (joinpath.c:1322) | | | | | ->01.26% (25,501,696B) 0x87B182: hash_inner_and_outer (joinpath.c:2309) | | | | | ->01.26% (25,501,696B) 0x877E2A: add_paths_to_joinrel (joinpath.c:354) | | | | | ->01.26% (25,501,696B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->01.15% (23,265,280B) 0x8EEE4A: build_joinrel_restrictlist (relnode.c:1471) | | | | ->01.15% (23,117,824B) 0x8ED949: build_join_rel (relnode.c:821) | | | | | ->01.15% (23,117,824B) 0x87C89E: make_join_rel (joinrels.c:755) | | | | | ->01.08% (21,889,024B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | | ->01.08% (21,889,024B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | ->01.08% (21,889,024B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | ->01.08% (21,889,024B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | ->01.08% (21,889,024B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | ->01.08% (21,889,024B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | ->01.08% (21,889,024B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | ->01.08% (21,889,024B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | ->01.08% (21,889,024B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | ->01.08% (21,889,024B) 0x89E46B: planner (planner.c:342) | | | | | | ->01.08% (21,889,024B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | ->01.08% (21,889,024B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | ->01.08% (21,889,024B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | ->01.08% (21,889,024B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | ->01.08% (21,889,024B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | ->01.08% (21,889,024B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | ->01.08% (21,889,024B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | ->01.08% (21,889,024B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | ->01.08% (21,889,024B) 0xA215E0: PortalRun (pquery.c:756) | | | | | | ->01.08% (21,889,024B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | | ->01.08% (21,889,024B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | | ->01.08% (21,889,024B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | | ->01.08% (21,889,024B) 0x918651: postmaster_child_launch (launch_backend.c:268) | | | | | | | | | | | ->00.06% (1,228,800B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.01% (147,456B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.04% (753,664B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->05.77% (116,514,816B) 0x86BD12: generate_join_implied_equalities_normal (equivclass.c:1756) | | | ->05.73% (115,630,080B) 0x86B992: generate_join_implied_equalities (equivclass.c:1619) | | | | ->04.84% (97,673,216B) 0x8EFA98: get_joinrel_parampathinfo (relnode.c:1883) | | | | | ->03.76% (75,923,456B) 0x8DEE6F: create_nestloop_path (pathnode.c:2408) | | | | | | ->03.76% (75,923,456B) 0x878F1E: try_nestloop_path (joinpath.c:975) | | | | | | ->03.22% (64,946,176B) 0x87A538: match_unsorted_outer (joinpath.c:1957) | | | | | | | ->03.22% (64,946,176B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | | | | | | ->02.27% (45,785,088B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | | | | | ->02.27% (45,785,088B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | | | | ->01.25% (25,231,360B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | | | | | ->01.25% (25,231,360B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | | | | ->01.25% (25,231,360B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | | | | ->01.25% (25,231,360B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | | | | ->01.25% (25,231,360B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | | | | ->01.25% (25,231,360B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | | | | ->01.25% (25,231,360B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | | | | ->01.25% (25,231,360B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | | | | ->01.25% (25,231,360B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | | | | ->01.25% (25,231,360B) 0x89E46B: planner (planner.c:342) | | | | | | | | | ->01.25% (25,231,360B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | | | | ->01.25% (25,231,360B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | | | | ->01.25% (25,231,360B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | | | | ->01.25% (25,231,360B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | | | | ->01.25% (25,231,360B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | | | | ->01.25% (25,231,360B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | | | | ->01.25% (25,231,360B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | | | | ->01.25% (25,231,360B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | | | | ->01.25% (25,231,360B) 0xA215E0: PortalRun (pquery.c:756) | | | | | | | | | | | | | | | | | ->01.02% (20,553,728B) 0x87BE2E: make_rels_by_clause_joins (joinrels.c:300) | | | | | | | | ->01.02% (20,553,728B) 0x87B978: join_search_one_level (joinrels.c:123) | | | | | | | | ->01.02% (20,553,728B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | | | ->01.02% (20,553,728B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | | | ->01.02% (20,553,728B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | | | ->01.02% (20,553,728B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | | | ->01.02% (20,553,728B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | | | ->01.02% (20,553,728B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | | | ->01.02% (20,553,728B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | | | ->01.02% (20,553,728B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | | | ->01.02% (20,553,728B) 0x89E46B: planner (planner.c:342) | | | | | | | | ->01.02% (20,553,728B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | | | ->01.02% (20,553,728B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | | | ->01.02% (20,553,728B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | | | ->01.02% (20,553,728B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | | | ->01.02% (20,553,728B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | | | ->01.02% (20,553,728B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | | | ->01.02% (20,553,728B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | | | ->01.02% (20,553,728B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | | | | | | | | | | ->00.95% (19,161,088B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | | | ->00.54% (10,977,280B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->01.08% (21,749,760B) 0x8DF13B: create_hashjoin_path (pathnode.c:2539) | | | | | ->01.08% (21,749,760B) 0x879812: try_hashjoin_path (joinpath.c:1322) | | | | | ->01.08% (21,749,760B) 0x87B182: hash_inner_and_outer (joinpath.c:2309) | | | | | ->01.08% (21,749,760B) 0x877E2A: add_paths_to_joinrel (joinpath.c:354) | | | | | ->01.08% (21,749,760B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.89% (17,956,864B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.04% (884,736B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.93% (79,306,752B) 0x88233F: make_inner_pathkeys_for_merge (pathkeys.c:1929) | | | ->02.09% (42,172,416B) 0x879ED0: generate_mergejoin_paths (joinpath.c:1640) | | | | ->02.09% (42,172,416B) 0x87A68D: match_unsorted_outer (joinpath.c:2001) | | | | ->02.09% (42,172,416B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | | | ->01.05% (21,184,512B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | | ->01.05% (21,184,512B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | ->01.05% (21,184,512B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->01.04% (20,987,904B) 0x87D033: populate_joinrel_with_paths (joinrels.c:1108) | | | | ->01.04% (20,987,904B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | ->01.04% (20,987,904B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.84% (37,134,336B) 0x879CF6: sort_inner_and_outer (joinpath.c:1534) | | | ->01.84% (37,134,336B) 0x877DA3: add_paths_to_joinrel (joinpath.c:315) | | | ->01.84% (37,134,336B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | ->05.03% (101,400,576B) in 20+ places, all below ms_print's threshold (01.00%) | | | ->08.40% (169,394,176B) 0x7DCED0: list_copy (list.c:1580) | | ->04.53% (91,422,720B) 0x7DAF70: list_concat (list.c:566) | | | ->02.54% (51,339,264B) 0x881A6D: find_mergeclauses_for_outer_pathkeys (pathkeys.c:1626) | | | | ->02.09% (42,254,336B) 0x879E6B: generate_mergejoin_paths (joinpath.c:1615) | | | | | ->02.09% (42,254,336B) 0x87A68D: match_unsorted_outer (joinpath.c:2001) | | | | | ->02.09% (42,254,336B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | | | | ->01.06% (21,479,424B) 0x87D033: populate_joinrel_with_paths (joinrels.c:1108) | | | | | | ->01.06% (21,479,424B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | | ->01.00% (20,242,432B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | | | ->01.00% (20,242,432B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | | ->01.00% (20,242,432B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | | ->01.00% (20,242,432B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | | ->01.00% (20,242,432B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | | ->01.00% (20,242,432B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | | ->01.00% (20,242,432B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | | ->01.00% (20,242,432B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | | ->01.00% (20,242,432B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | | ->01.00% (20,242,432B) 0x89E46B: planner (planner.c:342) | | | | | | | ->01.00% (20,242,432B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | | ->01.00% (20,242,432B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | | ->01.00% (20,242,432B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | | ->01.00% (20,242,432B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | | ->01.00% (20,242,432B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | | ->01.00% (20,242,432B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | | ->01.00% (20,242,432B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | | ->01.00% (20,242,432B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | | ->01.00% (20,242,432B) 0xA215E0: PortalRun (pquery.c:756) | | | | | | | ->01.00% (20,242,432B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | | | ->01.00% (20,242,432B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | | | | | | | | | ->00.06% (1,236,992B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->01.03% (20,774,912B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | | ->01.03% (20,774,912B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | ->01.03% (20,774,912B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.45% (9,084,928B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.09% (22,003,712B) 0x86B9DF: generate_join_implied_equalities (equivclass.c:1634) | | | | ->01.09% (22,003,712B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.90% (18,079,744B) in 4+ places, all below ms_print's threshold (01.00%) | | | | | ->03.55% (71,680,000B) 0x879C54: sort_inner_and_outer (joinpath.c:1518) | | | ->03.55% (71,680,000B) 0x877DA3: add_paths_to_joinrel (joinpath.c:315) | | | ->01.85% (37,273,600B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | ->01.85% (37,273,600B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | ->01.79% (36,126,720B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | ->01.79% (36,126,720B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | ->01.79% (36,126,720B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | ->01.79% (36,126,720B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | ->01.79% (36,126,720B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | ->01.79% (36,126,720B) 0x89DFF4: query_planner (planmain.c:297) | | | | | ->01.79% (36,126,720B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | ->01.79% (36,126,720B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | ->01.79% (36,126,720B) 0x89E9C8: standard_planner (planner.c:537) | | | | | ->01.79% (36,126,720B) 0x89E46B: planner (planner.c:342) | | | | | ->01.79% (36,126,720B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | ->01.79% (36,126,720B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | ->01.79% (36,126,720B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | ->01.79% (36,126,720B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | ->01.79% (36,126,720B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | ->01.79% (36,126,720B) 0xA23705: ProcessUtility (utility.c:528) | | | | | ->01.79% (36,126,720B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | ->01.79% (36,126,720B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | ->01.79% (36,126,720B) 0xA215E0: PortalRun (pquery.c:756) | | | | | ->01.79% (36,126,720B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | ->01.79% (36,126,720B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | ->01.79% (36,126,720B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | ->01.79% (36,126,720B) 0x918651: postmaster_child_launch (launch_backend.c:268) | | | | | ->01.79% (36,126,720B) 0x91E7F6: BackendStartup (postmaster.c:3627) | | | | | | | | | ->00.06% (1,146,880B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.71% (34,406,400B) 0x87D033: populate_joinrel_with_paths (joinrels.c:1108) | | | ->01.71% (34,406,400B) 0x87C92C: make_join_rel (joinrels.c:774) | | | ->01.65% (33,300,480B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | ->01.65% (33,300,480B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | ->01.65% (33,300,480B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | ->01.65% (33,300,480B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | ->01.65% (33,300,480B) 0x853D60: make_one_rel (allpaths.c:240) | | | | ->01.65% (33,300,480B) 0x89DFF4: query_planner (planmain.c:297) | | | | ->01.65% (33,300,480B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | ->01.65% (33,300,480B) 0x8A0975: subquery_planner (planner.c:1373) | | | | ->01.65% (33,300,480B) 0x89E9C8: standard_planner (planner.c:537) | | | | ->01.65% (33,300,480B) 0x89E46B: planner (planner.c:342) | | | | ->01.65% (33,300,480B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | ->01.65% (33,300,480B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | ->01.65% (33,300,480B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | ->01.65% (33,300,480B) 0x64C86A: ExplainQuery (explain.c:228) | | | | ->01.65% (33,300,480B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | ->01.65% (33,300,480B) 0xA23705: ProcessUtility (utility.c:528) | | | | ->01.65% (33,300,480B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | ->01.65% (33,300,480B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | ->01.65% (33,300,480B) 0xA215E0: PortalRun (pquery.c:756) | | | | ->01.65% (33,300,480B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | ->01.65% (33,300,480B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | ->01.65% (33,300,480B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | ->01.65% (33,300,480B) 0x918651: postmaster_child_launch (launch_backend.c:268) | | | | ->01.65% (33,300,480B) 0x91E7F6: BackendStartup (postmaster.c:3627) | | | | | | | ->00.05% (1,105,920B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.31% (6,291,456B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->00.93% (18,751,488B) in 4+ places, all below ms_print's threshold (01.00%) | ->30.35% (612,401,152B) 0x7DA5A6: enlarge_list (list.c:219) | ->14.01% (282,714,112B) 0x7DA8E4: new_tail_cell (list.c:327) | | ->13.94% (281,378,816B) 0x7DA956: lappend (list.c:346) | | | ->08.20% (165,396,480B) 0x88233F: make_inner_pathkeys_for_merge (pathkeys.c:1929) | | | | ->08.20% (165,396,480B) 0x879CF6: sort_inner_and_outer (joinpath.c:1534) | | | | ->08.20% (165,396,480B) 0x877DA3: add_paths_to_joinrel (joinpath.c:315) | | | | ->04.11% (82,845,696B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | | ->04.11% (82,845,696B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | ->04.01% (80,953,344B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | | ->04.01% (80,953,344B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | | ->04.01% (80,953,344B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | | ->04.01% (80,953,344B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | | ->04.01% (80,953,344B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | | ->04.01% (80,953,344B) 0x89DFF4: query_planner (planmain.c:297) | | | | | | ->04.01% (80,953,344B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | | ->04.01% (80,953,344B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | | ->04.01% (80,953,344B) 0x89E9C8: standard_planner (planner.c:537) | | | | | | ->04.01% (80,953,344B) 0x89E46B: planner (planner.c:342) | | | | | | ->04.01% (80,953,344B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | | ->04.01% (80,953,344B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | | ->04.01% (80,953,344B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | | ->04.01% (80,953,344B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | | ->04.01% (80,953,344B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | ->04.01% (80,953,344B) 0xA23705: ProcessUtility (utility.c:528) | | | | | | ->04.01% (80,953,344B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | | ->04.01% (80,953,344B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | | ->04.01% (80,953,344B) 0xA215E0: PortalRun (pquery.c:756) | | | | | | ->04.01% (80,953,344B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | | ->04.01% (80,953,344B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | | ->04.01% (80,953,344B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | | | | | | | ->00.09% (1,892,352B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->04.09% (82,550,784B) 0x87D033: populate_joinrel_with_paths (joinrels.c:1108) | | | | ->04.09% (82,550,784B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | ->03.99% (80,609,280B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | ->03.99% (80,609,280B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | ->03.99% (80,609,280B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | ->03.99% (80,609,280B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | ->03.99% (80,609,280B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | ->03.99% (80,609,280B) 0x89DFF4: query_planner (planmain.c:297) | | | | | ->03.99% (80,609,280B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | ->03.99% (80,609,280B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | ->03.99% (80,609,280B) 0x89E9C8: standard_planner (planner.c:537) | | | | | ->03.99% (80,609,280B) 0x89E46B: planner (planner.c:342) | | | | | ->03.99% (80,609,280B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | ->03.99% (80,609,280B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | ->03.99% (80,609,280B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | ->03.99% (80,609,280B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | ->03.99% (80,609,280B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | ->03.99% (80,609,280B) 0xA23705: ProcessUtility (utility.c:528) | | | | | ->03.99% (80,609,280B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | ->03.99% (80,609,280B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | ->03.99% (80,609,280B) 0xA215E0: PortalRun (pquery.c:756) | | | | | ->03.99% (80,609,280B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | ->03.99% (80,609,280B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | ->03.99% (80,609,280B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | | | | | ->00.10% (1,941,504B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.40% (28,262,400B) 0x882128: select_outer_pathkeys_for_merge (pathkeys.c:1827) | | | | ->01.40% (28,262,400B) 0x879C10: sort_inner_and_outer (joinpath.c:1504) | | | | ->01.40% (28,262,400B) 0x877DA3: add_paths_to_joinrel (joinpath.c:315) | | | | ->01.40% (28,262,400B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.19% (23,969,792B) 0x87AD9C: hash_inner_and_outer (joinpath.c:2240) | | | | ->01.19% (23,969,792B) 0x877E2A: add_paths_to_joinrel (joinpath.c:354) | | | | ->01.19% (23,969,792B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.05% (21,225,472B) 0x87B59F: select_mergejoin_clauses (joinpath.c:2507) | | | | ->01.05% (21,225,472B) 0x877B81: add_paths_to_joinrel (joinpath.c:243) | | | | ->01.05% (21,225,472B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | ->02.11% (42,524,672B) in 14+ places, all below ms_print's threshold (01.00%) | | | | | ->00.07% (1,335,296B) in 2+ places, all below ms_print's threshold (01.00%) | | | ->12.42% (250,601,472B) 0x7DAFD9: list_concat (list.c:575) | | ->07.99% (161,243,136B) 0x881A6D: find_mergeclauses_for_outer_pathkeys (pathkeys.c:1626) | | | ->07.99% (161,243,136B) 0x879C9F: sort_inner_and_outer (joinpath.c:1526) | | | ->07.99% (161,243,136B) 0x877DA3: add_paths_to_joinrel (joinpath.c:315) | | | ->04.08% (82,288,640B) 0x87D033: populate_joinrel_with_paths (joinrels.c:1108) | | | | ->04.08% (82,288,640B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | ->03.99% (80,437,248B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | ->03.99% (80,437,248B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | ->03.99% (80,437,248B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | ->03.99% (80,437,248B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | ->03.99% (80,437,248B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | ->03.99% (80,437,248B) 0x89DFF4: query_planner (planmain.c:297) | | | | | ->03.99% (80,437,248B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | ->03.99% (80,437,248B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | ->03.99% (80,437,248B) 0x89E9C8: standard_planner (planner.c:537) | | | | | ->03.99% (80,437,248B) 0x89E46B: planner (planner.c:342) | | | | | ->03.99% (80,437,248B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | ->03.99% (80,437,248B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | ->03.99% (80,437,248B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | ->03.99% (80,437,248B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | ->03.99% (80,437,248B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | ->03.99% (80,437,248B) 0xA23705: ProcessUtility (utility.c:528) | | | | | ->03.99% (80,437,248B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | ->03.99% (80,437,248B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | ->03.99% (80,437,248B) 0xA215E0: PortalRun (pquery.c:756) | | | | | ->03.99% (80,437,248B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | ->03.99% (80,437,248B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | ->03.99% (80,437,248B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | ->03.99% (80,437,248B) 0x918651: postmaster_child_launch (launch_backend.c:268) | | | | | | | | | ->00.09% (1,851,392B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->03.91% (78,954,496B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | ->03.91% (78,954,496B) 0x87C92C: make_join_rel (joinrels.c:774) | | | ->03.83% (77,307,904B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | ->03.83% (77,307,904B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | ->03.83% (77,307,904B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | ->03.83% (77,307,904B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | ->03.83% (77,307,904B) 0x853D60: make_one_rel (allpaths.c:240) | | | | ->03.83% (77,307,904B) 0x89DFF4: query_planner (planmain.c:297) | | | | ->03.83% (77,307,904B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | ->03.83% (77,307,904B) 0x8A0975: subquery_planner (planner.c:1373) | | | | ->03.83% (77,307,904B) 0x89E9C8: standard_planner (planner.c:537) | | | | ->03.83% (77,307,904B) 0x89E46B: planner (planner.c:342) | | | | ->03.83% (77,307,904B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | ->03.83% (77,307,904B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | ->03.83% (77,307,904B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | ->03.83% (77,307,904B) 0x64C86A: ExplainQuery (explain.c:228) | | | | ->03.83% (77,307,904B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | ->03.83% (77,307,904B) 0xA23705: ProcessUtility (utility.c:528) | | | | ->03.83% (77,307,904B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | ->03.83% (77,307,904B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | ->03.83% (77,307,904B) 0xA215E0: PortalRun (pquery.c:756) | | | | ->03.83% (77,307,904B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | ->03.83% (77,307,904B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | ->03.83% (77,307,904B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | ->03.83% (77,307,904B) 0x918651: postmaster_child_launch (launch_backend.c:268) | | | | | | | ->00.08% (1,646,592B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->04.03% (81,354,752B) 0x86B9DF: generate_join_implied_equalities (equivclass.c:1634) | | | ->03.47% (70,098,944B) 0x8EFA98: get_joinrel_parampathinfo (relnode.c:1883) | | | | ->02.80% (56,598,528B) 0x8DEE6F: create_nestloop_path (pathnode.c:2408) | | | | | ->02.80% (56,598,528B) 0x878F1E: try_nestloop_path (joinpath.c:975) | | | | | ->02.40% (48,439,296B) 0x87A538: match_unsorted_outer (joinpath.c:1957) | | | | | | ->02.40% (48,439,296B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | | | | | ->01.67% (33,611,776B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | | | | ->01.67% (33,611,776B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | | | ->01.67% (33,611,776B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | | | ->00.73% (14,827,520B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.40% (8,159,232B) in 2+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.67% (13,500,416B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.56% (11,255,808B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.40% (8,003,584B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->03.81% (76,849,152B) 0x7DA86A: new_head_cell (list.c:309) | | ->03.81% (76,849,152B) 0x7DAE15: lcons (list.c:502) | | ->03.81% (76,824,576B) 0x879C70: sort_inner_and_outer (joinpath.c:1518) | | | ->03.81% (76,824,576B) 0x877DA3: add_paths_to_joinrel (joinpath.c:315) | | | ->01.96% (39,501,824B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | ->01.96% (39,501,824B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | ->01.92% (38,682,624B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | | ->01.92% (38,682,624B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | ->01.92% (38,682,624B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | ->01.92% (38,682,624B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | ->01.92% (38,682,624B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | ->01.92% (38,682,624B) 0x89DFF4: query_planner (planmain.c:297) | | | | | ->01.92% (38,682,624B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | ->01.92% (38,682,624B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | ->01.92% (38,682,624B) 0x89E9C8: standard_planner (planner.c:537) | | | | | ->01.92% (38,682,624B) 0x89E46B: planner (planner.c:342) | | | | | ->01.92% (38,682,624B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | ->01.92% (38,682,624B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | ->01.92% (38,682,624B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | ->01.92% (38,682,624B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | ->01.92% (38,682,624B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | ->01.92% (38,682,624B) 0xA23705: ProcessUtility (utility.c:528) | | | | | ->01.92% (38,682,624B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | | ->01.92% (38,682,624B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | | ->01.92% (38,682,624B) 0xA215E0: PortalRun (pquery.c:756) | | | | | ->01.92% (38,682,624B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | | ->01.92% (38,682,624B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | | ->01.92% (38,682,624B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | ->01.92% (38,682,624B) 0x918651: postmaster_child_launch (launch_backend.c:268) | | | | | | | | | ->00.04% (819,200B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.85% (37,322,752B) 0x87D033: populate_joinrel_with_paths (joinrels.c:1108) | | | ->01.85% (37,322,752B) 0x87C92C: make_join_rel (joinrels.c:774) | | | ->01.82% (36,626,432B) 0x87BB52: join_search_one_level (joinrels.c:198) | | | | ->01.82% (36,626,432B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | ->01.82% (36,626,432B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | ->01.82% (36,626,432B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | ->01.82% (36,626,432B) 0x853D60: make_one_rel (allpaths.c:240) | | | | ->01.82% (36,626,432B) 0x89DFF4: query_planner (planmain.c:297) | | | | ->01.82% (36,626,432B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | ->01.82% (36,626,432B) 0x8A0975: subquery_planner (planner.c:1373) | | | | ->01.82% (36,626,432B) 0x89E9C8: standard_planner (planner.c:537) | | | | ->01.82% (36,626,432B) 0x89E46B: planner (planner.c:342) | | | | ->01.82% (36,626,432B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | ->01.82% (36,626,432B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | ->01.82% (36,626,432B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | ->01.82% (36,626,432B) 0x64C86A: ExplainQuery (explain.c:228) | | | | ->01.82% (36,626,432B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | ->01.82% (36,626,432B) 0xA23705: ProcessUtility (utility.c:528) | | | | ->01.82% (36,626,432B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | | ->01.82% (36,626,432B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | | ->01.82% (36,626,432B) 0xA215E0: PortalRun (pquery.c:756) | | | | ->01.82% (36,626,432B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | | ->01.82% (36,626,432B) 0xA1F896: PostgresMain (postgres.c:4856) | | | | ->01.82% (36,626,432B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | ->01.82% (36,626,432B) 0x918651: postmaster_child_launch (launch_backend.c:268) | | | | | | | ->00.03% (696,320B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (24,576B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->00.11% (2,236,416B) in 1+ places, all below ms_print's threshold (01.00%) | ->05.82% (117,399,552B) 0x8DB327: newNode (nodes.h:155) | ->04.29% (86,589,440B) 0x8DDC34: create_memoize_path (pathnode.c:1750) | | ->04.29% (86,589,440B) 0x878BBB: get_memoize_path (joinpath.c:859) | | ->04.29% (86,589,440B) 0x87A575: match_unsorted_outer (joinpath.c:1970) | | ->04.29% (86,589,440B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | ->04.29% (86,556,672B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | ->04.29% (86,556,672B) 0x87C92C: make_join_rel (joinrels.c:774) | | | ->04.29% (86,556,672B) 0x87BE2E: make_rels_by_clause_joins (joinrels.c:300) | | | ->04.29% (86,556,672B) 0x87B978: join_search_one_level (joinrels.c:123) | | | ->04.29% (86,556,672B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | ->04.29% (86,556,672B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | ->04.29% (86,556,672B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | ->04.29% (86,556,672B) 0x853D60: make_one_rel (allpaths.c:240) | | | ->04.29% (86,556,672B) 0x89DFF4: query_planner (planmain.c:297) | | | ->04.29% (86,556,672B) 0x8A19F1: grouping_planner (planner.c:1995) | | | ->04.29% (86,556,672B) 0x8A0975: subquery_planner (planner.c:1373) | | | ->04.29% (86,556,672B) 0x89E9C8: standard_planner (planner.c:537) | | | ->04.29% (86,556,672B) 0x89E46B: planner (planner.c:342) | | | ->04.29% (86,556,672B) 0xA19E51: pg_plan_query (postgres.c:917) | | | ->04.29% (86,556,672B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | ->04.29% (86,556,672B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | ->04.29% (86,556,672B) 0x64C86A: ExplainQuery (explain.c:228) | | | ->04.29% (86,556,672B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | ->04.29% (86,556,672B) 0xA23705: ProcessUtility (utility.c:528) | | | ->04.29% (86,556,672B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | | ->04.29% (86,556,672B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | | ->04.29% (86,556,672B) 0xA215E0: PortalRun (pquery.c:756) | | | ->04.29% (86,556,672B) 0xA1A4F8: exec_simple_query (postgres.c:1290) | | | ->04.29% (86,556,672B) 0xA1F896: PostgresMain (postgres.c:4856) | | | ->04.29% (86,556,672B) 0xA15D78: BackendMain (backend_startup.c:124) | | | | | ->00.00% (32,768B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->01.53% (30,810,112B) in 5+ places, all below ms_print's threshold (01.00%) | ->04.81% (97,140,736B) 0x7AE4F0: bms_copy (bitmapset.c:133) | ->01.67% (33,611,776B) 0x7AFA42: bms_add_members (bitmapset.c:913) | | ->01.48% (29,843,456B) 0x86F426: get_eclass_indexes_for_relids (equivclass.c:3634) | | | ->01.48% (29,843,456B) in 3+ places, all below ms_print's threshold (01.00%) | | | | | ->00.19% (3,768,320B) in 3+ places, all below ms_print's threshold (01.00%) | | | ->01.22% (24,526,848B) 0x7AE8BB: bms_union (bitmapset.c:269) | | ->01.22% (24,526,848B) in 7+ places, all below ms_print's threshold (01.00%) | | | ->01.93% (39,002,112B) in 7+ places, all below ms_print's threshold (01.00%) | ->02.06% (41,525,248B) 0x7DA528: enlarge_list (list.c:186) | ->01.18% (23,805,952B) 0x7DA8E4: new_tail_cell (list.c:327) | | ->01.18% (23,797,760B) 0x7DA956: lappend (list.c:346) | | | ->01.18% (23,797,760B) in 18+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (8,192B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->00.88% (17,719,296B) in 2+ places, all below ms_print's threshold (01.00%) | ->01.92% (38,715,392B) 0x7DB5D1: list_delete_nth_cell (list.c:800) | ->01.38% (27,885,568B) 0x879C5E: sort_inner_and_outer (joinpath.c:1518) | | ->01.38% (27,885,568B) 0x877DA3: add_paths_to_joinrel (joinpath.c:315) | | ->01.38% (27,885,568B) in 2+ places, all below ms_print's threshold (01.00%) | | | ->00.54% (10,829,824B) in 2+ places, all below ms_print's threshold (01.00%) | ->01.76% (35,487,744B) 0x7E6219: expression_tree_mutator_impl (nodeFuncs.c:3052) | ->01.76% (35,422,208B) 0x999C31: remove_nulling_relids_mutator (rewriteManip.c:1420) | | ->01.75% (35,405,824B) 0x7E93D2: query_or_expression_tree_mutator_impl (nodeFuncs.c:4095) | | | ->01.75% (35,405,824B) 0x999A21: remove_nulling_relids (rewriteManip.c:1349) | | | ->01.75% (35,405,824B) 0xB96706: add_unique_group_var (selfuncs.c:3689) | | | ->01.75% (35,405,824B) 0xB96A50: estimate_num_groups (selfuncs.c:3891) | | | ->01.75% (35,323,904B) 0x861759: cost_memoize_rescan (costsize.c:2681) | | | | ->01.75% (35,323,904B) 0x865346: cost_rescan (costsize.c:4876) | | | | ->01.75% (35,323,904B) 0x862A7C: initial_cost_nestloop (costsize.c:3393) | | | | ->01.75% (35,323,904B) 0x878E99: try_nestloop_path (joinpath.c:966) | | | | ->01.75% (35,323,904B) 0x87A5B8: match_unsorted_outer (joinpath.c:1974) | | | | ->01.75% (35,323,904B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | | | ->01.75% (35,315,712B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | | | | ->01.75% (35,315,712B) 0x87C92C: make_join_rel (joinrels.c:774) | | | | | ->01.75% (35,315,712B) 0x87BE2E: make_rels_by_clause_joins (joinrels.c:300) | | | | | ->01.75% (35,315,712B) 0x87B978: join_search_one_level (joinrels.c:123) | | | | | ->01.75% (35,315,712B) 0x859ED8: standard_join_search (allpaths.c:3983) | | | | | ->01.75% (35,315,712B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | | | | ->01.75% (35,315,712B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | | | | ->01.75% (35,315,712B) 0x853D60: make_one_rel (allpaths.c:240) | | | | | ->01.75% (35,315,712B) 0x89DFF4: query_planner (planmain.c:297) | | | | | ->01.75% (35,315,712B) 0x8A19F1: grouping_planner (planner.c:1995) | | | | | ->01.75% (35,315,712B) 0x8A0975: subquery_planner (planner.c:1373) | | | | | ->01.75% (35,315,712B) 0x89E9C8: standard_planner (planner.c:537) | | | | | ->01.75% (35,315,712B) 0x89E46B: planner (planner.c:342) | | | | | ->01.75% (35,315,712B) 0xA19E51: pg_plan_query (postgres.c:917) | | | | | ->01.75% (35,315,712B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | | | | ->01.75% (35,315,712B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | | | | ->01.75% (35,315,712B) 0x64C86A: ExplainQuery (explain.c:228) | | | | | ->01.75% (35,315,712B) 0xA24441: standard_ProcessUtility (utility.c:871) | | | | | | | | | ->00.00% (8,192B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.00% (81,920B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (16,384B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->00.00% (65,536B) in 1+ places, all below ms_print's threshold (01.00%) | ->01.13% (22,798,336B) 0xB96820: add_unique_group_var (selfuncs.c:3720) | ->01.13% (22,798,336B) 0xB96A50: estimate_num_groups (selfuncs.c:3891) | ->01.13% (22,790,144B) 0x861759: cost_memoize_rescan (costsize.c:2681) | | ->01.13% (22,790,144B) 0x865346: cost_rescan (costsize.c:4876) | | ->01.13% (22,790,144B) 0x862A7C: initial_cost_nestloop (costsize.c:3393) | | ->01.13% (22,790,144B) 0x878E99: try_nestloop_path (joinpath.c:966) | | ->01.13% (22,790,144B) 0x87A5B8: match_unsorted_outer (joinpath.c:1974) | | ->01.13% (22,790,144B) 0x877DDF: add_paths_to_joinrel (joinpath.c:327) | | ->01.13% (22,790,144B) 0x87D003: populate_joinrel_with_paths (joinrels.c:1105) | | ->01.13% (22,790,144B) 0x87C92C: make_join_rel (joinrels.c:774) | | ->01.13% (22,790,144B) 0x87BE2E: make_rels_by_clause_joins (joinrels.c:300) | | ->01.13% (22,790,144B) 0x87B978: join_search_one_level (joinrels.c:123) | | ->01.13% (22,790,144B) 0x859ED8: standard_join_search (allpaths.c:3983) | | ->01.13% (22,790,144B) 0x859E4D: make_rel_from_joinlist (allpaths.c:3914) | | ->01.13% (22,790,144B) 0x859D03: make_rel_from_joinlist (allpaths.c:3879) | | ->01.13% (22,790,144B) 0x853D60: make_one_rel (allpaths.c:240) | | ->01.13% (22,790,144B) 0x89DFF4: query_planner (planmain.c:297) | | ->01.13% (22,790,144B) 0x8A19F1: grouping_planner (planner.c:1995) | | ->01.13% (22,790,144B) 0x8A0975: subquery_planner (planner.c:1373) | | ->01.13% (22,790,144B) 0x89E9C8: standard_planner (planner.c:537) | | ->01.13% (22,790,144B) 0x89E46B: planner (planner.c:342) | | ->01.13% (22,790,144B) 0xA19E51: pg_plan_query (postgres.c:917) | | ->01.13% (22,790,144B) 0x64CD6B: standard_ExplainOneQuery (explain.c:359) | | ->01.13% (22,790,144B) 0x64CBCF: ExplainOneQuery (explain.c:315) | | ->01.13% (22,790,144B) 0x64C86A: ExplainQuery (explain.c:228) | | ->01.13% (22,790,144B) 0xA24441: standard_ProcessUtility (utility.c:871) | | ->01.13% (22,790,144B) 0xA23705: ProcessUtility (utility.c:528) | | ->01.13% (22,790,144B) 0xA21EFF: PortalRunUtility (pquery.c:1149) | | ->01.13% (22,790,144B) 0xA21C6C: FillPortalStore (pquery.c:1022) | | ->01.13% (22,790,144B) 0xA215E0: PortalRun (pquery.c:756) | | | ->00.00% (8,192B) in 1+ places, all below ms_print's threshold (01.00%) | ->00.80% (16,159,269B) in 83+ places, all below ms_print's threshold (01.00%)