CSIL Vendor Get Part ProfilingΒΆ

Raw execution profile SVG of execution profile

Execution Profile

../../../_images/csil.profile2.svg

pstats Output

Tue May 24 00:35:21 2016    /media/ldata/code/tendril/profiling/sourcing/get_part/csil.profile

         1357627 function calls (1339224 primitive calls) in 3.475 seconds

   Ordered by: cumulative time

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.003    0.003    3.481    3.481 vendors.py:63(profile_vendor_get_part)
       45    0.000    0.000    3.477    0.077 vendors.py:509(get_all_vparts)
       44    0.000    0.000    2.444    0.056 vendors.py:519(get_vpart)
       44    0.000    0.000    2.444    0.056 csil.py:262(__init__)
       44    0.000    0.000    2.444    0.056 vendors.py:236(__init__)
       44    0.001    0.000    2.444    0.056 vendors.py:248(_populate)
 1015/221    0.006    0.000    2.362    0.011 db.py:168(inner)
      486    0.003    0.000    1.533    0.003 query.py:2511(__iter__)
      486    0.004    0.000    1.405    0.003 query.py:2525(_execute_and_instances)
      530    0.002    0.000    1.400    0.003 base.py:846(execute)
      530    0.001    0.000    1.397    0.003 elements.py:322(_execute_on_connection)
      530    0.006    0.000    1.396    0.003 base.py:975(_execute_clauseelement)
       44    0.002    0.000    1.336    0.030 vendors.py:265(commit)
       44    0.001    0.000    1.332    0.030 vendors.py:272(_commit_to_db)
      530    0.010    0.000    1.088    0.002 base.py:1061(_execute_context)
      177    0.004    0.000    1.046    0.006 query.py:2393(all)
       45    0.000    0.000    1.032    0.023 vendors.py:504(get_all_vpnos)
       44    0.000    0.000    1.018    0.023 maps.py:73(get_all_partnos)
      530    0.001    0.000    0.962    0.002 default.py:449(do_execute)
      530    0.955    0.002    0.960    0.002 {method 'execute' of 'psycopg2.extensions.cursor' objects}
3307/3219    0.004    0.000    0.892    0.000 attributes.py:229(__get__)
  572/484    0.001    0.000    0.889    0.002 attributes.py:556(get)
       88    0.001    0.000    0.883    0.010 strategies.py:477(_load_for_state)
       88    0.003    0.000    0.882    0.010 strategies.py:550(_emit_lazyload)
       44    0.005    0.000    0.807    0.018 controller.py:181(populate_vpart_prices)
      266    0.003    0.000    0.755    0.003 db.py:111(get_session)
       88    0.003    0.000    0.753    0.009 controller.py:244(get_map_vpnos)
      309    0.007    0.000    0.666    0.002 query.py:2451(one)
       44    0.002    0.000    0.612    0.014 csil.py:270(_get_data)
      170    0.001    0.000    0.573    0.003 yml.py:37(load)
      170    0.008    0.000    0.572    0.003 __init__.py:64(load)
      170    0.001    0.000    0.562    0.003 constructor.py:35(get_single_data)
       44    0.000    0.000    0.550    0.012 vendors.py:88(get_upartnos)
      132    0.003    0.000    0.497    0.004 controller.py:215(get_map)
       44    0.000    0.000    0.468    0.011 vendors.py:84(get_apartnos)
      133    0.002    0.000    0.453    0.003 contextlib.py:21(__exit__)
      133    0.002    0.000    0.442    0.003 session.py:756(commit)
      177    0.004    0.000    0.441    0.002 session.py:389(commit)
      133    0.001    0.000    0.410    0.003 base.py:1569(commit)
      133    0.000    0.000    0.410    0.003 base.py:1603(_do_commit)
      133    0.002    0.000    0.409    0.003 base.py:679(_commit_impl)
      133    0.001    0.000    0.406    0.003 default.py:422(do_commit)
      133    0.405    0.003    0.405    0.003 {method 'commit' of 'psycopg2.extensions.connection' objects}
       44    0.000    0.000    0.399    0.009 controller.py:263(get_umap_vpnos)
       88    0.005    0.000    0.382    0.004 projfile.py:28(__init__)
       88    0.000    0.000    0.368    0.004 conffile.py:46(__init__)
       88    0.001    0.000    0.368    0.004 configbase.py:106(__init__)
       88    0.002    0.000    0.365    0.004 configbase.py:120(get_configs_file)
       44    0.000    0.000    0.356    0.008 controller.py:257(get_amap_vpnos)
      221    0.001    0.000    0.344    0.002 controller.py:45(_get_vendor)
      133    0.002    0.000    0.342    0.003 controller.py:94(get_vendor)
       44    0.001    0.000    0.324    0.007 csil.py:280(_load_descriptors)
       44    0.001    0.000    0.316    0.007 controller.py:113(get_vpno_obj)
      133    0.000    0.000    0.304    0.002 contextlib.py:15(__enter__)
      170    0.173    0.001    0.304    0.002 {method 'get_single_node' of '_yaml.CParser' objects}
      486    0.001    0.000    0.298    0.001 elements.py:431(compile)
      486    0.002    0.000    0.297    0.001 elements.py:496(_compiler)
      486    0.008    0.000    0.295    0.001 compiler.py:329(__init__)
       44    0.003    0.000    0.286    0.007 csil.py:316(_load_prices)
      133    0.003    0.000    0.286    0.002 db.py:83(_get_caller)
      486    0.002    0.000    0.286    0.001 compiler.py:167(__init__)
      486    0.001    0.000    0.283    0.001 compiler.py:212(process)
 9055/486    0.022    0.000    0.282    0.001 visitors.py:75(_compiler_dispatch)
      486    0.014    0.000    0.279    0.001 compiler.py:1503(visit_select)
      133    0.000    0.000    0.273    0.002 inspect.py:1053(stack)
      133    0.004    0.000    0.272    0.002 inspect.py:1026(getouterframes)
     1995    0.017    0.000    0.268    0.000 inspect.py:988(getframeinfo)
      170    0.005    0.000    0.257    0.002 constructor.py:42(construct_document)
9196/5940    0.006    0.000    0.239    0.000 constructor.py:395(construct_yaml_map)
     4598    0.009    0.000    0.231    0.000 constructor.py:205(construct_mapping)
       44    0.002    0.000    0.207    0.005 controller.py:128(populate_vpart_detail)
     4598    0.023    0.000    0.206    0.000 constructor.py:120(construct_mapping)
    32086    0.075    0.000    0.191    0.000 constructor.py:55(construct_object)
     1995    0.022    0.000    0.176    0.000 inspect.py:518(findsource)
     1617    0.011    0.000    0.167    0.000 loading.py:30(instances)
     3225    0.021    0.000    0.128    0.000 compiler.py:1275(_label_select_column)
      486    0.007    0.000    0.122    0.000 query.py:2953(_compile_context)
     4123    0.034    0.000    0.118    0.000 inspect.py:440(getsourcefile)
      973    0.002    0.000    0.102    0.000 session.py:1970(flush)
    32086    0.062    0.000    0.098    0.000 resolver.py:140(resolve)
3136/1103    0.006    0.000    0.097    0.000 operators.py:294(__eq__)
       44    0.002    0.000    0.097    0.002 session.py:2021(_flush)
2385/1323    0.004    0.000    0.093    0.000 {operator.eq}
     3225    0.024    0.000    0.093    0.000 compiler.py:581(visit_label)
     1323    0.006    0.000    0.086    0.000 base.py:196(generate)
      663    0.001    0.000    0.081    0.000 attributes.py:174(operate)
      486    0.009    0.000    0.081    0.000 compiler.py:1679(_compose_select_body)
       44    0.001    0.000    0.080    0.002 unitofwork.py:351(execute)
     1236    0.002    0.000    0.073    0.000 elements.py:738(operate)
   209271    0.066    0.000    0.073    0.000 {isinstance}
     1131    0.013    0.000    0.071    0.000 loading.py:360(_instance)
     1236    0.002    0.000    0.066    0.000 <string>:1(<lambda>)
 1986/706    0.008    0.000    0.064    0.000 visitors.py:86(_compiler_dispatch)
     1236    0.006    0.000    0.063    0.000 type_api.py:57(operate)
      530    0.016    0.000    0.060    0.000 default.py:515(_init_compiled)
     2128    0.008    0.000    0.060    0.000 inspect.py:472(getmodule)
      751    0.005    0.000    0.059    0.000 annotation.py:93(__eq__)
      486    0.011    0.000    0.056    0.000 query.py:3282(row_processor)
      531    0.001    0.000    0.052    0.000 properties.py:268(operate)
     6118    0.020    0.000    0.052    0.000 inspect.py:398(getfile)
      971    0.004    0.000    0.052    0.000 compiler.py:904(visit_binary)
      530    0.004    0.000    0.051    0.000 psycopg2.py:466(get_result_proxy)
      220    0.001    0.000    0.050    0.000 query.py:1511(join)
     4417    0.027    0.000    0.050    0.000 compiler.py:620(visit_column)
      220    0.000    0.000    0.049    0.000 <string>:1(_join)
      486    0.007    0.000    0.049    0.000 query.py:3071(_simple_statement)
    15212    0.012    0.000    0.049    0.000 constructor.py:383(construct_yaml_str)
      486    0.003    0.000    0.048    0.000 query.py:3317(setup_context)
      971    0.006    0.000    0.047    0.000 default_comparator.py:21(_boolean_compare)
      220    0.002    0.000    0.047    0.000 query.py:1800(_join)
       88    0.000    0.000    0.046    0.001 unitofwork.py:528(execute)
      971    0.004    0.000    0.046    0.000 compiler.py:935(_generate_generic_binary)
       88    0.001    0.000    0.046    0.001 persistence.py:124(save_obj)
      530    0.003    0.000    0.045    0.000 result.py:488(__init__)
      486    0.011    0.000    0.045    0.000 loading.py:224(_setup_entity_query)
      486    0.023    0.000    0.044    0.000 loading.py:269(_instance_processor)
     1463    0.003    0.000    0.043    0.000 inspect.py:460(getabsfile)
      530    0.004    0.000    0.043    0.000 result.py:513(_init_metadata)
     1131    0.008    0.000    0.042    0.000 loading.py:478(_populate_full)
    29876    0.042    0.000    0.042    0.000 {method 'match' of '_sre.SRE_Pattern' objects}
      220    0.003    0.000    0.041    0.000 query.py:1915(_join_left_to_right)
    26616    0.022    0.000    0.040    0.000 constructor.py:163(construct_scalar)
      486    0.004    0.000    0.040    0.000 <string>:1(select)
     3009    0.005    0.000    0.039    0.000 {method 'join' of 'str' objects}
      486    0.002    0.000    0.039    0.000 session.py:1245(query)
      486    0.023    0.000    0.038    0.000 result.py:189(__init__)
      486    0.004    0.000    0.038    0.000 compiler.py:1654(_setup_select_stack)
     1551    0.006    0.000    0.038    0.000 posixpath.py:365(abspath)
       88    0.001    0.000    0.038    0.000 persistence.py:597(_emit_update_statements)
      486    0.001    0.000    0.037    0.000 query.py:107(__init__)
     3617    0.008    0.000    0.037    0.000 langhelpers.py:744(__get__)
      265    0.002    0.000    0.037    0.000 compiler.py:735(visit_clauselist)
      486    0.012    0.000    0.037    0.000 selectable.py:2220(__init__)
      486    0.004    0.000    0.036    0.000 query.py:112(_set_entities)
     6526    0.020    0.000    0.035    0.000 constructor.py:227(construct_yaml_int)
      751    0.001    0.000    0.034    0.000 <string>:1(filter)
      220    0.001    0.000    0.034    0.000 query.py:2068(_join_to_left)
      795    0.001    0.000    0.034    0.000 compiler.py:742(<genexpr>)
     1996    0.002    0.000    0.034    0.000 type_api.py:1009(process)
      795    0.001    0.000    0.033    0.000 compiler.py:744(<genexpr>)
     1996    0.002    0.000    0.032    0.000 arrow.py:73(process_result_value)
      220    0.001    0.000    0.031    0.000 util.py:880(join)
      486    0.004    0.000    0.031    0.000 selectable.py:2506(_get_display_froms)
      133    0.002    0.000    0.031    0.000 query.py:1310(filter_by)
      220    0.003    0.000    0.031    0.000 util.py:779(__init__)
     4373    0.011    0.000    0.030    0.000 interfaces.py:498(setup)
     1262    0.002    0.000    0.030    0.000 api.py:17(get)
      486    0.001    0.000    0.028    0.000 query.py:2518(_connection_from_session)
      971    0.004    0.000    0.028    0.000 default_comparator.py:269(_check_literal)
     1262    0.008    0.000    0.027    0.000 factory.py:32(get)
      486    0.002    0.000    0.027    0.000 session.py:811(connection)
      132    0.001    0.000    0.026    0.000 relationships.py:961(__eq__)
     4211    0.007    0.000    0.026    0.000 genericpath.py:15(exists)
      310    0.003    0.000    0.025    0.000 session.py:456(close)
      220    0.002    0.000    0.025    0.000 selectable.py:651(__init__)
      751    0.006    0.000    0.024    0.000 query.py:1274(filter)
      486    0.002    0.000    0.024    0.000 result.py:944(fetchall)
      486    0.010    0.000    0.023    0.000 selectable.py:2479(_froms)
     3975    0.012    0.000    0.023    0.000 compiler.py:1130(_truncated_identifier)
      486    0.001    0.000    0.023    0.000 session.py:884(_connection_for_bind)
       44    0.001    0.000    0.023    0.001 unitofwork.py:300(_generate_actions)
  838/662    0.003    0.000    0.023    0.000 session.py:312(_connection_for_bind)
      750    0.003    0.000    0.022    0.000 compiler.py:1048(visit_bindparam)
      530    0.003    0.000    0.022    0.000 elements.py:3370(_bind_param)
    22963    0.021    0.000    0.021    0.000 {getattr}
      220    0.001    0.000    0.020    0.000 selectable.py:786(_match_primaries)
     1639    0.012    0.000    0.020    0.000 posixpath.py:336(normpath)
      220    0.002    0.000    0.020    0.000 selectable.py:793(_join_condition)
     4332    0.011    0.000    0.019    0.000 constructor.py:260(construct_yaml_float)
    12766    0.011    0.000    0.019    0.000 compiler.py:2693(quote)
     4211    0.019    0.000    0.019    0.000 {posix.stat}
      530    0.011    0.000    0.019    0.000 elements.py:913(__init__)
      440    0.003    0.000    0.018    0.000 unitofwork.py:417(execute)
     5521    0.018    0.000    0.018    0.000 interfaces.py:466(_get_context_loader)
      443    0.002    0.000    0.018    0.000 session.py:694(begin)
     4147    0.008    0.000    0.017    0.000 inspection.py:38(inspect)
    26616    0.017    0.000    0.017    0.000 nodes.py:27(__init__)
    15742    0.016    0.000    0.016    0.000 {method 'encode' of 'unicode' objects}
  928/664    0.002    0.000    0.016    0.000 annotation.py:71(_compiler_dispatch)
      486    0.001    0.000    0.016    0.000 result.py:911(_fetchall_impl)
      750    0.002    0.000    0.016    0.000 compiler.py:1117(_truncate_bindparam)
  530/265    0.001    0.000    0.016    0.000 operators.py:43(__and__)
      133    0.001    0.000    0.015    0.000 base.py:2020(contextual_connect)
      443    0.003    0.000    0.015    0.000 session.py:169(__init__)
     4598    0.014    0.000    0.015    0.000 constructor.py:170(flatten_mapping)
      486    0.004    0.000    0.015    0.000 selectable.py:3151(_columns_plus_names)
      486    0.009    0.000    0.015    0.000 {method 'fetchall' of 'psycopg2.extensions.cursor' objects}
      133    0.001    0.000    0.015    0.000 session.py:2646(__call__)
      264    0.001    0.000    0.014    0.000 elements.py:2758(_copy_internals)
      398    0.001    0.000    0.014    0.000 elements.py:1890(and_)
    20615    0.009    0.000    0.014    0.000 string.py:220(lower)
      220    0.003    0.000    0.014    0.000 mapper.py:2451(_get_state_attr_by_column)
       45    0.000    0.000    0.014    0.000 vendors.py:500(get_idents)
     1192    0.004    0.000    0.014    0.000 _collections.py:794(to_list)
        1    0.000    0.000    0.014    0.014 vendors.py:77(get_idents)
    64100    0.014    0.000    0.014    0.000 {method 'get' of 'dict' objects}
      132    0.002    0.000    0.013    0.000 relationships.py:1334(_optimized_compare)
     1678    0.008    0.000    0.013    0.000 base.py:36(_from_objects)
      133    0.002    0.000    0.013    0.000 session.py:512(__init__)
      486    0.004    0.000    0.013    0.000 query.py:122(_set_entity_selectables)
      398    0.005    0.000    0.013    0.000 elements.py:1856(_construct)
      133    0.001    0.000    0.013    0.000 base.py:793(close)
      265    0.001    0.000    0.013    0.000 {operator.and_}
    26616    0.010    0.000    0.013    0.000 constructor.py:105(construct_scalar)
       88    0.000    0.000    0.013    0.000 session.py:1559(add)
     1744    0.001    0.000    0.012    0.000 constructor.py:390(construct_yaml_seq)
      220    0.002    0.000    0.012    0.000 compiler.py:1803(visit_join)
      530    0.003    0.000    0.012    0.000 compiler.py:455(construct_params)
     3225    0.004    0.000    0.012    0.000 default.py:753(get_result_processor)
      133    0.000    0.000    0.012    0.000 pool.py:879(close)
       88    0.001    0.000    0.012    0.000 session.py:1588(_save_or_update_state)
      132    0.001    0.000    0.012    0.000 visitors.py:280(cloned_traverse)
      133    0.001    0.000    0.012    0.000 pool.py:756(_checkin)
      971    0.007    0.000    0.012    0.000 elements.py:2724(__init__)
     1131    0.006    0.000    0.011    0.000 instrumentation.py:311(new_instance)
  396/132    0.003    0.000    0.011    0.000 visitors.py:287(clone)
     1458    0.006    0.000    0.011    0.000 _collections.py:747(unique_list)
      133    0.001    0.000    0.011    0.000 pool.py:615(_finalize_fairy)
      220    0.003    0.000    0.011    0.000 selectable.py:847(_joincond_scan_left_right)
     1148    0.004    0.000    0.011    0.000 interfaces.py:507(create_row_processor)
      486    0.002    0.000    0.011    0.000 query.py:3159(__new__)
        1    0.000    0.000    0.011    0.011 controller.py:279(get_vendor_idents)
      530    0.003    0.000    0.011    0.000 psycopg2.py:435(create_cursor)
      132    0.000    0.000    0.011    0.000 util.py:746(_orm_annotate)
      872    0.002    0.000    0.011    0.000 constructor.py:112(construct_sequence)
       88    0.004    0.000    0.011    0.000 mapper.py:2555(cascade_iterator)
      265    0.001    0.000    0.011    0.000 default_comparator.py:89(_conjunction_operate)
    10241    0.006    0.000    0.011    0.000 inspect.py:51(ismodule)
      752    0.003    0.000    0.011    0.000 base.py:285(__get__)
      132    0.000    0.000    0.010    0.000 annotation.py:106(_deep_annotate)
  396/132    0.001    0.000    0.010    0.000 annotation.py:113(clone)
      750    0.003    0.000    0.010    0.000 elements.py:3624(apply_map)
      133    0.000    0.000    0.010    0.000 base.py:2071(_wrap_pool_connect)
     1262    0.004    0.000    0.010    0.000 arrow.py:118(fromdatetime)
      486    0.003    0.000    0.010    0.000 compiler.py:438(_bind_processors)
      133    0.000    0.000    0.009    0.000 pool.py:367(connect)
    37581    0.009    0.000    0.009    0.000 {method 'append' of 'list' objects}
      133    0.001    0.000    0.009    0.000 db.py:69(_format_frame)
     8113    0.005    0.000    0.009    0.000 inspect.py:59(isclass)
     1456    0.004    0.000    0.009    0.000 base.py:389(_inspect_mapped_class)
      133    0.001    0.000    0.009    0.000 pool.py:710(_checkout)
      443    0.004    0.000    0.009    0.000 session.py:256(_take_snapshot)
      132    0.000    0.000    0.009    0.000 elements.py:1168(effective_value)
     9589    0.009    0.000    0.009    0.000 {method 'update' of 'dict' objects}
     1014    0.001    0.000    0.009    0.000 _collections.py:727(__missing__)
       88    0.001    0.000    0.009    0.000 configbase.py:140(_verify_schema_decl)
      486    0.003    0.000    0.009    0.000 _collections.py:359(__init__)
      132    0.000    0.000    0.009    0.000 relationships.py:1385(_go)
      396    0.001    0.000    0.008    0.000 elements.py:291(_annotate)
     3225    0.005    0.000    0.008    0.000 type_api.py:382(_cached_result_processor)
      530    0.001    0.000    0.008    0.000 pool.py:845(cursor)
    10108    0.005    0.000    0.008    0.000 inspect.py:181(istraceback)
      752    0.001    0.000    0.008    0.000 base.py:108(_for_instance)
      486    0.002    0.000    0.008    0.000 base.py:325(_is_mapped_class)
     4123    0.008    0.000    0.008    0.000 {imp.get_suffixes}
      133    0.001    0.000    0.008    0.000 session.py:1031(close)
      133    0.001    0.000    0.008    0.000 pool.py:478(checkout)
     1262    0.007    0.000    0.007    0.000 util.py:25(is_timestamp)
    49563    0.007    0.000    0.007    0.000 {len}
      133    0.001    0.000    0.007    0.000 session.py:1076(_close_impl)
    11334    0.007    0.000    0.007    0.000 {built-in method __new__ of type object at 0x919120}
     1236    0.004    0.000    0.007    0.000 abc.py:128(__instancecheck__)
      133    0.001    0.000    0.007    0.000 pool.py:501(checkin)
     1995    0.002    0.000    0.007    0.000 re.py:188(compile)
      530    0.007    0.000    0.007    0.000 {method 'cursor' of 'psycopg2.extensions.connection' objects}
    19708    0.007    0.000    0.007    0.000 {method 'startswith' of 'str' objects}
      264    0.001    0.000    0.007    0.000 persistence.py:1017(_connections_for_states)
      662    0.002    0.000    0.007    0.000 elements.py:3513(__new__)
     4875    0.007    0.000    0.007    0.000 {hasattr}
    32086    0.007    0.000    0.007    0.000 resolver.py:111(ascend_resolver)
      752    0.002    0.000    0.007    0.000 base.py:105(_for_class)
       88    0.001    0.000    0.007    0.000 strategies.py:448(_generate_lazy_clause)
      884    0.001    0.000    0.006    0.000 elements.py:2783(self_group)
     1149    0.003    0.000    0.006    0.000 operators.py:895(is_precedent)
     1815    0.004    0.000    0.006    0.000 posixpath.py:68(join)
     4727    0.006    0.000    0.006    0.000 weakref.py:314(__getitem__)
      396    0.002    0.000    0.006    0.000 elements.py:3919(__init__)
      486    0.004    0.000    0.006    0.000 query.py:3190(setup_entity)
      486    0.001    0.000    0.006    0.000 compiler.py:441(<genexpr>)
     3225    0.005    0.000    0.006    0.000 strategies.py:141(setup_query)
     3225    0.003    0.000    0.006    0.000 result.py:497(_getter)
     8113    0.004    0.000    0.006    0.000 inspect.py:67(ismethod)
      486    0.006    0.000    0.006    0.000 query.py:3715(__init__)
      133    0.000    0.000    0.006    0.000 pool.py:388(_return_conn)
    32086    0.006    0.000    0.006    0.000 resolver.py:88(descend_resolver)
    10108    0.004    0.000    0.006    0.000 inspect.py:191(isframe)
     3225    0.002    0.000    0.006    0.000 compiler.py:2722(format_label)
     8113    0.004    0.000    0.006    0.000 inspect.py:142(isfunction)
     1839    0.002    0.000    0.006    0.000 utf_8.py:15(decode)
      750    0.004    0.000    0.006    0.000 compiler.py:1149(_process_anon)
    24947    0.006    0.000    0.006    0.000 {method 'lower' of 'str' objects}
      926    0.003    0.000    0.006    0.000 selectable.py:35(_interpret_as_from)
     1236    0.002    0.000    0.006    0.000 compiler.py:442(<genexpr>)
      133    0.001    0.000    0.006    0.000 pool.py:1030(_do_return_conn)
     1350    0.004    0.000    0.005    0.000 arrow.py:49(__init__)
      352    0.003    0.000    0.005    0.000 relationships.py:1504(cascade_iterator)
       88    0.000    0.000    0.005    0.000 strategy_options.py:781(lazyload)
     1509    0.003    0.000    0.005    0.000 __init__.py:1345(isEnabledFor)
      308    0.001    0.000    0.005    0.000 schema.py:1635(get_referent)
       88    0.000    0.000    0.005    0.000 <string>:1(set_relationship_strategy)
      176    0.001    0.000    0.005    0.000 persistence.py:256(_organize_states_for_save)
     1995    0.004    0.000    0.005    0.000 re.py:226(_compile)
       88    0.000    0.000    0.005    0.000 base.py:40(_generative)
      133    0.001    0.000    0.005    0.000 queue.py:87(put)
     3225    0.004    0.000    0.005    0.000 selectable.py:3156(name_for_col)
     1544    0.002    0.000    0.005    0.000 base.py:208(manager_of_class)
     1368    0.002    0.000    0.005    0.000 default.py:592(<genexpr>)
     1323    0.003    0.000    0.005    0.000 query.py:416(_clone)
       88    0.000    0.000    0.005    0.000 unitofwork.py:557(execute)
      133    0.001    0.000    0.005    0.000 pool.py:1039(_do_get)
      133    0.002    0.000    0.005    0.000 base.py:47(__init__)
      176    0.001    0.000    0.005    0.000 unitofwork.py:228(register_object)
       88    0.001    0.000    0.005    0.000 persistence.py:223(delete_obj)
      308    0.003    0.000    0.005    0.000 selectable.py:450(corresponding_column)
      574    0.002    0.000    0.005    0.000 path_registry.py:62(set)
     8113    0.004    0.000    0.004    0.000 inspect.py:209(iscode)
      132    0.001    0.000    0.004    0.000 dependency.py:445(presort_saves)
      133    0.000    0.000    0.004    0.000 <string>:1(and_)
      924    0.004    0.000    0.004    0.000 {sorted}
      752    0.003    0.000    0.004    0.000 base.py:74(__init__)
      619    0.003    0.000    0.004    0.000 langhelpers.py:1033(_next)
      616    0.002    0.000    0.004    0.000 unitofwork.py:178(get_attribute_history)
      132    0.001    0.000    0.004    0.000 elements.py:1183(_clone)
      133    0.001    0.000    0.004    0.000 queue.py:130(get)
     1463    0.004    0.000    0.004    0.000 {posix.getcwd}
       88    0.000    0.000    0.004    0.000 strategy_options.py:190(set_relationship_strategy)
     2962    0.004    0.000    0.004    0.000 attr.py:226(__bool__)
     3822    0.002    0.000    0.004    0.000 projfile.py:49(strip_line)
     3225    0.004    0.000    0.004    0.000 compiler.py:271(__init__)
     1839    0.004    0.000    0.004    0.000 {_codecs.utf_8_decode}
     3225    0.003    0.000    0.004    0.000 compiler.py:1272(_add_to_result_map)
     1131    0.004    0.000    0.004    0.000 state.py:75(__init__)
      972    0.001    0.000    0.004    0.000 selectable.py:2438(<genexpr>)
       44    0.000    0.000    0.004    0.000 unitofwork.py:375(finalize_flush_changes)
      177    0.002    0.000    0.004    0.000 session.py:358(_prepare_impl)
     1283    0.003    0.000    0.004    0.000 base.py:89(__getattr__)
       44    0.001    0.000    0.004    0.000 attributes.py:1066(set_committed_value)
      132    0.002    0.000    0.004    0.000 persistence.py:416(_collect_update_commands)
      264    0.002    0.000    0.004    0.000 elements.py:235(_clone)
     1106    0.002    0.000    0.004    0.000 session.py:2016(_is_clean)
      713    0.001    0.000    0.004    0.000 __init__.py:1130(debug)
      486    0.001    0.000    0.004    0.000 session.py:1279(_autoflush)
       88    0.001    0.000    0.004    0.000 unitofwork.py:257(_per_mapper_flush_actions)
     3969    0.004    0.000    0.004    0.000 {method 'copy' of 'dict' objects}
      486    0.003    0.000    0.004    0.000 elements.py:3665(_select_iterables)
     3225    0.003    0.000    0.003    0.000 result.py:419(_getter)
     1995    0.002    0.000    0.003    0.000 <string>:8(__new__)
      486    0.002    0.000    0.003    0.000 query.py:306(_bind_mapper)
      176    0.001    0.000    0.003    0.000 persistence.py:1052(_sort_states)
     5901    0.003    0.000    0.003    0.000 {method 'split' of 'str' objects}
     1131    0.002    0.000    0.003    0.000 state.py:251(_cleanup)
       44    0.001    0.000    0.003    0.000 session.py:1491(_register_newly_persistent)
      486    0.003    0.000    0.003    0.000 query.py:3107(_adjust_for_single_inheritance)
      486    0.003    0.000    0.003    0.000 result.py:928(process_rows)
     1144    0.001    0.000    0.003    0.000 unitofwork.py:402(<genexpr>)
       44    0.003    0.000    0.003    0.000 topological.py:55(find_cycles)
      265    0.002    0.000    0.003    0.000 elements.py:1821(_from_objects)
      258    0.003    0.000    0.003    0.000 {open}
    10858    0.003    0.000    0.003    0.000 {method 'replace' of 'str' objects}
     5470    0.003    0.000    0.003    0.000 nodes.py:36(__init__)
      176    0.000    0.000    0.003    0.000 unitofwork.py:482(execute)
      750    0.002    0.000    0.003    0.000 type_api.py:372(_cached_bind_processor)
      750    0.003    0.000    0.003    0.000 compiler.py:1155(bindparam_string)
      133    0.001    0.000    0.003    0.000 pool.py:764(_reset)
      662    0.002    0.000    0.003    0.000 elements.py:3469(__new__)
       88    0.001    0.000    0.003    0.000 dependency.py:68(per_property_flush_actions)
     1596    0.003    0.000    0.003    0.000 weakref.py:282(__init__)
     1414    0.001    0.000    0.003    0.000 elements.py:3765(_expression_literal_as_text)
      264    0.001    0.000    0.003    0.000 attributes.py:222(__set__)
       88    0.000    0.000    0.003    0.000 query.py:1090(options)
     1551    0.002    0.000    0.003    0.000 posixpath.py:59(isabs)
     3753    0.003    0.000    0.003    0.000 elements.py:3292(_get_table)
      266    0.002    0.000    0.003    0.000 threading.py:146(acquire)
     1942    0.003    0.000    0.003    0.000 elements.py:698(self_group)
       88    0.000    0.000    0.003    0.000 <string>:1(_options)
     3225    0.003    0.000    0.003    0.000 compiler.py:280(type)
     3225    0.002    0.000    0.003    0.000 elements.py:3839(_interpret_as_column_or_from)
     1544    0.003    0.000    0.003    0.000 {method 'get' of 'dictproxy' objects}
       88    0.000    0.000    0.003    0.000 configbase.py:83(validate)
       88    0.000    0.000    0.003    0.000 persistence.py:336(_organize_states_for_delete)
      265    0.001    0.000    0.003    0.000 elements.py:1967(self_group)
      530    0.002    0.000    0.003    0.000 result.py:637(_soft_close)
      662    0.002    0.000    0.003    0.000 session.py:1142(get_bind)
       88    0.001    0.000    0.002    0.000 decimal.py:515(__new__)
      396    0.001    0.000    0.002    0.000 annotation.py:45(__init__)
       44    0.000    0.000    0.002    0.000 type_api.py:961(process)
      133    0.000    0.000    0.002    0.000 base.py:534(begin)
      220    0.001    0.000    0.002    0.000 selectable.py:1057(_hide_froms)
      170    0.002    0.000    0.002    0.000 cyaml.py:30(__init__)
      440    0.001    0.000    0.002    0.000 dependency.py:230(prop_has_changes)
       44    0.000    0.000    0.002    0.000 arrow.py:68(process_bind_param)
    15808    0.002    0.000    0.002    0.000 {hash}
       88    0.001    0.000    0.002    0.000 mapper.py:1774(_is_orphan)
       88    0.001    0.000    0.002    0.000 strategy_options.py:110(_generate_path)
      176    0.001    0.000    0.002    0.000 session.py:229(connection)
      971    0.002    0.000    0.002    0.000 elements.py:2754(_from_objects)
     1280    0.002    0.000    0.002    0.000 _weakrefset.py:70(__contains__)
      176    0.001    0.000    0.002    0.000 decimal.py:889(__le__)
      572    0.001    0.000    0.002    0.000 unitofwork.py:399(_mappers)
      396    0.000    0.000    0.002    0.000 topological.py:43(sort)
    10488    0.002    0.000    0.002    0.000 {method 'add' of 'set' objects}
     1509    0.002    0.000    0.002    0.000 __init__.py:1331(getEffectiveLevel)
      924    0.001    0.000    0.002    0.000 langhelpers.py:750(_reset)
      707    0.001    0.000    0.002    0.000 compiler.py:1788(visit_table)
      176    0.000    0.000    0.002    0.000 dependency.py:581(_pks_changed)
      264    0.001    0.000    0.002    0.000 attributes.py:687(set)
     1900    0.001    0.000    0.002    0.000 elements.py:3769(_literal_as_text)
     5211    0.002    0.000    0.002    0.000 {method 'intersection' of 'set' objects}
      707    0.001    0.000    0.002    0.000 attr.py:214(__call__)
      133    0.001    0.000    0.002    0.000 session.py:1082(expunge_all)
      133    0.001    0.000    0.002    0.000 base.py:1595(__init__)
       88    0.001    0.000    0.002    0.000 query.py:1105(_options)
     3990    0.002    0.000    0.002    0.000 {max}
      265    0.000    0.000    0.002    0.000 elements.py:1825(self_group)
     1323    0.002    0.000    0.002    0.000 elements.py:3657(_expand_cloned)
      264    0.001    0.000    0.002    0.000 topological.py:16(sort_as_subsets)
      954    0.001    0.000    0.002    0.000 session.py:1967(_contains_state)
      176    0.001    0.000    0.002    0.000 sync.py:106(source_modified)
      750    0.002    0.000    0.002    0.000 {method 'split' of 'unicode' objects}
      530    0.001    0.000    0.002    0.000 type_api.py:424(coerce_compared_value)
       44    0.000    0.000    0.002    0.000 default.py:807(_setup_crud_result_proxy)
     1219    0.002    0.000    0.002    0.000 {method 'issuperset' of 'frozenset' objects}
     1412    0.002    0.000    0.002    0.000 session.py:190(_assert_active)
       88    0.001    0.000    0.002    0.000 decimal.py:662(from_float)
     1350    0.001    0.000    0.002    0.000 util.py:37(isstr)
      530    0.001    0.000    0.002    0.000 default.py:692(should_autocommit)
      220    0.001    0.000    0.002    0.000 query.py:1983(_prepare_right_side)
      266    0.001    0.000    0.002    0.000 threading.py:372(notify)
      133    0.001    0.000    0.002    0.000 weakref.py:98(__setitem__)
     1148    0.002    0.000    0.002    0.000 strategies.py:615(create_row_processor)
      264    0.000    0.000    0.002    0.000 unitofwork.py:503(_elements)
      486    0.002    0.000    0.002    0.000 query.py:2638(_select_args)
      133    0.001    0.000    0.001    0.000 base.py:359(_entity_descriptor)
      482    0.001    0.000    0.001    0.000 constructor.py:223(construct_yaml_bool)
     1995    0.001    0.000    0.001    0.000 linecache.py:33(getlines)
      971    0.001    0.000    0.001    0.000 type_api.py:1137(to_instance)
      530    0.001    0.000    0.001    0.000 {sqlalchemy.cutils._distill_params}
     1087    0.001    0.000    0.001    0.000 identity.py:190(_fast_discard)
     1106    0.001    0.000    0.001    0.000 identity.py:53(check_modified)
      660    0.001    0.000    0.001    0.000 state.py:277(dict)
      133    0.001    0.000    0.001    0.000 default.py:419(do_rollback)
      486    0.001    0.000    0.001    0.000 query.py:3180(__init__)
      690    0.001    0.000    0.001    0.000 vendors.py:205(__init__)
      619    0.001    0.000    0.001    0.000 query.py:289(_mapper_zero)
      924    0.001    0.000    0.001    0.000 langhelpers.py:753(reset)
     1496    0.001    0.000    0.001    0.000 _collections.py:688(<genexpr>)
     1131    0.001    0.000    0.001    0.000 identity.py:140(_add_unpresent)
     1131    0.001    0.000    0.001    0.000 <string>:1(set)
     4815    0.001    0.000    0.001    0.000 {method 'update' of 'set' objects}
      266    0.001    0.000    0.001    0.000 threading.py:186(release)
      751    0.001    0.000    0.001    0.000 query.py:228(_adapt_clause)
      220    0.001    0.000    0.001    0.000 selectable.py:1062(_from_objects)
       44    0.000    0.000    0.001    0.000 dependency.py:541(process_saves)
       44    0.000    0.000    0.001    0.000 attributes.py:976(_initialize_collection)
      176    0.001    0.000    0.001    0.000 validate.py:476(get_dict_val)
       44    0.000    0.000    0.001    0.000 persistence.py:1047(<lambda>)
      133    0.001    0.000    0.001    0.000 base.py:642(_begin_impl)
      176    0.001    0.000    0.001    0.000 decimal.py:800(_cmp)
      220    0.001    0.000    0.001    0.000 elements.py:2742(__bool__)
      972    0.001    0.000    0.001    0.000 query.py:3262(_get_entity_clauses)
     2167    0.001    0.000    0.001    0.000 {method 'endswith' of 'str' objects}
       44    0.000    0.000    0.001    0.000 vendors.py:408(__repr__)
      486    0.001    0.000    0.001    0.000 path_registry.py:70(get)
       44    0.001    0.000    0.001    0.000 state.py:611(_commit_all_states)
       44    0.000    0.000    0.001    0.000 arrow.py:425(to)
      265    0.001    0.000    0.001    0.000 elements.py:716(comparator)
       41    0.000    0.000    0.001    0.000 collections.py:659(append_multiple_without_event)
      176    0.001    0.000    0.001    0.000 _collections.py:315(values)
       88    0.000    0.000    0.001    0.000 instrumentation.py:354(has_parent)
       88    0.000    0.000    0.001    0.000 <string>:1(params)
      885    0.001    0.000    0.001    0.000 {method 'acquire' of 'thread.lock' objects}
       44    0.000    0.000    0.001    0.000 aggregates.py:535(construct_aggregate_queries)
      177    0.001    0.000    0.001    0.000 {method 'format' of 'str' objects}
       44    0.000    0.000    0.001    0.000 base.py:149(execution_options)
     1134    0.001    0.000    0.001    0.000 {method 'remove' of 'list' objects}
      486    0.001    0.000    0.001    0.000 selectable.py:1695(__init__)
      398    0.001    0.000    0.001    0.000 _collections.py:787(coerce_generator_arg)
       88    0.001    0.000    0.001    0.000 attributes.py:900(get_all_pending)
      264    0.001    0.000    0.001    0.000 unitofwork.py:293(states_for_mapper_hierarchy)
      396    0.001    0.000    0.001    0.000 annotation.py:31(__new__)
     1456    0.001    0.000    0.001    0.000 instrumentation.py:94(is_mapped)
      704    0.001    0.000    0.001    0.000 unitofwork.py:454(__new__)
     1042    0.001    0.000    0.001    0.000 identity.py:106(contains_state)
       88    0.001    0.000    0.001    0.000 state.py:565(_commit)
     1131    0.001    0.000    0.001    0.000 identity.py:145(get)
      264    0.000    0.000    0.001    0.000 type_api.py:276(compare_values)
      220    0.001    0.000    0.001    0.000 controller.py:57(_get_ident)
       44    0.000    0.000    0.001    0.000 type_api.py:1057(compare_values)
     2076    0.001    0.000    0.001    0.000 {method 'values' of 'dict' objects}
      132    0.001    0.000    0.001    0.000 relationships.py:1363(visit_bindparam)
       88    0.000    0.000    0.001    0.000 <string>:1(_adapt_all_clauses)
      574    0.001    0.000    0.001    0.000 _collections.py:155(union)
      530    0.001    0.000    0.001    0.000 base.py:1220(_safe_close_cursor)
     2759    0.001    0.000    0.001    0.000 {method 'pop' of 'dict' objects}
      264    0.001    0.000    0.001    0.000 state.py:524(_modified_event)
      220    0.000    0.000    0.001    0.000 dependency.py:59(per_property_preprocessors)
      133    0.001    0.000    0.001    0.000 base.py:116(_join)
      971    0.001    0.000    0.001    0.000 query.py:389(_no_limit_offset)
      530    0.001    0.000    0.001    0.000 _collections.py:394(__iter__)
      748    0.001    0.000    0.001    0.000 _collections.py:687(__iter__)
      133    0.000    0.000    0.001    0.000 query.py:300(_joinpoint_zero)
       88    0.000    0.000    0.001    0.000 configbase.py:485(configdata)
       44    0.000    0.000    0.001    0.000 api.py:25(utcnow)
       44    0.000    0.000    0.001    0.000 session.py:234(_begin)
       44    0.000    0.000    0.001    0.000 dependency.py:495(process_deletes)
      971    0.001    0.000    0.001    0.000 query.py:381(_no_statement_condition)
     3310    0.001    0.000    0.001    0.000 mapper.py:642(mapper)
       88    0.000    0.000    0.001    0.000 strategy_options.py:216(_set_path_strategy)
       88    0.000    0.000    0.001    0.000 path_registry.py:250(entity_path)
     1806    0.001    0.000    0.001    0.000 mapper.py:1965(selectable)
       88    0.000    0.000    0.001    0.000 strategy_options.py:94(process_query)
       44    0.000    0.000    0.001    0.000 arrow.py:78(_coerce)
       44    0.000    0.000    0.001    0.000 factory.py:206(utcnow)
     1234    0.001    0.000    0.001    0.000 {method 'pop' of 'list' objects}
     1616    0.001    0.000    0.001    0.000 {method 'keys' of 'dict' objects}
       44    0.000    0.000    0.001    0.000 dependency.py:745(process_saves)
      133    0.000    0.000    0.001    0.000 log.py:54(_should_log_debug)
       88    0.001    0.000    0.001    0.000 mapper.py:2397(_identity_key_from_state)
      968    0.001    0.000    0.001    0.000 annotation.py:90(__hash__)
       88    0.000    0.000    0.001    0.000 attributes.py:675(get_history)
      176    0.000    0.000    0.001    0.000 attributes.py:740(get_history)
      690    0.001    0.000    0.001    0.000 collections.py:1071(append)
      266    0.000    0.000    0.001    0.000 pool.py:854(__getattr__)
       88    0.000    0.000    0.001    0.000 persistence.py:918(_finalize_insert_update_commands)
      220    0.001    0.000    0.001    0.000 query.py:3245(corresponds_to)
      266    0.001    0.000    0.001    0.000 identity.py:14(__init__)
      486    0.001    0.000    0.001    0.000 {zip}
     5030    0.001    0.000    0.001    0.000 {method 'strip' of 'str' objects}
       44    0.000    0.000    0.001    0.000 arrow.py:700(__eq__)
       88    0.000    0.000    0.001    0.000 strategy_options.py:86(_generate)
      924    0.001    0.000    0.001    0.000 {method 'difference' of 'set' objects}
      220    0.000    0.000    0.001    0.000 unitofwork.py:223(register_preprocessor)
     1995    0.001    0.000    0.001    0.000 {min}
      530    0.001    0.000    0.001    0.000 result.py:632(_cursor_description)
       44    0.000    0.000    0.001    0.000 arrow.py:76(utcnow)
     1283    0.001    0.000    0.001    0.000 {setattr}
       44    0.000    0.000    0.001    0.000 instrumentation.py:290(initialize_collection)
      838    0.001    0.000    0.001    0.000 {_codecs.utf_8_encode}
       88    0.000    0.000    0.001    0.000 attributes.py:474(hasparent)
      486    0.001    0.000    0.001    0.000 mapper.py:1890(_with_polymorphic_mappers)
       88    0.001    0.000    0.001    0.000 {_warnings.warn}
     3225    0.001    0.000    0.001    0.000 elements.py:758(_select_iterable)
     3225    0.001    0.000    0.001    0.000 elements.py:3521(apply_map)
       88    0.000    0.000    0.001    0.000 <string>:1(_with_invoke_all_eagers)
       88    0.000    0.000    0.001    0.000 conffile.py:51(_cfpath)
     4200    0.001    0.000    0.001    0.000 {id}
      133    0.001    0.000    0.001    0.000 pool.py:559(get_connection)
       88    0.000    0.000    0.001    0.000 path_registry.py:254(__getitem__)
      133    0.000    0.000    0.001    0.000 log.py:57(_should_log_info)
       88    0.000    0.000    0.001    0.000 dependency.py:708(presort_saves)
       88    0.000    0.000    0.001    0.000 strategy_options.py:100(_process)
      264    0.001    0.000    0.001    0.000 attributes.py:752(get_all_pending)
       44    0.000    0.000    0.001    0.000 attributes.py:629(set_committed_value)
     1496    0.001    0.000    0.001    0.000 _collections.py:689(<genexpr>)
      133    0.000    0.000    0.001    0.000 session.py:297(_remove_snapshot)
       88    0.000    0.000    0.001    0.000 _collections.py:183(__iter__)
      690    0.000    0.000    0.001    0.000 currency.py:219(__init__)
      133    0.000    0.000    0.001    0.000 contextlib.py:82(helper)
       88    0.000    0.000    0.001    0.000 persistence.py:720(_emit_insert_statements)
       88    0.000    0.000    0.001    0.000 session.py:1842(_save_or_update_impl)
       44    0.000    0.000    0.001    0.000 session.py:1959(__iter__)
      133    0.001    0.000    0.001    0.000 weakref.py:267(__init__)
       88    0.000    0.000    0.000    0.000 strategy_options.py:185(_coerce_strat)
       88    0.000    0.000    0.000    0.000 attributes.py:1303(from_scalar_attribute)
      220    0.000    0.000    0.000    0.000 elements.py:269(_cloned_set)
      177    0.000    0.000    0.000    0.000 identity.py:184(all_states)
      706    0.000    0.000    0.000    0.000 _collections.py:724(__init__)
      220    0.000    0.000    0.000    0.000 selectable.py:874(<lambda>)
       88    0.000    0.000    0.000    0.000 query.py:1254(params)
     1410    0.000    0.000    0.000    0.000 {iter}
       88    0.000    0.000    0.000    0.000 configbase.py:77(__init__)
      619    0.000    0.000    0.000    0.000 {next}
       88    0.000    0.000    0.000    0.000 _collections.py:805(has_intersection)
      486    0.000    0.000    0.000    0.000 base.py:1472(get_select_precolumns)
      176    0.000    0.000    0.000    0.000 decimal.py:760(_compare_check_nans)
      220    0.000    0.000    0.000    0.000 unitofwork.py:282(<lambda>)
      798    0.000    0.000    0.000    0.000 base.py:301(connection)
       88    0.000    0.000    0.000    0.000 persistence.py:835(_emit_delete_statements)
       88    0.000    0.000    0.000    0.000 session.py:37(_state_session)
      176    0.000    0.000    0.000    0.000 persistence.py:1044(_cached_connection_dict)
       44    0.000    0.000    0.000    0.000 persistence.py:959(_postfetch)
      132    0.000    0.000    0.000    0.000 instrumentation.py:302(get_impl)
      885    0.000    0.000    0.000    0.000 {method 'release' of 'thread.lock' objects}
       88    0.000    0.000    0.000    0.000 configbase.py:128(_schema_name_policy)
       44    0.000    0.000    0.000    0.000 session.py:1542(_register_altered)
      308    0.000    0.000    0.000    0.000 base.py:590(contains_column)
      176    0.000    0.000    0.000    0.000 unitofwork.py:475(__init__)
      176    0.000    0.000    0.000    0.000 interfaces.py:486(_get_strategy)
      176    0.000    0.000    0.000    0.000 _collections.py:846(flatten_iterator)
       44    0.000    0.000    0.000    0.000 {method 'astimezone' of 'datetime.datetime' objects}
      176    0.000    0.000    0.000    0.000 validate.py:463(__init__)
      133    0.000    0.000    0.000    0.000 {range}
      352    0.000    0.000    0.000    0.000 relationships.py:1731(_get_cascade)
     1147    0.000    0.000    0.000    0.000 selectable.py:1418(_from_objects)
      576    0.000    0.000    0.000    0.000 session.py:225(_is_transaction_boundary)
      798    0.000    0.000    0.000    0.000 threading.py:63(_note)
      266    0.000    0.000    0.000    0.000 threading.py:237(_is_owned)
       88    0.000    0.000    0.000    0.000 session.py:1818(_update_impl)
      572    0.000    0.000    0.000    0.000 {method 'difference_update' of 'set' objects}
      133    0.000    0.000    0.000    0.000 weakref.py:262(__new__)
       88    0.000    0.000    0.000    0.000 strategy_options.py:80(__init__)
      872    0.000    0.000    0.000    0.000 {method 'extend' of 'list' objects}
     1463    0.000    0.000    0.000    0.000 posixpath.py:51(normcase)
       88    0.000    0.000    0.000    0.000 base.py:314(_generate)
       44    0.000    0.000    0.000    0.000 unitofwork.py:109(__init__)
      704    0.000    0.000    0.000    0.000 attributes.py:1251(__bool__)
       88    0.000    0.000    0.000    0.000 _collections.py:144(__new__)
      133    0.000    0.000    0.000    0.000 queue.py:194(_put)
      971    0.000    0.000    0.000    0.000 {callable}
      398    0.000    0.000    0.000    0.000 {method 'items' of 'dict' objects}
       44    0.000    0.000    0.000    0.000 attributes.py:1290(as_state)
      798    0.000    0.000    0.000    0.000 {thread.get_ident}
       88    0.000    0.000    0.000    0.000 path_registry.py:283(__getitem__)
      530    0.000    0.000    0.000    0.000 compiler.py:215(__str__)
       88    0.000    0.000    0.000    0.000 path_registry.py:267(__init__)
      170    0.000    0.000    0.000    0.000 constructor.py:20(__init__)
      264    0.000    0.000    0.000    0.000 mapper.py:2652(_memo)
      220    0.000    0.000    0.000    0.000 query.py:2112(_reset_joinpoint)
       88    0.000    0.000    0.000    0.000 _collections.py:312(keys)
      352    0.000    0.000    0.000    0.000 decimal.py:2803(adjusted)
      133    0.000    0.000    0.000    0.000 queue.py:190(_full)
      133    0.000    0.000    0.000    0.000 queue.py:198(_get)
      265    0.000    0.000    0.000    0.000 type_api.py:53(__init__)
      133    0.000    0.000    0.000    0.000 session.py:239(_iterate_parents)
      619    0.000    0.000    0.000    0.000 query.py:286(_entity_zero)
       44    0.000    0.000    0.000    0.000 identity.py:163(values)
      133    0.000    0.000    0.000    0.000 base.py:255(__init__)
       44    0.000    0.000    0.000    0.000 base.py:135(_clone)
      574    0.000    0.000    0.000    0.000 query.py:3746(<genexpr>)
      220    0.000    0.000    0.000    0.000 unitofwork.py:411(__init__)
       44    0.000    0.000    0.000    0.000 arrow.py:335(naive)
       88    0.000    0.000    0.000    0.000 {method 'as_integer_ratio' of 'float' objects}
       88    0.000    0.000    0.000    0.000 configbase.py:134(_schema_ver_policy)
      530    0.000    0.000    0.000    0.000 {method 'union' of 'set' objects}
       44    0.000    0.000    0.000    0.000 _collections.py:879(get)
       88    0.000    0.000    0.000    0.000 decimal.py:3724(_dec_from_triple)
      706    0.000    0.000    0.000    0.000 selectable.py:170(selectable)
      836    0.000    0.000    0.000    0.000 {method 'isdisjoint' of 'set' objects}
      532    0.000    0.000    0.000    0.000 langhelpers.py:825(<lambda>)
     1148    0.000    0.000    0.000    0.000 interfaces.py:617(setup_query)
      132    0.000    0.000    0.000    0.000 session.py:1533(<genexpr>)
       44    0.000    0.000    0.000    0.000 collections.py:687(__iter__)
      121    0.000    0.000    0.000    0.000 weakref.py:48(remove)
       88    0.000    0.000    0.000    0.000 arrow.py:844(_get_datetime)
       44    0.000    0.000    0.000    0.000 attributes.py:1330(from_object_attribute)
      170    0.000    0.000    0.000    0.000 resolver.py:21(__init__)
      176    0.000    0.000    0.000    0.000 unitofwork.py:164(memo)
      133    0.000    0.000    0.000    0.000 pool.py:677(__init__)
      530    0.000    0.000    0.000    0.000 default.py:750(post_exec)
      133    0.000    0.000    0.000    0.000 base.py:1532(__init__)
       44    0.000    0.000    0.000    0.000 {built-in method utcnow}
      532    0.000    0.000    0.000    0.000 {method 'setdefault' of 'dict' objects}
      133    0.000    0.000    0.000    0.000 {method 'rollback' of 'psycopg2.extensions.connection' objects}
      132    0.000    0.000    0.000    0.000 dependency.py:797(per_property_preprocessors)
       44    0.000    0.000    0.000    0.000 dependency.py:594(per_property_dependencies)
      530    0.000    0.000    0.000    0.000 default.py:747(pre_exec)
       88    0.000    0.000    0.000    0.000 _collections.py:318(items)
      482    0.000    0.000    0.000    0.000 {method 'lower' of 'unicode' objects}
       44    0.000    0.000    0.000    0.000 dependency.py:324(per_property_dependencies)
      264    0.000    0.000    0.000    0.000 unitofwork.py:524(__init__)
      690    0.000    0.000    0.000    0.000 currency.py:248(source_value)
      352    0.000    0.000    0.000    0.000 mapper.py:2340(primary_base_mapper)
      264    0.000    0.000    0.000    0.000 validate.py:380(__init__)
      176    0.000    0.000    0.000    0.000 identity.py:72(__len__)
       88    0.000    0.000    0.000    0.000 selectable.py:857(<lambda>)
     1013    0.000    0.000    0.000    0.000 {method 'popleft' of 'collections.deque' objects}
      690    0.000    0.000    0.000    0.000 vendors.py:210(moq)
      176    0.000    0.000    0.000    0.000 {method 'intersection' of 'frozenset' objects}
      132    0.000    0.000    0.000    0.000 interfaces.py:362(adapter)
       44    0.000    0.000    0.000    0.000 {method 'replace' of 'datetime.datetime' objects}
       44    0.000    0.000    0.000    0.000 result.py:536(rowcount)
      176    0.000    0.000    0.000    0.000 decimal.py:441(getcontext)
       44    0.000    0.000    0.000    0.000 collections.py:578(__init__)
      690    0.000    0.000    0.000    0.000 vendors.py:214(oqmultiple)
      690    0.000    0.000    0.000    0.000 vendors.py:488(currency)
      530    0.000    0.000    0.000    0.000 {method 'close' of 'psycopg2.extensions.cursor' objects}
      176    0.000    0.000    0.000    0.000 decimal.py:5835(_convert_other)
       64    0.000    0.000    0.000    0.000 constructor.py:210(construct_yaml_null)
      690    0.000    0.000    0.000    0.000 collections.py:1038(__set)
       44    0.000    0.000    0.000    0.000 parser.py:281(parse)
       88    0.000    0.000    0.000    0.000 weakref.py:284(remove)
      352    0.000    0.000    0.000    0.000 decimal.py:793(__nonzero__)
      220    0.000    0.000    0.000    0.000 mapper.py:2278(common_parent)
      132    0.000    0.000    0.000    0.000 relationships.py:1384(_get_attr_w_warn_on_none)
      221    0.000    0.000    0.000    0.000 {method 'discard' of 'set' objects}
       44    0.000    0.000    0.000    0.000 six.py:552(iteritems)
      690    0.000    0.000    0.000    0.000 vendors.py:218(unit_price)
       44    0.000    0.000    0.000    0.000 unitofwork.py:271(_mapper_for_dep)
      133    0.000    0.000    0.000    0.000 {sys._getframe}
       88    0.000    0.000    0.000    0.000 weakref.py:69(__getitem__)
      133    0.000    0.000    0.000    0.000 base.py:1537(_parent)
      220    0.000    0.000    0.000    0.000 query.py:3241(entity_zero_or_selectable)
      528    0.000    0.000    0.000    0.000 elements.py:378(_copy_internals)
       88    0.000    0.000    0.000    0.000 weakref.py:320(__setitem__)
      264    0.000    0.000    0.000    0.000 unitofwork.py:553(__init__)
      133    0.000    0.000    0.000    0.000 queue.py:186(_empty)
       88    0.000    0.000    0.000    0.000 path_registry.py:77(__len__)
       88    0.000    0.000    0.000    0.000 query.py:224(_adapt_all_clauses)
      264    0.000    0.000    0.000    0.000 persistence.py:1054(<genexpr>)
      176    0.000    0.000    0.000    0.000 mapper.py:2299(iterate_to_root)
       44    0.000    0.000    0.000    0.000 attributes.py:893(get_history)
      133    0.000    0.000    0.000    0.000 contextlib.py:12(__init__)
       88    0.000    0.000    0.000    0.000 _collections.py:309(__iter__)
      264    0.000    0.000    0.000    0.000 configbase.py:157(projectfolder)
      484    0.000    0.000    0.000    0.000 {method 'remove' of 'set' objects}
       88    0.000    0.000    0.000    0.000 state.py:234(has_identity)
       44    0.000    0.000    0.000    0.000 session.py:2506(_dirty_states)
       88    0.000    0.000    0.000    0.000 {method 'clear' of 'dict' objects}
       44    0.000    0.000    0.000    0.000 persistence.py:632(<lambda>)
       88    0.000    0.000    0.000    0.000 {math.copysign}
       88    0.000    0.000    0.000    0.000 identity.py:109(replace)
      176    0.000    0.000    0.000    0.000 persistence.py:184(<genexpr>)
       88    0.000    0.000    0.000    0.000 validate.py:34(__init__)
       44    0.000    0.000    0.000    0.000 attributes.py:1255(empty)
       88    0.000    0.000    0.000    0.000 validate.py:502(__init__)
      220    0.000    0.000    0.000    0.000 elements.py:405(self_group)
      176    0.000    0.000    0.000    0.000 tz.py:47(utcoffset)
       44    0.000    0.000    0.000    0.000 vendors.py:472(name)
       85    0.000    0.000    0.000    0.000 {method 'iteritems' of 'dict' objects}
       88    0.000    0.000    0.000    0.000 vendors.py:324(vpno)
       44    0.000    0.000    0.000    0.000 vendors.py:386(prices)
       88    0.000    0.000    0.000    0.000 {math.isinf}
      132    0.000    0.000    0.000    0.000 base.py:32(_clone)
      133    0.000    0.000    0.000    0.000 interfaces.py:120(create_row_processor)
       44    0.000    0.000    0.000    0.000 _collections.py:875(_inc_counter)
       88    0.000    0.000    0.000    0.000 persistence.py:1057(<lambda>)
       88    0.000    0.000    0.000    0.000 persistence.py:568(_collect_delete_commands)
      133    0.000    0.000    0.000    0.000 interfaces.py:111(setup)
      133    0.000    0.000    0.000    0.000 default.py:416(do_begin)
       44    0.000    0.000    0.000    0.000 unitofwork.py:154(has_work)
       88    0.000    0.000    0.000    0.000 persistence.py:180(<genexpr>)
       88    0.000    0.000    0.000    0.000 persistence.py:362(_collect_insert_commands)
      133    0.000    0.000    0.000    0.000 {method 'append' of 'collections.deque' objects}
       44    0.000    0.000    0.000    0.000 vendors.py:332(vqtyavail)
       44    0.000    0.000    0.000    0.000 default.py:797(rowcount)
       88    0.000    0.000    0.000    0.000 query.py:906(_with_invoke_all_eagers)
       44    0.000    0.000    0.000    0.000 vendors.py:340(manufacturer)
      170    0.000    0.000    0.000    0.000 {method 'dispose' of '_yaml.CParser' objects}
       44    0.000    0.000    0.000    0.000 arrow.py:329(datetime)
       88    0.000    0.000    0.000    0.000 {abs}
       88    0.000    0.000    0.000    0.000 state.py:221(parents)
       88    0.000    0.000    0.000    0.000 {math.isnan}
       44    0.000    0.000    0.000    0.000 unitofwork.py:388(<genexpr>)
       44    0.000    0.000    0.000    0.000 vendors.py:356(vpartdesc)
       44    0.000    0.000    0.000    0.000 vendors.py:348(mpartno)
       88    0.000    0.000    0.000    0.000 {method 'bit_length' of 'int' objects}
       88    0.000    0.000    0.000    0.000 tz.py:50(dst)
       88    0.000    0.000    0.000    0.000 {method 'pop' of 'collections.deque' objects}
       88    0.000    0.000    0.000    0.000 _collections.py:149(__init__)
       44    0.000    0.000    0.000    0.000 default.py:401(set_connection_execution_options)
       44    0.000    0.000    0.000    0.000 base.py:121(_root)
       44    0.000    0.000    0.000    0.000 state.py:225(_pending_mutations)
       44    0.000    0.000    0.000    0.000 dependency.py:727(process_deletes)
       44    0.000    0.000    0.000    0.000 vendors.py:368(pkgqty)
       44    0.000    0.000    0.000    0.000 identity.py:50(_dirty_states)
       44    0.000    0.000    0.000    0.000 state.py:244(_detach)
        1    0.000    0.000    0.000    0.000 attributes.py:145(__clause_element__)
        1    0.000    0.000    0.000    0.000 {method 'disable' of '_lsprof.Profiler' objects}