Solution 6:

2593122 function calls (2299165 primitive calls) in 3.663 seconds

   Ordered by: standard name

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.005    0.005    3.663    3.663 <string>:1(<module>)
    37566    0.023    0.000    0.082    0.000 <string>:8(__new__)
        4    0.000    0.000    0.000    0.000 __init__.py:102(_param_escape)
     2087    0.002    0.000    0.008    0.000 __init__.py:1118(debug)
        3    0.000    0.000    0.000    0.000 __init__.py:1118(get_internal_type)
        1    0.000    0.000    0.004    0.004 __init__.py:119(connect)
     2087    0.003    0.000    0.004    0.000 __init__.py:123(validate_thread_sharing)
     2087    0.004    0.000    0.004    0.000 __init__.py:1318(getEffectiveLevel)
     2087    0.003    0.000    0.006    0.000 __init__.py:1332(isEnabledFor)
     6264    0.014    0.000    0.022    0.000 __init__.py:172(is_managed)
        1    0.000    0.000    0.058    0.058 __init__.py:185(dumps)
     2089    0.008    0.000    0.018    0.000 __init__.py:204(db_type)
     2089    0.001    0.000    0.001    0.000 __init__.py:276(get_db_prep_value)
     2089    0.005    0.000    0.011    0.000 __init__.py:294(get_prep_lookup)
     2087    0.012    0.000    0.045    0.000 __init__.py:302(cursor)
     2087    0.003    0.000    0.004    0.000 __init__.py:311(make_debug_cursor)
     2089    0.006    0.000    0.013    0.000 __init__.py:322(get_db_prep_lookup)
     4928    0.003    0.000    0.005    0.000 __init__.py:489(value_from_object)
        1    0.000    0.000    0.000    0.000 __init__.py:49(normalize_encoding)
     2086    0.001    0.000    0.001    0.000 __init__.py:519(get_internal_type)
     2086    0.002    0.000    0.002    0.000 __init__.py:534(get_prep_value)
     2087    0.002    0.000    0.003    0.000 __init__.py:659(compiler)
        1    0.000    0.000    0.000    0.000 __init__.py:71(search_function)
        3    0.000    0.000    0.000    0.000 __init__.py:963(get_prep_value)
        3    0.000    0.000    0.000    0.000 __init__.py:968(get_prep_lookup)
        1    0.000    0.000    0.000    0.000 base.py:151(_get_pg_version)
     2087    0.010    0.000    0.021    0.000 base.py:157(_cursor)
     2464    0.002    0.000    0.002    0.000 base.py:267(__init__)
     2464    0.053    0.000    0.117    0.000 base.py:278(__init__)
     4928    0.002    0.000    0.002    0.000 base.py:36(utc_tzinfo_factory)
      378    0.000    0.000    0.000    0.000 base.py:425(_get_pk_val)
     2087    0.001    0.000    0.001    0.000 base.py:47(__init__)
     2087    0.003    0.000    0.718    0.000 base.py:50(execute)
     6264    0.007    0.000    0.010    0.000 base.py:66(__getattr__)
        1    0.000    0.000    0.000    0.000 codecs.py:77(__new__)
        1    0.000    0.000    0.000    0.000 compiler.py:1(<module>)
        1    0.000    0.000    0.000    0.000 compiler.py:1041(SQLAggregateCompiler)
        1    0.000    0.000    0.000    0.000 compiler.py:1060(SQLDateCompiler)
        1    0.000    0.000    0.000    0.000 compiler.py:14(SQLCompiler)
     2087    0.002    0.000    0.002    0.000 compiler.py:15(__init__)
     2087    0.024    0.000    0.235    0.000 compiler.py:168(get_columns)
     2087    0.004    0.000    0.015    0.000 compiler.py:21(pre_sql_setup)
     2087    0.104    0.000    0.194    0.000 compiler.py:248(get_default_columns)
     2087    0.002    0.000    0.002    0.000 compiler.py:313(get_distinct)
     2087    0.006    0.000    0.006    0.000 compiler.py:333(get_ordering)
    43833    0.028    0.000    0.039    0.000 compiler.py:37(quote_name_unless_alias)
        2    0.000    0.000    0.000    0.000 compiler.py:418(find_ordering_name)
        2    0.000    0.000    0.000    0.000 compiler.py:448(_setup_joins)
        2    0.000    0.000    0.000    0.000 compiler.py:476(_final_join_removal)
     2087    0.010    0.000    0.011    0.000 compiler.py:495(get_from_clause)
     2087    0.041    0.000    0.512    0.000 compiler.py:53(as_sql)
     2087    0.002    0.000    0.002    0.000 compiler.py:539(get_grouping)
     2087    0.003    0.000    0.004    0.000 compiler.py:741(deferred_to_columns)
     4551    0.021    0.000    1.480    0.000 compiler.py:751(results_iter)
     2087    0.019    0.000    1.365    0.001 compiler.py:794(execute_sql)
     4177    0.012    0.000    0.090    0.000 compiler.py:832(<lambda>)
        1    0.000    0.000    0.000    0.000 compiler.py:842(SQLInsertCompiler)
        1    0.000    0.000    0.000    0.000 compiler.py:919(SQLDeleteCompiler)
        1    0.000    0.000    0.000    0.000 compiler.py:933(SQLUpdateCompiler)
114823/25044    0.351    0.000    1.059    0.000 copy.py:145(deepcopy)
    29223    0.005    0.000    0.005    0.000 copy.py:198(_deepcopy_atomic)
35483/31305    0.035    0.000    0.336    0.000 copy.py:226(_deepcopy_list)
16700/8350    0.102    0.000    0.549    0.000 copy.py:234(_deepcopy_tuple)
     2089    0.012    0.000    0.072    0.000 copy.py:253(_deepcopy_dict)
   112717    0.147    0.000    0.183    0.000 copy.py:267(_keep_alive)
     8350    0.043    0.000    0.317    0.000 copy.py:306(_reconstruct)
     2089    0.001    0.000    0.002    0.000 copy_reg.py:92(__newobj__)
    29218    0.051    0.000    0.066    0.000 datastructures.py:103(__new__)
    29218    0.095    0.000    0.124    0.000 datastructures.py:108(__init__)
     6261    0.019    0.000    0.070    0.000 datastructures.py:127(__deepcopy__)
     4180    0.010    0.000    0.010    0.000 datastructures.py:131(__setitem__)
     8353    0.010    0.000    0.032    0.000 datastructures.py:157(items)
     8348    0.004    0.000    0.004    0.000 datastructures.py:160(iteritems)
    32061    0.014    0.000    0.014    0.000 datastructures.py:164(keys)
     8353    0.008    0.000    0.016    0.000 datastructures.py:170(values)
     2087    0.001    0.000    0.001    0.000 datastructures.py:173(itervalues)
    16696    0.036    0.000    0.146    0.000 datastructures.py:200(copy)
     2089    0.009    0.000    0.009    0.000 datastructures.py:489(__init__)
        3    0.000    0.000    0.000    0.000 datastructures.py:494(__getitem__)
     4929    0.008    0.000    0.042    0.000 dispatcher.py:149(send)
     4928    0.010    0.000    0.020    0.000 dispatcher.py:214(_live_receivers)
     9856    0.008    0.000    0.023    0.000 dispatcher.py:8(_make_id)
        1    0.000    0.000    0.000    0.000 encoder.py:102(__init__)
        1    0.002    0.002    0.058    0.058 encoder.py:180(encode)
        1    0.000    0.000    0.000    0.000 encoder.py:206(iterencode)
        1    0.000    0.000    0.000    0.000 encoder.py:266(_make_iterencode)
70423/10693    0.022    0.000    0.052    0.000 encoder.py:282(_iterencode_list)
69558/10690    0.026    0.000    0.048    0.000 encoder.py:335(_iterencode_dict)
    10693    0.004    0.000    0.055    0.000 encoder.py:411(_iterencode)
    10439    0.009    0.000    0.013    0.000 functional.py:182(inner)
        1    0.000    0.000    0.001    0.001 importlib.py:18(import_module)
        1    0.000    0.000    0.000    0.000 loading.py:115(app_cache_ready)
        2    0.000    0.000    0.000    0.000 manager.py:106(get_query_set)
        1    0.000    0.000    0.009    0.009 manager.py:130(get)
     2086    0.002    0.000    0.002    0.000 manager.py:217(__get__)
        1    0.000    0.000    0.001    0.001 managers.py:101(_mptt_filter)
        2    0.000    0.000    0.001    0.000 managers.py:175(get_query_set)
        4    0.000    0.000    0.000    0.000 managers.py:75(left_attr)
        3    0.000    0.000    0.000    0.000 managers.py:83(tree_id_attr)
        1    0.000    0.000    0.000    0.000 managers.py:91(_translate_lookups)
        1    0.000    0.000    0.000    0.000 models.py:218(__getattr__)
     2464    0.009    0.000    0.176    0.000 models.py:328(__init__)
        4    0.000    0.000    0.000    0.000 models.py:332(_mpttfield)
        1    0.000    0.000    0.001    0.001 models.py:400(get_descendants)
        1    0.000    0.000    0.000    0.000 models.py:428(get_descendant_count)
      378    0.000    0.000    0.000    0.000 models.py:525(get_level)
        1    0.000    0.000    0.000    0.000 models.py:545(is_leaf_node)
 2464/379    0.025    0.000    3.570    0.009 models.py:55(__init__)
     4928    0.010    0.000    0.039    0.000 models.py:63(get_raw_field_value)
 2086/378    0.004    0.000    0.006    0.000 models.py:75(get_wbs_code)
     2464    0.011    0.000    0.051    0.000 models.py:82(update_mptt_cached_fields)
        1    0.001    0.001    3.583    3.583 mptt_tags.py:224(cache_tree_children)
     2087    0.000    0.000    0.000    0.000 operations.py:171(max_name_length)
     2087    0.008    0.000    0.012    0.000 operations.py:191(last_executed_query)
     2089    0.002    0.000    0.002    0.000 operations.py:40(lookup_cast)
     2089    0.001    0.000    0.001    0.000 operations.py:54(field_cast_sql)
    41743    0.034    0.000    0.051    0.000 operations.py:69(quote_name)
        1    0.000    0.000    0.000    0.000 operations.py:74(set_time_zone_sql)
    18206    0.010    0.000    0.010    0.000 options.py:216(_fields)
     4175    0.002    0.000    0.002    0.000 options.py:231(get_fields_with_model)
     9104    0.009    0.000    0.013    0.000 options.py:255(_many_to_many)
        1    0.000    0.000    0.000    0.000 options.py:263(get_m2m_with_model)
     9104    0.028    0.000    0.046    0.000 options.py:285(get_field)
     4176    0.004    0.000    0.004    0.000 options.py:295(get_field_by_name)
        1    0.000    0.000    0.000    0.000 options.py:334(init_name_map)
        1    0.000    0.000    0.000    0.000 options.py:368(get_all_related_objects_with_model)
        3    0.000    0.000    0.000    0.000 options.py:383(<lambda>)
        3    0.000    0.000    0.000    0.000 options.py:386(<lambda>)
        1    0.000    0.000    0.000    0.000 options.py:421(get_all_related_m2m_objects_with_model)
     2087    0.037    0.000    0.074    0.000 query.py:101(__init__)
     2089    0.044    0.000    0.169    0.000 query.py:1030(add_filter)
      381    0.000    0.000    3.581    0.009 query.py:108(_result_iter)
        1    0.000    0.000    0.921    0.921 query.py:120(__nonzero__)
     2087    0.018    0.000    0.214    0.000 query.py:1219(add_q)
     2091    0.017    0.000    0.025    0.000 query.py:1270(setup_joins)
     2089    0.004    0.000    0.006    0.000 query.py:1481(trim_joins)
     6262    0.003    0.000    0.003    0.000 query.py:1614(can_filter)
     2089    0.002    0.000    0.002    0.000 query.py:1672(add_ordering)
     2089    0.001    0.000    0.001    0.000 query.py:1692(clear_ordering)
     2087    0.003    0.000    0.004    0.000 query.py:1847(get_loaded_field_names)
     8350    0.004    0.000    0.004    0.000 query.py:1886(_aggregate_select)
    12525    0.006    0.000    0.006    0.000 query.py:1904(_extra_select)
        6    0.000    0.000    0.000    0.000 query.py:1955(get_order_dir)
     2087    0.010    0.000    0.028    0.000 query.py:215(get_compiler)
     2089    0.001    0.000    0.001    0.000 query.py:227(get_meta)
 4551/381    0.039    0.000    3.587    0.009 query.py:231(iterator)
     6261    0.142    0.000    1.326    0.000 query.py:235(clone)
     8348    0.019    0.000    0.093    0.000 query.py:32(__init__)
 2086/378    0.018    0.000    3.457    0.009 query.py:353(get)
     4174    0.002    0.000    0.002    0.000 query.py:559(deferred_to_data)
     2087    0.003    0.000    0.577    0.000 query.py:616(filter)
     2087    0.010    0.000    0.574    0.000 query.py:630(_filter_or_exclude)
     2087    0.007    0.000    0.014    0.000 query.py:649(table_alias)
        6    0.000    0.000    0.000    0.000 query.py:675(ref_alias)
     2087    0.005    0.000    0.009    0.000 query.py:679(unref_alias)
        2    0.000    0.000    0.000    0.000 query.py:683(promote_alias)
        2    0.000    0.000    0.000    0.000 query.py:700(promote_alias_chain)
     2087    0.009    0.000    0.047    0.000 query.py:710(reset_refcounts)
     2089    0.008    0.000    0.670    0.000 query.py:748(order_by)
 2086/378    0.017    0.000    3.229    0.009 query.py:77(__len__)
     2085    0.002    0.000    0.378    0.000 query.py:817(using)
     2091    0.003    0.000    0.027    0.000 query.py:831(get_initial_alias)
     4174    0.002    0.000    0.002    0.000 query.py:842(db)
     2087    0.008    0.000    0.023    0.000 query.py:851(join)
     6261    0.031    0.000    1.371    0.000 query.py:853(_clone)
        4    0.001    0.000    3.580    0.895 query.py:867(_fill_cache)
        2    0.000    0.000    0.000    0.000 query.py:92(__iter__)
     2087    0.010    0.000    0.011    0.000 query.py:929(setup_inherited_models)
     2087    0.008    0.000    0.012    0.000 query_utils.py:43(__init__)
        4    0.000    0.000    0.000    0.000 re.py:248(_compile_repl)
        4    0.000    0.000    0.000    0.000 re.py:268(_subx)
        3    0.000    0.000    0.000    0.000 related.py:215(related_query_name)
     2085    0.021    0.000    0.488    0.000 related.py:308(get_query_set)
4172/2087    0.038    0.000    3.542    0.002 related.py:331(__get__)
        3    0.000    0.000    0.000    0.000 related.py:852(is_hidden)
     2085    0.004    0.000    0.005    0.000 related.py:856(get_related_field)
        1    0.000    0.000    0.000    0.000 sre_parse.py:178(__init__)
        4    0.000    0.000    0.000    0.000 sre_parse.py:182(__next)
        3    0.000    0.000    0.000    0.000 sre_parse.py:201(get)
        1    0.000    0.000    0.000    0.000 sre_parse.py:691(parse_template)
        1    0.000    0.000    0.000    0.000 sre_parse.py:698(literal)
     2089    0.007    0.000    0.010    0.000 tree.py:120(start_subtree)
     2089    0.007    0.000    0.011    0.000 tree.py:140(end_subtree)
    25050    0.030    0.000    0.030    0.000 tree.py:18(__init__)
14611/12522    0.055    0.000    0.520    0.000 tree.py:55(__deepcopy__)
     2087    0.002    0.000    0.002    0.000 tree.py:71(__nonzero__)
     2089    0.005    0.000    0.006    0.000 tree.py:83(add)
     2464    0.003    0.000    0.010    0.000 utf_8.py:15(decode)
        1    0.000    0.000    0.000    0.000 utf_8.py:33(getregentry)
     2087    0.001    0.000    0.001    0.000 util.py:15(__init__)
     6264    0.005    0.000    0.027    0.000 util.py:19(set_dirty)
     4177    0.007    0.000    0.037    0.000 util.py:23(__getattr__)
     2087    0.039    0.000    0.788    0.000 util.py:36(execute)
     2089    0.002    0.000    0.002    0.000 utils.py:128(_route_db)
     4174    0.005    0.000    0.008    0.000 utils.py:86(__getitem__)
        1    0.000    0.000    0.000    0.000 version.py:24(get_version)
    378/1    0.002    0.000    0.008    0.008 views.py:310(recursive_node_to_dict)
        1    0.000    0.000    3.659    3.659 views.py:328(profileJSON)
     2089    0.017    0.000    0.091    0.000 where.py:130(make_atom)
     2089    0.006    0.000    0.019    0.000 where.py:219(sql_for_columns)
     2089    0.003    0.000    0.003    0.000 where.py:291(__init__)
     2089    0.004    0.000    0.005    0.000 where.py:294(__getstate__)
     2089    0.008    0.000    0.021    0.000 where.py:308(__setstate__)
     2089    0.002    0.000    0.013    0.000 where.py:318(prepare)
     2089    0.020    0.000    0.050    0.000 where.py:323(process)
     2089    0.012    0.000    0.038    0.000 where.py:39(add)
6263/4174    0.022    0.000    0.122    0.000 where.py:74(as_sql)
        2    0.000    0.000    0.001    0.000 {__import__}
     2464    0.007    0.000    0.007    0.000 {_codecs.utf_8_decode}
     3024    0.001    0.000    0.001    0.000 {_json.encode_basestring_ascii}
        3    0.000    0.000    0.000    0.000 {all}
    68874    0.075    0.000    0.075    0.000 {built-in method __new__ of type object at 0x10017ff20}
     2089    0.000    0.000    0.000    0.000 {callable}
        1    0.000    0.000    0.000    0.000 {chr}
        1    0.000    0.000    0.000    0.000 {filter}
        3    0.000    0.000    0.000    0.000 {function __getitem__ at 0x1011dede8}
79133/74956    0.045    0.000    0.048    0.000 {getattr}
    51627    0.057    0.000    0.057    0.000 {hasattr}
   325547    0.035    0.000    0.035    0.000 {id}
    94290    0.035    0.000    0.035    0.000 {isinstance}
    31309    0.012    0.000    0.012    0.000 {issubclass}
     4552    0.002    0.000    0.002    0.000 {iter}
59987/9131    0.013    0.000    3.231    0.000 {len}
     8353    0.009    0.000    0.009    0.000 {map}
     8350    0.038    0.000    0.043    0.000 {method '__reduce_ex__' of 'object' objects}
    39659    0.011    0.000    0.011    0.000 {method 'add' of 'set' objects}
   186943    0.045    0.000    0.045    0.000 {method 'append' of 'list' objects}
    39655    0.010    0.000    0.010    0.000 {method 'copy' of 'dict' objects}
     2088    0.003    0.000    0.003    0.000 {method 'cursor' of 'psycopg2._psycopg.connection' objects}
        1    0.000    0.000    0.000    0.000 {method 'disable' of '_lsprof.Profiler' objects}
     2088    0.633    0.000    0.715    0.000 {method 'execute' of 'psycopg2._psycopg.cursor' objects}
    14617    0.003    0.000    0.003    0.000 {method 'extend' of 'list' objects}
     4177    0.028    0.000    0.040    0.000 {method 'fetchmany' of 'psycopg2._psycopg.cursor' objects}
   244249    0.041    0.000    0.041    0.000 {method 'get' of 'dict' objects}
        1    0.000    0.000    0.000    0.000 {method 'get_parameter_status' of 'psycopg2._psycopg.connection' objects}
     2088    0.001    0.000    0.001    0.000 {method 'items' of 'dict' objects}
     2468    0.001    0.000    0.001    0.000 {method 'iteritems' of 'dict' objects}
     8357    0.007    0.000    0.007    0.000 {method 'join' of 'str' objects}
     6261    0.001    0.000    0.001    0.000 {method 'keys' of 'dict' objects}
        1    0.000    0.000    0.000    0.000 {method 'lower' of 'str' objects}
        6    0.000    0.000    0.000    0.000 {method 'match' of '_sre.SRE_Pattern' objects}
     4178    0.001    0.000    0.001    0.000 {method 'pop' of 'dict' objects}
     8729    0.004    0.000    0.004    0.000 {method 'pop' of 'list' objects}
        1    0.000    0.000    0.000    0.000 {method 'replace' of 'str' objects}
        4    0.000    0.000    0.000    0.000 {method 'search' of '_sre.SRE_Pattern' objects}
        1    0.000    0.000    0.000    0.000 {method 'set_client_encoding' of 'psycopg2._psycopg.connection' objects}
        2    0.001    0.000    0.001    0.000 {method 'set_isolation_level' of 'psycopg2._psycopg.connection' objects}
     2095    0.003    0.000    0.003    0.000 {method 'split' of 'str' objects}
    41747    0.017    0.000    0.017    0.000 {method 'startswith' of 'str' objects}
        4    0.000    0.000    0.000    0.000 {method 'sub' of '_sre.SRE_Pattern' objects}
        1    0.000    0.000    0.000    0.000 {method 'translate' of 'str' objects}
    14612    0.007    0.000    0.007    0.000 {method 'update' of 'dict' objects}
     4176    0.004    0.000    0.004    0.000 {method 'update' of 'set' objects}
        1    0.003    0.003    0.003    0.003 {psycopg2._psycopg._connect}
    16704    0.012    0.000    0.012    0.000 {range}
    46437    0.018    0.000    0.018    0.000 {setattr}
     2087    0.001    0.000    0.001    0.000 {thread.get_ident}
     4174    0.002    0.000    0.002    0.000 {time.time}
     8353    0.006    0.000    0.006    0.000 {zip}