CSIL Vendor Map Audit Generation ProfilingΒΆ

Raw execution profile SVG of execution profile

Execution Profile

../../../_images/csil.profile1.svg

pstats Output

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

         1688107 function calls (1665150 primitive calls) in 5.876 seconds

   Ordered by: cumulative time

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    5.888    5.888 vendors.py:52(profile_vendor_genvmapaudit)
        1    0.003    0.003    5.888    5.888 electronics.py:123(export_vendor_map_audit)
       44    0.000    0.000    4.767    0.108 vendors.py:519(get_vpart)
       44    0.000    0.000    4.766    0.108 csil.py:262(__init__)
       44    0.000    0.000    4.766    0.108 vendors.py:236(__init__)
       44    0.001    0.000    4.766    0.108 vendors.py:248(_populate)
 1238/266    0.007    0.000    3.557    0.013 db.py:168(inner)
       44    0.000    0.000    2.159    0.049 vendors.py:265(commit)
       44    0.001    0.000    2.159    0.049 vendors.py:272(_commit_to_db)
     1398    0.004    0.000    2.118    0.002 base.py:846(execute)
     1398    0.003    0.000    2.112    0.002 elements.py:322(_execute_on_connection)
     1398    0.016    0.000    2.109    0.002 base.py:975(_execute_clauseelement)
      620    0.003    0.000    1.808    0.003 query.py:2511(__iter__)
     1398    0.025    0.000    1.675    0.001 base.py:1061(_execute_context)
      620    0.006    0.000    1.638    0.003 query.py:2525(_execute_and_instances)
       44    0.007    0.000    1.558    0.035 controller.py:181(populate_vpart_prices)
       44    0.003    0.000    1.525    0.035 csil.py:270(_get_data)
      170    0.001    0.000    1.471    0.009 yml.py:37(load)
      170    0.010    0.000    1.470    0.009 __init__.py:64(load)
      170    0.001    0.000    1.457    0.009 constructor.py:35(get_single_data)
     1398    0.003    0.000    1.327    0.001 default.py:449(do_execute)
     1398    1.314    0.001    1.324    0.001 {method 'execute' of 'psycopg2.extensions.cursor' objects}
       44    0.003    0.000    1.156    0.026 csil.py:280(_load_descriptors)
      170    0.922    0.005    1.140    0.007 {method 'get_single_node' of '_yaml.CParser' objects}
       44    0.000    0.000    1.055    0.024 maps.py:73(get_all_partnos)
      268    0.002    0.000    1.039    0.004 db.py:111(get_session)
      177    0.004    0.000    1.009    0.006 query.py:2393(all)
      443    0.010    0.000    0.964    0.002 query.py:2451(one)
4406/4318    0.007    0.000    0.857    0.000 attributes.py:556(get)
4353/4265    0.004    0.000    0.854    0.000 attributes.py:229(__get__)
      822    0.002    0.000    0.847    0.001 strategies.py:477(_load_for_state)
       88    0.003    0.000    0.844    0.010 strategies.py:550(_emit_lazyload)
     1110    0.004    0.000    0.812    0.001 session.py:1970(flush)
       85    0.006    0.000    0.804    0.009 session.py:2021(_flush)
       88    0.003    0.000    0.783    0.009 controller.py:244(get_map_vpnos)
       85    0.002    0.000    0.744    0.009 unitofwork.py:351(execute)
      176    0.005    0.000    0.741    0.004 controller.py:215(get_map)
      134    0.002    0.000    0.718    0.005 contextlib.py:21(__exit__)
      134    0.002    0.000    0.706    0.005 session.py:756(commit)
      219    0.004    0.000    0.706    0.003 session.py:389(commit)
      134    0.001    0.000    0.673    0.005 base.py:1569(commit)
      134    0.000    0.000    0.672    0.005 base.py:1603(_do_commit)
      134    0.003    0.000    0.672    0.005 base.py:679(_commit_impl)
      134    0.001    0.000    0.668    0.005 default.py:422(do_commit)
      134    0.667    0.005    0.667    0.005 {method 'commit' of 'psycopg2.extensions.connection' objects}
       88    0.002    0.000    0.648    0.007 controller.py:113(get_vpno_obj)
      211    0.001    0.000    0.610    0.003 unitofwork.py:528(execute)
      211    0.005    0.000    0.609    0.003 persistence.py:124(save_obj)
       44    0.000    0.000    0.553    0.013 vendors.py:88(get_upartnos)
      211    0.015    0.000    0.537    0.003 persistence.py:720(_emit_insert_statements)
       44    0.000    0.000    0.502    0.011 vendors.py:84(get_apartnos)
      266    0.001    0.000    0.462    0.002 controller.py:45(_get_vendor)
      178    0.002    0.000    0.461    0.003 controller.py:94(get_vendor)
       88    0.007    0.000    0.427    0.005 projfile.py:28(__init__)
       88    0.001    0.000    0.409    0.005 conffile.py:46(__init__)
       88    0.001    0.000    0.409    0.005 configbase.py:106(__init__)
      620    0.002    0.000    0.406    0.001 elements.py:431(compile)
       88    0.003    0.000    0.405    0.005 configbase.py:120(get_configs_file)
      620    0.003    0.000    0.404    0.001 elements.py:496(_compiler)
      620    0.011    0.000    0.401    0.001 compiler.py:329(__init__)
       44    0.000    0.000    0.400    0.009 controller.py:263(get_umap_vpnos)
      620    0.002    0.000    0.388    0.001 compiler.py:167(__init__)
      620    0.001    0.000    0.386    0.001 compiler.py:212(process)
       44    0.000    0.000    0.385    0.009 controller.py:257(get_amap_vpnos)
11420/620    0.032    0.000    0.385    0.001 visitors.py:75(_compiler_dispatch)
  621/620    0.018    0.000    0.381    0.001 compiler.py:1503(visit_select)
       44    0.004    0.000    0.366    0.008 csil.py:316(_load_prices)
      134    0.000    0.000    0.323    0.002 contextlib.py:15(__enter__)
      170    0.006    0.000    0.317    0.002 constructor.py:42(construct_document)
       44    0.000    0.000    0.313    0.007 vendors.py:285(load_from_db)
       44    0.001    0.000    0.313    0.007 vendors.py:292(_load_from_db)
      134    0.003    0.000    0.304    0.002 db.py:83(_get_caller)
9196/5940    0.007    0.000    0.294    0.000 constructor.py:395(construct_yaml_map)
      134    0.001    0.000    0.291    0.002 inspect.py:1053(stack)
      134    0.005    0.000    0.290    0.002 inspect.py:1026(getouterframes)
     1918    0.018    0.000    0.285    0.000 inspect.py:988(getframeinfo)
     4598    0.011    0.000    0.284    0.000 constructor.py:205(construct_mapping)
       44    0.002    0.000    0.262    0.006 controller.py:128(populate_vpart_detail)
     4598    0.028    0.000    0.254    0.000 constructor.py:120(construct_mapping)
    32086    0.093    0.000    0.237    0.000 constructor.py:55(construct_object)
     1398    0.049    0.000    0.204    0.000 default.py:515(_init_compiled)
     1918    0.023    0.000    0.187    0.000 inspect.py:518(findsource)
     4070    0.029    0.000    0.177    0.000 compiler.py:1275(_label_select_column)
      621    0.009    0.000    0.162    0.000 query.py:2953(_compile_context)
     1151    0.012    0.000    0.151    0.000 loading.py:30(instances)
4072/1415    0.008    0.000    0.129    0.000 operators.py:294(__eq__)
     4070    0.033    0.000    0.128    0.000 compiler.py:581(visit_label)
    32086    0.078    0.000    0.126    0.000 resolver.py:140(resolve)
     3970    0.036    0.000    0.126    0.000 inspect.py:440(getsourcefile)
3097/1679    0.005    0.000    0.124    0.000 {operator.eq}
  621/620    0.011    0.000    0.112    0.000 compiler.py:1679(_compose_select_body)
     1594    0.008    0.000    0.110    0.000 base.py:196(generate)
      885    0.001    0.000    0.109    0.000 attributes.py:174(operate)
   223383    0.085    0.000    0.100    0.000 {isinstance}
     1592    0.002    0.000    0.096    0.000 elements.py:738(operate)
 2568/887    0.011    0.000    0.090    0.000 visitors.py:86(_compiler_dispatch)
     1592    0.003    0.000    0.086    0.000 <string>:1(<lambda>)
      690    0.001    0.000    0.085    0.000 collections.py:1071(append)
      690    0.001    0.000    0.084    0.000 collections.py:1038(__set)
     1592    0.007    0.000    0.083    0.000 type_api.py:57(operate)
      690    0.002    0.000    0.082    0.000 collections.py:701(fire_append_event)
     1398    0.008    0.000    0.080    0.000 psycopg2.py:466(get_result_proxy)
      690    0.005    0.000    0.079    0.000 attributes.py:932(fire_append_event)
      973    0.006    0.000    0.077    0.000 annotation.py:93(__eq__)
     1239    0.005    0.000    0.072    0.000 compiler.py:904(visit_binary)
    26616    0.070    0.000    0.070    0.000 nodes.py:27(__init__)
      619    0.013    0.000    0.070    0.000 query.py:3282(row_processor)
      709    0.002    0.000    0.070    0.000 properties.py:268(operate)
     5576    0.036    0.000    0.067    0.000 compiler.py:620(visit_column)
     1398    0.006    0.000    0.066    0.000 result.py:488(__init__)
      621    0.009    0.000    0.065    0.000 query.py:3071(_simple_statement)
     1239    0.006    0.000    0.064    0.000 compiler.py:935(_generate_generic_binary)
      619    0.004    0.000    0.064    0.000 query.py:3317(setup_context)
      266    0.001    0.000    0.063    0.000 query.py:1511(join)
     1239    0.008    0.000    0.062    0.000 default_comparator.py:21(_boolean_compare)
      266    0.001    0.000    0.062    0.000 <string>:1(_join)
     2052    0.008    0.000    0.061    0.000 inspect.py:472(getmodule)
     1398    0.007    0.000    0.060    0.000 result.py:513(_init_metadata)
      619    0.015    0.000    0.060    0.000 loading.py:224(_setup_entity_query)
    15212    0.014    0.000    0.059    0.000 constructor.py:383(construct_yaml_str)
      266    0.003    0.000    0.059    0.000 query.py:1800(_join)
       85    0.003    0.000    0.056    0.001 unitofwork.py:300(_generate_actions)
     5888    0.021    0.000    0.056    0.000 inspect.py:398(getfile)
      619    0.028    0.000    0.056    0.000 loading.py:269(_instance_processor)
     3471    0.007    0.000    0.055    0.000 {method 'join' of 'str' objects}
     6950    0.009    0.000    0.055    0.000 default.py:592(<genexpr>)
6137/6130    0.014    0.000    0.054    0.000 langhelpers.py:744(__get__)
      422    0.001    0.000    0.054    0.000 unitofwork.py:482(execute)
      354    0.004    0.000    0.054    0.000 compiler.py:735(visit_clauselist)
      621    0.005    0.000    0.053    0.000 <string>:1(select)
    29894    0.053    0.000    0.053    0.000 {method 'match' of '_sre.SRE_Pattern' objects}
      266    0.004    0.000    0.053    0.000 query.py:1915(_join_left_to_right)
      620    0.002    0.000    0.052    0.000 session.py:1245(query)
      620    0.030    0.000    0.051    0.000 result.py:189(__init__)
      620    0.001    0.000    0.050    0.000 query.py:107(__init__)
      621    0.006    0.000    0.050    0.000 compiler.py:1654(_setup_select_stack)
    26616    0.027    0.000    0.049    0.000 constructor.py:163(construct_scalar)
      621    0.006    0.000    0.049    0.000 query.py:112(_set_entities)
      621    0.017    0.000    0.049    0.000 selectable.py:2220(__init__)
     1061    0.001    0.000    0.048    0.000 compiler.py:742(<genexpr>)
     1061    0.001    0.000    0.047    0.000 compiler.py:744(<genexpr>)
      822    0.004    0.000    0.046    0.000 session.py:1588(_save_or_update_state)
      850    0.006    0.000    0.045    0.000 unitofwork.py:417(execute)
     1382    0.003    0.000    0.045    0.000 inspect.py:460(getabsfile)
      973    0.002    0.000    0.045    0.000 <string>:1(filter)
     6526    0.026    0.000    0.044    0.000 constructor.py:227(construct_yaml_int)
      266    0.002    0.000    0.043    0.000 query.py:2068(_join_to_left)
      778    0.005    0.000    0.043    0.000 default.py:807(_setup_crud_result_proxy)
      690    0.005    0.000    0.042    0.000 unitofwork.py:29(append)
      178    0.002    0.000    0.042    0.000 query.py:1310(filter_by)
     1512    0.001    0.000    0.041    0.000 type_api.py:961(process)
      621    0.006    0.000    0.040    0.000 selectable.py:2506(_get_display_froms)
      690    0.002    0.000    0.040    0.000 <string>:1(__init__)
      266    0.001    0.000    0.040    0.000 util.py:880(join)
      530    0.008    0.000    0.040    0.000 loading.py:360(_instance)
     5570    0.015    0.000    0.040    0.000 interfaces.py:498(setup)
     1470    0.006    0.000    0.040    0.000 posixpath.py:365(abspath)
      211    0.002    0.000    0.040    0.000 persistence.py:597(_emit_update_statements)
     1512    0.004    0.000    0.039    0.000 arrow.py:68(process_bind_param)
      266    0.003    0.000    0.039    0.000 util.py:779(__init__)
     1239    0.005    0.000    0.037    0.000 default_comparator.py:269(_check_literal)
      734    0.004    0.000    0.036    0.000 state.py:296(_initialize_instance)
      176    0.002    0.000    0.035    0.000 relationships.py:961(__eq__)
       85    0.003    0.000    0.034    0.000 dependency.py:745(process_saves)
      822    0.017    0.000    0.033    0.000 mapper.py:2555(cascade_iterator)
      266    0.002    0.000    0.032    0.000 selectable.py:651(__init__)
     5043    0.016    0.000    0.032    0.000 compiler.py:1130(_truncated_identifier)
      973    0.008    0.000    0.032    0.000 query.py:1274(filter)
      622    0.013    0.000    0.032    0.000 selectable.py:2479(_froms)
      620    0.002    0.000    0.032    0.000 query.py:2518(_connection_from_session)
  778/734    0.002    0.000    0.031    0.000 attributes.py:778(set)
29928/29927    0.029    0.000    0.031    0.000 {getattr}
      972    0.005    0.000    0.030    0.000 compiler.py:1048(visit_bindparam)
      620    0.003    0.000    0.030    0.000 session.py:811(connection)
      708    0.004    0.000    0.029    0.000 elements.py:3370(_bind_param)
     2378    0.006    0.000    0.029    0.000 attributes.py:222(__set__)
      734    0.003    0.000    0.028    0.000 base.py:633(_declarative_constructor)
     4058    0.007    0.000    0.028    0.000 genericpath.py:15(exists)
      353    0.004    0.000    0.027    0.000 session.py:456(close)
      266    0.001    0.000    0.027    0.000 selectable.py:786(_match_primaries)
      690    0.003    0.000    0.026    0.000 attributes.py:1167(emit_backref_from_collection_append_event)
     1398    0.006    0.000    0.026    0.000 psycopg2.py:435(create_cursor)
    16108    0.016    0.000    0.026    0.000 compiler.py:2693(quote)
1464/1042    0.005    0.000    0.026    0.000 session.py:312(_connection_for_bind)
      266    0.002    0.000    0.026    0.000 selectable.py:793(_join_condition)
  778/734    0.005    0.000    0.025    0.000 attributes.py:815(fire_replace_event)
      708    0.015    0.000    0.025    0.000 elements.py:913(__init__)
      734    0.001    0.000    0.025    0.000 attributes.py:602(append)
      620    0.001    0.000    0.025    0.000 session.py:884(_connection_for_bind)
       85    0.001    0.000    0.025    0.000 unitofwork.py:375(finalize_flush_changes)
      734    0.005    0.000    0.024    0.000 default.py:1002(_process_executesingle_defaults)
     4332    0.014    0.000    0.024    0.000 constructor.py:260(construct_yaml_float)
       85    0.006    0.000    0.023    0.000 session.py:1491(_register_newly_persistent)
     1921    0.007    0.000    0.023    0.000 unitofwork.py:178(get_attribute_history)
 1240/886    0.003    0.000    0.023    0.000 annotation.py:71(_compiler_dispatch)
     5389    0.011    0.000    0.023    0.000 inspection.py:38(inspect)
     3805    0.004    0.000    0.023    0.000 {setattr}
     1030    0.004    0.000    0.023    0.000 persistence.py:256(_organize_states_for_save)
    16610    0.023    0.000    0.023    0.000 {method 'encode' of 'unicode' objects}
     1558    0.014    0.000    0.022    0.000 posixpath.py:336(normpath)
     1241    0.003    0.000    0.022    0.000 persistence.py:1017(_connections_for_states)
     7072    0.021    0.000    0.021    0.000 interfaces.py:466(_get_context_loader)
     3802    0.011    0.000    0.021    0.000 attributes.py:687(set)
      972    0.003    0.000    0.021    0.000 compiler.py:1117(_truncate_bindparam)
      620    0.002    0.000    0.021    0.000 result.py:944(fetchall)
     1398    0.010    0.000    0.021    0.000 compiler.py:455(construct_params)
      486    0.005    0.000    0.021    0.000 loading.py:478(_populate_full)
     4061    0.020    0.000    0.020    0.000 {posix.stat}
      622    0.005    0.000    0.020    0.000 selectable.py:3151(_columns_plus_names)
  706/353    0.001    0.000    0.020    0.000 operators.py:43(__and__)
    74243    0.020    0.000    0.020    0.000 {method 'get' of 'dict' objects}
     1398    0.003    0.000    0.020    0.000 pool.py:845(cursor)
      352    0.001    0.000    0.019    0.000 elements.py:2758(_copy_internals)
      487    0.002    0.000    0.019    0.000 session.py:694(begin)
      531    0.002    0.000    0.019    0.000 elements.py:1890(and_)
      734    0.002    0.000    0.019    0.000 base.py:1877(get_insert_default)
      778    0.006    0.000    0.019    0.000 arrow.py:425(to)
        1    0.000    0.000    0.019    0.019 vendors.py:71(length)
     4598    0.017    0.000    0.019    0.000 constructor.py:170(flatten_mapping)
     1468    0.008    0.000    0.019    0.000 sync.py:16(populate)
      176    0.002    0.000    0.018    0.000 relationships.py:1334(_optimized_compare)
     1508    0.005    0.000    0.018    0.000 _collections.py:794(to_list)
      621    0.005    0.000    0.018    0.000 query.py:122(_set_entity_selectables)
      945    0.012    0.000    0.017    0.000 persistence.py:362(_collect_insert_commands)
      734    0.003    0.000    0.017    0.000 dependency.py:759(_synchronize)
      126    0.001    0.000    0.017    0.000 dependency.py:541(process_saves)
      531    0.006    0.000    0.017    0.000 elements.py:1856(_construct)
      264    0.004    0.000    0.017    0.000 mapper.py:2451(_get_state_attr_by_column)
      353    0.001    0.000    0.017    0.000 {operator.and_}
     4069    0.005    0.000    0.017    0.000 default.py:753(get_result_processor)
  266/265    0.002    0.000    0.017    0.000 compiler.py:1803(visit_join)
     2131    0.009    0.000    0.017    0.000 base.py:36(_from_objects)
     1398    0.017    0.000    0.017    0.000 {method 'cursor' of 'psycopg2.extensions.connection' objects}
        2    0.000    0.000    0.017    0.008 fsutils.py:347(close)
        1    0.000    0.000    0.017    0.017 fsutils.py:366(_replace_current_file)
      734    0.002    0.000    0.017    0.000 default.py:962(get_insert_default)
        1    0.000    0.000    0.016    0.016 fsutils.py:373(_backup_current_file)
      487    0.003    0.000    0.016    0.000 session.py:169(__init__)
      176    0.001    0.000    0.016    0.000 visitors.py:280(cloned_traverse)
      211    0.001    0.000    0.016    0.000 unitofwork.py:557(execute)
      134    0.001    0.000    0.016    0.000 base.py:2020(contextual_connect)
      616    0.001    0.000    0.016    0.000 type_api.py:1009(process)
     1744    0.002    0.000    0.016    0.000 constructor.py:390(construct_yaml_seq)
     1239    0.009    0.000    0.016    0.000 elements.py:2724(__init__)
        1    0.000    0.000    0.015    0.015 fsutils.py:416(_delete_old_revisions)
        1    0.000    0.000    0.015    0.015 controller.py:289(get_vendor_map_length)
      134    0.001    0.000    0.015    0.000 session.py:2646(__call__)
  528/176    0.004    0.000    0.015    0.000 visitors.py:287(clone)
        1    0.015    0.015    0.015    0.015 {posix.remove}
      211    0.003    0.000    0.015    0.000 persistence.py:223(delete_obj)
     2286    0.009    0.000    0.015    0.000 abc.py:128(__instancecheck__)
    19850    0.010    0.000    0.015    0.000 string.py:220(lower)
      266    0.006    0.000    0.015    0.000 selectable.py:847(_joincond_scan_left_right)
    26616    0.012    0.000    0.015    0.000 constructor.py:105(construct_scalar)
      734    0.001    0.000    0.015    0.000 default.py:948(_exec_default)
      616    0.001    0.000    0.015    0.000 arrow.py:73(process_result_value)
      176    0.001    0.000    0.015    0.000 util.py:746(_orm_annotate)
        1    0.000    0.000    0.015    0.015 vendors.py:77(get_idents)
      622    0.003    0.000    0.015    0.000 query.py:3159(__new__)
     1528    0.002    0.000    0.014    0.000 _collections.py:727(__missing__)
      734    0.010    0.000    0.014    0.000 default.py:881(_setup_ins_pk_from_implicit_returning)
      176    0.000    0.000    0.014    0.000 annotation.py:106(_deep_annotate)
      778    0.005    0.000    0.014    0.000 unitofwork.py:71(set_)
     1864    0.007    0.000    0.014    0.000 _collections.py:747(unique_list)
  528/176    0.002    0.000    0.014    0.000 annotation.py:113(clone)
      353    0.001    0.000    0.014    0.000 default_comparator.py:89(_conjunction_operate)
      778    0.001    0.000    0.014    0.000 api.py:25(utcnow)
      974    0.004    0.000    0.014    0.000 elements.py:3624(apply_map)
      872    0.002    0.000    0.014    0.000 constructor.py:112(construct_sequence)
      134    0.001    0.000    0.014    0.000 base.py:793(close)
      134    0.002    0.000    0.014    0.000 session.py:512(__init__)
      528    0.001    0.000    0.013    0.000 api.py:17(get)
      734    0.001    0.000    0.013    0.000 schema.py:1990(<lambda>)
      734    0.002    0.000    0.013    0.000 dependency.py:565(_synchronize)
      134    0.000    0.000    0.013    0.000 pool.py:879(close)
      620    0.001    0.000    0.013    0.000 result.py:911(_fetchall_impl)
      892    0.003    0.000    0.013    0.000 base.py:285(__get__)
      778    0.001    0.000    0.013    0.000 factory.py:206(utcnow)
     2372    0.004    0.000    0.013    0.000 unitofwork.py:228(register_object)
     1502    0.005    0.000    0.013    0.000 interfaces.py:507(create_row_processor)
      255    0.002    0.000    0.012    0.000 dependency.py:445(presort_saves)
      134    0.001    0.000    0.012    0.000 pool.py:756(_checkin)
      620    0.004    0.000    0.012    0.000 compiler.py:438(_bind_processors)
      528    0.004    0.000    0.012    0.000 factory.py:32(get)
    17078    0.012    0.000    0.012    0.000 {built-in method __new__ of type object at 0x919120}
    43666    0.012    0.000    0.012    0.000 {method 'append' of 'list' objects}
     1860    0.005    0.000    0.012    0.000 base.py:389(_inspect_mapped_class)
      134    0.001    0.000    0.012    0.000 pool.py:615(_finalize_fairy)
     4069    0.006    0.000    0.012    0.000 type_api.py:382(_cached_result_processor)
      620    0.007    0.000    0.012    0.000 {method 'fetchall' of 'psycopg2.extensions.cursor' objects}
      529    0.001    0.000    0.012    0.000 elements.py:291(_annotate)
     9858    0.007    0.000    0.012    0.000 inspect.py:51(ismodule)
      176    0.000    0.000    0.011    0.000 elements.py:1168(effective_value)
       88    0.002    0.000    0.011    0.000 configbase.py:140(_verify_schema_decl)
      778    0.004    0.000    0.011    0.000 arrow.py:76(utcnow)
      624    0.004    0.000    0.011    0.000 _collections.py:359(__init__)
        1    0.000    0.000    0.011    0.011 query.py:2697(count)
    10839    0.011    0.000    0.011    0.000 {method 'update' of 'dict' objects}
      819    0.004    0.000    0.011    0.000 mapper.py:1774(_is_orphan)
      176    0.000    0.000    0.011    0.000 relationships.py:1385(_go)
      778    0.002    0.000    0.011    0.000 arrow.py:78(_coerce)
      422    0.004    0.000    0.011    0.000 persistence.py:1052(_sort_states)
        1    0.000    0.000    0.011    0.011 controller.py:279(get_vendor_idents)
     7985    0.010    0.000    0.011    0.000 {hasattr}
     4069    0.004    0.000    0.011    0.000 result.py:497(_getter)
       44    0.001    0.000    0.011    0.000 terminal.py:230(next)
     8886    0.011    0.000    0.011    0.000 state.py:277(dict)
      621    0.002    0.000    0.010    0.000 base.py:325(_is_mapped_class)
     1553    0.007    0.000    0.010    0.000 mapper.py:2397(_identity_key_from_state)
     7806    0.006    0.000    0.010    0.000 inspect.py:59(isclass)
      134    0.000    0.000    0.010    0.000 base.py:2071(_wrap_pool_connect)
      134    0.001    0.000    0.010    0.000 db.py:69(_format_frame)
       44    0.003    0.000    0.010    0.000 bar.py:65(update)
       88    0.000    0.000    0.010    0.000 session.py:1559(add)
      134    0.000    0.000    0.010    0.000 pool.py:367(connect)
     5270    0.009    0.000    0.010    0.000 state.py:524(_modified_event)
      892    0.002    0.000    0.010    0.000 base.py:108(_for_instance)
      134    0.001    0.000    0.010    0.000 session.py:1031(close)
      487    0.004    0.000    0.010    0.000 session.py:256(_take_snapshot)
     2084    0.006    0.000    0.009    0.000 arrow.py:49(__init__)
        1    0.000    0.000    0.009    0.009 query.py:2484(scalar)
     2242    0.008    0.000    0.009    0.000 {sorted}
     9234    0.009    0.000    0.009    0.000 attr.py:226(__bool__)
      134    0.001    0.000    0.009    0.000 pool.py:710(_checkout)
      822    0.001    0.000    0.009    0.000 session.py:1842(_save_or_update_impl)
      888    0.003    0.000    0.009    0.000 elements.py:3513(__new__)
      211    0.000    0.000    0.009    0.000 persistence.py:336(_organize_states_for_delete)
53966/53965    0.009    0.000    0.009    0.000 {len}
     5933    0.009    0.000    0.009    0.000 weakref.py:314(__getitem__)
      134    0.001    0.000    0.009    0.000 session.py:1076(_close_impl)
     2514    0.005    0.000    0.009    0.000 __init__.py:1345(isEnabledFor)
     1505    0.004    0.000    0.009    0.000 operators.py:895(is_precedent)
     9724    0.005    0.000    0.009    0.000 inspect.py:181(istraceback)
     1151    0.002    0.000    0.009    0.000 elements.py:2783(self_group)
    32086    0.009    0.000    0.009    0.000 resolver.py:111(ascend_resolver)
      528    0.003    0.000    0.008    0.000 elements.py:3919(__init__)
      619    0.005    0.000    0.008    0.000 query.py:3190(setup_entity)
     3970    0.008    0.000    0.008    0.000 {imp.get_suffixes}
      620    0.001    0.000    0.008    0.000 compiler.py:441(<genexpr>)
      778    0.007    0.000    0.008    0.000 persistence.py:959(_postfetch)
    19482    0.008    0.000    0.008    0.000 {method 'startswith' of 'str' objects}
     4068    0.007    0.000    0.008    0.000 strategies.py:141(setup_query)
       85    0.006    0.000    0.008    0.000 topological.py:55(find_cycles)
     1919    0.002    0.000    0.008    0.000 re.py:188(compile)
     1086    0.005    0.000    0.008    0.000 relationships.py:1504(cascade_iterator)
      892    0.003    0.000    0.008    0.000 base.py:105(_for_class)
      621    0.007    0.000    0.008    0.000 query.py:3715(__init__)
     4070    0.003    0.000    0.008    0.000 compiler.py:2722(format_label)
     2679    0.004    0.000    0.008    0.000 base.py:208(manager_of_class)
     1527    0.004    0.000    0.008    0.000 _collections.py:155(union)
      134    0.001    0.000    0.008    0.000 pool.py:478(checkout)
    32086    0.008    0.000    0.008    0.000 resolver.py:88(descend_resolver)
      734    0.003    0.000    0.008    0.000 session.py:1806(_save_impl)
      974    0.005    0.000    0.008    0.000 compiler.py:1149(_process_anon)
      134    0.001    0.000    0.008    0.000 pool.py:501(checkin)
      211    0.003    0.000    0.008    0.000 dependency.py:68(per_property_flush_actions)
      170    0.003    0.000    0.007    0.000 unitofwork.py:257(_per_mapper_flush_actions)
      486    0.003    0.000    0.007    0.000 instrumentation.py:311(new_instance)
     1742    0.005    0.000    0.007    0.000 posixpath.py:68(join)
     4069    0.007    0.000    0.007    0.000 result.py:419(_getter)
       88    0.001    0.000    0.007    0.000 strategies.py:448(_generate_lazy_clause)
     1592    0.003    0.000    0.007    0.000 compiler.py:442(<genexpr>)
     2374    0.003    0.000    0.007    0.000 unitofwork.py:402(<genexpr>)
       85    0.003    0.000    0.007    0.000 state.py:611(_commit_all_states)
      422    0.002    0.000    0.007    0.000 session.py:229(connection)
      734    0.002    0.000    0.007    0.000 result.py:999(fetchone)
     1153    0.003    0.000    0.007    0.000 selectable.py:35(_interpret_as_from)
      734    0.003    0.000    0.007    0.000 instrumentation.py:329(_new_state_if_none)
     7806    0.004    0.000    0.007    0.000 inspect.py:67(ismethod)
      989    0.002    0.000    0.007    0.000 attributes.py:740(get_history)
     4071    0.006    0.000    0.007    0.000 selectable.py:3156(name_for_col)
      850    0.002    0.000    0.007    0.000 dependency.py:230(prop_has_changes)
     5352    0.004    0.000    0.006    0.000 session.py:1967(_contains_state)
      778    0.005    0.000    0.006    0.000 {method 'astimezone' of 'datetime.datetime' objects}
     7806    0.004    0.000    0.006    0.000 inspect.py:142(isfunction)
      134    0.000    0.000    0.006    0.000 pool.py:388(_return_conn)
     9724    0.005    0.000    0.006    0.000 inspect.py:191(isframe)
      178    0.000    0.000    0.006    0.000 <string>:1(and_)
     1594    0.004    0.000    0.006    0.000 query.py:416(_clone)
     1919    0.004    0.000    0.006    0.000 re.py:226(_compile)
    24183    0.006    0.000    0.006    0.000 {method 'lower' of 'str' objects}
      134    0.001    0.000    0.006    0.000 pool.py:1030(_do_return_conn)
       88    0.000    0.000    0.006    0.000 strategy_options.py:781(lazyload)
      355    0.001    0.000    0.006    0.000 schema.py:1635(get_referent)
     1398    0.004    0.000    0.006    0.000 result.py:637(_soft_close)
      707    0.002    0.000    0.006    0.000 path_registry.py:62(set)
      929    0.001    0.000    0.006    0.000 topological.py:43(sort)
     1468    0.001    0.000    0.006    0.000 state.py:165(session)
       88    0.000    0.000    0.006    0.000 <string>:1(set_relationship_strategy)
     1220    0.006    0.000    0.006    0.000 state.py:75(__init__)
      176    0.002    0.000    0.006    0.000 elements.py:1183(_clone)
     4069    0.006    0.000    0.006    0.000 compiler.py:271(__init__)
      360    0.003    0.000    0.005    0.000 selectable.py:450(corresponding_column)
       89    0.000    0.000    0.005    0.000 base.py:40(_generative)
      134    0.001    0.000    0.005    0.000 queue.py:87(put)
     1468    0.002    0.000    0.005    0.000 dependency.py:253(_verify_canload)
     1354    0.005    0.000    0.005    0.000 result.py:928(process_rows)
      778    0.003    0.000    0.005    0.000 arrow.py:335(naive)
     4069    0.004    0.000    0.005    0.000 compiler.py:1272(_add_to_result_map)
      356    0.003    0.000    0.005    0.000 elements.py:235(_clone)
      892    0.004    0.000    0.005    0.000 base.py:74(__init__)
      819    0.003    0.000    0.005    0.000 attributes.py:1330(from_object_attribute)
      134    0.002    0.000    0.005    0.000 base.py:47(__init__)
      754    0.003    0.000    0.005    0.000 langhelpers.py:1033(_next)
     1187    0.003    0.000    0.005    0.000 unitofwork.py:399(_mappers)
  778/734    0.003    0.000    0.005    0.000 attributes.py:1129(emit_backref_from_scalar_set_event)
      355    0.003    0.000    0.005    0.000 elements.py:1821(_from_objects)
     1462    0.002    0.000    0.005    0.000 utf_8.py:15(decode)
     1242    0.001    0.000    0.005    0.000 selectable.py:2438(<genexpr>)
     7806    0.004    0.000    0.005    0.000 inspect.py:209(iscode)
     3822    0.003    0.000    0.005    0.000 projfile.py:49(strip_line)
      620    0.003    0.000    0.005    0.000 query.py:306(_bind_mapper)
      620    0.002    0.000    0.005    0.000 session.py:1279(_autoflush)
     3064    0.005    0.000    0.005    0.000 _weakrefset.py:70(__contains__)
      260    0.005    0.000    0.005    0.000 {open}
      134    0.001    0.000    0.005    0.000 pool.py:1039(_do_get)
      622    0.004    0.000    0.005    0.000 elements.py:3665(_select_iterables)
     2257    0.002    0.000    0.005    0.000 attr.py:214(__call__)
      528    0.002    0.000    0.005    0.000 arrow.py:118(fromdatetime)
     1556    0.003    0.000    0.005    0.000 session.py:37(_state_session)
      860    0.004    0.000    0.005    0.000 attributes.py:1290(as_state)
      510    0.003    0.000    0.005    0.000 topological.py:16(sort_as_subsets)
     1282    0.002    0.000    0.005    0.000 unitofwork.py:503(_elements)
     1042    0.003    0.000    0.005    0.000 session.py:1142(get_bind)
     5552    0.005    0.000    0.005    0.000 {_codecs.utf_8_encode}
     7243    0.004    0.000    0.004    0.000 {method 'intersection' of 'set' objects}
       88    0.000    0.000    0.004    0.000 strategy_options.py:190(set_relationship_strategy)
      381    0.001    0.000    0.004    0.000 dependency.py:581(_pks_changed)
     5470    0.004    0.000    0.004    0.000 nodes.py:36(__init__)
     1514    0.004    0.000    0.004    0.000 base.py:89(__getattr__)
     5003    0.004    0.000    0.004    0.000 {method 'copy' of 'dict' objects}
      620    0.004    0.000    0.004    0.000 query.py:3107(_adjust_for_single_inheritance)
      992    0.004    0.000    0.004    0.000 _collections.py:315(values)
      847    0.001    0.000    0.004    0.000 __init__.py:1130(debug)
      972    0.004    0.000    0.004    0.000 compiler.py:1155(bindparam_string)
     1244    0.003    0.000    0.004    0.000 session.py:2016(_is_clean)
      134    0.001    0.000    0.004    0.000 queue.py:130(get)
     1354    0.003    0.000    0.004    0.000 {zip}
     1858    0.002    0.000    0.004    0.000 elements.py:3765(_expression_literal_as_text)
     2685    0.004    0.000    0.004    0.000 {method 'get' of 'dictproxy' objects}
      893    0.003    0.000    0.004    0.000 elements.py:3469(__new__)
      219    0.002    0.000    0.004    0.000 session.py:358(_prepare_impl)
     5827    0.004    0.000    0.004    0.000 {method 'split' of 'str' objects}
     1382    0.004    0.000    0.004    0.000 {posix.getcwd}
      819    0.001    0.000    0.004    0.000 instrumentation.py:354(has_parent)
      972    0.002    0.000    0.004    0.000 type_api.py:372(_cached_bind_processor)
    10860    0.004    0.000    0.004    0.000 {method 'replace' of 'str' objects}
    17112    0.004    0.000    0.004    0.000 {method 'add' of 'set' objects}
     4068    0.004    0.000    0.004    0.000 compiler.py:280(type)
      779    0.003    0.000    0.004    0.000 _collections.py:879(get)
     2514    0.004    0.000    0.004    0.000 __init__.py:1331(getEffectiveLevel)
     1918    0.002    0.000    0.004    0.000 <string>:8(__new__)
     4692    0.004    0.000    0.004    0.000 elements.py:3292(_get_table)
      353    0.001    0.000    0.004    0.000 elements.py:1967(self_group)
       44    0.001    0.000    0.004    0.000 terminal.py:241(writeln)
      381    0.002    0.000    0.004    0.000 sync.py:106(source_modified)
      734    0.002    0.000    0.004    0.000 attr.py:250(__call__)
      907    0.003    0.000    0.004    0.000 _collections.py:144(__new__)
     1241    0.002    0.000    0.004    0.000 unitofwork.py:293(states_for_mapper_hierarchy)
      129    0.000    0.000    0.004    0.000 persistence.py:1047(<lambda>)
     2481    0.004    0.000    0.004    0.000 elements.py:698(self_group)
      734    0.002    0.000    0.003    0.000 attributes.py:496(sethasparent)
      134    0.002    0.000    0.003    0.000 session.py:1082(expunge_all)
       88    0.001    0.000    0.003    0.000 decimal.py:515(__new__)
     1398    0.003    0.000    0.003    0.000 default.py:692(should_autocommit)
      211    0.002    0.000    0.003    0.000 persistence.py:918(_finalize_insert_update_commands)
     1398    0.003    0.000    0.003    0.000 {sqlalchemy.cutils._distill_params}
       88    0.000    0.000    0.003    0.000 configbase.py:83(validate)
     4070    0.002    0.000    0.003    0.000 elements.py:3839(_interpret_as_column_or_from)
     2084    0.002    0.000    0.003    0.000 util.py:37(isstr)
      170    0.003    0.000    0.003    0.000 cyaml.py:30(__init__)
       88    0.000    0.000    0.003    0.000 query.py:1090(options)
      134    0.001    0.000    0.003    0.000 pool.py:764(_reset)
     1468    0.003    0.000    0.003    0.000 mapper.py:2284(_canload)
     1462    0.003    0.000    0.003    0.000 {_codecs.utf_8_decode}
      529    0.002    0.000    0.003    0.000 annotation.py:45(__init__)
      129    0.001    0.000    0.003    0.000 base.py:149(execution_options)
     1241    0.001    0.000    0.003    0.000 langhelpers.py:750(_reset)
     3218    0.002    0.000    0.003    0.000 _collections.py:688(<genexpr>)
     1244    0.003    0.000    0.003    0.000 elements.py:2754(_from_objects)
     1608    0.003    0.000    0.003    0.000 weakref.py:282(__init__)
     1470    0.002    0.000    0.003    0.000 posixpath.py:59(isabs)
      778    0.003    0.000    0.003    0.000 {built-in method utcnow}
      778    0.003    0.000    0.003    0.000 parser.py:281(parse)
       88    0.000    0.000    0.003    0.000 <string>:1(_options)
      887    0.002    0.000    0.003    0.000 compiler.py:1788(visit_table)
     2478    0.002    0.000    0.003    0.000 elements.py:3769(_literal_as_text)
      270    0.002    0.000    0.003    0.000 threading.py:146(acquire)
    16029    0.003    0.000    0.003    0.000 {hash}
      176    0.001    0.000    0.003    0.000 decimal.py:889(__le__)
     2409    0.003    0.000    0.003    0.000 session.py:190(_assert_active)
      778    0.003    0.000    0.003    0.000 {method 'replace' of 'datetime.datetime' objects}
      528    0.003    0.000    0.003    0.000 util.py:25(is_timestamp)
      354    0.001    0.000    0.003    0.000 elements.py:1825(self_group)
       85    0.001    0.000    0.003    0.000 aggregates.py:535(construct_aggregate_queries)
      734    0.003    0.000    0.003    0.000 schema.py:2565(__iter__)
       88    0.000    0.000    0.003    0.000 __init__.py:39(__getitem__)
       44    0.000    0.000    0.003    0.000 attributes.py:1066(set_committed_value)
      734    0.002    0.000    0.003    0.000 session.py:1914(_before_attach)
       88    0.001    0.000    0.003    0.000 strategy_options.py:110(_generate_path)
      134    0.000    0.000    0.003    0.000 base.py:534(begin)
      708    0.002    0.000    0.002    0.000 type_api.py:424(coerce_compared_value)
     2504    0.002    0.000    0.002    0.000 identity.py:106(contains_state)
      255    0.001    0.000    0.002    0.000 persistence.py:416(_collect_update_commands)
       88    0.001    0.000    0.002    0.000 decimal.py:662(from_float)
      974    0.002    0.000    0.002    0.000 {method 'split' of 'unicode' objects}
     1606    0.002    0.000    0.002    0.000 unitofwork.py:454(__new__)
      819    0.001    0.000    0.002    0.000 identity.py:109(replace)
      442    0.001    0.000    0.002    0.000 state.py:251(_cleanup)
      734    0.001    0.000    0.002    0.000 result.py:896(_fetchone_impl)
     1398    0.002    0.000    0.002    0.000 base.py:1220(_safe_close_cursor)
      975    0.002    0.000    0.002    0.000 query.py:228(_adapt_clause)
      734    0.002    0.000    0.002    0.000 session.py:1935(_attach)
     1515    0.002    0.000    0.002    0.000 elements.py:3657(_expand_cloned)
       88    0.001    0.000    0.002    0.000 query.py:1105(_options)
      134    0.001    0.000    0.002    0.000 base.py:1595(__init__)
     1400    0.002    0.000    0.002    0.000 _collections.py:394(__iter__)
      621    0.002    0.000    0.002    0.000 query.py:2638(_select_args)
     6432    0.002    0.000    0.002    0.000 {method 'update' of 'set' objects}
      170    0.001    0.000    0.002    0.000 dependency.py:708(presort_saves)
      178    0.001    0.000    0.002    0.000 base.py:359(_entity_descriptor)
     3925    0.002    0.000    0.002    0.000 {max}
     1502    0.002    0.000    0.002    0.000 strategies.py:615(create_row_processor)
      266    0.001    0.000    0.002    0.000 query.py:1983(_prepare_right_side)
       85    0.001    0.000    0.002    0.000 session.py:1542(_register_altered)
     1609    0.002    0.000    0.002    0.000 _collections.py:687(__iter__)
      126    0.000    0.000    0.002    0.000 dependency.py:495(process_deletes)
      734    0.002    0.000    0.002    0.000 mapper.py:2828(_event_on_init)
      482    0.001    0.000    0.002    0.000 constructor.py:223(construct_yaml_bool)
      425    0.000    0.000    0.002    0.000 dependency.py:59(per_property_preprocessors)
     2038    0.002    0.000    0.002    0.000 {method 'difference' of 'set' objects}
     1245    0.001    0.000    0.002    0.000 type_api.py:1137(to_instance)
      819    0.001    0.000    0.002    0.000 attributes.py:474(hasparent)
     1468    0.002    0.000    0.002    0.000 attr.py:261(__iter__)
      265    0.001    0.000    0.002    0.000 selectable.py:1057(_hide_froms)
     1241    0.001    0.000    0.002    0.000 langhelpers.py:753(reset)
      619    0.001    0.000    0.002    0.000 query.py:3180(__init__)
     1468    0.002    0.000    0.002    0.000 schema.py:2570(<genexpr>)
      268    0.001    0.000    0.002    0.000 threading.py:372(notify)
      904    0.001    0.000    0.002    0.000 session.py:1533(<genexpr>)
       85    0.000    0.000    0.002    0.000 attributes.py:893(get_history)
     1918    0.002    0.000    0.002    0.000 linecache.py:33(getlines)
       85    0.000    0.000    0.002    0.000 session.py:234(_begin)
      134    0.001    0.000    0.002    0.000 weakref.py:98(__setitem__)
      799    0.001    0.000    0.002    0.000 query.py:289(_mapper_zero)
       44    0.001    0.000    0.002    0.000 __init__.py:91(eta_td)
  270/268    0.001    0.000    0.002    0.000 selectable.py:1062(_from_objects)
        1    0.000    0.000    0.002    0.002 query.py:971(from_self)
     1244    0.002    0.000    0.002    0.000 identity.py:53(check_modified)
      690    0.001    0.000    0.002    0.000 vendors.py:205(__init__)
      176    0.001    0.000    0.002    0.000 validate.py:476(get_dict_val)
      176    0.001    0.000    0.001    0.000 decimal.py:800(_cmp)
      264    0.001    0.000    0.001    0.000 elements.py:2742(__bool__)
       45    0.001    0.000    0.001    0.000 {method 'flush' of 'file' objects}
      734    0.001    0.000    0.001    0.000 persistence.py:731(<lambda>)
     1398    0.001    0.000    0.001    0.000 result.py:632(_cursor_description)
       88    0.001    0.000    0.001    0.000 attributes.py:900(get_all_pending)
      132    0.001    0.000    0.001    0.000 state.py:565(_commit)
     1238    0.001    0.000    0.001    0.000 query.py:3262(_get_entity_clauses)
      425    0.001    0.000    0.001    0.000 unitofwork.py:223(register_preprocessor)
      134    0.001    0.000    0.001    0.000 default.py:419(do_rollback)
      619    0.001    0.000    0.001    0.000 path_registry.py:70(get)
      355    0.001    0.000    0.001    0.000 elements.py:716(comparator)
     3218    0.001    0.000    0.001    0.000 _collections.py:689(<genexpr>)
      211    0.001    0.000    0.001    0.000 persistence.py:835(_emit_delete_statements)
     2641    0.001    0.000    0.001    0.000 {method 'values' of 'dict' objects}
     1305    0.001    0.000    0.001    0.000 {method 'issuperset' of 'frozenset' objects}
      621    0.001    0.000    0.001    0.000 selectable.py:1695(__init__)
      734    0.001    0.000    0.001    0.000 {method 'fetchone' of 'psycopg2.extensions.cursor' objects}
       85    0.001    0.000    0.001    0.000 session.py:1959(__iter__)
      530    0.001    0.000    0.001    0.000 annotation.py:31(__new__)
     1798    0.001    0.000    0.001    0.000 {method 'difference_update' of 'set' objects}
       41    0.001    0.000    0.001    0.000 attributes.py:1356(from_collection)
     1556    0.001    0.000    0.001    0.000 weakref.py:69(__getitem__)
      531    0.001    0.000    0.001    0.000 _collections.py:787(coerce_generator_arg)
      270    0.001    0.000    0.001    0.000 threading.py:186(release)
     1860    0.001    0.000    0.001    0.000 instrumentation.py:94(is_mapped)
      998    0.001    0.000    0.001    0.000 attributes.py:752(get_all_pending)
     2096    0.001    0.000    0.001    0.000 {method 'endswith' of 'str' objects}
      134    0.001    0.000    0.001    0.000 base.py:642(_begin_impl)
     2699    0.001    0.000    0.001    0.000 attributes.py:1251(__bool__)
     2484    0.001    0.000    0.001    0.000 {method 'keys' of 'dict' objects}
     1023    0.001    0.000    0.001    0.000 {method 'acquire' of 'thread.lock' objects}
      422    0.001    0.000    0.001    0.000 persistence.py:1044(_cached_connection_dict)
     2523    0.001    0.000    0.001    0.000 {method 'pop' of 'list' objects}
      176    0.001    0.000    0.001    0.000 relationships.py:1363(visit_bindparam)
      863    0.001    0.000    0.001    0.000 instrumentation.py:302(get_impl)
       44    0.000    0.000    0.001    0.000 attributes.py:976(_initialize_collection)
      264    0.001    0.000    0.001    0.000 controller.py:57(_get_ident)
      170    0.001    0.000    0.001    0.000 _collections.py:183(__iter__)
       88    0.000    0.000    0.001    0.000 <string>:1(params)
     1468    0.001    0.000    0.001    0.000 {method 'difference' of 'frozenset' objects}
       88    0.000    0.000    0.001    0.000 configbase.py:485(configdata)
     5866    0.001    0.000    0.001    0.000 {id}
     3265    0.001    0.000    0.001    0.000 {iter}
      178    0.001    0.000    0.001    0.000 query.py:300(_joinpoint_zero)
      129    0.000    0.000    0.001    0.000 attributes.py:675(get_history)
       44    0.001    0.000    0.001    0.000 vendors.py:376(abs_moq)
      734    0.001    0.000    0.001    0.000 identity.py:39(_manage_incoming_state)
       88    0.000    0.000    0.001    0.000 <string>:1(_adapt_all_clauses)
     1239    0.001    0.000    0.001    0.000 query.py:389(_no_limit_offset)
      422    0.001    0.000    0.001    0.000 unitofwork.py:475(__init__)
        2    0.000    0.000    0.001    0.001 fsutils.py:400(_revisions)
     1239    0.001    0.000    0.001    0.000 query.py:381(_no_statement_condition)
     3545    0.001    0.000    0.001    0.000 {method 'pop' of 'dict' objects}
     4069    0.001    0.000    0.001    0.000 elements.py:3521(apply_map)
       44    0.001    0.000    0.001    0.000 {method 'writerow' of '_csv.writer' objects}
        2    0.000    0.000    0.001    0.000 glob.py:18(glob)
       44    0.000    0.000    0.001    0.000 __init__.py:87(eta)
        9    0.000    0.000    0.001    0.000 glob.py:29(iglob)
     1468    0.001    0.000    0.001    0.000 unitofwork.py:158(is_deleted)
     1086    0.001    0.000    0.001    0.000 relationships.py:1731(_get_cascade)
     4164    0.001    0.000    0.001    0.000 mapper.py:642(mapper)
     2216    0.001    0.000    0.001    0.000 mapper.py:1965(selectable)
       88    0.000    0.000    0.001    0.000 conffile.py:51(_cfpath)
      134    0.001    0.000    0.001    0.000 base.py:116(_join)
      129    0.001    0.000    0.001    0.000 base.py:135(_clone)
        1    0.000    0.000    0.001    0.001 fsutils.py:393(_current_revision)
     2054    0.001    0.000    0.001    0.000 {min}
     1238    0.001    0.000    0.001    0.000 annotation.py:90(__hash__)
     4071    0.001    0.000    0.001    0.000 elements.py:758(_select_iterable)
        2    0.000    0.000    0.001    0.000 glob.py:66(glob1)
      425    0.001    0.000    0.001    0.000 unitofwork.py:282(<lambda>)
     1398    0.001    0.000    0.001    0.000 compiler.py:215(__str__)
     5074    0.001    0.000    0.001    0.000 {method 'strip' of 'str' objects}
      619    0.001    0.000    0.001    0.000 mapper.py:1890(_with_polymorphic_mappers)
      398    0.001    0.000    0.001    0.000 identity.py:190(_fast_discard)
      633    0.001    0.000    0.001    0.000 mapper.py:2652(_memo)
       88    0.001    0.000    0.001    0.000 {_warnings.warn}
     6979    0.001    0.000    0.001    0.000 {method 'popleft' of 'collections.deque' objects}
      268    0.000    0.000    0.001    0.000 pool.py:854(__getattr__)
      211    0.001    0.000    0.001    0.000 _collections.py:312(keys)
      264    0.001    0.000    0.001    0.000 query.py:3245(corresponds_to)
       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 strategy_options.py:94(process_query)
      779    0.001    0.000    0.001    0.000 _collections.py:875(_inc_counter)
     1220    0.001    0.000    0.001    0.000 <string>:1(set)
       88    0.000    0.000    0.001    0.000 path_registry.py:250(entity_path)
     1128    0.001    0.000    0.001    0.000 _collections.py:724(__init__)
      734    0.001    0.000    0.001    0.000 {method 'issubset' of 'frozenset' objects}
      904    0.001    0.000    0.001    0.000 identity.py:72(__len__)
      820    0.001    0.000    0.001    0.000 weakref.py:320(__setitem__)
       91    0.001    0.000    0.001    0.000 {print}
        2    0.000    0.000    0.001    0.000 fnmatch.py:45(filter)
      129    0.000    0.000    0.001    0.000 attributes.py:1303(from_scalar_attribute)
      134    0.000    0.000    0.001    0.000 log.py:54(_should_log_debug)
      530    0.001    0.000    0.001    0.000 identity.py:145(get)
        1    0.000    0.000    0.001    0.001 <string>:1(_from_selectable)
      268    0.001    0.000    0.001    0.000 identity.py:14(__init__)
     1638    0.001    0.000    0.001    0.000 mapper.py:2299(iterate_to_root)
      486    0.001    0.000    0.001    0.000 identity.py:140(_add_unpresent)
        1    0.000    0.000    0.001    0.001 query.py:992(_from_selectable)
      5/2    0.000    0.000    0.001    0.000 selectable.py:537(columns)
       88    0.000    0.000    0.001    0.000 <string>:1(_with_invoke_all_eagers)
       88    0.000    0.000    0.001    0.000 strategy_options.py:86(_generate)
      219    0.000    0.000    0.001    0.000 identity.py:184(all_states)
      270    0.001    0.000    0.001    0.000 elements.py:269(_cloned_set)
       85    0.001    0.000    0.001    0.000 unitofwork.py:109(__init__)
      134    0.001    0.000    0.001    0.000 contextlib.py:82(helper)
     1984    0.001    0.000    0.001    0.000 {method 'isdisjoint' of 'set' objects}
       88    0.000    0.000    0.001    0.000 path_registry.py:254(__getitem__)
      690    0.001    0.000    0.001    0.000 currency.py:219(__init__)
       44    0.000    0.000    0.001    0.000 instrumentation.py:290(initialize_collection)
       88    0.000    0.000    0.001    0.000 strategy_options.py:100(_process)
      134    0.001    0.000    0.001    0.000 session.py:297(_remove_snapshot)
       85    0.000    0.000    0.001    0.000 identity.py:163(values)
     1468    0.001    0.000    0.001    0.000 mapper.py:2334(primary_mapper)
      134    0.000    0.000    0.001    0.000 log.py:57(_should_log_info)
       44    0.000    0.000    0.001    0.000 state.py:502(unloaded)
      134    0.001    0.000    0.001    0.000 pool.py:559(get_connection)
      621    0.001    0.000    0.001    0.000 base.py:1472(get_select_precolumns)
       88    0.000    0.000    0.001    0.000 configbase.py:77(__init__)
       88    0.000    0.000    0.001    0.000 configbase.py:128(_schema_name_policy)
        2    0.000    0.000    0.001    0.000 query.py:3693(setup_context)
      425    0.001    0.000    0.001    0.000 unitofwork.py:411(__init__)
        1    0.000    0.000    0.001    0.001 query.py:422(statement)
       44    0.000    0.000    0.001    0.000 helpers.py:61(clearln)
      819    0.001    0.000    0.001    0.000 state.py:234(has_identity)
      907    0.001    0.000    0.001    0.000 {method 'intersection' of 'frozenset' objects}
      448    0.001    0.000    0.001    0.000 {method 'remove' of 'list' objects}
        1    0.000    0.000    0.001    0.001 query.py:3656(adapt_to_selectable)
      266    0.001    0.000    0.001    0.000 selectable.py:874(<lambda>)
        1    0.000    0.000    0.001    0.001 visitors.py:304(replacement_traverse)
       44    0.000    0.000    0.001    0.000 attributes.py:629(set_committed_value)
      176    0.000    0.000    0.001    0.000 decimal.py:760(_compare_check_nans)
        1    0.000    0.000    0.001    0.001 compiler.py:1244(visit_alias)
       88    0.000    0.000    0.001    0.000 strategy_options.py:185(_coerce_strat)
      5/1    0.000    0.000    0.001    0.001 visitors.py:311(clone)
      754    0.001    0.000    0.001    0.000 {next}
      134    0.001    0.000    0.001    0.000 weakref.py:267(__init__)
      804    0.001    0.000    0.001    0.000 base.py:301(connection)
      126    0.000    0.000    0.001    0.000 dependency.py:324(per_property_dependencies)
     1426    0.001    0.000    0.001    0.000 selectable.py:1418(_from_objects)
     1556    0.001    0.000    0.001    0.000 tz.py:47(utcoffset)
       88    0.000    0.000    0.001    0.000 _collections.py:805(has_intersection)
      176    0.000    0.000    0.001    0.000 validate.py:463(__init__)
      381    0.000    0.000    0.000    0.000 unitofwork.py:164(memo)
       88    0.000    0.000    0.000    0.000 query.py:1254(params)
        1    0.000    0.000    0.000    0.000 sre_compile.py:493(compile)
      211    0.000    0.000    0.000    0.000 _collections.py:318(items)
     1023    0.000    0.000    0.000    0.000 {method 'release' of 'thread.lock' objects}
      132    0.000    0.000    0.000    0.000 __init__.py:99(progress)
     1421    0.000    0.000    0.000    0.000 vendors.py:210(moq)
     1398    0.000    0.000    0.000    0.000 default.py:750(post_exec)
      945    0.000    0.000    0.000    0.000 persistence.py:180(<genexpr>)
      360    0.000    0.000    0.000    0.000 base.py:590(contains_column)
      822    0.000    0.000    0.000    0.000 state.py:244(_detach)
      268    0.000    0.000    0.000    0.000 threading.py:237(_is_owned)
     1398    0.000    0.000    0.000    0.000 {method 'close' of 'psycopg2.extensions.cursor' objects}
        2    0.000    0.000    0.000    0.000 selectable.py:3179(_populate_column_collection)
      487    0.000    0.000    0.000    0.000 {method 'items' of 'dict' objects}
      844    0.000    0.000    0.000    0.000 mapper.py:2340(primary_base_mapper)
      176    0.000    0.000    0.000    0.000 _collections.py:846(flatten_iterator)
       88    0.000    0.000    0.000    0.000 {method 'as_integer_ratio' of 'float' objects}
      126    0.000    0.000    0.000    0.000 collections.py:687(__iter__)
       44    0.000    0.000    0.000    0.000 type_api.py:1057(compare_values)
      135    0.000    0.000    0.000    0.000 {range}
       88    0.000    0.000    0.000    0.000 strategy_options.py:80(__init__)
      592    0.000    0.000    0.000    0.000 unitofwork.py:524(__init__)
      706    0.000    0.000    0.000    0.000 {method 'union' of 'set' objects}
     1244    0.000    0.000    0.000    0.000 {callable}
     1398    0.000    0.000    0.000    0.000 default.py:747(pre_exec)
      734    0.000    0.000    0.000    0.000 identity.py:94(__contains__)
      808    0.000    0.000    0.000    0.000 threading.py:63(_note)
        3    0.000    0.000    0.000    0.000 schema.py:1346(_make_proxy)
      134    0.000    0.000    0.000    0.000 {method 'format' of 'str' objects}
      621    0.000    0.000    0.000    0.000 session.py:225(_is_transaction_boundary)
      176    0.000    0.000    0.000    0.000 interfaces.py:486(_get_strategy)
        1    0.000    0.000    0.000    0.000 elements.py:3125(_copy_internals)
      874    0.000    0.000    0.000    0.000 {method 'extend' of 'list' objects}
     1385    0.000    0.000    0.000    0.000 posixpath.py:51(normcase)
      134    0.000    0.000    0.000    0.000 weakref.py:262(__new__)
      255    0.000    0.000    0.000    0.000 dependency.py:797(per_property_preprocessors)
      819    0.000    0.000    0.000    0.000 {method 'clear' of 'dict' objects}
      709    0.000    0.000    0.000    0.000 query.py:3746(<genexpr>)
      355    0.000    0.000    0.000    0.000 type_api.py:53(__init__)
      352    0.000    0.000    0.000    0.000 decimal.py:2803(adjusted)
      778    0.000    0.000    0.000    0.000 base.py:121(_root)
        5    0.000    0.000    0.000    0.000 query.py:268(replace)
        3    0.000    0.000    0.000    0.000 query.py:3539(__init__)
      170    0.000    0.000    0.000    0.000 constructor.py:20(__init__)
       44    0.000    0.000    0.000    0.000 __init__.py:44(avg)
       88    0.000    0.000    0.000    0.000 configbase.py:134(_schema_ver_policy)
        5    0.000    0.000    0.000    0.000 util.py:492(replace)
       88    0.000    0.000    0.000    0.000 decimal.py:3724(_dec_from_triple)
       88    0.000    0.000    0.000    0.000 base.py:314(_generate)
        1    0.000    0.000    0.000    0.000 selectable.py:3432(__init__)
     1556    0.000    0.000    0.000    0.000 tz.py:50(dst)
     1502    0.000    0.000    0.000    0.000 interfaces.py:617(setup_query)
       88    0.000    0.000    0.000    0.000 path_registry.py:267(__init__)
      798    0.000    0.000    0.000    0.000 query.py:286(_entity_zero)
       85    0.000    0.000    0.000    0.000 dependency.py:594(per_property_dependencies)
       90    0.000    0.000    0.000    0.000 {method 'isatty' of 'file' objects}
       41    0.000    0.000    0.000    0.000 attributes.py:890(__copy)
      266    0.000    0.000    0.000    0.000 query.py:2112(_reset_joinpoint)
      211    0.000    0.000    0.000    0.000 attributes.py:1255(empty)
        1    0.000    0.000    0.000    0.000 selectable.py:1123(_populate_column_collection)
      134    0.000    0.000    0.000    0.000 queue.py:194(_put)
      592    0.000    0.000    0.000    0.000 unitofwork.py:553(__init__)
       88    0.000    0.000    0.000    0.000 path_registry.py:283(__getitem__)
      507    0.000    0.000    0.000    0.000 persistence.py:1054(<genexpr>)
       85    0.000    0.000    0.000    0.000 six.py:552(iteritems)
      141    0.000    0.000    0.000    0.000 weakref.py:48(remove)
      134    0.000    0.000    0.000    0.000 queue.py:190(_full)
      959    0.000    0.000    0.000    0.000 {method 'discard' of 'set' objects}
       85    0.000    0.000    0.000    0.000 unitofwork.py:271(_mapper_for_dep)
      810    0.000    0.000    0.000    0.000 {thread.get_ident}
      211    0.000    0.000    0.000    0.000 _collections.py:309(__iter__)
       88    0.000    0.000    0.000    0.000 session.py:1818(_update_impl)
      889    0.000    0.000    0.000    0.000 selectable.py:170(selectable)
      778    0.000    0.000    0.000    0.000 state.py:221(parents)
      134    0.000    0.000    0.000    0.000 session.py:239(_iterate_parents)
      134    0.000    0.000    0.000    0.000 base.py:255(__init__)
        1    0.000    0.000    0.000    0.000 sre_parse.py:675(parse)
      134    0.000    0.000    0.000    0.000 queue.py:198(_get)
      711    0.000    0.000    0.000    0.000 langhelpers.py:825(<lambda>)
        1    0.000    0.000    0.000    0.000 sre_parse.py:301(_parse_sub)
       44    0.000    0.000    0.000    0.000 type_api.py:276(compare_values)
        1    0.000    0.000    0.000    0.000 sre_parse.py:379(_parse)
      170    0.000    0.000    0.000    0.000 resolver.py:21(__init__)
      264    0.000    0.000    0.000    0.000 validate.py:380(__init__)
      176    0.000    0.000    0.000    0.000 interfaces.py:362(adapter)
     1222    0.000    0.000    0.000    0.000 {method 'remove' of 'set' objects}
      482    0.000    0.000    0.000    0.000 {method 'lower' of 'unicode' objects}
       44    0.000    0.000    0.000    0.000 __init__.py:95(percent)
      265    0.000    0.000    0.000    0.000 mapper.py:2278(common_parent)
       64    0.000    0.000    0.000    0.000 constructor.py:210(construct_yaml_null)
      907    0.000    0.000    0.000    0.000 _collections.py:149(__init__)
        1    0.000    0.000    0.000    0.000 __init__.py:1142(info)
      134    0.000    0.000    0.000    0.000 pool.py:677(__init__)
      176    0.000    0.000    0.000    0.000 decimal.py:441(getcontext)
      176    0.000    0.000    0.000    0.000 decimal.py:5835(_convert_other)
      690    0.000    0.000    0.000    0.000 collections.py:696(__bool__)
      690    0.000    0.000    0.000    0.000 currency.py:248(source_value)
       44    0.000    0.000    0.000    0.000 loading.py:506(_populate_partial)
      734    0.000    0.000    0.000    0.000 state.py:521(_instance_dict)
      134    0.000    0.000    0.000    0.000 {method 'rollback' of 'psycopg2.extensions.connection' objects}
      536    0.000    0.000    0.000    0.000 {method 'setdefault' of 'dict' objects}
      134    0.000    0.000    0.000    0.000 base.py:1532(__init__)
        1    0.000    0.000    0.000    0.000 __init__.py:1252(_log)
        1    0.000    0.000    0.000    0.000 sre_compile.py:478(_code)
      705    0.000    0.000    0.000    0.000 elements.py:378(_copy_internals)
        1    0.000    0.000    0.000    0.000 functions.py:155(_copy_internals)
        1    0.000    0.000    0.000    0.000 terminal.py:221(__init__)
        4    0.000    0.000    0.000    0.000 util.py:476(_corresponding_column)
        1    0.000    0.000    0.000    0.000 linecache.py:68(updatecache)
       89    0.000    0.000    0.000    0.000 selectable.py:857(<lambda>)
       44    0.000    0.000    0.000    0.000 {sum}
       85    0.000    0.000    0.000    0.000 session.py:2506(_dirty_states)
      690    0.000    0.000    0.000    0.000 vendors.py:488(currency)
        3    0.000    0.000    0.000    0.000 schema.py:861(__init__)
      352    0.000    0.000    0.000    0.000 decimal.py:793(__nonzero__)
      690    0.000    0.000    0.000    0.000 vendors.py:218(unit_price)
       44    0.000    0.000    0.000    0.000 result.py:536(rowcount)
        1    0.000    0.000    0.000    0.000 functions.py:258(__call__)
      176    0.000    0.000    0.000    0.000 relationships.py:1384(_get_attr_w_warn_on_none)
       44    0.000    0.000    0.000    0.000 collections.py:578(__init__)
      211    0.000    0.000    0.000    0.000 persistence.py:568(_collect_delete_commands)
        1    0.000    0.000    0.000    0.000 selectable.py:1118(is_derived_from)
      135    0.000    0.000    0.000    0.000 {sys._getframe}
        1    0.000    0.000    0.000    0.000 fnmatch.py:81(translate)
       44    0.000    0.000    0.000    0.000 arrow.py:700(__eq__)
      264    0.000    0.000    0.000    0.000 query.py:3241(entity_zero_or_selectable)
        1    0.000    0.000    0.000    0.000 functions.py:579(__init__)
      822    0.000    0.000    0.000    0.000 {method 'pop' of 'collections.deque' objects}
       85    0.000    0.000    0.000    0.000 unitofwork.py:388(<genexpr>)
       88    0.000    0.000    0.000    0.000 path_registry.py:77(__len__)
        1    0.000    0.000    0.000    0.000 functions.py:483(__init__)
      690    0.000    0.000    0.000    0.000 vendors.py:214(oqmultiple)
      264    0.000    0.000    0.000    0.000 configbase.py:157(projectfolder)
        1    0.000    0.000    0.000    0.000 selectable.py:2689(is_derived_from)
      134    0.000    0.000    0.000    0.000 base.py:1537(_parent)
       88    0.000    0.000    0.000    0.000 query.py:224(_adapt_all_clauses)
      132    0.000    0.000    0.000    0.000 vendors.py:332(vqtyavail)
        1    0.000    0.000    0.000    0.000 query.py:158(_set_select_from)
      134    0.000    0.000    0.000    0.000 queue.py:186(_empty)
        1    0.000    0.000    0.000    0.000 {method 'readlines' of 'file' objects}
       44    0.000    0.000    0.000    0.000 {math.ceil}
       44    0.000    0.000    0.000    0.000 __init__.py:103(remaining)
       88    0.000    0.000    0.000    0.000 {math.copysign}
      134    0.000    0.000    0.000    0.000 contextlib.py:12(__init__)
        1    0.000    0.000    0.000    0.000 type_api.py:395(_dialect_info)
        1    0.000    0.000    0.000    0.000 elements.py:2822(_copy_internals)
       50    0.000    0.000    0.000    0.000 re.py:204(escape)
      296    0.000    0.000    0.000    0.000 persistence.py:184(<genexpr>)
        2    0.000    0.000    0.000    0.000 {posix.listdir}
        1    0.000    0.000    0.000    0.000 __init__.py:1273(handle)
        1    0.000    0.000    0.000    0.000 sre_compile.py:359(_compile_info)
      6/4    0.000    0.000    0.000    0.000 elements.py:767(proxy_set)
        4    0.000    0.000    0.000    0.000 elements.py:727(__getattr__)
       85    0.000    0.000    0.000    0.000 unitofwork.py:154(has_work)
       88    0.000    0.000    0.000    0.000 validate.py:502(__init__)
        1    0.000    0.000    0.000    0.000 util.py:34(find_join_source)
      2/1    0.000    0.000    0.000    0.000 sre_compile.py:32(_compile)
        1    0.000    0.000    0.000    0.000 __init__.py:1305(callHandlers)
        1    0.000    0.000    0.000    0.000 fsutils.py:329(__init__)
      266    0.000    0.000    0.000    0.000 elements.py:405(self_group)
        1    0.000    0.000    0.000    0.000 langhelpers.py:767(oneshot)
      126    0.000    0.000    0.000    0.000 {method 'iteritems' of 'dict' objects}
        1    0.000    0.000    0.000    0.000 compiler.py:793(visit_function)
        1    0.000    0.000    0.000    0.000 terminal.py:61(get_terminal_width)
        1    0.000    0.000    0.000    0.000 terminal.py:65(get_terminal_size)
       88    0.000    0.000    0.000    0.000 validate.py:34(__init__)
        1    0.000    0.000    0.000    0.000 __init__.py:736(handle)
       44    0.000    0.000    0.000    0.000 persistence.py:632(<lambda>)
        3    0.000    0.000    0.000    0.000 selectable.py:577(_init_collections)
      187    0.000    0.000    0.000    0.000 {method 'append' of 'collections.deque' objects}
       41    0.000    0.000    0.000    0.000 collections.py:602(attr)
      129    0.000    0.000    0.000    0.000 default.py:401(set_connection_execution_options)
        1    0.000    0.000    0.000    0.000 terminal.py:175(__init__)
        1    0.000    0.000    0.000    0.000 selectable.py:2655(locate_all_froms)
        1    0.000    0.000    0.000    0.000 {method 'close' of 'file' objects}
       63    0.000    0.000    0.000    0.000 sre_parse.py:201(get)
        2    0.000    0.000    0.000    0.000 elements.py:3136(_from_objects)
      178    0.000    0.000    0.000    0.000 interfaces.py:120(create_row_processor)
        1    0.000    0.000    0.000    0.000 elements.py:1815(_copy_internals)
        1    0.000    0.000    0.000    0.000 elements.py:3322(_label)
        2    0.000    0.000    0.000    0.000 {posix.rename}
       46    0.000    0.000    0.000    0.000 {time.time}
        1    0.000    0.000    0.000    0.000 __init__.py:1239(makeRecord)
       45    0.000    0.000    0.000    0.000 terminal.py:226(term_width)
       88    0.000    0.000    0.000    0.000 {math.isinf}
        1    0.000    0.000    0.000    0.000 elements.py:3330(_gen_label)
       88    0.000    0.000    0.000    0.000 vendors.py:340(manufacturer)
        1    0.000    0.000    0.000    0.000 compiler.py:816(function_argspec)
        1    0.000    0.000    0.000    0.000 helpers.py:53(__init__)
       88    0.000    0.000    0.000    0.000 vendors.py:324(vpno)
        1    0.000    0.000    0.000    0.000 __init__.py:242(__init__)
      177    0.000    0.000    0.000    0.000 base.py:32(_clone)
       66    0.000    0.000    0.000    0.000 sre_parse.py:182(__next)
        4    0.000    0.000    0.000    0.000 elements.py:3189(__init__)
       46    0.000    0.000    0.000    0.000 vendors.py:472(name)
       85    0.000    0.000    0.000    0.000 persistence.py:1057(<lambda>)
        1    0.000    0.000    0.000    0.000 __init__.py:839(emit)
       88    0.000    0.000    0.000    0.000 vendors.py:348(mpartno)
       88    0.000    0.000    0.000    0.000 vendors.py:356(vpartdesc)
        1    0.000    0.000    0.000    0.000 type_api.py:414(adapt)
      170    0.000    0.000    0.000    0.000 {method 'dispose' of '_yaml.CParser' objects}
      178    0.000    0.000    0.000    0.000 interfaces.py:111(setup)
        1    0.000    0.000    0.000    0.000 compiler.py:523(visit_grouping)
        1    0.000    0.000    0.000    0.000 terminal.py:118(_get_terminal_size_linux)
      134    0.000    0.000    0.000    0.000 default.py:416(do_begin)
        1    0.000    0.000    0.000    0.000 elements.py:3825(_literal_as_binds)
        3    0.000    0.000    0.000    0.000 base.py:500(add)
       85    0.000    0.000    0.000    0.000 dependency.py:727(process_deletes)
       44    0.000    0.000    0.000    0.000 vendors.py:386(prices)
       85    0.000    0.000    0.000    0.000 identity.py:50(_dirty_states)
        1    0.000    0.000    0.000    0.000 langhelpers.py:1014(constructor_copy)
       88    0.000    0.000    0.000    0.000 {abs}
       44    0.000    0.000    0.000    0.000 vendors.py:364(ident)
       88    0.000    0.000    0.000    0.000 query.py:906(_with_invoke_all_eagers)
        7    0.000    0.000    0.000    0.000 elements.py:3295(_set_table)
        2    0.000    0.000    0.000    0.000 visitors.py:210(iterate)
        3    0.000    0.000    0.000    0.000 base.py:454(__init__)
        1    0.000    0.000    0.000    0.000 terminal.py:119(ioctl_GWINSZ)
        3    0.000    0.000    0.000    0.000 base.py:518(__setitem__)
        9    0.000    0.000    0.000    0.000 langhelpers.py:785(expire_instance)
        2    0.000    0.000    0.000    0.000 functions.py:148(_from_objects)
        5    0.000    0.000    0.000    0.000 base.py:594(as_immutable)
        2    0.000    0.000    0.000    0.000 genericpath.py:26(isfile)
        1    0.000    0.000    0.000    0.000 selectable.py:392(alias)
       88    0.000    0.000    0.000    0.000 {math.isnan}
        2    0.000    0.000    0.000    0.000 elements.py:3610(__add__)
      6/1    0.000    0.000    0.000    0.000 langhelpers.py:216(get_cls_kwargs)
       44    0.000    0.000    0.000    0.000 default.py:797(rowcount)
        1    0.000    0.000    0.000    0.000 <string>:1(correlate)
        1    0.000    0.000    0.000    0.000 selectable.py:1088(__init__)
        1    0.000    0.000    0.000    0.000 sre_compile.py:178(_compile_charset)
        1    0.000    0.000    0.000    0.000 elements.py:857(label)
       88    0.000    0.000    0.000    0.000 {method 'bit_length' of 'int' objects}
        6    0.000    0.000    0.000    0.000 base.py:575(__contains__)
       53    0.000    0.000    0.000    0.000 sre_parse.py:138(append)
        1    0.000    0.000    0.000    0.000 elements.py:3049(__init__)
        1    0.000    0.000    0.000    0.000 __init__.py:83(__init__)
        5    0.000    0.000    0.000    0.000 base.py:600(__init__)
        1    0.000    0.000    0.000    0.000 sre_compile.py:207(_optimize_charset)
        1    0.000    0.000    0.000    0.000 elements.py:2230(literal_column)
        3    0.000    0.000    0.000    0.000 _collections.py:252(__init__)
      3/2    0.000    0.000    0.000    0.000 sre_parse.py:140(getwidth)
        6    0.000    0.000    0.000    0.000 glob.py:94(has_magic)
       10    0.000    0.000    0.000    0.000 sre_parse.py:257(_escape)
        1    0.000    0.000    0.000    0.000 type_api.py:411(_gen_dialect_impl)
        1    0.000    0.000    0.000    0.000 util.py:537(__init__)
        2    0.000    0.000    0.000    0.000 {filter}
        1    0.000    0.000    0.000    0.000 {_csv.writer}
        1    0.000    0.000    0.000    0.000 selectable.py:1658(_generate)
        1    0.000    0.000    0.000    0.000 __init__.py:31(__init__)
       44    0.000    0.000    0.000    0.000 state.py:225(_pending_mutations)
        1    0.000    0.000    0.000    0.000 default.py:350(type_descriptor)
        1    0.000    0.000    0.000    0.000 elements.py:1782(__init__)
        1    0.000    0.000    0.000    0.000 {method 'write' of 'file' objects}
       44    0.000    0.000    0.000    0.000 vendors.py:368(pkgqty)
        2    0.000    0.000    0.000    0.000 selectable.py:532(_reset_exported)
        2    0.000    0.000    0.000    0.000 posixpath.py:89(split)
        1    0.000    0.000    0.000    0.000 __init__.py:713(format)
        1    0.000    0.000    0.000    0.000 query.py:3669(corresponds_to)
        1    0.000    0.000    0.000    0.000 __init__.py:1218(findCaller)
        1    0.000    0.000    0.000    0.000 functions.py:244(__getattr__)
        1    0.000    0.000    0.000    0.000 __init__.py:451(format)
        8    0.000    0.000    0.000    0.000 _collections.py:177(__init__)
        1    0.000    0.000    0.000    0.000 query.py:3662(setup_entity)
        1    0.000    0.000    0.000    0.000 {fcntl.ioctl}
        1    0.000    0.000    0.000    0.000 type_api.py:1147(adapt_type)
        6    0.000    0.000    0.000    0.000 {method 'search' of '_sre.SRE_Pattern' objects}
        2    0.000    0.000    0.000    0.000 __init__.py:693(acquire)
        3    0.000    0.000    0.000    0.000 _collections.py:331(__setitem__)
        2    0.000    0.000    0.000    0.000 elements.py:3101(element)
        1    0.000    0.000    0.000    0.000 _collections.py:932(lightweight_named_tuple)
        1    0.000    0.000    0.000    0.000 <string>:1(with_labels)
        1    0.000    0.000    0.000    0.000 __init__.py:828(flush)
      6/4    0.000    0.000    0.000    0.000 selectable.py:745(is_derived_from)
        1    0.000    0.000    0.000    0.000 helpers.py:71(finish)
        3    0.000    0.000    0.000    0.000 _collections.py:368(add)
        6    0.000    0.000    0.000    0.000 sre_parse.py:130(__getitem__)
        1    0.000    0.000    0.000    0.000 query.py:3681(row_processor)
        1    0.000    0.000    0.000    0.000 util.py:464(__init__)
       74    0.000    0.000    0.000    0.000 glob.py:77(<lambda>)
        7    0.000    0.000    0.000    0.000 string.py:281(split)
        1    0.000    0.000    0.000    0.000 <string>:1(enable_eagerloads)
        2    0.000    0.000    0.000    0.000 annotation.py:75(_constructor)
        1    0.000    0.000    0.000    0.000 platform.py:1326(system)
        6    0.000    0.000    0.000    0.000 _collections.py:213(__contains__)
        2    0.000    0.000    0.000    0.000 base.py:353(_is_aliased_class)
        2    0.000    0.000    0.000    0.000 __init__.py:700(release)
        1    0.000    0.000    0.000    0.000 posixpath.py:104(splitext)
        1    0.000    0.000    0.000    0.000 query.py:340(__all_equivs)
        1    0.000    0.000    0.000    0.000 attributes.py:148(_query_clause_element)
        1    0.000    0.000    0.000    0.000 schema.py:1391(get_children)
        1    0.000    0.000    0.000    0.000 compiler.py:2725(format_alias)
        1    0.000    0.000    0.000    0.000 elements.py:2807(__init__)
        2    0.000    0.000    0.000    0.000 elements.py:3300(_from_objects)
        1    0.000    0.000    0.000    0.000 compiler.py:660(escape_literal_column)
       52    0.000    0.000    0.000    0.000 {ord}
        1    0.000    0.000    0.000    0.000 __init__.py:153(getLevelName)
        5    0.000    0.000    0.000    0.000 {method 'rfind' of 'str' objects}
        3    0.000    0.000    0.000    0.000 elements.py:3633(_as_truncated)
       19    0.000    0.000    0.000    0.000 selectable.py:406(is_derived_from)
        1    0.000    0.000    0.000    0.000 sre_compile.py:354(_simple)
        1    0.000    0.000    0.000    0.000 type_api.py:226(_has_column_expression)
        1    0.000    0.000    0.000    0.000 __init__.py:445(usesTime)
        3    0.000    0.000    0.000    0.000 langhelpers.py:1225(set_creation_order)
        2    0.000    0.000    0.000    0.000 stat.py:49(S_ISREG)
        9    0.000    0.000    0.000    0.000 sre_parse.py:195(match)
        1    0.000    0.000    0.000    0.000 posixpath.py:119(basename)
        1    0.000    0.000    0.000    0.000 fsutils.py:360(__getattr__)
        1    0.000    0.000    0.000    0.000 sre_parse.py:178(__init__)
        1    0.000    0.000    0.000    0.000 __init__.py:311(getMessage)
        1    0.000    0.000    0.000    0.000 attributes.py:145(__clause_element__)
        1    0.000    0.000    0.000    0.000 interfaces.py:347(_query_clause_element)
        1    0.000    0.000    0.000    0.000 elements.py:3095(type)
        1    0.000    0.000    0.000    0.000 genericpath.py:85(_splitext)
        2    0.000    0.000    0.000    0.000 fsutils.py:387(_versioned_name)
        3    0.000    0.000    0.000    0.000 _collections.py:270(__init__)
        1    0.000    0.000    0.000    0.000 __init__.py:81(<lambda>)
        1    0.000    0.000    0.000    0.000 elements.py:2832(__getattr__)
        1    0.000    0.000    0.000    0.000 {_sre.compile}
        1    0.000    0.000    0.000    0.000 query.py:294(_mapper_entities)
        2    0.000    0.000    0.000    0.000 __init__.py:598(filter)
        3    0.000    0.000    0.000    0.000 schema.py:67(_init_items)
        1    0.000    0.000    0.000    0.000 selectable.py:2960(correlate)
        2    0.000    0.000    0.000    0.000 sre_compile.py:472(isstring)
        2    0.000    0.000    0.000    0.000 functions.py:89(clauses)
        2    0.000    0.000    0.000    0.000 elements.py:3122(get_children)
        2    0.000    0.000    0.000    0.000 {method 'sort' of 'list' objects}
        2    0.000    0.000    0.000    0.000 sre_parse.py:90(__init__)
        4    0.000    0.000    0.000    0.000 sre_parse.py:126(__len__)
        1    0.000    0.000    0.000    0.000 weakref.py:284(remove)
        2    0.000    0.000    0.000    0.000 {method 'rstrip' of 'str' objects}
        1    0.000    0.000    0.000    0.000 platform.py:1189(uname)
        1    0.000    0.000    0.000    0.000 vendors.py:484(map)
        1    0.000    0.000    0.000    0.000 fsutils.py:344(__del__)
        1    0.000    0.000    0.000    0.000 threading.py:1152(currentThread)
        1    0.000    0.000    0.000    0.000 threading.py:967(name)
        1    0.000    0.000    0.000    0.000 functions.py:240(__init__)
        1    0.000    0.000    0.000    0.000 weakref.py:352(__contains__)
        1    0.000    0.000    0.000    0.000 _collections.py:115(__new__)
        1    0.000    0.000    0.000    0.000 {_struct.unpack}
        2    0.000    0.000    0.000    0.000 elements.py:391(get_children)
        1    0.000    0.000    0.000    0.000 sre_parse.py:134(__setitem__)
        2    0.000    0.000    0.000    0.000 stat.py:24(S_IFMT)
        1    0.000    0.000    0.000    0.000 type_api.py:188(result_processor)
        1    0.000    0.000    0.000    0.000 {posix.getpid}
        1    0.000    0.000    0.000    0.000 sre_parse.py:67(__init__)
        1    0.000    0.000    0.000    0.000 selectable.py:1156(_from_objects)
        3    0.000    0.000    0.000    0.000 elements.py:257(_constructor)
        1    0.000    0.000    0.000    0.000 compiler.py:1269(get_render_as_alias_suffix)
        1    0.000    0.000    0.000    0.000 query.py:598(with_labels)
        4    0.000    0.000    0.000    0.000 sre_compile.py:24(_identityfunction)
        1    0.000    0.000    0.000    0.000 functions.py:152(get_children)
        1    0.000    0.000    0.000    0.000 elements.py:1818(get_children)
        1    0.000    0.000    0.000    0.000 langhelpers.py:1022(<genexpr>)
        1    0.000    0.000    0.000    0.000 {method 'find' of 'str' objects}
        1    0.000    0.000    0.000    0.000 {method 'disable' of '_lsprof.Profiler' objects}
        1    0.000    0.000    0.000    0.000 query.py:3647(entity_zero_or_selectable)
        1    0.000    0.000    0.000    0.000 query.py:572(enable_eagerloads)
        1    0.000    0.000    0.000    0.000 elements.py:2825(get_children)