Advertisement
Guest User

profile solution 5

a guest
Sep 24th, 2012
415
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.67 KB | None | 0 0
  1. Solution 5:
  2.  
  3. 2536504 function calls (2357256 primitive calls) in 3.779 seconds
  4.  
  5. Ordered by: standard name
  6.  
  7. ncalls tottime percall cumtime percall filename:lineno(function)
  8. 1 0.000 0.000 3.779 3.779 <string>:1(<module>)
  9. 39574 0.025 0.000 0.066 0.000 <string>:8(__new__)
  10. 4 0.000 0.000 0.000 0.000 __init__.py:102(_param_escape)
  11. 2192 0.002 0.000 0.009 0.000 __init__.py:1118(debug)
  12. 1 0.000 0.000 0.003 0.003 __init__.py:119(connect)
  13. 2192 0.003 0.000 0.004 0.000 __init__.py:123(validate_thread_sharing)
  14. 2192 0.004 0.000 0.004 0.000 __init__.py:1318(getEffectiveLevel)
  15. 2192 0.003 0.000 0.007 0.000 __init__.py:1332(isEnabledFor)
  16. 6576 0.015 0.000 0.023 0.000 __init__.py:172(is_managed)
  17. 1 0.000 0.000 0.001 0.001 __init__.py:185(dumps)
  18. 2192 0.009 0.000 0.019 0.000 __init__.py:204(db_type)
  19. 12 0.000 0.000 0.000 0.000 __init__.py:231(unique)
  20. 12 0.000 0.000 0.000 0.000 __init__.py:258(get_cache_name)
  21. 2192 0.001 0.000 0.001 0.000 __init__.py:276(get_db_prep_value)
  22. 2192 0.005 0.000 0.011 0.000 __init__.py:294(get_prep_lookup)
  23. 2192 0.012 0.000 0.046 0.000 __init__.py:302(cursor)
  24. 2192 0.003 0.000 0.005 0.000 __init__.py:311(make_debug_cursor)
  25. 2192 0.007 0.000 0.014 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.001 0.000 0.001 0.000 __init__.py:519(get_internal_type)
  28. 2192 0.002 0.000 0.002 0.000 __init__.py:534(get_prep_value)
  29. 2192 0.002 0.000 0.002 0.000 __init__.py:659(compiler)
  30. 106 0.002 0.000 0.003 0.000 __init__.py:76(__init__)
  31. 106 0.000 0.000 0.000 0.000 __init__.py:974(get_internal_type)
  32. 1 0.000 0.000 0.000 0.000 base.py:151(_get_pg_version)
  33. 2192 0.011 0.000 0.022 0.000 base.py:157(_cursor)
  34. 2475 0.002 0.000 0.002 0.000 base.py:267(__init__)
  35. 2475 0.057 0.000 0.121 0.000 base.py:278(__init__)
  36. 4950 0.002 0.000 0.002 0.000 base.py:36(utc_tzinfo_factory)
  37. 378 0.000 0.000 0.001 0.000 base.py:425(_get_pk_val)
  38. 2192 0.001 0.000 0.001 0.000 base.py:47(__init__)
  39. 2192 0.003 0.000 0.751 0.000 base.py:50(execute)
  40. 6576 0.007 0.000 0.010 0.000 base.py:66(__getattr__)
  41. 2192 0.002 0.000 0.002 0.000 compiler.py:15(__init__)
  42. 2192 0.025 0.000 0.246 0.000 compiler.py:168(get_columns)
  43. 2192 0.004 0.000 0.017 0.000 compiler.py:21(pre_sql_setup)
  44. 2204 0.108 0.000 0.203 0.000 compiler.py:248(get_default_columns)
  45. 2192 0.002 0.000 0.002 0.000 compiler.py:313(get_distinct)
  46. 2192 0.009 0.000 0.017 0.000 compiler.py:333(get_ordering)
  47. 46516 0.029 0.000 0.041 0.000 compiler.py:37(quote_name_unless_alias)
  48. 212 0.001 0.000 0.007 0.000 compiler.py:418(find_ordering_name)
  49. 212 0.001 0.000 0.006 0.000 compiler.py:448(_setup_joins)
  50. 212 0.000 0.000 0.000 0.000 compiler.py:476(_final_join_removal)
  51. 2192 0.010 0.000 0.012 0.000 compiler.py:495(get_from_clause)
  52. 2192 0.045 0.000 0.556 0.000 compiler.py:53(as_sql)
  53. 2192 0.002 0.000 0.002 0.000 compiler.py:539(get_grouping)
  54. 13/1 0.000 0.000 0.001 0.001 compiler.py:573(fill_related_selections)
  55. 2204 0.003 0.000 0.004 0.000 compiler.py:741(deferred_to_columns)
  56. 4655 0.022 0.000 1.564 0.000 compiler.py:751(results_iter)
  57. 2192 0.018 0.000 1.444 0.001 compiler.py:794(execute_sql)
  58. 4384 0.013 0.000 0.093 0.000 compiler.py:832(<lambda>)
  59. 117305/25884 0.357 0.000 1.079 0.000 copy.py:145(deepcopy)
  60. 29429 0.005 0.000 0.005 0.000 copy.py:198(_deepcopy_atomic)
  61. 36529/32355 0.037 0.000 0.335 0.000 copy.py:226(_deepcopy_list)
  62. 17116/8558 0.105 0.000 0.558 0.000 copy.py:234(_deepcopy_tuple)
  63. 2087 0.012 0.000 0.071 0.000 copy.py:253(_deepcopy_dict)
  64. 115219 0.149 0.000 0.186 0.000 copy.py:267(_keep_alive)
  65. 8558 0.044 0.000 0.320 0.000 copy.py:306(_reconstruct)
  66. 2087 0.001 0.000 0.002 0.000 copy_reg.py:92(__newobj__)
  67. 31189 0.054 0.000 0.070 0.000 datastructures.py:103(__new__)
  68. 31189 0.101 0.000 0.132 0.000 datastructures.py:108(__init__)
  69. 6471 0.020 0.000 0.072 0.000 datastructures.py:127(__deepcopy__)
  70. 5151 0.011 0.000 0.012 0.000 datastructures.py:131(__setitem__)
  71. 8768 0.011 0.000 0.034 0.000 datastructures.py:157(items)
  72. 8663 0.004 0.000 0.004 0.000 datastructures.py:160(iteritems)
  73. 33212 0.014 0.000 0.014 0.000 datastructures.py:164(keys)
  74. 8768 0.008 0.000 0.017 0.000 datastructures.py:170(values)
  75. 2192 0.001 0.000 0.001 0.000 datastructures.py:173(itervalues)
  76. 17326 0.037 0.000 0.152 0.000 datastructures.py:200(copy)
  77. 2192 0.009 0.000 0.009 0.000 datastructures.py:489(__init__)
  78. 4951 0.009 0.000 0.042 0.000 dispatcher.py:149(send)
  79. 4950 0.010 0.000 0.020 0.000 dispatcher.py:214(_live_receivers)
  80. 9900 0.008 0.000 0.023 0.000 dispatcher.py:8(_make_id)
  81. 1 0.000 0.000 0.001 0.001 encoder.py:180(encode)
  82. 1 0.001 0.001 0.001 0.001 encoder.py:206(iterencode)
  83. 11067 0.010 0.000 0.014 0.000 functional.py:182(inner)
  84. 1 0.000 0.000 0.000 0.000 importlib.py:18(import_module)
  85. 272 0.001 0.000 0.010 0.000 manager.py:103(get_empty_query_set)
  86. 107 0.000 0.000 0.004 0.000 manager.py:106(get_query_set)
  87. 272 0.000 0.000 0.010 0.000 manager.py:112(none)
  88. 1 0.000 0.000 0.007 0.007 manager.py:130(get)
  89. 2086 0.002 0.000 0.002 0.000 manager.py:217(__get__)
  90. 106 0.001 0.000 0.062 0.001 managers.py:101(_mptt_filter)
  91. 107 0.001 0.000 0.026 0.000 managers.py:175(get_query_set)
  92. 106 0.000 0.000 0.000 0.000 managers.py:71(parent_attr)
  93. 107 0.000 0.000 0.000 0.000 managers.py:75(left_attr)
  94. 107 0.000 0.000 0.000 0.000 managers.py:83(tree_id_attr)
  95. 106 0.001 0.000 0.001 0.000 managers.py:91(_translate_lookups)
  96. 2463 0.009 0.000 0.181 0.000 models.py:328(__init__)
  97. 1134 0.001 0.000 0.002 0.000 models.py:332(_mpttfield)
  98. 378 0.001 0.000 0.077 0.000 models.py:377(get_children)
  99. 378 0.001 0.000 0.003 0.000 models.py:428(get_descendant_count)
  100. 378 0.000 0.000 0.003 0.000 models.py:545(is_leaf_node)
  101. 2463/378 0.024 0.000 3.548 0.009 models.py:55(__init__)
  102. 4926 0.011 0.000 0.040 0.000 models.py:63(get_raw_field_value)
  103. 4172/756 0.007 0.000 0.009 0.000 models.py:75(get_wbs_code)
  104. 2463 0.012 0.000 0.052 0.000 models.py:82(update_mptt_cached_fields)
  105. 2192 0.001 0.000 0.001 0.000 operations.py:171(max_name_length)
  106. 2192 0.008 0.000 0.013 0.000 operations.py:191(last_executed_query)
  107. 2192 0.002 0.000 0.002 0.000 operations.py:40(lookup_cast)
  108. 2192 0.001 0.000 0.001 0.000 operations.py:54(field_cast_sql)
  109. 44096 0.036 0.000 0.054 0.000 operations.py:69(quote_name)
  110. 1 0.000 0.000 0.000 0.000 operations.py:74(set_time_zone_sql)
  111. 18681 0.010 0.000 0.010 0.000 options.py:216(_fields)
  112. 4409 0.002 0.000 0.002 0.000 options.py:231(get_fields_with_model)
  113. 9310 0.009 0.000 0.013 0.000 options.py:255(_many_to_many)
  114. 9310 0.029 0.000 0.047 0.000 options.py:285(get_field)
  115. 4607 0.003 0.000 0.003 0.000 options.py:295(get_field_by_name)
  116. 2464 0.040 0.000 0.083 0.000 query.py:101(__init__)
  117. 2192 0.045 0.000 0.191 0.000 query.py:1030(add_filter)
  118. 483 0.001 0.000 3.673 0.008 query.py:108(_result_iter)
  119. 272 0.001 0.000 0.009 0.000 query.py:1121(__init__)
  120. 2192 0.019 0.000 0.238 0.000 query.py:1219(add_q)
  121. 13/1 0.000 0.000 0.000 0.000 query.py:1240(get_klass_info)
  122. 2404 0.029 0.000 0.040 0.000 query.py:1270(setup_joins)
  123. 13/1 0.000 0.000 0.003 0.003 query.py:1339(get_cached_row)
  124. 2192 0.004 0.000 0.007 0.000 query.py:1481(trim_joins)
  125. 9 0.000 0.000 0.000 0.000 query.py:1539(update_dupe_avoidance)
  126. 6471 0.003 0.000 0.003 0.000 query.py:1614(can_filter)
  127. 2193 0.002 0.000 0.003 0.000 query.py:1672(add_ordering)
  128. 2193 0.001 0.000 0.001 0.000 query.py:1692(clear_ordering)
  129. 2192 0.003 0.000 0.004 0.000 query.py:1847(get_loaded_field_names)
  130. 8980 0.004 0.000 0.004 0.000 query.py:1886(_aggregate_select)
  131. 13384 0.006 0.000 0.006 0.000 query.py:1904(_extra_select)
  132. 636 0.000 0.000 0.000 0.000 query.py:1955(get_order_dir)
  133. 2192 0.011 0.000 0.028 0.000 query.py:215(get_compiler)
  134. 2193 0.001 0.000 0.001 0.000 query.py:227(get_meta)
  135. 4655/485 0.040 0.000 3.677 0.008 query.py:231(iterator)
  136. 6471 0.142 0.000 1.350 0.000 query.py:235(clone)
  137. 8935 0.021 0.000 0.103 0.000 query.py:32(__init__)
  138. 2086/378 0.018 0.000 3.432 0.009 query.py:353(get)
  139. 4396 0.002 0.000 0.002 0.000 query.py:559(deferred_to_data)
  140. 2192 0.003 0.000 0.623 0.000 query.py:616(filter)
  141. 2192 0.011 0.000 0.620 0.000 query.py:630(_filter_or_exclude)
  142. 2310 0.009 0.000 0.016 0.000 query.py:649(table_alias)
  143. 1 0.000 0.000 0.000 0.000 query.py:671(select_related)
  144. 425 0.001 0.000 0.002 0.000 query.py:675(ref_alias)
  145. 2416 0.005 0.000 0.010 0.000 query.py:679(unref_alias)
  146. 212 0.000 0.000 0.000 0.000 query.py:683(promote_alias)
  147. 212 0.000 0.000 0.000 0.000 query.py:700(promote_alias_chain)
  148. 2192 0.010 0.000 0.050 0.000 query.py:710(reset_refcounts)
  149. 2193 0.008 0.000 0.683 0.000 query.py:748(order_by)
  150. 2086/378 0.017 0.000 3.204 0.008 query.py:77(__len__)
  151. 2085 0.002 0.000 0.373 0.000 query.py:817(using)
  152. 2405 0.004 0.000 0.029 0.000 query.py:831(get_initial_alias)
  153. 4384 0.002 0.000 0.003 0.000 query.py:842(db)
  154. 2310 0.009 0.000 0.026 0.000 query.py:851(join)
  155. 6471 0.033 0.000 1.397 0.000 query.py:853(_clone)
  156. 106 0.002 0.000 3.672 0.035 query.py:867(_fill_cache)
  157. 378 0.001 0.000 0.001 0.000 query.py:92(__iter__)
  158. 2192 0.011 0.000 0.012 0.000 query.py:929(setup_inherited_models)
  159. 272 0.000 0.000 0.000 0.000 query_utils.py:113(select_related_descend)
  160. 2192 0.008 0.000 0.013 0.000 query_utils.py:43(__init__)
  161. 4 0.000 0.000 0.000 0.000 re.py:248(_compile_repl)
  162. 4 0.000 0.000 0.000 0.000 re.py:268(_subx)
  163. 106 0.001 0.000 0.005 0.000 related.py:1011(db_type)
  164. 106 0.000 0.000 0.003 0.000 related.py:127(get_prep_lookup)
  165. 106 0.000 0.000 0.003 0.000 related.py:144(get_db_prep_lookup)
  166. 212 0.002 0.000 0.005 0.000 related.py:175(_pk_trace)
  167. 2085 0.021 0.000 0.481 0.000 related.py:308(get_query_set)
  168. 5879/3794 0.039 0.000 3.520 0.001 related.py:331(__get__)
  169. 2203 0.004 0.000 0.005 0.000 related.py:856(get_related_field)
  170. 13 0.000 0.000 0.000 0.000 socket.py:276(close)
  171. 13 0.000 0.000 0.000 0.000 socket.py:285(__del__)
  172. 2192 0.007 0.000 0.010 0.000 tree.py:120(start_subtree)
  173. 2192 0.007 0.000 0.012 0.000 tree.py:140(end_subtree)
  174. 26533 0.031 0.000 0.031 0.000 tree.py:18(__init__)
  175. 15029/12942 0.055 0.000 0.525 0.000 tree.py:55(__deepcopy__)
  176. 2192 0.002 0.000 0.002 0.000 tree.py:71(__nonzero__)
  177. 2192 0.005 0.000 0.007 0.000 tree.py:83(add)
  178. 2511 0.003 0.000 0.010 0.000 utf_8.py:15(decode)
  179. 2192 0.002 0.000 0.002 0.000 util.py:15(__init__)
  180. 6576 0.006 0.000 0.029 0.000 util.py:19(set_dirty)
  181. 4384 0.007 0.000 0.039 0.000 util.py:23(__getattr__)
  182. 2192 0.039 0.000 0.823 0.000 util.py:36(execute)
  183. 2299 0.003 0.000 0.003 0.000 utils.py:128(_route_db)
  184. 4384 0.006 0.000 0.009 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 3.755 3.755 views.py:213(serializable_object)
  187. 1 0.000 0.000 3.770 3.770 views.py:221(serializable_object_select_related)
  188. 1 0.000 0.000 3.779 3.779 views.py:255(profileJSON)
  189. 2192 0.018 0.000 0.102 0.000 where.py:130(make_atom)
  190. 2192 0.006 0.000 0.019 0.000 where.py:219(sql_for_columns)
  191. 2192 0.003 0.000 0.003 0.000 where.py:291(__init__)
  192. 2087 0.004 0.000 0.005 0.000 where.py:294(__getstate__)
  193. 2087 0.008 0.000 0.021 0.000 where.py:308(__setstate__)
  194. 2192 0.003 0.000 0.016 0.000 where.py:318(prepare)
  195. 2192 0.021 0.000 0.060 0.000 where.py:323(process)
  196. 2192 0.012 0.000 0.043 0.000 where.py:39(add)
  197. 6576/4384 0.023 0.000 0.134 0.000 where.py:74(as_sql)
  198. 1 0.000 0.000 0.000 0.000 {__import__}
  199. 2511 0.007 0.000 0.007 0.000 {_codecs.utf_8_decode}
  200. 72850 0.057 0.000 0.057 0.000 {built-in method __new__ of type object at 0x10017ff20}
  201. 2192 0.000 0.000 0.000 0.000 {callable}
  202. 86066/81682 0.048 0.000 0.052 0.000 {getattr}
  203. 54863 0.060 0.000 0.060 0.000 {hasattr}
  204. 332616 0.036 0.000 0.036 0.000 {id}
  205. 90383 0.034 0.000 0.034 0.000 {isinstance}
  206. 32145 0.012 0.000 0.012 0.000 {issubclass}
  207. 4939 0.002 0.000 0.002 0.000 {iter}
  208. 61971/11123 0.013 0.000 3.206 0.000 {len}
  209. 8768 0.009 0.000 0.009 0.000 {map}
  210. 8558 0.039 0.000 0.044 0.000 {method '__reduce_ex__' of 'object' objects}
  211. 42452 0.011 0.000 0.011 0.000 {method 'add' of 'set' objects}
  212. 193632 0.046 0.000 0.046 0.000 {method 'append' of 'list' objects}
  213. 40913 0.009 0.000 0.009 0.000 {method 'copy' of 'dict' objects}
  214. 24 0.000 0.000 0.000 0.000 {method 'copy' of 'set' objects}
  215. 2193 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. 2193 0.682 0.000 0.748 0.000 {method 'execute' of 'psycopg2._psycopg.cursor' objects}
  218. 15476 0.004 0.000 0.004 0.000 {method 'extend' of 'list' objects}
  219. 4384 0.029 0.000 0.041 0.000 {method 'fetchmany' of 'psycopg2._psycopg.cursor' objects}
  220. 250429 0.041 0.000 0.041 0.000 {method 'get' of 'dict' objects}
  221. 1 0.000 0.000 0.000 0.000 {method 'get_parameter_status' of 'psycopg2._psycopg.connection' objects}
  222. 2298 0.001 0.000 0.001 0.000 {method 'items' of 'dict' objects}
  223. 2088 0.001 0.000 0.001 0.000 {method 'iteritems' of 'dict' objects}
  224. 8982 0.006 0.000 0.006 0.000 {method 'join' of 'str' objects}
  225. 7392 0.001 0.000 0.001 0.000 {method 'keys' of 'dict' objects}
  226. 214 0.001 0.000 0.001 0.000 {method 'match' of '_sre.SRE_Pattern' objects}
  227. 4175 0.001 0.000 0.001 0.000 {method 'pop' of 'dict' objects}
  228. 8767 0.004 0.000 0.004 0.000 {method 'pop' of 'list' objects}
  229. 4 0.000 0.000 0.000 0.000 {method 'search' of '_sre.SRE_Pattern' objects}
  230. 1 0.000 0.000 0.000 0.000 {method 'set_client_encoding' of 'psycopg2._psycopg.connection' objects}
  231. 2 0.000 0.000 0.000 0.000 {method 'set_isolation_level' of 'psycopg2._psycopg.connection' objects}
  232. 2510 0.003 0.000 0.003 0.000 {method 'split' of 'str' objects}
  233. 44097 0.018 0.000 0.018 0.000 {method 'startswith' of 'str' objects}
  234. 4 0.000 0.000 0.000 0.000 {method 'sub' of '_sre.SRE_Pattern' objects}
  235. 12 0.000 0.000 0.000 0.000 {method 'union' of 'set' objects}
  236. 15454 0.007 0.000 0.007 0.000 {method 'update' of 'dict' objects}
  237. 4393 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. 17222 0.013 0.000 0.013 0.000 {range}
  240. 46549 0.018 0.000 0.018 0.000 {setattr}
  241. 2192 0.001 0.000 0.001 0.000 {thread.get_ident}
  242. 4384 0.002 0.000 0.002 0.000 {time.time}
  243. 8768 0.006 0.000 0.006 0.000 {zip}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement