Advertisement
Guest User

profile solution 4

a guest
Sep 24th, 2012
499
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.58 KB | None | 0 0
  1. Solution 4
  2.  
  3.  
  4. 2812638 function calls (2465952 primitive calls) in 3.807 seconds
  5.  
  6. Ordered by: standard name
  7.  
  8. ncalls tottime percall cumtime percall filename:lineno(function)
  9. 1 0.005 0.005 3.807 3.807 <string>:1(<module>)
  10. 37566 0.024 0.000 0.049 0.000 <string>:8(__new__)
  11. 4 0.000 0.000 0.000 0.000 __init__.py:102(_param_escape)
  12. 2087 0.002 0.000 0.008 0.000 __init__.py:1118(debug)
  13. 3 0.000 0.000 0.000 0.000 __init__.py:1118(get_internal_type)
  14. 1 0.000 0.000 0.003 0.003 __init__.py:119(connect)
  15. 2087 0.003 0.000 0.004 0.000 __init__.py:123(validate_thread_sharing)
  16. 2087 0.004 0.000 0.004 0.000 __init__.py:1318(getEffectiveLevel)
  17. 2087 0.002 0.000 0.006 0.000 __init__.py:1332(isEnabledFor)
  18. 6264 0.014 0.000 0.022 0.000 __init__.py:172(is_managed)
  19. 1 0.000 0.000 0.065 0.065 __init__.py:185(dumps)
  20. 2089 0.008 0.000 0.017 0.000 __init__.py:204(db_type)
  21. 2089 0.001 0.000 0.001 0.000 __init__.py:276(get_db_prep_value)
  22. 2466 0.006 0.000 0.012 0.000 __init__.py:294(get_prep_lookup)
  23. 2087 0.011 0.000 0.042 0.000 __init__.py:302(cursor)
  24. 2087 0.003 0.000 0.004 0.000 __init__.py:311(make_debug_cursor)
  25. 2089 0.006 0.000 0.013 0.000 __init__.py:322(get_db_prep_lookup)
  26. 4926 0.003 0.000 0.005 0.000 __init__.py:489(value_from_object)
  27. 2086 0.000 0.000 0.000 0.000 __init__.py:519(get_internal_type)
  28. 2462 0.002 0.000 0.002 0.000 __init__.py:534(get_prep_value)
  29. 2087 0.002 0.000 0.002 0.000 __init__.py:659(compiler)
  30. 3 0.000 0.000 0.000 0.000 __init__.py:963(get_prep_value)
  31. 3 0.000 0.000 0.000 0.000 __init__.py:968(get_prep_lookup)
  32. 1 0.000 0.000 0.000 0.000 base.py:151(_get_pg_version)
  33. 2087 0.010 0.000 0.020 0.000 base.py:157(_cursor)
  34. 2463 0.002 0.000 0.002 0.000 base.py:267(__init__)
  35. 2463 0.053 0.000 0.117 0.000 base.py:278(__init__)
  36. 4926 0.002 0.000 0.002 0.000 base.py:36(utc_tzinfo_factory)
  37. 377 0.001 0.000 0.005 0.000 base.py:378(__str__)
  38. 753 0.001 0.000 0.001 0.000 base.py:425(_get_pk_val)
  39. 2087 0.001 0.000 0.001 0.000 base.py:47(__init__)
  40. 2087 0.003 0.000 0.683 0.000 base.py:50(execute)
  41. 6264 0.007 0.000 0.009 0.000 base.py:66(__getattr__)
  42. 2087 0.002 0.000 0.002 0.000 compiler.py:15(__init__)
  43. 2087 0.023 0.000 0.232 0.000 compiler.py:168(get_columns)
  44. 2087 0.004 0.000 0.015 0.000 compiler.py:21(pre_sql_setup)
  45. 2087 0.102 0.000 0.191 0.000 compiler.py:248(get_default_columns)
  46. 2087 0.002 0.000 0.002 0.000 compiler.py:313(get_distinct)
  47. 2087 0.006 0.000 0.006 0.000 compiler.py:333(get_ordering)
  48. 43833 0.027 0.000 0.038 0.000 compiler.py:37(quote_name_unless_alias)
  49. 2 0.000 0.000 0.000 0.000 compiler.py:418(find_ordering_name)
  50. 2 0.000 0.000 0.000 0.000 compiler.py:448(_setup_joins)
  51. 2 0.000 0.000 0.000 0.000 compiler.py:476(_final_join_removal)
  52. 2087 0.009 0.000 0.011 0.000 compiler.py:495(get_from_clause)
  53. 2087 0.041 0.000 0.503 0.000 compiler.py:53(as_sql)
  54. 2087 0.002 0.000 0.002 0.000 compiler.py:539(get_grouping)
  55. 2087 0.003 0.000 0.004 0.000 compiler.py:741(deferred_to_columns)
  56. 4550 0.020 0.000 1.428 0.000 compiler.py:751(results_iter)
  57. 2087 0.020 0.000 1.315 0.001 compiler.py:794(execute_sql)
  58. 4177 0.012 0.000 0.088 0.000 compiler.py:832(<lambda>)
  59. 123871/28060 0.375 0.000 1.133 0.000 copy.py:145(deepcopy)
  60. 29977 0.005 0.000 0.005 0.000 copy.py:198(_deepcopy_atomic)
  61. 39253/35075 0.038 0.000 0.335 0.000 copy.py:226(_deepcopy_list)
  62. 18208/9104 0.109 0.000 0.579 0.000 copy.py:234(_deepcopy_tuple)
  63. 2089 0.012 0.000 0.071 0.000 copy.py:253(_deepcopy_dict)
  64. 121765 0.159 0.000 0.198 0.000 copy.py:267(_keep_alive)
  65. 9104 0.046 0.000 0.331 0.000 copy.py:306(_reconstruct)
  66. 2089 0.001 0.000 0.002 0.000 copy_reg.py:92(__newobj__)
  67. 32611 0.056 0.000 0.072 0.000 datastructures.py:103(__new__)
  68. 32611 0.104 0.000 0.136 0.000 datastructures.py:108(__init__)
  69. 7015 0.021 0.000 0.077 0.000 datastructures.py:127(__deepcopy__)
  70. 4557 0.010 0.000 0.011 0.000 datastructures.py:131(__setitem__)
  71. 8727 0.010 0.000 0.033 0.000 datastructures.py:157(items)
  72. 9102 0.004 0.000 0.004 0.000 datastructures.py:160(iteritems)
  73. 33944 0.014 0.000 0.014 0.000 datastructures.py:164(keys)
  74. 8727 0.008 0.000 0.017 0.000 datastructures.py:170(values)
  75. 2087 0.001 0.000 0.001 0.000 datastructures.py:173(itervalues)
  76. 18204 0.038 0.000 0.156 0.000 datastructures.py:200(copy)
  77. 2089 0.009 0.000 0.009 0.000 datastructures.py:489(__init__)
  78. 3 0.000 0.000 0.000 0.000 datastructures.py:494(__getitem__)
  79. 4927 0.009 0.000 0.042 0.000 dispatcher.py:149(send)
  80. 4926 0.010 0.000 0.019 0.000 dispatcher.py:214(_live_receivers)
  81. 9852 0.009 0.000 0.023 0.000 dispatcher.py:8(_make_id)
  82. 1 0.000 0.000 0.000 0.000 encoder.py:102(__init__)
  83. 1 0.002 0.002 0.065 0.065 encoder.py:180(encode)
  84. 1 0.000 0.000 0.000 0.000 encoder.py:206(iterencode)
  85. 1 0.000 0.000 0.000 0.000 encoder.py:266(_make_iterencode)
  86. 121306/11795 0.035 0.000 0.059 0.000 encoder.py:282(_iterencode_list)
  87. 65123/11792 0.020 0.000 0.056 0.000 encoder.py:335(_iterencode_dict)
  88. 11795 0.003 0.000 0.062 0.000 encoder.py:411(_iterencode)
  89. 377 0.001 0.000 0.003 0.000 encoding.py:54(force_unicode)
  90. 10439 0.009 0.000 0.012 0.000 functional.py:182(inner)
  91. 1 0.000 0.000 0.000 0.000 importlib.py:18(import_module)
  92. 379 0.001 0.000 0.014 0.000 manager.py:106(get_query_set)
  93. 1 0.000 0.000 0.007 0.007 manager.py:130(get)
  94. 377 0.002 0.000 0.195 0.001 manager.py:142(filter)
  95. 2086 0.002 0.000 0.002 0.000 manager.py:217(__get__)
  96. 1 0.000 0.000 0.001 0.001 managers.py:101(_mptt_filter)
  97. 379 0.003 0.000 0.087 0.000 managers.py:175(get_query_set)
  98. 381 0.000 0.000 0.000 0.000 managers.py:75(left_attr)
  99. 380 0.000 0.000 0.000 0.000 managers.py:83(tree_id_attr)
  100. 1 0.000 0.000 0.000 0.000 managers.py:91(_translate_lookups)
  101. 2463 0.009 0.000 0.176 0.000 models.py:328(__init__)
  102. 4 0.000 0.000 0.000 0.000 models.py:332(_mpttfield)
  103. 377 0.002 0.000 0.197 0.001 models.py:377(get_children)
  104. 1 0.000 0.000 0.001 0.001 models.py:400(get_descendants)
  105. 1 0.000 0.000 0.000 0.000 models.py:428(get_descendant_count)
  106. 377 0.000 0.000 0.000 0.000 models.py:525(get_level)
  107. 1 0.000 0.000 0.000 0.000 models.py:545(is_leaf_node)
  108. 2463/378 0.024 0.000 3.493 0.009 models.py:55(__init__)
  109. 4926 0.011 0.000 0.039 0.000 models.py:63(get_raw_field_value)
  110. 377 0.001 0.000 0.002 0.000 models.py:69(__unicode__)
  111. 4170/754 0.007 0.000 0.010 0.000 models.py:75(get_wbs_code)
  112. 2463 0.012 0.000 0.050 0.000 models.py:82(update_mptt_cached_fields)
  113. 1 0.001 0.001 3.506 3.506 mptt_tags.py:224(cache_tree_children)
  114. 2087 0.001 0.000 0.001 0.000 operations.py:171(max_name_length)
  115. 2087 0.008 0.000 0.012 0.000 operations.py:191(last_executed_query)
  116. 2089 0.001 0.000 0.001 0.000 operations.py:40(lookup_cast)
  117. 2089 0.001 0.000 0.001 0.000 operations.py:54(field_cast_sql)
  118. 41743 0.033 0.000 0.051 0.000 operations.py:69(quote_name)
  119. 1 0.000 0.000 0.000 0.000 operations.py:74(set_time_zone_sql)
  120. 18579 0.010 0.000 0.010 0.000 options.py:216(_fields)
  121. 4174 0.002 0.000 0.002 0.000 options.py:231(get_fields_with_model)
  122. 9479 0.009 0.000 0.013 0.000 options.py:255(_many_to_many)
  123. 9479 0.029 0.000 0.048 0.000 options.py:285(get_field)
  124. 4553 0.003 0.000 0.003 0.000 options.py:295(get_field_by_name)
  125. 2464 0.038 0.000 0.081 0.000 query.py:101(__init__)
  126. 2466 0.050 0.000 0.196 0.000 query.py:1030(add_filter)
  127. 380 0.000 0.000 3.503 0.009 query.py:108(_result_iter)
  128. 1 0.000 0.000 0.912 0.912 query.py:120(__nonzero__)
  129. 2464 0.021 0.000 0.248 0.000 query.py:1219(add_q)
  130. 2468 0.020 0.000 0.028 0.000 query.py:1270(setup_joins)
  131. 2466 0.004 0.000 0.007 0.000 query.py:1481(trim_joins)
  132. 7016 0.004 0.000 0.004 0.000 query.py:1614(can_filter)
  133. 2466 0.003 0.000 0.004 0.000 query.py:1672(add_ordering)
  134. 2466 0.001 0.000 0.001 0.000 query.py:1692(clear_ordering)
  135. 2087 0.003 0.000 0.004 0.000 query.py:1847(get_loaded_field_names)
  136. 8350 0.004 0.000 0.004 0.000 query.py:1886(_aggregate_select)
  137. 12525 0.006 0.000 0.006 0.000 query.py:1904(_extra_select)
  138. 6 0.000 0.000 0.000 0.000 query.py:1955(get_order_dir)
  139. 2087 0.010 0.000 0.026 0.000 query.py:215(get_compiler)
  140. 2466 0.001 0.000 0.001 0.000 query.py:227(get_meta)
  141. 4550/380 0.038 0.000 3.509 0.009 query.py:231(iterator)
  142. 7015 0.150 0.000 1.439 0.000 query.py:235(clone)
  143. 9479 0.021 0.000 0.103 0.000 query.py:32(__init__)
  144. 2086/378 0.018 0.000 3.379 0.009 query.py:353(get)
  145. 4174 0.002 0.000 0.002 0.000 query.py:559(deferred_to_data)
  146. 2464 0.004 0.000 0.673 0.000 query.py:616(filter)
  147. 2464 0.012 0.000 0.670 0.000 query.py:630(_filter_or_exclude)
  148. 2464 0.009 0.000 0.017 0.000 query.py:649(table_alias)
  149. 6 0.000 0.000 0.000 0.000 query.py:675(ref_alias)
  150. 2087 0.004 0.000 0.009 0.000 query.py:679(unref_alias)
  151. 2 0.000 0.000 0.000 0.000 query.py:683(promote_alias)
  152. 2 0.000 0.000 0.000 0.000 query.py:700(promote_alias_chain)
  153. 2087 0.009 0.000 0.047 0.000 query.py:710(reset_refcounts)
  154. 2466 0.009 0.000 0.742 0.000 query.py:748(order_by)
  155. 2086/378 0.016 0.000 3.154 0.008 query.py:77(__len__)
  156. 2085 0.002 0.000 0.370 0.000 query.py:817(using)
  157. 2468 0.004 0.000 0.031 0.000 query.py:831(get_initial_alias)
  158. 4174 0.002 0.000 0.002 0.000 query.py:842(db)
  159. 2464 0.009 0.000 0.027 0.000 query.py:851(join)
  160. 7015 0.034 0.000 1.488 0.000 query.py:853(_clone)
  161. 4 0.001 0.000 3.503 0.876 query.py:867(_fill_cache)
  162. 379 0.000 0.000 0.001 0.000 query.py:92(__iter__)
  163. 2087 0.010 0.000 0.011 0.000 query.py:929(setup_inherited_models)
  164. 2464 0.009 0.000 0.014 0.000 query_utils.py:43(__init__)
  165. 4 0.000 0.000 0.000 0.000 re.py:248(_compile_repl)
  166. 4 0.000 0.000 0.000 0.000 re.py:268(_subx)
  167. 2085 0.021 0.000 0.475 0.000 related.py:308(get_query_set)
  168. 6256/4171 0.038 0.000 3.467 0.001 related.py:331(__get__)
  169. 2085 0.004 0.000 0.005 0.000 related.py:856(get_related_field)
  170. 14 0.000 0.000 0.000 0.000 socket.py:276(close)
  171. 14 0.000 0.000 0.000 0.000 socket.py:285(__del__)
  172. 2466 0.008 0.000 0.011 0.000 tree.py:120(start_subtree)
  173. 2466 0.008 0.000 0.013 0.000 tree.py:140(end_subtree)
  174. 28443 0.033 0.000 0.033 0.000 tree.py:18(__init__)
  175. 16119/14030 0.059 0.000 0.540 0.000 tree.py:55(__deepcopy__)
  176. 2464 0.002 0.000 0.002 0.000 tree.py:71(__nonzero__)
  177. 2466 0.005 0.000 0.008 0.000 tree.py:83(add)
  178. 2463 0.003 0.000 0.010 0.000 utf_8.py:15(decode)
  179. 2087 0.002 0.000 0.002 0.000 util.py:15(__init__)
  180. 6264 0.005 0.000 0.027 0.000 util.py:19(set_dirty)
  181. 4177 0.007 0.000 0.037 0.000 util.py:23(__getattr__)
  182. 2087 0.036 0.000 0.749 0.000 util.py:36(execute)
  183. 2089 0.002 0.000 0.002 0.000 utils.py:128(_route_db)
  184. 4174 0.005 0.000 0.008 0.000 utils.py:86(__getitem__)
  185. 1 0.000 0.000 0.000 0.000 version.py:24(get_version)
  186. 377/1 0.009 0.000 0.223 0.223 views.py:230(recursive_node_to_dict)
  187. 1 0.000 0.000 3.802 3.802 views.py:247(profileJSON)
  188. 2089 0.016 0.000 0.089 0.000 where.py:130(make_atom)
  189. 2089 0.005 0.000 0.018 0.000 where.py:219(sql_for_columns)
  190. 2466 0.003 0.000 0.003 0.000 where.py:291(__init__)
  191. 2089 0.004 0.000 0.005 0.000 where.py:294(__getstate__)
  192. 2089 0.008 0.000 0.020 0.000 where.py:308(__setstate__)
  193. 2466 0.003 0.000 0.015 0.000 where.py:318(prepare)
  194. 2089 0.019 0.000 0.049 0.000 where.py:323(process)
  195. 2466 0.014 0.000 0.044 0.000 where.py:39(add)
  196. 6263/4174 0.022 0.000 0.118 0.000 where.py:74(as_sql)
  197. 1 0.000 0.000 0.000 0.000 {__import__}
  198. 2463 0.007 0.000 0.007 0.000 {_codecs.utf_8_decode}
  199. 3016 0.001 0.000 0.001 0.000 {_json.encode_basestring_ascii}
  200. 72266 0.043 0.000 0.043 0.000 {built-in method __new__ of type object at 0x10017ff20}
  201. 2466 0.000 0.000 0.000 0.000 {callable}
  202. 3 0.000 0.000 0.000 0.000 {function __getitem__ at 0x1011dede8}
  203. 85358/81181 0.048 0.000 0.051 0.000 {getattr}
  204. 56523 0.060 0.000 0.060 0.000 {hasattr}
  205. 353062 0.038 0.000 0.038 0.000 {id}
  206. 105575 0.038 0.000 0.038 0.000 {isinstance}
  207. 34325 0.013 0.000 0.013 0.000 {issubclass}
  208. 4928 0.002 0.000 0.002 0.000 {iter}
  209. 64877/14029 0.013 0.000 3.157 0.000 {len}
  210. 8727 0.009 0.000 0.009 0.000 {map}
  211. 9104 0.041 0.000 0.046 0.000 {method '__reduce_ex__' of 'object' objects}
  212. 40036 0.011 0.000 0.011 0.000 {method 'add' of 'set' objects}
  213. 197492 0.047 0.000 0.047 0.000 {method 'append' of 'list' objects}
  214. 44179 0.028 0.000 0.028 0.000 {method 'copy' of 'dict' objects}
  215. 2088 0.003 0.000 0.003 0.000 {method 'cursor' of 'psycopg2._psycopg.connection' objects}
  216. 1 0.000 0.000 0.000 0.000 {method 'disable' of '_lsprof.Profiler' objects}
  217. 377 0.001 0.000 0.001 0.000 {method 'encode' of 'unicode' objects}
  218. 2088 0.631 0.000 0.680 0.000 {method 'execute' of 'psycopg2._psycopg.cursor' objects}
  219. 14994 0.003 0.000 0.003 0.000 {method 'extend' of 'list' objects}
  220. 4177 0.027 0.000 0.039 0.000 {method 'fetchmany' of 'psycopg2._psycopg.cursor' objects}
  221. 264227 0.044 0.000 0.044 0.000 {method 'get' of 'dict' objects}
  222. 1 0.000 0.000 0.000 0.000 {method 'get_parameter_status' of 'psycopg2._psycopg.connection' objects}
  223. 2465 0.001 0.000 0.001 0.000 {method 'items' of 'dict' objects}
  224. 2467 0.001 0.000 0.001 0.000 {method 'iteritems' of 'dict' objects}
  225. 8356 0.006 0.000 0.006 0.000 {method 'join' of 'str' objects}
  226. 7392 0.001 0.000 0.001 0.000 {method 'keys' of 'dict' objects}
  227. 760 0.001 0.000 0.001 0.000 {method 'match' of '_sre.SRE_Pattern' objects}
  228. 4178 0.001 0.000 0.001 0.000 {method 'pop' of 'dict' objects}
  229. 10237 0.005 0.000 0.005 0.000 {method 'pop' of 'list' objects}
  230. 4 0.000 0.000 0.000 0.000 {method 'search' of '_sre.SRE_Pattern' objects}
  231. 1 0.000 0.000 0.000 0.000 {method 'set_client_encoding' of 'psycopg2._psycopg.connection' objects}
  232. 2 0.000 0.000 0.000 0.000 {method 'set_isolation_level' of 'psycopg2._psycopg.connection' objects}
  233. 2471 0.003 0.000 0.003 0.000 {method 'split' of 'str' objects}
  234. 41747 0.017 0.000 0.017 0.000 {method 'startswith' of 'str' objects}
  235. 4 0.000 0.000 0.000 0.000 {method 'sub' of '_sre.SRE_Pattern' objects}
  236. 16120 0.008 0.000 0.008 0.000 {method 'update' of 'dict' objects}
  237. 4553 0.004 0.000 0.004 0.000 {method 'update' of 'set' objects}
  238. 1 0.003 0.003 0.003 0.003 {psycopg2._psycopg._connect}
  239. 18212 0.013 0.000 0.013 0.000 {range}
  240. 46419 0.018 0.000 0.018 0.000 {setattr}
  241. 2087 0.001 0.000 0.001 0.000 {thread.get_ident}
  242. 4174 0.002 0.000 0.002 0.000 {time.time}
  243. 8727 0.006 0.000 0.006 0.000 {zip}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement