Advertisement
Guest User

Profile- solution 6

a guest
Sep 25th, 2012
591
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.40 KB | None | 0 0
  1. Solution 6:
  2.  
  3. 2593122 function calls (2299165 primitive calls) in 3.663 seconds
  4.  
  5. Ordered by: standard name
  6.  
  7. ncalls tottime percall cumtime percall filename:lineno(function)
  8. 1 0.005 0.005 3.663 3.663 <string>:1(<module>)
  9. 37566 0.023 0.000 0.082 0.000 <string>:8(__new__)
  10. 4 0.000 0.000 0.000 0.000 __init__.py:102(_param_escape)
  11. 2087 0.002 0.000 0.008 0.000 __init__.py:1118(debug)
  12. 3 0.000 0.000 0.000 0.000 __init__.py:1118(get_internal_type)
  13. 1 0.000 0.000 0.004 0.004 __init__.py:119(connect)
  14. 2087 0.003 0.000 0.004 0.000 __init__.py:123(validate_thread_sharing)
  15. 2087 0.004 0.000 0.004 0.000 __init__.py:1318(getEffectiveLevel)
  16. 2087 0.003 0.000 0.006 0.000 __init__.py:1332(isEnabledFor)
  17. 6264 0.014 0.000 0.022 0.000 __init__.py:172(is_managed)
  18. 1 0.000 0.000 0.058 0.058 __init__.py:185(dumps)
  19. 2089 0.008 0.000 0.018 0.000 __init__.py:204(db_type)
  20. 2089 0.001 0.000 0.001 0.000 __init__.py:276(get_db_prep_value)
  21. 2089 0.005 0.000 0.011 0.000 __init__.py:294(get_prep_lookup)
  22. 2087 0.012 0.000 0.045 0.000 __init__.py:302(cursor)
  23. 2087 0.003 0.000 0.004 0.000 __init__.py:311(make_debug_cursor)
  24. 2089 0.006 0.000 0.013 0.000 __init__.py:322(get_db_prep_lookup)
  25. 4928 0.003 0.000 0.005 0.000 __init__.py:489(value_from_object)
  26. 1 0.000 0.000 0.000 0.000 __init__.py:49(normalize_encoding)
  27. 2086 0.001 0.000 0.001 0.000 __init__.py:519(get_internal_type)
  28. 2086 0.002 0.000 0.002 0.000 __init__.py:534(get_prep_value)
  29. 2087 0.002 0.000 0.003 0.000 __init__.py:659(compiler)
  30. 1 0.000 0.000 0.000 0.000 __init__.py:71(search_function)
  31. 3 0.000 0.000 0.000 0.000 __init__.py:963(get_prep_value)
  32. 3 0.000 0.000 0.000 0.000 __init__.py:968(get_prep_lookup)
  33. 1 0.000 0.000 0.000 0.000 base.py:151(_get_pg_version)
  34. 2087 0.010 0.000 0.021 0.000 base.py:157(_cursor)
  35. 2464 0.002 0.000 0.002 0.000 base.py:267(__init__)
  36. 2464 0.053 0.000 0.117 0.000 base.py:278(__init__)
  37. 4928 0.002 0.000 0.002 0.000 base.py:36(utc_tzinfo_factory)
  38. 378 0.000 0.000 0.000 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.718 0.000 base.py:50(execute)
  41. 6264 0.007 0.000 0.010 0.000 base.py:66(__getattr__)
  42. 1 0.000 0.000 0.000 0.000 codecs.py:77(__new__)
  43. 1 0.000 0.000 0.000 0.000 compiler.py:1(<module>)
  44. 1 0.000 0.000 0.000 0.000 compiler.py:1041(SQLAggregateCompiler)
  45. 1 0.000 0.000 0.000 0.000 compiler.py:1060(SQLDateCompiler)
  46. 1 0.000 0.000 0.000 0.000 compiler.py:14(SQLCompiler)
  47. 2087 0.002 0.000 0.002 0.000 compiler.py:15(__init__)
  48. 2087 0.024 0.000 0.235 0.000 compiler.py:168(get_columns)
  49. 2087 0.004 0.000 0.015 0.000 compiler.py:21(pre_sql_setup)
  50. 2087 0.104 0.000 0.194 0.000 compiler.py:248(get_default_columns)
  51. 2087 0.002 0.000 0.002 0.000 compiler.py:313(get_distinct)
  52. 2087 0.006 0.000 0.006 0.000 compiler.py:333(get_ordering)
  53. 43833 0.028 0.000 0.039 0.000 compiler.py:37(quote_name_unless_alias)
  54. 2 0.000 0.000 0.000 0.000 compiler.py:418(find_ordering_name)
  55. 2 0.000 0.000 0.000 0.000 compiler.py:448(_setup_joins)
  56. 2 0.000 0.000 0.000 0.000 compiler.py:476(_final_join_removal)
  57. 2087 0.010 0.000 0.011 0.000 compiler.py:495(get_from_clause)
  58. 2087 0.041 0.000 0.512 0.000 compiler.py:53(as_sql)
  59. 2087 0.002 0.000 0.002 0.000 compiler.py:539(get_grouping)
  60. 2087 0.003 0.000 0.004 0.000 compiler.py:741(deferred_to_columns)
  61. 4551 0.021 0.000 1.480 0.000 compiler.py:751(results_iter)
  62. 2087 0.019 0.000 1.365 0.001 compiler.py:794(execute_sql)
  63. 4177 0.012 0.000 0.090 0.000 compiler.py:832(<lambda>)
  64. 1 0.000 0.000 0.000 0.000 compiler.py:842(SQLInsertCompiler)
  65. 1 0.000 0.000 0.000 0.000 compiler.py:919(SQLDeleteCompiler)
  66. 1 0.000 0.000 0.000 0.000 compiler.py:933(SQLUpdateCompiler)
  67. 114823/25044 0.351 0.000 1.059 0.000 copy.py:145(deepcopy)
  68. 29223 0.005 0.000 0.005 0.000 copy.py:198(_deepcopy_atomic)
  69. 35483/31305 0.035 0.000 0.336 0.000 copy.py:226(_deepcopy_list)
  70. 16700/8350 0.102 0.000 0.549 0.000 copy.py:234(_deepcopy_tuple)
  71. 2089 0.012 0.000 0.072 0.000 copy.py:253(_deepcopy_dict)
  72. 112717 0.147 0.000 0.183 0.000 copy.py:267(_keep_alive)
  73. 8350 0.043 0.000 0.317 0.000 copy.py:306(_reconstruct)
  74. 2089 0.001 0.000 0.002 0.000 copy_reg.py:92(__newobj__)
  75. 29218 0.051 0.000 0.066 0.000 datastructures.py:103(__new__)
  76. 29218 0.095 0.000 0.124 0.000 datastructures.py:108(__init__)
  77. 6261 0.019 0.000 0.070 0.000 datastructures.py:127(__deepcopy__)
  78. 4180 0.010 0.000 0.010 0.000 datastructures.py:131(__setitem__)
  79. 8353 0.010 0.000 0.032 0.000 datastructures.py:157(items)
  80. 8348 0.004 0.000 0.004 0.000 datastructures.py:160(iteritems)
  81. 32061 0.014 0.000 0.014 0.000 datastructures.py:164(keys)
  82. 8353 0.008 0.000 0.016 0.000 datastructures.py:170(values)
  83. 2087 0.001 0.000 0.001 0.000 datastructures.py:173(itervalues)
  84. 16696 0.036 0.000 0.146 0.000 datastructures.py:200(copy)
  85. 2089 0.009 0.000 0.009 0.000 datastructures.py:489(__init__)
  86. 3 0.000 0.000 0.000 0.000 datastructures.py:494(__getitem__)
  87. 4929 0.008 0.000 0.042 0.000 dispatcher.py:149(send)
  88. 4928 0.010 0.000 0.020 0.000 dispatcher.py:214(_live_receivers)
  89. 9856 0.008 0.000 0.023 0.000 dispatcher.py:8(_make_id)
  90. 1 0.000 0.000 0.000 0.000 encoder.py:102(__init__)
  91. 1 0.002 0.002 0.058 0.058 encoder.py:180(encode)
  92. 1 0.000 0.000 0.000 0.000 encoder.py:206(iterencode)
  93. 1 0.000 0.000 0.000 0.000 encoder.py:266(_make_iterencode)
  94. 70423/10693 0.022 0.000 0.052 0.000 encoder.py:282(_iterencode_list)
  95. 69558/10690 0.026 0.000 0.048 0.000 encoder.py:335(_iterencode_dict)
  96. 10693 0.004 0.000 0.055 0.000 encoder.py:411(_iterencode)
  97. 10439 0.009 0.000 0.013 0.000 functional.py:182(inner)
  98. 1 0.000 0.000 0.001 0.001 importlib.py:18(import_module)
  99. 1 0.000 0.000 0.000 0.000 loading.py:115(app_cache_ready)
  100. 2 0.000 0.000 0.000 0.000 manager.py:106(get_query_set)
  101. 1 0.000 0.000 0.009 0.009 manager.py:130(get)
  102. 2086 0.002 0.000 0.002 0.000 manager.py:217(__get__)
  103. 1 0.000 0.000 0.001 0.001 managers.py:101(_mptt_filter)
  104. 2 0.000 0.000 0.001 0.000 managers.py:175(get_query_set)
  105. 4 0.000 0.000 0.000 0.000 managers.py:75(left_attr)
  106. 3 0.000 0.000 0.000 0.000 managers.py:83(tree_id_attr)
  107. 1 0.000 0.000 0.000 0.000 managers.py:91(_translate_lookups)
  108. 1 0.000 0.000 0.000 0.000 models.py:218(__getattr__)
  109. 2464 0.009 0.000 0.176 0.000 models.py:328(__init__)
  110. 4 0.000 0.000 0.000 0.000 models.py:332(_mpttfield)
  111. 1 0.000 0.000 0.001 0.001 models.py:400(get_descendants)
  112. 1 0.000 0.000 0.000 0.000 models.py:428(get_descendant_count)
  113. 378 0.000 0.000 0.000 0.000 models.py:525(get_level)
  114. 1 0.000 0.000 0.000 0.000 models.py:545(is_leaf_node)
  115. 2464/379 0.025 0.000 3.570 0.009 models.py:55(__init__)
  116. 4928 0.010 0.000 0.039 0.000 models.py:63(get_raw_field_value)
  117. 2086/378 0.004 0.000 0.006 0.000 models.py:75(get_wbs_code)
  118. 2464 0.011 0.000 0.051 0.000 models.py:82(update_mptt_cached_fields)
  119. 1 0.001 0.001 3.583 3.583 mptt_tags.py:224(cache_tree_children)
  120. 2087 0.000 0.000 0.000 0.000 operations.py:171(max_name_length)
  121. 2087 0.008 0.000 0.012 0.000 operations.py:191(last_executed_query)
  122. 2089 0.002 0.000 0.002 0.000 operations.py:40(lookup_cast)
  123. 2089 0.001 0.000 0.001 0.000 operations.py:54(field_cast_sql)
  124. 41743 0.034 0.000 0.051 0.000 operations.py:69(quote_name)
  125. 1 0.000 0.000 0.000 0.000 operations.py:74(set_time_zone_sql)
  126. 18206 0.010 0.000 0.010 0.000 options.py:216(_fields)
  127. 4175 0.002 0.000 0.002 0.000 options.py:231(get_fields_with_model)
  128. 9104 0.009 0.000 0.013 0.000 options.py:255(_many_to_many)
  129. 1 0.000 0.000 0.000 0.000 options.py:263(get_m2m_with_model)
  130. 9104 0.028 0.000 0.046 0.000 options.py:285(get_field)
  131. 4176 0.004 0.000 0.004 0.000 options.py:295(get_field_by_name)
  132. 1 0.000 0.000 0.000 0.000 options.py:334(init_name_map)
  133. 1 0.000 0.000 0.000 0.000 options.py:368(get_all_related_objects_with_model)
  134. 3 0.000 0.000 0.000 0.000 options.py:383(<lambda>)
  135. 3 0.000 0.000 0.000 0.000 options.py:386(<lambda>)
  136. 1 0.000 0.000 0.000 0.000 options.py:421(get_all_related_m2m_objects_with_model)
  137. 2087 0.037 0.000 0.074 0.000 query.py:101(__init__)
  138. 2089 0.044 0.000 0.169 0.000 query.py:1030(add_filter)
  139. 381 0.000 0.000 3.581 0.009 query.py:108(_result_iter)
  140. 1 0.000 0.000 0.921 0.921 query.py:120(__nonzero__)
  141. 2087 0.018 0.000 0.214 0.000 query.py:1219(add_q)
  142. 2091 0.017 0.000 0.025 0.000 query.py:1270(setup_joins)
  143. 2089 0.004 0.000 0.006 0.000 query.py:1481(trim_joins)
  144. 6262 0.003 0.000 0.003 0.000 query.py:1614(can_filter)
  145. 2089 0.002 0.000 0.002 0.000 query.py:1672(add_ordering)
  146. 2089 0.001 0.000 0.001 0.000 query.py:1692(clear_ordering)
  147. 2087 0.003 0.000 0.004 0.000 query.py:1847(get_loaded_field_names)
  148. 8350 0.004 0.000 0.004 0.000 query.py:1886(_aggregate_select)
  149. 12525 0.006 0.000 0.006 0.000 query.py:1904(_extra_select)
  150. 6 0.000 0.000 0.000 0.000 query.py:1955(get_order_dir)
  151. 2087 0.010 0.000 0.028 0.000 query.py:215(get_compiler)
  152. 2089 0.001 0.000 0.001 0.000 query.py:227(get_meta)
  153. 4551/381 0.039 0.000 3.587 0.009 query.py:231(iterator)
  154. 6261 0.142 0.000 1.326 0.000 query.py:235(clone)
  155. 8348 0.019 0.000 0.093 0.000 query.py:32(__init__)
  156. 2086/378 0.018 0.000 3.457 0.009 query.py:353(get)
  157. 4174 0.002 0.000 0.002 0.000 query.py:559(deferred_to_data)
  158. 2087 0.003 0.000 0.577 0.000 query.py:616(filter)
  159. 2087 0.010 0.000 0.574 0.000 query.py:630(_filter_or_exclude)
  160. 2087 0.007 0.000 0.014 0.000 query.py:649(table_alias)
  161. 6 0.000 0.000 0.000 0.000 query.py:675(ref_alias)
  162. 2087 0.005 0.000 0.009 0.000 query.py:679(unref_alias)
  163. 2 0.000 0.000 0.000 0.000 query.py:683(promote_alias)
  164. 2 0.000 0.000 0.000 0.000 query.py:700(promote_alias_chain)
  165. 2087 0.009 0.000 0.047 0.000 query.py:710(reset_refcounts)
  166. 2089 0.008 0.000 0.670 0.000 query.py:748(order_by)
  167. 2086/378 0.017 0.000 3.229 0.009 query.py:77(__len__)
  168. 2085 0.002 0.000 0.378 0.000 query.py:817(using)
  169. 2091 0.003 0.000 0.027 0.000 query.py:831(get_initial_alias)
  170. 4174 0.002 0.000 0.002 0.000 query.py:842(db)
  171. 2087 0.008 0.000 0.023 0.000 query.py:851(join)
  172. 6261 0.031 0.000 1.371 0.000 query.py:853(_clone)
  173. 4 0.001 0.000 3.580 0.895 query.py:867(_fill_cache)
  174. 2 0.000 0.000 0.000 0.000 query.py:92(__iter__)
  175. 2087 0.010 0.000 0.011 0.000 query.py:929(setup_inherited_models)
  176. 2087 0.008 0.000 0.012 0.000 query_utils.py:43(__init__)
  177. 4 0.000 0.000 0.000 0.000 re.py:248(_compile_repl)
  178. 4 0.000 0.000 0.000 0.000 re.py:268(_subx)
  179. 3 0.000 0.000 0.000 0.000 related.py:215(related_query_name)
  180. 2085 0.021 0.000 0.488 0.000 related.py:308(get_query_set)
  181. 4172/2087 0.038 0.000 3.542 0.002 related.py:331(__get__)
  182. 3 0.000 0.000 0.000 0.000 related.py:852(is_hidden)
  183. 2085 0.004 0.000 0.005 0.000 related.py:856(get_related_field)
  184. 1 0.000 0.000 0.000 0.000 sre_parse.py:178(__init__)
  185. 4 0.000 0.000 0.000 0.000 sre_parse.py:182(__next)
  186. 3 0.000 0.000 0.000 0.000 sre_parse.py:201(get)
  187. 1 0.000 0.000 0.000 0.000 sre_parse.py:691(parse_template)
  188. 1 0.000 0.000 0.000 0.000 sre_parse.py:698(literal)
  189. 2089 0.007 0.000 0.010 0.000 tree.py:120(start_subtree)
  190. 2089 0.007 0.000 0.011 0.000 tree.py:140(end_subtree)
  191. 25050 0.030 0.000 0.030 0.000 tree.py:18(__init__)
  192. 14611/12522 0.055 0.000 0.520 0.000 tree.py:55(__deepcopy__)
  193. 2087 0.002 0.000 0.002 0.000 tree.py:71(__nonzero__)
  194. 2089 0.005 0.000 0.006 0.000 tree.py:83(add)
  195. 2464 0.003 0.000 0.010 0.000 utf_8.py:15(decode)
  196. 1 0.000 0.000 0.000 0.000 utf_8.py:33(getregentry)
  197. 2087 0.001 0.000 0.001 0.000 util.py:15(__init__)
  198. 6264 0.005 0.000 0.027 0.000 util.py:19(set_dirty)
  199. 4177 0.007 0.000 0.037 0.000 util.py:23(__getattr__)
  200. 2087 0.039 0.000 0.788 0.000 util.py:36(execute)
  201. 2089 0.002 0.000 0.002 0.000 utils.py:128(_route_db)
  202. 4174 0.005 0.000 0.008 0.000 utils.py:86(__getitem__)
  203. 1 0.000 0.000 0.000 0.000 version.py:24(get_version)
  204. 378/1 0.002 0.000 0.008 0.008 views.py:310(recursive_node_to_dict)
  205. 1 0.000 0.000 3.659 3.659 views.py:328(profileJSON)
  206. 2089 0.017 0.000 0.091 0.000 where.py:130(make_atom)
  207. 2089 0.006 0.000 0.019 0.000 where.py:219(sql_for_columns)
  208. 2089 0.003 0.000 0.003 0.000 where.py:291(__init__)
  209. 2089 0.004 0.000 0.005 0.000 where.py:294(__getstate__)
  210. 2089 0.008 0.000 0.021 0.000 where.py:308(__setstate__)
  211. 2089 0.002 0.000 0.013 0.000 where.py:318(prepare)
  212. 2089 0.020 0.000 0.050 0.000 where.py:323(process)
  213. 2089 0.012 0.000 0.038 0.000 where.py:39(add)
  214. 6263/4174 0.022 0.000 0.122 0.000 where.py:74(as_sql)
  215. 2 0.000 0.000 0.001 0.000 {__import__}
  216. 2464 0.007 0.000 0.007 0.000 {_codecs.utf_8_decode}
  217. 3024 0.001 0.000 0.001 0.000 {_json.encode_basestring_ascii}
  218. 3 0.000 0.000 0.000 0.000 {all}
  219. 68874 0.075 0.000 0.075 0.000 {built-in method __new__ of type object at 0x10017ff20}
  220. 2089 0.000 0.000 0.000 0.000 {callable}
  221. 1 0.000 0.000 0.000 0.000 {chr}
  222. 1 0.000 0.000 0.000 0.000 {filter}
  223. 3 0.000 0.000 0.000 0.000 {function __getitem__ at 0x1011dede8}
  224. 79133/74956 0.045 0.000 0.048 0.000 {getattr}
  225. 51627 0.057 0.000 0.057 0.000 {hasattr}
  226. 325547 0.035 0.000 0.035 0.000 {id}
  227. 94290 0.035 0.000 0.035 0.000 {isinstance}
  228. 31309 0.012 0.000 0.012 0.000 {issubclass}
  229. 4552 0.002 0.000 0.002 0.000 {iter}
  230. 59987/9131 0.013 0.000 3.231 0.000 {len}
  231. 8353 0.009 0.000 0.009 0.000 {map}
  232. 8350 0.038 0.000 0.043 0.000 {method '__reduce_ex__' of 'object' objects}
  233. 39659 0.011 0.000 0.011 0.000 {method 'add' of 'set' objects}
  234. 186943 0.045 0.000 0.045 0.000 {method 'append' of 'list' objects}
  235. 39655 0.010 0.000 0.010 0.000 {method 'copy' of 'dict' objects}
  236. 2088 0.003 0.000 0.003 0.000 {method 'cursor' of 'psycopg2._psycopg.connection' objects}
  237. 1 0.000 0.000 0.000 0.000 {method 'disable' of '_lsprof.Profiler' objects}
  238. 2088 0.633 0.000 0.715 0.000 {method 'execute' of 'psycopg2._psycopg.cursor' objects}
  239. 14617 0.003 0.000 0.003 0.000 {method 'extend' of 'list' objects}
  240. 4177 0.028 0.000 0.040 0.000 {method 'fetchmany' of 'psycopg2._psycopg.cursor' objects}
  241. 244249 0.041 0.000 0.041 0.000 {method 'get' of 'dict' objects}
  242. 1 0.000 0.000 0.000 0.000 {method 'get_parameter_status' of 'psycopg2._psycopg.connection' objects}
  243. 2088 0.001 0.000 0.001 0.000 {method 'items' of 'dict' objects}
  244. 2468 0.001 0.000 0.001 0.000 {method 'iteritems' of 'dict' objects}
  245. 8357 0.007 0.000 0.007 0.000 {method 'join' of 'str' objects}
  246. 6261 0.001 0.000 0.001 0.000 {method 'keys' of 'dict' objects}
  247. 1 0.000 0.000 0.000 0.000 {method 'lower' of 'str' objects}
  248. 6 0.000 0.000 0.000 0.000 {method 'match' of '_sre.SRE_Pattern' objects}
  249. 4178 0.001 0.000 0.001 0.000 {method 'pop' of 'dict' objects}
  250. 8729 0.004 0.000 0.004 0.000 {method 'pop' of 'list' objects}
  251. 1 0.000 0.000 0.000 0.000 {method 'replace' of 'str' objects}
  252. 4 0.000 0.000 0.000 0.000 {method 'search' of '_sre.SRE_Pattern' objects}
  253. 1 0.000 0.000 0.000 0.000 {method 'set_client_encoding' of 'psycopg2._psycopg.connection' objects}
  254. 2 0.001 0.000 0.001 0.000 {method 'set_isolation_level' of 'psycopg2._psycopg.connection' objects}
  255. 2095 0.003 0.000 0.003 0.000 {method 'split' of 'str' objects}
  256. 41747 0.017 0.000 0.017 0.000 {method 'startswith' of 'str' objects}
  257. 4 0.000 0.000 0.000 0.000 {method 'sub' of '_sre.SRE_Pattern' objects}
  258. 1 0.000 0.000 0.000 0.000 {method 'translate' of 'str' objects}
  259. 14612 0.007 0.000 0.007 0.000 {method 'update' of 'dict' objects}
  260. 4176 0.004 0.000 0.004 0.000 {method 'update' of 'set' objects}
  261. 1 0.003 0.003 0.003 0.003 {psycopg2._psycopg._connect}
  262. 16704 0.012 0.000 0.012 0.000 {range}
  263. 46437 0.018 0.000 0.018 0.000 {setattr}
  264. 2087 0.001 0.000 0.001 0.000 {thread.get_ident}
  265. 4174 0.002 0.000 0.002 0.000 {time.time}
  266. 8353 0.006 0.000 0.006 0.000 {zip}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement