CPU: Core 2, speed 2000 MHz (estimated) Counted CPU_CLK_UNHALTED events (Clock cycles when not halted) with a unit mask of 0x00 (Unhalted core cycles) count 100000 samples % image name app name symbol name ------------------------------------------------------------------------------- 87000 21.2565 no-vmlinux no-vmlinux /no-vmlinux 87000 100.000 no-vmlinux no-vmlinux /no-vmlinux [self] ------------------------------------------------------------------------------- 14 0.0222 postgres postgres add_paths_to_joinrel 123 0.1953 postgres postgres make_pathkey_from_sortinfo 19347 30.7139 postgres postgres select_outer_pathkeys_for_merge 43507 69.0686 postgres postgres make_inner_pathkeys_for_merge 62999 15.3924 postgres postgres make_canonical_pathkey 62999 100.000 postgres postgres make_canonical_pathkey [self] ------------------------------------------------------------------------------- 1 0.0030 postgres postgres find_eclass_clauses_for_index_join 2 0.0060 postgres postgres check_outerjoin_delay 2 0.0060 postgres postgres deconstruct_recurse 5 0.0150 postgres postgres have_join_order_restriction 12 0.0361 postgres postgres add_paths_to_joinrel 25 0.0751 postgres postgres have_relevant_eclass_joinclause 33 0.0992 postgres postgres pathkeys_useful_for_merging 243 0.7304 postgres postgres make_join_rel 257 0.7725 postgres postgres build_join_rel 400 1.2024 postgres postgres select_outer_pathkeys_for_merge 676 2.0320 postgres postgres build_joinrel_restrictlist 1049 3.1532 postgres postgres eclass_useful_for_merging 6445 19.3730 postgres postgres has_relevant_eclass_joinclause 7493 22.5231 postgres postgres join_is_legal 16625 49.9729 postgres postgres generate_join_implied_equalities 33275 8.1300 postgres postgres bms_overlap 33275 100.000 postgres postgres bms_overlap [self] ------------------------------------------------------------------------------- 32118 7.8473 oprofiled oprofiled /usr/bin/oprofiled 32118 100.000 oprofiled oprofiled /usr/bin/oprofiled [self] ------------------------------------------------------------------------------- 27349 6.6821 libxul.so libxul.so /usr/local/firefox-3.5.2/libxul.so 27349 100.000 libxul.so libxul.so /usr/local/firefox-3.5.2/libxul.so [self] ------------------------------------------------------------------------------- 29 0.0594 postgres postgres build_join_rel 48786 99.9406 postgres postgres build_joinrel_restrictlist 26656 6.5128 postgres postgres generate_join_implied_equalities 26656 54.6062 postgres postgres generate_join_implied_equalities [self] 16625 34.0572 postgres postgres bms_overlap 3327 6.8155 postgres postgres bms_is_subset 1229 2.5177 postgres postgres lappend 477 0.9772 postgres postgres select_equality_operator 204 0.4179 postgres postgres op_hashjoinable 194 0.3974 postgres postgres create_join_clause 45 0.0922 postgres postgres list_concat 26 0.0533 postgres postgres new_list 14 0.0287 postgres postgres MemoryContextAlloc 10 0.0205 postgres postgres AllocSetAlloc 3 0.0061 postgres postgres SearchSysCache 3 0.0061 postgres postgres get_opfamily_member 1 0.0020 postgres postgres ReleaseCatCache 1 0.0020 postgres postgres SearchCatCache ------------------------------------------------------------------------------- 70 0.2623 postgres postgres make_join_rel 26614 99.7377 postgres postgres add_paths_to_joinrel 24336 5.9459 postgres postgres add_path 24336 91.1939 postgres postgres add_path [self] 846 3.1702 postgres postgres compare_pathkeys 676 2.5332 postgres postgres lappend_cell 307 1.1504 postgres postgres list_delete_cell 176 0.6595 postgres postgres pfree 156 0.5846 postgres postgres compare_path_costs 110 0.4122 postgres postgres lcons 33 0.1237 postgres postgres AllocSetFree 22 0.0824 postgres postgres MemoryContextAlloc 17 0.0637 postgres postgres AllocSetAlloc 6 0.0225 postgres postgres list_free_private 1 0.0037 postgres postgres new_list ------------------------------------------------------------------------------- 7832 1.9136 libmozjs.so libmozjs.so /usr/local/firefox-3.5.2/libmozjs.so 7832 100.000 libmozjs.so libmozjs.so /usr/local/firefox-3.5.2/libmozjs.so [self] ------------------------------------------------------------------------------- 1 0.0149 postgres postgres have_relevant_eclass_joinclause 4 0.0594 postgres postgres best_inner_indexscan 8 0.1188 postgres postgres create_hashjoin_path 10 0.1485 postgres postgres create_mergejoin_path 12 0.1782 postgres postgres have_join_order_restriction 13 0.1931 postgres postgres pathkeys_useful_for_merging 31 0.4604 postgres postgres make_join_rel 62 0.9207 postgres postgres create_index_paths 94 1.3959 postgres postgres cost_hashjoin 146 2.1681 postgres postgres find_eclass_clauses_for_index_join 238 3.5343 postgres postgres has_relevant_eclass_joinclause 403 5.9846 postgres postgres build_join_rel 430 6.3855 postgres postgres join_is_legal 436 6.4746 postgres postgres add_paths_to_joinrel 460 6.8310 postgres postgres build_joinrel_restrictlist 513 7.6181 postgres postgres cost_mergejoin 546 8.1081 postgres postgres eclass_useful_for_merging 3327 49.4060 postgres postgres generate_join_implied_equalities 6735 1.6455 postgres postgres bms_is_subset 6735 100.000 postgres postgres bms_is_subset [self] ------------------------------------------------------------------------------- 114 1.7941 postgres postgres hash_search 6240 98.2059 postgres postgres bms_hash_value 6356 1.5529 postgres postgres hash_any 6356 100.000 postgres postgres hash_any [self] ------------------------------------------------------------------------------- 2 0.0164 postgres postgres make_join_rel 12195 99.9836 postgres postgres build_join_rel 5515 1.3475 postgres postgres has_relevant_eclass_joinclause 6445 52.8365 postgres postgres bms_overlap 5515 45.2123 postgres postgres has_relevant_eclass_joinclause [self] 238 1.9511 postgres postgres bms_is_subset ------------------------------------------------------------------------------- 4854 1.1860 Xorg Xorg /usr/bin/Xorg 4854 100.000 Xorg Xorg /usr/bin/Xorg [self] ------------------------------------------------------------------------------- 11868 100.000 postgres postgres make_join_rel 3951 0.9653 postgres postgres join_is_legal 7493 63.1043 postgres postgres bms_overlap 3951 33.2744 postgres postgres join_is_legal [self] 430 3.6214 postgres postgres bms_is_subset ------------------------------------------------------------------------------- 1 0.0241 postgres postgres build_join_rel 70 1.6892 postgres postgres find_join_rel 4073 98.2867 postgres postgres hash_search 3915 0.9565 postgres postgres hash_search_with_hash_value 3915 94.4739 postgres postgres hash_search_with_hash_value [self] 184 4.4402 postgres postgres element_alloc 43 1.0376 postgres postgres seg_alloc 2 0.0483 postgres postgres DynaHashAlloc ------------------------------------------------------------------------------- 1 0.0290 postgres postgres get_relation_info 1 0.0290 postgres postgres AcquireRewriteLocks 1 0.0290 postgres postgres bms_intersect 1 0.0290 postgres postgres element_alloc 1 0.0290 postgres postgres _bt_getroot 1 0.0290 postgres postgres list_copy_tail 2 0.0580 postgres postgres replace_rte_variables_mutator 3 0.0870 postgres postgres MemoryContextAllocZero 3 0.0870 postgres postgres load_relcache_init_file 3 0.0870 postgres postgres add_paths_to_joinrel 3 0.0870 postgres postgres create_hashjoin_path 4 0.1159 postgres postgres create_material_path 7 0.2029 postgres postgres MemoryContextCreate 7 0.2029 postgres postgres build_joinrel_tlist 10 0.2899 postgres postgres generate_join_implied_equalities 11 0.3188 postgres postgres MemoryContextStrdup 13 0.3768 postgres postgres build_join_rel 16 0.4638 postgres postgres copyObject 17 0.4928 postgres postgres add_path 26 0.7536 postgres postgres create_mergejoin_path 35 1.0145 postgres postgres lcons 38 1.1014 postgres postgres expression_tree_mutator 45 1.3043 postgres postgres select_outer_pathkeys_for_merge 48 1.3913 postgres postgres hash_create 48 1.3913 postgres postgres list_copy 51 1.4783 postgres postgres bms_copy 64 1.8551 postgres postgres DynaHashAlloc 105 3.0435 postgres postgres create_nestloop_path 272 7.8841 postgres postgres lappend_cell 476 13.7971 postgres postgres lappend 993 28.7826 postgres postgres MemoryContextAllocZeroAligned 1144 33.1594 postgres postgres new_list 3303 0.8070 postgres postgres AllocSetAlloc 3303 95.4900 postgres postgres AllocSetAlloc [self] 148 4.2787 libc-2.10.2.so postgres malloc 7 0.2024 libc-2.10.2.so postgres _int_malloc 1 0.0289 libc-2.10.2.so postgres __i686.get_pc_thunk.bx ------------------------------------------------------------------------------- 2940 0.7183 firefox-bin firefox-bin /usr/local/firefox-3.5.2/firefox-bin 2940 100.000 firefox-bin firefox-bin /usr/local/firefox-3.5.2/firefox-bin [self] ------------------------------------------------------------------------------- 2932 0.7164 libglib-2.0.so.0.2200.3 libglib-2.0.so.0.2200.3 /lib/libglib-2.0.so.0.2200.3 2932 100.000 libglib-2.0.so.0.2200.3 libglib-2.0.so.0.2200.3 /lib/libglib-2.0.so.0.2200.3 [self] ------------------------------------------------------------------------------- 1 1.8519 libc-2.10.2.so libc-2.10.2.so _IO_sgetn 3 5.5556 libc-2.10.2.so libc-2.10.2.so qsort_r 11 20.3704 libc-2.10.2.so libc-2.10.2.so vfprintf 14 25.9259 libc-2.10.2.so libc-2.10.2.so realloc 25 46.2963 libc-2.10.2.so libc-2.10.2.so msort_with_tmp 2820 0.6890 libc-2.10.2.so libc-2.10.2.so memcpy 2820 100.000 libc-2.10.2.so libc-2.10.2.so memcpy [self] ------------------------------------------------------------------------------- 46 1.2342 postgres postgres add_paths_to_joinrel 3681 98.7658 postgres postgres create_nestloop_path 2211 0.5402 postgres postgres cost_nestloop 2211 59.3079 postgres postgres cost_nestloop [self] 1371 36.7758 postgres postgres cost_qual_eval 112 3.0043 postgres postgres adjust_semi_join 34 0.9120 postgres postgres cost_qual_eval_walker ------------------------------------------------------------------------------- 21 0.4195 postgres postgres add_paths_to_joinrel 4985 99.5805 postgres postgres create_mergejoin_path 2101 0.5133 postgres postgres cost_mergejoin 2101 42.0368 postgres postgres cost_mergejoin [self] 865 17.3069 postgres postgres cost_qual_eval 857 17.1469 postgres postgres cost_sort 536 10.7243 postgres postgres approx_tuple_count 513 10.2641 postgres postgres bms_is_subset 29 0.5802 postgres postgres cost_qual_eval_walker 29 0.5802 libm-2.10.2.so postgres rint 18 0.3601 libm-2.10.2.so postgres ceil 17 0.3401 postgres postgres ExecSupportsMarkRestore 15 0.3001 libm-2.10.2.so postgres log 14 0.2801 postgres postgres clause_selectivity 4 0.0800 postgres postgres mergejoinscansel ------------------------------------------------------------------------------- 2019 0.4933 libQtCore.so.4.5.3 libQtCore.so.4.5.3 /usr/lib/libQtCore.so.4.5.3 2019 100.000 libQtCore.so.4.5.3 libQtCore.so.4.5.3 /usr/lib/libQtCore.so.4.5.3 [self] ------------------------------------------------------------------------------- 2 0.0242 postgres postgres build_join_rel 50 0.6057 postgres postgres find_join_rel 8203 99.3701 postgres postgres hash_search 2016 0.4926 postgres postgres bms_hash_value 6240 75.5814 postgres postgres hash_any 2016 24.4186 postgres postgres bms_hash_value [self] ------------------------------------------------------------------------------- 1906 0.4657 libpthread-2.10.2.so libpthread-2.10.2.so pthread_mutex_lock 1906 100.000 libpthread-2.10.2.so libpthread-2.10.2.so pthread_mutex_lock [self] ------------------------------------------------------------------------------- 13 0.6989 postgres postgres create_mergejoin_path 106 5.6989 postgres postgres get_cheapest_path_for_pathkeys 198 10.6452 postgres postgres add_paths_to_joinrel 697 37.4731 postgres postgres pathkeys_contained_in 846 45.4839 postgres postgres add_path 1860 0.4544 postgres postgres compare_pathkeys 1860 100.000 postgres postgres compare_pathkeys [self] ------------------------------------------------------------------------------- 1742 0.4256 libQtGui.so.4.5.3 libQtGui.so.4.5.3 /usr/lib/libQtGui.so.4.5.3 1742 100.000 libQtGui.so.4.5.3 libQtGui.so.4.5.3 /usr/lib/libQtGui.so.4.5.3 [self] ------------------------------------------------------------------------------- 115738 100.000 postgres postgres make_join_rel 1719 0.4200 postgres postgres add_paths_to_joinrel 44326 38.2903 postgres postgres make_inner_pathkeys_for_merge 26614 22.9901 postgres postgres add_path 20311 17.5453 postgres postgres select_outer_pathkeys_for_merge 6472 5.5907 postgres postgres create_mergejoin_path 5468 4.7234 postgres postgres create_nestloop_path 3054 2.6381 postgres postgres truncate_useless_pathkeys 2617 2.2607 postgres postgres get_cheapest_path_for_pathkeys 1719 1.4849 postgres postgres add_paths_to_joinrel [self] 1085 0.9373 postgres postgres best_inner_indexscan 1013 0.8751 postgres postgres find_mergeclauses_for_pathkeys 775 0.6695 postgres postgres create_hashjoin_path 446 0.3853 postgres postgres pfree 436 0.3766 postgres postgres bms_is_subset 204 0.1762 postgres postgres lappend 198 0.1710 postgres postgres compare_pathkeys 184 0.1589 postgres postgres pathkeys_contained_in 148 0.1278 postgres postgres compare_path_costs 137 0.1183 postgres postgres create_material_path 89 0.0769 postgres postgres AllocSetFree 84 0.0726 postgres postgres MemoryContextAllocZeroAligned 46 0.0397 postgres postgres cost_nestloop 44 0.0380 postgres postgres cache_mergeclause_eclasses 33 0.0285 postgres postgres build_join_pathkeys 30 0.0259 postgres postgres pathkeys_useful_for_ordering 26 0.0225 postgres postgres list_copy 26 0.0225 postgres postgres lappend_cell 22 0.0190 postgres postgres list_delete_cell 21 0.0181 postgres postgres cost_mergejoin 18 0.0155 postgres postgres lcons 15 0.0130 postgres postgres pathkeys_useful_for_merging 14 0.0121 postgres postgres make_canonical_pathkey 12 0.0104 postgres postgres list_concat 12 0.0104 postgres postgres bms_overlap 11 0.0095 postgres postgres list_delete_ptr 9 0.0078 postgres postgres new_list 9 0.0078 postgres postgres MemoryContextAlloc 8 0.0069 postgres postgres list_truncate 7 0.0060 postgres postgres ExecMaterializesOutput 6 0.0052 postgres postgres bms_intersect 4 0.0035 postgres postgres bms_is_empty 3 0.0026 postgres postgres AllocSetAlloc 3 0.0026 postgres postgres cost_hashjoin 2 0.0017 postgres postgres bms_equal 2 0.0017 postgres postgres cost_material ------------------------------------------------------------------------------- 1680 0.4105 libgobject-2.0.so.0.2200.3 libgobject-2.0.so.0.2200.3 /usr/lib/libgobject-2.0.so.0.2200.3 1680 100.000 libgobject-2.0.so.0.2200.3 libgobject-2.0.so.0.2200.3 /usr/lib/libgobject-2.0.so.0.2200.3 [self] ------------------------------------------------------------------------------- 1 0.0623 postgres postgres cost_qual_eval_walker 3 0.1869 postgres postgres cost_hashjoin 29 1.8069 postgres postgres cost_mergejoin 34 2.1184 postgres postgres cost_nestloop 1538 95.8255 postgres postgres cost_qual_eval 1603 0.3917 postgres postgres cost_qual_eval_walker 1603 99.8754 postgres postgres cost_qual_eval_walker [self] 1 0.0623 postgres postgres cost_qual_eval_walker 1 0.0623 postgres postgres get_func_cost ------------------------------------------------------------------------------- 5 100.000 libpthread-2.10.2.so libpthread-2.10.2.so pthread_cond_timedwait@@GLIBC_2.3.2 1400 0.3421 libpthread-2.10.2.so libpthread-2.10.2.so __pthread_mutex_unlock_usercnt 1400 100.000 libpthread-2.10.2.so libpthread-2.10.2.so __pthread_mutex_unlock_usercnt [self] ------------------------------------------------------------------------------- 3 0.2230 postgres postgres best_inner_indexscan 148 11.0037 postgres postgres add_paths_to_joinrel 156 11.5985 postgres postgres add_path 249 18.5130 postgres postgres set_cheapest 789 58.6617 postgres postgres get_cheapest_path_for_pathkeys 1383 0.3379 postgres postgres compare_path_costs 1383 100.000 postgres postgres compare_path_costs [self] ------------------------------------------------------------------------------- 1 0.0767 postgres postgres eqjoinsel 1 0.0767 postgres postgres hash_create 1 0.0767 postgres postgres list_concat_unique_ptr 1 0.0767 postgres postgres bms_difference 1 0.0767 postgres postgres make_inner_pathkeys_for_merge 1 0.0767 postgres postgres _copyRangeTblEntry 2 0.1534 postgres postgres element_alloc 3 0.2301 postgres postgres replace_rte_variables_mutator 4 0.3067 postgres postgres MemoryContextCreate 5 0.3834 postgres postgres MemoryContextStrdup 5 0.3834 postgres postgres list_difference_ptr 8 0.6135 postgres postgres build_join_rel 9 0.6902 postgres postgres add_paths_to_joinrel 10 0.7669 postgres postgres build_joinrel_tlist 11 0.8436 postgres postgres copyObject 14 1.0736 postgres postgres generate_join_implied_equalities 14 1.0736 postgres postgres expression_tree_mutator 15 1.1503 postgres postgres list_copy 19 1.4571 postgres postgres select_outer_pathkeys_for_merge 20 1.5337 postgres postgres DynaHashAlloc 21 1.6104 postgres postgres lcons 22 1.6871 postgres postgres add_path 26 1.9939 postgres postgres bms_copy 192 14.7239 postgres postgres lappend_cell 385 29.5245 postgres postgres lappend 513 39.3405 postgres postgres new_list 1310 0.3201 postgres postgres MemoryContextAlloc 1310 100.000 postgres postgres MemoryContextAlloc [self] ------------------------------------------------------------------------------- 5 0.3873 postgres postgres build_join_rel 103 7.9783 postgres postgres find_join_rel 1183 91.6344 postgres postgres hash_search 1291 0.3154 postgres postgres bitmap_hash 1291 100.000 postgres postgres bitmap_hash [self] ------------------------------------------------------------------------------- 6 42.8571 postgres postgres make_join_rel 8 57.1429 postgres postgres add_paths_to_joinrel 1290 0.3152 postgres postgres list_truncate 1290 100.000 postgres postgres list_truncate [self] ------------------------------------------------------------------------------- 1218 0.2976 libnspr4.so libnspr4.so /usr/local/firefox-3.5.2/libnspr4.so 1218 100.000 libnspr4.so libnspr4.so /usr/local/firefox-3.5.2/libnspr4.so [self] ------------------------------------------------------------------------------- 1186 0.2898 intel_drv.so intel_drv.so /usr/lib/xorg/modules/drivers/intel_drv.so 1186 100.000 intel_drv.so intel_drv.so /usr/lib/xorg/modules/drivers/intel_drv.so [self] ------------------------------------------------------------------------------- 1 0.0469 postgres postgres makeString 1 0.0469 postgres postgres best_inner_indexscan 1 0.0469 postgres postgres make_join_rel 1 0.0469 postgres postgres _copyResTarget 2 0.0938 postgres postgres create_index_path 2 0.0938 postgres postgres get_relation_info 2 0.0938 postgres postgres build_simple_rel 2 0.0938 postgres postgres makeVar 5 0.2345 postgres postgres _copyRangeTblEntry 40 1.8762 postgres postgres copyObject 66 3.0957 postgres postgres create_material_path 75 3.5178 postgres postgres create_hashjoin_path 84 3.9400 postgres postgres add_paths_to_joinrel 89 4.1745 postgres postgres build_join_rel 554 25.9850 postgres postgres create_mergejoin_path 1207 56.6135 postgres postgres create_nestloop_path 1134 0.2771 postgres postgres MemoryContextAllocZeroAligned 1134 53.1396 postgres postgres MemoryContextAllocZeroAligned [self] 993 46.5323 postgres postgres AllocSetAlloc 7 0.3280 libc-2.10.2.so postgres malloc ------------------------------------------------------------------------------- 1119 0.2734 libflashplayer.so libflashplayer.so /home/wulczer/.mozilla/plugins/libflashplayer.so 1119 100.000 libflashplayer.so libflashplayer.so /home/wulczer/.mozilla/plugins/libflashplayer.so [self] ------------------------------------------------------------------------------- 1026 0.2507 libX11.so.6.3.0 libX11.so.6.3.0 /usr/lib/libX11.so.6.3.0 1026 100.000 libX11.so.6.3.0 libX11.so.6.3.0 /usr/lib/libX11.so.6.3.0 [self] ------------------------------------------------------------------------------- 11 0.4186 postgres postgres make_join_rel 2617 99.5814 postgres postgres add_paths_to_joinrel 917 0.2240 postgres postgres get_cheapest_path_for_pathkeys 917 34.8935 postgres postgres get_cheapest_path_for_pathkeys [self] 816 31.0502 postgres postgres pathkeys_contained_in 789 30.0228 postgres postgres compare_path_costs 106 4.0335 postgres postgres compare_pathkeys ------------------------------------------------------------------------------- 5 0.2052 postgres postgres create_hashjoin_path 32 1.3131 postgres postgres create_mergejoin_path 44 1.8055 postgres postgres create_nestloop_path 120 4.9241 postgres postgres cost_hashjoin 865 35.4945 postgres postgres cost_mergejoin 1371 56.2577 postgres postgres cost_nestloop 899 0.2197 postgres postgres cost_qual_eval 1538 63.1104 postgres postgres cost_qual_eval_walker 899 36.8896 postgres postgres cost_qual_eval [self] ------------------------------------------------------------------------------- 1 0.1307 postgres postgres MemoryContextDeleteChildren 2 0.2614 postgres postgres best_inner_indexscan 3 0.3922 postgres postgres make_join_rel 9 1.1765 postgres postgres list_free_private 13 1.6993 postgres postgres select_outer_pathkeys_for_merge 32 4.1830 postgres postgres list_delete_cell 33 4.3137 postgres postgres add_path 89 11.6340 postgres postgres add_paths_to_joinrel 583 76.2092 postgres postgres pfree 765 0.1869 postgres postgres AllocSetFree 765 100.000 postgres postgres AllocSetFree [self] ------------------------------------------------------------------------------- 1 0.0293 postgres postgres find_list_position 1 0.0293 postgres postgres expandTupleDesc 1 0.0293 postgres postgres distribute_qual_to_rels 1 0.0293 postgres postgres choose_bitmap_and 2 0.0586 postgres postgres get_actual_clauses 2 0.0586 postgres postgres replace_rte_variables_mutator 2 0.0586 postgres postgres best_inner_indexscan 2 0.0586 postgres postgres find_usable_indexes 3 0.0880 postgres postgres expandRTE 3 0.0880 postgres postgres group_clauses_by_indexkey 4 0.1173 postgres postgres reduce_outer_joins_pass1 6 0.1759 postgres postgres set_joinrel_size_estimates 11 0.3225 postgres postgres AcquireRewriteLocks 13 0.3811 postgres postgres make_join_rel 43 1.2606 postgres postgres build_joinrel_restrictlist 55 1.6124 postgres postgres list_difference_ptr 62 1.8176 postgres postgres list_concat_unique_ptr 86 2.5213 postgres postgres expression_tree_mutator 132 3.8698 postgres postgres select_outer_pathkeys_for_merge 204 5.9807 postgres postgres add_paths_to_joinrel 261 7.6517 postgres postgres build_joinrel_tlist 332 9.7332 postgres postgres build_join_rel 476 13.9549 postgres postgres find_mergeclauses_for_pathkeys 479 14.0428 postgres postgres make_inner_pathkeys_for_merge 1229 36.0305 postgres postgres generate_join_implied_equalities 740 0.1808 postgres postgres lappend 1837 53.4322 postgres postgres new_list 740 21.5241 postgres postgres lappend [self] 476 13.8453 postgres postgres AllocSetAlloc 385 11.1984 postgres postgres MemoryContextAlloc ------------------------------------------------------------------------------- 4 0.0248 postgres postgres make_join_rel 16093 99.9752 postgres postgres build_join_rel 677 0.1654 postgres postgres find_join_rel 14985 93.0688 postgres postgres hash_search 677 4.2047 postgres postgres find_join_rel [self] 200 1.2422 postgres postgres hash_create 103 0.6397 postgres postgres bitmap_hash 70 0.4348 postgres postgres hash_search_with_hash_value 50 0.3105 postgres postgres bms_hash_value 11 0.0683 postgres postgres bms_equal 3 0.0186 libc-2.10.2.so postgres strlen 1 0.0062 postgres postgres seg_alloc 1 0.0062 postgres postgres AllocSetContextCreate ------------------------------------------------------------------------------- 15 0.5248 postgres postgres add_paths_to_joinrel 2843 99.4752 postgres postgres truncate_useless_pathkeys 657 0.1605 postgres postgres pathkeys_useful_for_merging 2069 72.3933 postgres postgres eclass_useful_for_merging 657 22.9881 postgres postgres pathkeys_useful_for_merging [self] 86 3.0091 postgres postgres cache_mergeclause_eclasses 33 1.1547 postgres postgres bms_overlap 13 0.4549 postgres postgres bms_is_subset ------------------------------------------------------------------------------- 6 0.4304 postgres postgres make_join_rel 1388 99.5696 postgres postgres build_join_rel 621 0.1517 postgres postgres build_joinrel_tlist 621 44.5481 postgres postgres build_joinrel_tlist [self] 416 29.8422 postgres postgres bms_nonempty_difference 261 18.7231 postgres postgres lappend 78 5.5954 postgres postgres find_base_rel 10 0.7174 postgres postgres MemoryContextAlloc 7 0.5022 postgres postgres AllocSetAlloc 1 0.0717 postgres postgres new_list ------------------------------------------------------------------------------- 1 0.0065 postgres postgres genericcostestimate 1 0.0065 postgres postgres relation_open 1 0.0065 postgres postgres pgstat_get_db_entry 1 0.0065 postgres postgres LockRelease 1 0.0065 postgres postgres RelationIdGetRelation 2 0.0130 postgres postgres make_join_rel 2 0.0130 postgres postgres load_relcache_init_file 3 0.0195 postgres postgres pgstat_collect_oids 5 0.0324 postgres postgres find_oper_cache_entry 6 0.0389 postgres postgres LockAcquireExtended 12 0.0779 postgres postgres get_tablespace_page_costs 393 2.5498 postgres postgres build_join_rel 14985 97.2231 postgres postgres find_join_rel 576 0.1407 postgres postgres hash_search 8203 53.4015 postgres postgres bms_hash_value 4073 26.5152 postgres postgres hash_search_with_hash_value 1199 7.8055 libc-2.10.2.so postgres memcpy 1183 7.7013 postgres postgres bitmap_hash 576 3.7498 postgres postgres hash_search [self] 114 0.7421 postgres postgres hash_any 5 0.0325 postgres postgres element_alloc 4 0.0260 libc-2.10.2.so postgres memcmp 3 0.0195 postgres postgres hash_uint32 1 0.0065 postgres postgres oid_hash ------------------------------------------------------------------------------- 1 0.1855 libc-2.10.2.so libc-2.10.2.so fdopen@@GLIBC_2.1 15 2.7829 libc-2.10.2.so libc-2.10.2.so calloc 31 5.7514 libc-2.10.2.so libc-2.10.2.so _int_realloc 492 91.2801 libc-2.10.2.so libc-2.10.2.so malloc 516 0.1261 libc-2.10.2.so libc-2.10.2.so _int_malloc 516 93.4783 libc-2.10.2.so libc-2.10.2.so _int_malloc [self] 35 6.3406 libc-2.10.2.so libc-2.10.2.so malloc_consolidate 1 0.1812 libc-2.10.2.so libc-2.10.2.so sbrk ------------------------------------------------------------------------------- 505 0.1234 libdbus-1.so.3.4.0 libdbus-1.so.3.4.0 /lib/libdbus-1.so.3.4.0 505 100.000 libdbus-1.so.3.4.0 libdbus-1.so.3.4.0 /lib/libdbus-1.so.3.4.0 [self] ------------------------------------------------------------------------------- 18 0.8625 postgres postgres truncate_useless_pathkeys 2069 99.1375 postgres postgres pathkeys_useful_for_merging 492 0.1202 postgres postgres eclass_useful_for_merging 1049 50.2635 postgres postgres bms_overlap 546 26.1620 postgres postgres bms_is_subset 492 23.5745 postgres postgres eclass_useful_for_merging [self] ------------------------------------------------------------------------------- 488 0.1192 libxcb.so.1.1.0 libxcb.so.1.1.0 /usr/lib/libxcb.so.1.1.0 488 100.000 libxcb.so.1.1.0 libxcb.so.1.1.0 /usr/lib/libxcb.so.1.1.0 [self] ------------------------------------------------------------------------------- 486 0.1187 libpixman-1.so.0.16.2 libpixman-1.so.0.16.2 /usr/lib/libpixman-1.so.0.16.2 486 100.000 libpixman-1.so.0.16.2 libpixman-1.so.0.16.2 /usr/lib/libpixman-1.so.0.16.2 [self] ------------------------------------------------------------------------------- 463 0.1131 bash bash /bin/bash 463 100.000 bash bash /bin/bash [self] ------------------------------------------------------------------------------- 7 0.6189 postgres postgres make_join_rel 124 10.9637 postgres postgres create_mergejoin_path 184 16.2688 postgres postgres add_paths_to_joinrel 816 72.1485 postgres postgres get_cheapest_path_for_pathkeys 434 0.1060 postgres postgres pathkeys_contained_in 697 61.6269 postgres postgres compare_pathkeys 434 38.3731 postgres postgres pathkeys_contained_in [self] ------------------------------------------------------------------------------- 15 3.4803 postgres postgres build_join_rel 416 96.5197 postgres postgres build_joinrel_tlist 431 0.1053 postgres postgres bms_nonempty_difference 431 100.000 postgres postgres bms_nonempty_difference [self] ------------------------------------------------------------------------------- 46 0.8342 postgres postgres make_join_rel 5468 99.1658 postgres postgres add_paths_to_joinrel 424 0.1036 postgres postgres create_nestloop_path 3681 66.7573 postgres postgres cost_nestloop 1207 21.8897 postgres postgres MemoryContextAllocZeroAligned 424 7.6895 postgres postgres create_nestloop_path [self] 105 1.9042 postgres postgres AllocSetAlloc 44 0.7980 postgres postgres cost_qual_eval 43 0.7798 postgres postgres adjust_semi_join 10 0.1814 libm-2.10.2.so postgres ceil ------------------------------------------------------------------------------- 1 0.1610 postgres postgres create_hashjoin_path 17 2.7375 postgres postgres create_mergejoin_path 67 10.7890 postgres postgres cost_hashjoin 536 86.3124 postgres postgres cost_mergejoin 423 0.1034 postgres postgres approx_tuple_count 423 68.1159 postgres postgres approx_tuple_count [self] 198 31.8841 postgres postgres clause_selectivity ------------------------------------------------------------------------------- 13 1.2671 postgres postgres make_join_rel 1013 98.7329 postgres postgres add_paths_to_joinrel 423 0.1034 postgres postgres find_mergeclauses_for_pathkeys 476 46.3938 postgres postgres lappend 423 41.2281 postgres postgres find_mergeclauses_for_pathkeys [self] 94 9.1618 postgres postgres cache_mergeclause_eclasses 24 2.3392 postgres postgres list_concat 9 0.8772 postgres postgres new_list ------------------------------------------------------------------------------- 422 0.1031 thunderbird-bin thunderbird-bin /usr/local/thunderbird-2.0.0.23/thunderbird-bin 422 100.000 thunderbird-bin thunderbird-bin /usr/local/thunderbird-2.0.0.23/thunderbird-bin [self] ------------------------------------------------------------------------------- 20 2.2805 postgres postgres create_mergejoin_path 857 97.7195 postgres postgres cost_mergejoin 381 0.0931 postgres postgres cost_sort 381 43.4436 postgres postgres cost_sort [self] 361 41.1631 libm-2.10.2.so postgres __ieee754_log 90 10.2623 libm-2.10.2.so postgres log 15 1.7104 libm-2.10.2.so postgres __i686.get_pc_thunk.bx 15 1.7104 libm-2.10.2.so postgres isnan 14 1.5964 libm-2.10.2.so postgres __i686.get_pc_thunk.dx 1 0.1140 postgres postgres tuplesort_merge_order ------------------------------------------------------------------------------- 379 0.0926 emacs23-x emacs23-x /usr/bin/emacs23-x 379 100.000 emacs23-x emacs23-x /usr/bin/emacs23-x [self] ------------------------------------------------------------------------------- 13 0.2005 postgres postgres make_join_rel 6472 99.7995 postgres postgres add_paths_to_joinrel 363 0.0887 postgres postgres create_mergejoin_path 4985 77.4189 postgres postgres cost_mergejoin 554 8.6038 postgres postgres MemoryContextAllocZeroAligned 363 5.6375 postgres postgres create_mergejoin_path [self] 288 4.4727 libm-2.10.2.so postgres rint 124 1.9258 postgres postgres pathkeys_contained_in 32 0.4970 postgres postgres cost_qual_eval 26 0.4038 postgres postgres AllocSetAlloc 20 0.3106 postgres postgres cost_sort 17 0.2640 postgres postgres approx_tuple_count 13 0.2019 postgres postgres compare_pathkeys 10 0.1553 postgres postgres bms_is_subset 7 0.1087 postgres postgres ExecSupportsMarkRestore ------------------------------------------------------------------------------- 361 0.0882 libm-2.10.2.so libm-2.10.2.so __ieee754_log 361 100.000 libm-2.10.2.so libm-2.10.2.so __ieee754_log [self] ------------------------------------------------------------------------------- 1 0.0495 postgres postgres list_difference_ptr 1 0.0495 postgres postgres set_joinrel_size_estimates 1 0.0495 postgres postgres add_path 1 0.0495 postgres postgres build_joinrel_tlist 1 0.0495 postgres postgres build_joinrel_restrictlist 2 0.0990 postgres postgres build_join_rel 5 0.2475 postgres postgres select_outer_pathkeys_for_merge 9 0.4455 postgres postgres add_paths_to_joinrel 9 0.4455 postgres postgres find_mergeclauses_for_pathkeys 16 0.7921 postgres postgres make_inner_pathkeys_for_merge 25 1.2376 postgres postgres list_copy 26 1.2871 postgres postgres generate_join_implied_equalities 86 4.2574 postgres postgres lcons 1837 90.9406 postgres postgres lappend 360 0.0880 postgres postgres new_list 1144 56.6056 postgres postgres AllocSetAlloc 513 25.3835 postgres postgres MemoryContextAlloc 360 17.8130 postgres postgres new_list [self] 4 0.1979 libc-2.10.2.so postgres malloc ------------------------------------------------------------------------------- 356 0.0870 libm-2.10.2.so libm-2.10.2.so rint 356 100.000 libm-2.10.2.so libm-2.10.2.so rint [self] ------------------------------------------------------------------------------- 1 0.1553 postgres postgres InitPostgres 1 0.1553 postgres postgres generate_join_implied_equalities 1 0.1553 postgres postgres get_func_cost 1 0.1553 postgres postgres op_mergejoinable 1 0.1553 postgres postgres oper 1 0.1553 postgres postgres RelationInitIndexAccessInfo 1 0.1553 postgres postgres get_oprjoin 2 0.3106 postgres postgres get_namespace_name 3 0.4658 postgres postgres get_atttypetypmod 3 0.4658 postgres postgres func_volatile 3 0.4658 postgres postgres get_attname 3 0.4658 postgres postgres get_rel_name 4 0.6211 postgres postgres select_equality_operator 5 0.7764 postgres postgres get_op_opfamily_strategy 6 0.9317 postgres postgres get_oprrest 6 0.9317 postgres postgres SearchSysCacheExists 7 1.0870 postgres postgres btcostestimate 9 1.3975 postgres postgres get_rte_attribute_is_dropped 11 1.7081 postgres postgres examine_variable 13 2.0186 postgres postgres get_attavgwidth 14 2.1739 postgres postgres get_typlen 161 25.0000 postgres postgres op_hashjoinable 387 60.0932 postgres postgres get_opfamily_member 334 0.0816 postgres postgres SearchCatCache 334 51.8634 postgres postgres SearchCatCache [self] 140 21.7391 postgres postgres CatalogCacheComputeHashValue 41 6.3665 postgres postgres oideq 31 4.8137 postgres postgres FunctionCall2 22 3.4161 postgres postgres heap_getsysattr 20 3.1056 postgres postgres ResourceOwnerRememberCatCacheRef 20 3.1056 postgres postgres ResourceOwnerEnlargeCatCacheRefs 17 2.6398 postgres postgres int2eq 10 1.5528 postgres postgres DirectFunctionCall1 4 0.6211 postgres postgres DLMoveToFront 3 0.4658 postgres postgres nocachegetattr 1 0.1553 postgres postgres systable_endscan 1 0.1553 postgres postgres systable_beginscan ------------------------------------------------------------------------------- 1 0.1095 postgres postgres list_delete_ptr 1 0.1095 postgres postgres btendscan 2 0.2191 postgres postgres set_joinrel_size_estimates 9 0.9858 postgres postgres MemoryContextDeleteChildren 17 1.8620 postgres postgres best_inner_indexscan 21 2.3001 postgres postgres list_free_private 45 4.9288 postgres postgres select_outer_pathkeys_for_merge 69 7.5575 postgres postgres make_join_rel 126 13.8007 postgres postgres list_delete_cell 176 19.2771 postgres postgres add_path 446 48.8499 postgres postgres add_paths_to_joinrel 330 0.0806 postgres postgres pfree 583 63.7856 postgres postgres AllocSetFree 330 36.1050 postgres postgres pfree [self] 1 0.1094 libc-2.10.2.so postgres free ------------------------------------------------------------------------------- 329 0.0804 libdrm_intel.so.1.0.0 libdrm_intel.so.1.0.0 /usr/lib/libdrm_intel.so.1.0.0 329 100.000 libdrm_intel.so.1.0.0 libdrm_intel.so.1.0.0 /usr/lib/libdrm_intel.so.1.0.0 [self] ------------------------------------------------------------------------------- 13 0.0640 postgres postgres make_join_rel 20311 99.9360 postgres postgres add_paths_to_joinrel 312 0.0762 postgres postgres select_outer_pathkeys_for_merge 19347 95.1835 postgres postgres make_canonical_pathkey 400 1.9679 postgres postgres bms_overlap 312 1.5350 postgres postgres select_outer_pathkeys_for_merge [self] 132 0.6494 postgres postgres lappend 45 0.2214 postgres postgres AllocSetAlloc 45 0.2214 postgres postgres pfree 19 0.0935 postgres postgres MemoryContextAlloc 13 0.0640 postgres postgres AllocSetFree 8 0.0394 postgres postgres cache_mergeclause_eclasses 5 0.0246 postgres postgres new_list ------------------------------------------------------------------------------- 12 0.0271 postgres postgres make_join_rel 44326 99.9729 postgres postgres add_paths_to_joinrel 305 0.0745 postgres postgres make_inner_pathkeys_for_merge 43507 98.1169 postgres postgres make_canonical_pathkey 479 1.0802 postgres postgres lappend 305 0.6878 postgres postgres make_inner_pathkeys_for_merge [self] 34 0.0767 postgres postgres cache_mergeclause_eclasses 16 0.0361 postgres postgres new_list 1 0.0023 postgres postgres MemoryContextAlloc