API tools faq
paste
Advertisement
Guest User

solution 3 - profile

a guest
Sep 24th, 2012
452
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.90 KB | None | 0 0
raw download clone embed print report
  1. #Solution 3 profile
  2.  
  3. 2533621 function calls (2354441 primitive calls) in 3.684 seconds
  4.  
  5. Ordered by: standard name
  6.  
  7. ncalls tottime percall cumtime percall filename:lineno(function)
  8. 1 0.000 0.000 3.684 3.684 <string>:1(<module>)
  9. 39456 0.025 0.000 0.048 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.008 0.000 0.018 0.000 __init__.py:204(db_type)
  19. 2192 0.001 0.000 0.001 0.000 __init__.py:276(get_db_prep_value)
  20. 2192 0.005 0.000 0.011 0.000 __init__.py:294(get_prep_lookup)
  21. 2192 0.012 0.000 0.045 0.000 __init__.py:302(cursor)
  22. 2192 0.003 0.000 0.005 0.000 __init__.py:311(make_debug_cursor)
  23. 2192 0.007 0.000 0.013 0.000 __init__.py:322(get_db_prep_lookup)
  24. 4926 0.003 0.000 0.005 0.000 __init__.py:489(value_from_object)
  25. 2086 0.000 0.000 0.000 0.000 __init__.py:519(get_internal_type)
  26. 2192 0.002 0.000 0.002 0.000 __init__.py:534(get_prep_value)
  27. 2192 0.002 0.000 0.002 0.000 __init__.py:659(compiler)
  28. 106 0.002 0.000 0.003 0.000 __init__.py:76(__init__)
  29. 106 0.000 0.000 0.000 0.000 __init__.py:974(get_internal_type)
  30. 1 0.000 0.000 0.000 0.000 base.py:151(_get_pg_version)
  31. 2192 0.010 0.000 0.021 0.000 base.py:157(_cursor)
  32. 2463 0.002 0.000 0.002 0.000 base.py:267(__init__)
  33. 2463 0.055 0.000 0.119 0.000 base.py:278(__init__)
  34. 4926 0.002 0.000 0.002 0.000 base.py:36(utc_tzinfo_factory)
  35. 378 0.000 0.000 0.001 0.000 base.py:425(_get_pk_val)
  36. 2192 0.001 0.000 0.001 0.000 base.py:47(__init__)
  37. 2192 0.003 0.000 0.720 0.000 base.py:50(execute)
  38. 6576 0.007 0.000 0.010 0.000 base.py:66(__getattr__)
  39. 2192 0.002 0.000 0.002 0.000 compiler.py:15(__init__)
  40. 2192 0.025 0.000 0.238 0.000 compiler.py:168(get_columns)
  41. 2192 0.004 0.000 0.015 0.000 compiler.py:21(pre_sql_setup)
  42. 2192 0.104 0.000 0.196 0.000 compiler.py:248(get_default_columns)
  43. 2192 0.002 0.000 0.002 0.000 compiler.py:313(get_distinct)
  44. 2192 0.009 0.000 0.017 0.000 compiler.py:333(get_ordering)
  45. 46244 0.029 0.000 0.040 0.000 compiler.py:37(quote_name_unless_alias)
  46. 212 0.001 0.000 0.007 0.000 compiler.py:418(find_ordering_name)
  47. 212 0.001 0.000 0.006 0.000 compiler.py:448(_setup_joins)
  48. 212 0.000 0.000 0.000 0.000 compiler.py:476(_final_join_removal)
  49. 2192 0.010 0.000 0.012 0.000 compiler.py:495(get_from_clause)
  50. 2192 0.043 0.000 0.538 0.000 compiler.py:53(as_sql)
  51. 2192 0.002 0.000 0.002 0.000 compiler.py:539(get_grouping)
  52. 2192 0.003 0.000 0.004 0.000 compiler.py:741(deferred_to_columns)
  53. 4655 0.021 0.000 1.511 0.000 compiler.py:751(results_iter)
  54. 2192 0.017 0.000 1.393 0.001 compiler.py:794(execute_sql)
  55. 4384 0.013 0.000 0.092 0.000 compiler.py:832(<lambda>)
  56. 117274/25880 0.350 0.000 1.053 0.000 copy.py:145(deepcopy)
  57. 29416 0.005 0.000 0.005 0.000 copy.py:198(_deepcopy_atomic)
  58. 36522/32350 0.035 0.000 0.327 0.000 copy.py:226(_deepcopy_list)
  59. 17112/8556 0.102 0.000 0.546 0.000 copy.py:234(_deepcopy_tuple)
  60. 2086 0.011 0.000 0.070 0.000 copy.py:253(_deepcopy_dict)
  61. 115188 0.145 0.000 0.181 0.000 copy.py:267(_keep_alive)
  62. 8556 0.043 0.000 0.312 0.000 copy.py:306(_reconstruct)
  63. 2086 0.001 0.000 0.002 0.000 copy_reg.py:92(__newobj__)
  64. 31186 0.053 0.000 0.068 0.000 datastructures.py:103(__new__)
  65. 31186 0.098 0.000 0.128 0.000 datastructures.py:108(__init__)
  66. 6470 0.019 0.000 0.070 0.000 datastructures.py:127(__deepcopy__)
  67. 5126 0.011 0.000 0.012 0.000 datastructures.py:131(__setitem__)
  68. 8768 0.010 0.000 0.033 0.000 datastructures.py:157(items)
  69. 8662 0.004 0.000 0.004 0.000 datastructures.py:160(iteritems)
  70. 33209 0.014 0.000 0.014 0.000 datastructures.py:164(keys)
  71. 8768 0.008 0.000 0.017 0.000 datastructures.py:170(values)
  72. 2192 0.001 0.000 0.001 0.000 datastructures.py:173(itervalues)
  73. 17324 0.036 0.000 0.147 0.000 datastructures.py:200(copy)
  74. 2192 0.009 0.000 0.009 0.000 datastructures.py:489(__init__)
  75. 4927 0.008 0.000 0.041 0.000 dispatcher.py:149(send)
  76. 4926 0.010 0.000 0.019 0.000 dispatcher.py:214(_live_receivers)
  77. 9852 0.008 0.000 0.023 0.000 dispatcher.py:8(_make_id)
  78. 1 0.000 0.000 0.001 0.001 encoder.py:180(encode)
  79. 1 0.001 0.001 0.001 0.001 encoder.py:206(iterencode)
  80. 11067 0.010 0.000 0.013 0.000 functional.py:182(inner)
  81. 1 0.000 0.000 0.000 0.000 importlib.py:18(import_module)
  82. 272 0.001 0.000 0.010 0.000 manager.py:103(get_empty_query_set)
  83. 107 0.000 0.000 0.004 0.000 manager.py:106(get_query_set)
  84. 272 0.000 0.000 0.010 0.000 manager.py:112(none)
  85. 1 0.000 0.000 0.008 0.008 manager.py:130(get)
  86. 2086 0.002 0.000 0.002 0.000 manager.py:217(__get__)
  87. 106 0.001 0.000 0.059 0.001 managers.py:101(_mptt_filter)
  88. 107 0.001 0.000 0.025 0.000 managers.py:175(get_query_set)
  89. 106 0.000 0.000 0.000 0.000 managers.py:71(parent_attr)
  90. 107 0.000 0.000 0.000 0.000 managers.py:75(left_attr)
  91. 107 0.000 0.000 0.000 0.000 managers.py:83(tree_id_attr)
  92. 106 0.000 0.000 0.001 0.000 managers.py:91(_translate_lookups)
  93. 2463 0.009 0.000 0.179 0.000 models.py:328(__init__)
  94. 1134 0.001 0.000 0.002 0.000 models.py:332(_mpttfield)
  95. 378 0.001 0.000 0.074 0.000 models.py:377(get_children)
  96. 378 0.001 0.000 0.003 0.000 models.py:428(get_descendant_count)
  97. 378 0.000 0.000 0.003 0.000 models.py:545(is_leaf_node)
  98. 2463/378 0.024 0.000 3.471 0.009 models.py:55(__init__)
  99. 4926 0.010 0.000 0.040 0.000 models.py:63(get_raw_field_value)
  100. 4171/755 0.007 0.000 0.009 0.000 models.py:75(get_wbs_code)
  101. 2463 0.012 0.000 0.051 0.000 models.py:82(update_mptt_cached_fields)
  102. 2192 0.001 0.000 0.001 0.000 operations.py:171(max_name_length)
  103. 2192 0.008 0.000 0.013 0.000 operations.py:191(last_executed_query)
  104. 2192 0.002 0.000 0.002 0.000 operations.py:40(lookup_cast)
  105. 2192 0.001 0.000 0.001 0.000 operations.py:54(field_cast_sql)
  106. 44052 0.034 0.000 0.052 0.000 operations.py:69(quote_name)
  107. 1 0.000 0.000 0.000 0.000 operations.py:74(set_time_zone_sql)
  108. 18619 0.010 0.000 0.010 0.000 options.py:216(_fields)
  109. 4384 0.002 0.000 0.002 0.000 options.py:231(get_fields_with_model)
  110. 9309 0.009 0.000 0.013 0.000 options.py:255(_many_to_many)
  111. 9309 0.029 0.000 0.047 0.000 options.py:285(get_field)
  112. 4595 0.003 0.000 0.003 0.000 options.py:295(get_field_by_name)
  113. 2464 0.039 0.000 0.082 0.000 query.py:101(__init__)
  114. 2192 0.044 0.000 0.201 0.000 query.py:1030(add_filter)
  115. 483 0.001 0.000 3.581 0.007 query.py:108(_result_iter)
  116. 272 0.001 0.000 0.009 0.000 query.py:1121(__init__)
  117. 2192 0.019 0.000 0.246 0.000 query.py:1219(add_q)
  118. 2404 0.043 0.000 0.053 0.000 query.py:1270(setup_joins)
  119. 2192 0.004 0.000 0.007 0.000 query.py:1481(trim_joins)
  120. 6471 0.003 0.000 0.003 0.000 query.py:1614(can_filter)
  121. 2193 0.002 0.000 0.003 0.000 query.py:1672(add_ordering)
  122. 2193 0.001 0.000 0.001 0.000 query.py:1692(clear_ordering)
  123. 2192 0.003 0.000 0.004 0.000 query.py:1847(get_loaded_field_names)
  124. 8980 0.004 0.000 0.004 0.000 query.py:1886(_aggregate_select)
  125. 13364 0.006 0.000 0.006 0.000 query.py:1904(_extra_select)
  126. 636 0.000 0.000 0.000 0.000 query.py:1955(get_order_dir)
  127. 2192 0.011 0.000 0.028 0.000 query.py:215(get_compiler)
  128. 2192 0.001 0.000 0.001 0.000 query.py:227(get_meta)
  129. 4655/485 0.038 0.000 3.585 0.007 query.py:231(iterator)
  130. 6470 0.138 0.000 1.315 0.000 query.py:235(clone)
  131. 8934 0.020 0.000 0.102 0.000 query.py:32(__init__)
  132. 2086/378 0.018 0.000 3.358 0.009 query.py:353(get)
  133. 4384 0.002 0.000 0.002 0.000 query.py:559(deferred_to_data)
  134. 2192 0.003 0.000 0.621 0.000 query.py:616(filter)
  135. 2192 0.010 0.000 0.617 0.000 query.py:630(_filter_or_exclude)
  136. 2298 0.008 0.000 0.016 0.000 query.py:649(table_alias)
  137. 424 0.001 0.000 0.002 0.000 query.py:675(ref_alias)
  138. 2404 0.005 0.000 0.010 0.000 query.py:679(unref_alias)
  139. 212 0.000 0.000 0.000 0.000 query.py:683(promote_alias)
  140. 212 0.000 0.000 0.000 0.000 query.py:700(promote_alias_chain)
  141. 2192 0.010 0.000 0.049 0.000 query.py:710(reset_refcounts)
  142. 2193 0.008 0.000 0.667 0.000 query.py:748(order_by)
  143. 2086/378 0.016 0.000 3.136 0.008 query.py:77(__len__)
  144. 2085 0.002 0.000 0.363 0.000 query.py:817(using)
  145. 2404 0.004 0.000 0.028 0.000 query.py:831(get_initial_alias)
  146. 4384 0.002 0.000 0.003 0.000 query.py:842(db)
  147. 2298 0.009 0.000 0.025 0.000 query.py:851(join)
  148. 6470 0.031 0.000 1.361 0.000 query.py:853(_clone)
  149. 106 0.002 0.000 3.580 0.034 query.py:867(_fill_cache)
  150. 378 0.001 0.000 0.001 0.000 query.py:92(__iter__)
  151. 2192 0.010 0.000 0.011 0.000 query.py:929(setup_inherited_models)
  152. 2192 0.008 0.000 0.013 0.000 query_utils.py:43(__init__)
  153. 4 0.000 0.000 0.000 0.000 re.py:248(_compile_repl)
  154. 4 0.000 0.000 0.000 0.000 re.py:268(_subx)
  155. 106 0.001 0.000 0.005 0.000 related.py:1011(db_type)
  156. 106 0.000 0.000 0.003 0.000 related.py:127(get_prep_lookup)
  157. 106 0.000 0.000 0.003 0.000 related.py:144(get_db_prep_lookup)
  158. 212 0.002 0.000 0.005 0.000 related.py:175(_pk_trace)
  159. 2085 0.020 0.000 0.468 0.000 related.py:308(get_query_set)
  160. 5879/3794 0.038 0.000 3.444 0.001 related.py:331(__get__)
  161. 2191 0.004 0.000 0.005 0.000 related.py:856(get_related_field)
  162. 1 0.000 0.000 0.000 0.000 socket.py:276(close)
  163. 1 0.000 0.000 0.000 0.000 socket.py:285(__del__)
  164. 2192 0.007 0.000 0.010 0.000 tree.py:120(start_subtree)
  165. 2192 0.007 0.000 0.011 0.000 tree.py:140(end_subtree)
  166. 26530 0.030 0.000 0.030 0.000 tree.py:18(__init__)
  167. 15026/12940 0.054 0.000 0.513 0.000 tree.py:55(__deepcopy__)
  168. 2192 0.002 0.000 0.002 0.000 tree.py:71(__nonzero__)
  169. 2192 0.005 0.000 0.007 0.000 tree.py:83(add)
  170. 2463 0.002 0.000 0.009 0.000 utf_8.py:15(decode)
  171. 2192 0.002 0.000 0.002 0.000 util.py:15(__init__)
  172. 6576 0.006 0.000 0.029 0.000 util.py:19(set_dirty)
  173. 4384 0.007 0.000 0.040 0.000 util.py:23(__getattr__)
  174. 2192 0.039 0.000 0.792 0.000 util.py:36(execute)
  175. 2299 0.003 0.000 0.003 0.000 utils.py:128(_route_db)
  176. 4384 0.005 0.000 0.008 0.000 utils.py:86(__getitem__)
  177. 1 0.000 0.000 0.000 0.000 version.py:24(get_version)
  178. 377/1 0.008 0.000 3.671 3.671 views.py:213(serializable_object)
  179. 1 0.000 0.000 3.675 3.675 views.py:220(serializable_object_List_Comprehension)
  180. 1 0.000 0.000 3.684 3.684 views.py:231(profileJSON)
  181. 2192 0.017 0.000 0.099 0.000 where.py:130(make_atom)
  182. 2192 0.006 0.000 0.019 0.000 where.py:219(sql_for_columns)
  183. 2192 0.003 0.000 0.003 0.000 where.py:291(__init__)
  184. 2086 0.004 0.000 0.005 0.000 where.py:294(__getstate__)
  185. 2086 0.007 0.000 0.020 0.000 where.py:308(__setstate__)
  186. 2192 0.003 0.000 0.016 0.000 where.py:318(prepare)
  187. 2192 0.020 0.000 0.057 0.000 where.py:323(process)
  188. 2192 0.012 0.000 0.041 0.000 where.py:39(add)
  189. 6576/4384 0.022 0.000 0.130 0.000 where.py:74(as_sql)
  190. 1 0.000 0.000 0.000 0.000 {__import__}
  191. 2463 0.007 0.000 0.007 0.000 {_codecs.utf_8_decode}
  192. 72728 0.040 0.000 0.040 0.000 {built-in method __new__ of type object at 0x10017ff20}
  193. 2192 0.000 0.000 0.000 0.000 {callable}
  194. 86058/81674 0.047 0.000 0.051 0.000 {getattr}
  195. 54813 0.059 0.000 0.059 0.000 {hasattr}
  196. 332470 0.035 0.000 0.035 0.000 {id}
  197. 90372 0.033 0.000 0.033 0.000 {isinstance}
  198. 32138 0.012 0.000 0.012 0.000 {issubclass}
  199. 4927 0.002 0.000 0.002 0.000 {iter}
  200. 61918/11070 0.013 0.000 3.138 0.000 {len}
  201. 8768 0.009 0.000 0.009 0.000 {map}
  202. 8556 0.039 0.000 0.044 0.000 {method '__reduce_ex__' of 'object' objects}
  203. 42072 0.011 0.000 0.011 0.000 {method 'add' of 'set' objects}
  204. 193301 0.046 0.000 0.046 0.000 {method 'append' of 'list' objects}
  205. 40906 0.009 0.000 0.009 0.000 {method 'copy' of 'dict' objects}
  206. 2193 0.003 0.000 0.003 0.000 {method 'cursor' of 'psycopg2._psycopg.connection' objects}
  207. 1 0.000 0.000 0.000 0.000 {method 'disable' of '_lsprof.Profiler' objects}
  208. 2193 0.670 0.000 0.718 0.000 {method 'execute' of 'psycopg2._psycopg.cursor' objects}
  209. 15452 0.004 0.000 0.004 0.000 {method 'extend' of 'list' objects}
  210. 4384 0.028 0.000 0.039 0.000 {method 'fetchmany' of 'psycopg2._psycopg.cursor' objects}
  211. 250320 0.041 0.000 0.041 0.000 {method 'get' of 'dict' objects}
  212. 1 0.000 0.000 0.000 0.000 {method 'get_parameter_status' of 'psycopg2._psycopg.connection' objects}
  213. 2298 0.001 0.000 0.001 0.000 {method 'items' of 'dict' objects}
  214. 2087 0.001 0.000 0.001 0.000 {method 'iteritems' of 'dict' objects}
  215. 8982 0.006 0.000 0.006 0.000 {method 'join' of 'str' objects}
  216. 7392 0.001 0.000 0.001 0.000 {method 'keys' of 'dict' objects}
  217. 214 0.001 0.000 0.001 0.000 {method 'match' of '_sre.SRE_Pattern' objects}
  218. 4172 0.001 0.000 0.001 0.000 {method 'pop' of 'dict' objects}
  219. 8767 0.004 0.000 0.004 0.000 {method 'pop' of 'list' objects}
  220. 4 0.000 0.000 0.000 0.000 {method 'search' of '_sre.SRE_Pattern' objects}
  221. 1 0.000 0.000 0.000 0.000 {method 'set_client_encoding' of 'psycopg2._psycopg.connection' objects}
  222. 2 0.001 0.000 0.001 0.000 {method 'set_isolation_level' of 'psycopg2._psycopg.connection' objects}
  223. 2510 0.003 0.000 0.003 0.000 {method 'split' of 'str' objects}
  224. 44053 0.018 0.000 0.018 0.000 {method 'startswith' of 'str' objects}
  225. 4 0.000 0.000 0.000 0.000 {method 'sub' of '_sre.SRE_Pattern' objects}
  226. 15451 0.007 0.000 0.007 0.000 {method 'update' of 'dict' objects}
  227. 4384 0.004 0.000 0.004 0.000 {method 'update' of 'set' objects}
  228. 1 0.003 0.003 0.003 0.003 {psycopg2._psycopg._connect}
  229. 17218 0.012 0.000 0.012 0.000 {range}
  230. 46419 0.018 0.000 0.018 0.000 {setattr}
  231. 2192 0.001 0.000 0.001 0.000 {thread.get_ident}
  232. 4384 0.002 0.000 0.002 0.000 {time.time}
  233. 8768 0.006 0.000 0.006 0.000 {zip}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!