TI Vendor Map Audit Generation ProfilingΒΆ

Raw execution profile SVG of execution profile

Execution Profile

../../../_images/ti.profile1.svg

pstats Output

Tue May 24 00:34:24 2016    /media/ldata/code/tendril/profiling/sourcing/genvmapaudit/ti.profile

         2805453 function calls (2748097 primitive calls) in 12.565 seconds

   Ordered by: cumulative time

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000   12.597   12.597 vendors.py:52(profile_vendor_genvmapaudit)
        1    0.010    0.010   12.597   12.597 electronics.py:123(export_vendor_map_audit)
      201    0.001    0.000    8.555    0.043 vendors.py:519(get_vpart)
      201    0.002    0.000    8.554    0.043 ti.py:50(__init__)
      201    0.001    0.000    8.552    0.043 vendors.py:415(__init__)
      201    0.001    0.000    8.551    0.043 vendors.py:236(__init__)
      201    0.004    0.000    8.550    0.043 vendors.py:248(_populate)
     2008    0.015    0.000    8.482    0.004 query.py:2511(__iter__)
      201    0.009    0.000    7.819    0.039 vendors.py:285(load_from_db)
      201    0.003    0.000    7.802    0.039 vendors.py:427(_load_from_db)
     2008    0.024    0.000    7.742    0.004 query.py:2525(_execute_and_instances)
     2008    0.008    0.000    7.563    0.004 base.py:846(execute)
     2008    0.007    0.000    7.550    0.004 elements.py:322(_execute_on_connection)
     2008    0.032    0.000    7.543    0.004 base.py:975(_execute_clauseelement)
      201    0.022    0.000    7.233    0.036 vendors.py:292(_load_from_db)
      870    0.027    0.000    6.077    0.007 query.py:2393(all)
 3139/469    0.024    0.000    6.061    0.013 db.py:168(inner)
     2008    0.053    0.000    5.694    0.003 base.py:1061(_execute_context)
11104/10501    0.024    0.000    5.652    0.001 attributes.py:229(__get__)
1673/1070    0.009    0.000    5.629    0.005 attributes.py:556(get)
      603    0.005    0.000    5.594    0.009 strategies.py:477(_load_for_state)
      603    0.030    0.000    5.580    0.009 strategies.py:550(_emit_lazyload)
     2008    0.006    0.000    5.031    0.003 default.py:449(do_execute)
     2008    4.996    0.002    5.025    0.003 {method 'execute' of 'psycopg2.extensions.cursor' objects}
      133    0.001    0.000    3.913    0.029 maps.py:73(get_all_partnos)
     1138    0.034    0.000    3.289    0.003 query.py:2451(one)
      266    0.012    0.000    2.966    0.011 controller.py:244(get_map_vpnos)
      467    0.017    0.000    2.553    0.005 controller.py:215(get_map)
      201    0.005    0.000    2.111    0.011 controller.py:113(get_vpno_obj)
      133    0.001    0.000    1.962    0.015 vendors.py:88(get_upartnos)
      133    0.001    0.000    1.950    0.015 vendors.py:84(get_apartnos)
     2008    0.009    0.000    1.799    0.001 elements.py:431(compile)
     2008    0.015    0.000    1.790    0.001 elements.py:496(_compiler)
     2008    0.054    0.000    1.775    0.001 compiler.py:329(__init__)
     2008    0.012    0.000    1.713    0.001 compiler.py:167(__init__)
     2008    0.007    0.000    1.701    0.001 compiler.py:212(process)
35732/2008    0.140    0.000    1.693    0.001 visitors.py:75(_compiler_dispatch)
2009/2008    0.080    0.000    1.675    0.001 compiler.py:1503(visit_select)
      938    0.010    0.000    1.649    0.002 db.py:111(get_session)
      735    0.003    0.000    1.510    0.002 controller.py:45(_get_vendor)
      469    0.006    0.000    1.503    0.003 controller.py:94(get_vendor)
      133    0.001    0.000    1.492    0.011 controller.py:263(get_umap_vpnos)
      133    0.001    0.000    1.485    0.011 controller.py:257(get_amap_vpnos)
      469    0.001    0.000    1.388    0.003 contextlib.py:15(__enter__)
      469    0.014    0.000    1.308    0.003 db.py:83(_get_caller)
      469    0.002    0.000    1.247    0.003 inspect.py:1053(stack)
      469    0.019    0.000    1.245    0.003 inspect.py:1026(getouterframes)
     6966    0.078    0.000    1.223    0.000 inspect.py:988(getframeinfo)
     5262    0.057    0.000    0.823    0.000 loading.py:30(instances)
     6966    0.099    0.000    0.807    0.000 inspect.py:518(findsource)
    12915    0.125    0.000    0.787    0.000 compiler.py:1275(_label_select_column)
     2009    0.041    0.000    0.704    0.000 query.py:2953(_compile_context)
    12915    0.153    0.000    0.574    0.000 compiler.py:581(visit_label)
    14401    0.163    0.000    0.545    0.000 inspect.py:440(getsourcefile)
11569/4145    0.032    0.000    0.483    0.000 operators.py:294(__eq__)
8961/5215    0.020    0.000    0.462    0.000 {operator.eq}
2009/2008    0.049    0.000    0.461    0.000 compiler.py:1679(_compose_select_body)
     6093    0.036    0.000    0.434    0.000 base.py:196(generate)
     2340    0.005    0.000    0.384    0.000 attributes.py:174(operate)
     4613    0.010    0.000    0.368    0.000 elements.py:738(operate)
7559/2744    0.046    0.000    0.361    0.000 visitors.py:86(_compiler_dispatch)
     2007    0.081    0.000    0.334    0.000 query.py:3282(row_processor)
     4613    0.012    0.000    0.327    0.000 <string>:1(<lambda>)
     4613    0.030    0.000    0.315    0.000 type_api.py:57(operate)
     2008    0.100    0.000    0.309    0.000 default.py:515(_init_compiled)
     2943    0.024    0.000    0.302    0.000 annotation.py:93(__eq__)
     3678    0.022    0.000    0.297    0.000 compiler.py:904(visit_binary)
    17329    0.162    0.000    0.297    0.000 compiler.py:620(visit_column)
     2009    0.040    0.000    0.291    0.000 query.py:3071(_simple_statement)
     3321    0.056    0.000    0.284    0.000 loading.py:360(_instance)
     2008    0.019    0.000    0.282    0.000 psycopg2.py:466(get_result_proxy)
   402838    0.243    0.000    0.279    0.000 {isinstance}
     2007    0.016    0.000    0.275    0.000 query.py:3317(setup_context)
      469    0.007    0.000    0.269    0.001 contextlib.py:21(__exit__)
     7435    0.037    0.000    0.267    0.000 inspect.py:472(getmodule)
     3678    0.026    0.000    0.265    0.000 compiler.py:935(_generate_generic_binary)
     2007    0.060    0.000    0.257    0.000 loading.py:224(_setup_entity_query)
     2008    0.013    0.000    0.253    0.000 result.py:488(__init__)
     2007    0.120    0.000    0.249    0.000 loading.py:269(_instance_processor)
     1873    0.007    0.000    0.245    0.000 properties.py:268(operate)
     2009    0.020    0.000    0.241    0.000 <string>:1(select)
    21367    0.089    0.000    0.241    0.000 inspect.py:398(getfile)
     2008    0.020    0.000    0.240    0.000 result.py:513(_init_metadata)
     2009    0.053    0.000    0.238    0.000 compiler.py:1654(_setup_select_stack)
     3678    0.031    0.000    0.234    0.000 default_comparator.py:21(_boolean_compare)
      735    0.005    0.000    0.227    0.000 query.py:1511(join)
      469    0.007    0.000    0.227    0.000 session.py:756(commit)
      735    0.002    0.000    0.222    0.000 <string>:1(_join)
     2009    0.075    0.000    0.221    0.000 selectable.py:2220(__init__)
      469    0.015    0.000    0.219    0.000 session.py:389(commit)
     2008    0.129    0.000    0.217    0.000 result.py:189(__init__)
    11163    0.031    0.000    0.215    0.000 {method 'join' of 'str' objects}
      735    0.010    0.000    0.211    0.000 query.py:1800(_join)
     2008    0.008    0.000    0.204    0.000 session.py:1245(query)
13208/13201    0.041    0.000    0.201    0.000 langhelpers.py:744(__get__)
     2008    0.006    0.000    0.197    0.000 query.py:107(__init__)
     5090    0.015    0.000    0.197    0.000 inspect.py:460(getabsfile)
      936    0.005    0.000    0.196    0.000 compiler.py:735(visit_clauselist)
     2009    0.022    0.000    0.191    0.000 query.py:112(_set_entities)
      735    0.013    0.000    0.188    0.000 query.py:1915(_join_left_to_right)
     2807    0.003    0.000    0.184    0.000 compiler.py:742(<genexpr>)
     2807    0.006    0.000    0.180    0.000 compiler.py:744(<genexpr>)
    17258    0.066    0.000    0.176    0.000 interfaces.py:498(setup)
     2943    0.008    0.000    0.174    0.000 <string>:1(filter)
     2009    0.023    0.000    0.169    0.000 selectable.py:2506(_get_display_froms)
     3321    0.041    0.000    0.167    0.000 loading.py:478(_populate_full)
     5090    0.025    0.000    0.162    0.000 posixpath.py:365(abspath)
      735    0.007    0.000    0.152    0.000 query.py:2068(_join_to_left)
      735    0.003    0.000    0.141    0.000 util.py:880(join)
      735    0.012    0.000    0.138    0.000 util.py:779(__init__)
    15858    0.069    0.000    0.136    0.000 compiler.py:1130(_truncated_identifier)
     2008    0.008    0.000    0.134    0.000 query.py:2518(_connection_from_session)
      469    0.008    0.000    0.134    0.000 query.py:1310(filter_by)
     2010    0.059    0.000    0.133    0.000 selectable.py:2479(_froms)
     3678    0.020    0.000    0.131    0.000 default_comparator.py:269(_check_literal)
88938/88937    0.123    0.000    0.131    0.000 {getattr}
     2942    0.020    0.000    0.128    0.000 compiler.py:1048(visit_bindparam)
     5166    0.007    0.000    0.126    0.000 type_api.py:1009(process)
     2008    0.011    0.000    0.126    0.000 session.py:811(connection)
      467    0.006    0.000    0.125    0.000 relationships.py:961(__eq__)
     2943    0.030    0.000    0.122    0.000 query.py:1274(filter)
     5166    0.008    0.000    0.119    0.000 arrow.py:73(process_result_value)
    50316    0.067    0.000    0.115    0.000 compiler.py:2693(quote)
    14401    0.030    0.000    0.113    0.000 genericpath.py:15(exists)
     2008    0.010    0.000    0.112    0.000 result.py:944(fetchall)
     3585    0.010    0.000    0.112    0.000 api.py:17(get)
      735    0.008    0.000    0.112    0.000 selectable.py:651(__init__)
     2008    0.006    0.000    0.105    0.000 session.py:884(_connection_for_bind)
    21603    0.103    0.000    0.103    0.000 interfaces.py:466(_get_context_loader)
     1070    0.020    0.000    0.102    0.000 mapper.py:2451(_get_state_attr_by_column)
     3585    0.033    0.000    0.102    0.000 factory.py:32(get)
     1872    0.012    0.000    0.100    0.000 elements.py:3370(_bind_param)
      469    0.003    0.000    0.100    0.000 base.py:1569(commit)
      938    0.013    0.000    0.099    0.000 session.py:456(close)
     2008    0.014    0.000    0.099    0.000 session.py:312(_connection_for_bind)
      469    0.002    0.000    0.096    0.000 base.py:1603(_do_commit)
      469    0.008    0.000    0.095    0.000 base.py:679(_commit_impl)
      735    0.003    0.000    0.092    0.000 selectable.py:786(_match_primaries)
     2942    0.013    0.000    0.090    0.000 compiler.py:1117(_truncate_bindparam)
     2010    0.021    0.000    0.090    0.000 selectable.py:3151(_columns_plus_names)
      735    0.008    0.000    0.088    0.000 selectable.py:793(_join_condition)
     1872    0.051    0.000    0.088    0.000 elements.py:913(__init__)
3277/2341    0.013    0.000    0.087    0.000 annotation.py:71(_compiler_dispatch)
      469    0.004    0.000    0.086    0.000 default.py:422(do_commit)
    14404    0.084    0.000    0.084    0.000 {posix.stat}
    15527    0.041    0.000    0.084    0.000 inspection.py:38(inspect)
     5090    0.051    0.000    0.082    0.000 posixpath.py:336(normpath)
      469    0.081    0.000    0.081    0.000 {method 'commit' of 'psycopg2.extensions.connection' objects}
     4753    0.020    0.000    0.078    0.000 _collections.py:794(to_list)
 1870/935    0.004    0.000    0.075    0.000 operators.py:43(__and__)
     2009    0.021    0.000    0.071    0.000 query.py:122(_set_entity_selectables)
     2008    0.005    0.000    0.071    0.000 result.py:911(_fetchall_impl)
      934    0.004    0.000    0.070    0.000 elements.py:2758(_copy_internals)
     1407    0.007    0.000    0.070    0.000 session.py:694(begin)
      603    0.008    0.000    0.069    0.000 strategies.py:448(_generate_lazy_clause)
    12914    0.021    0.000    0.068    0.000 default.py:753(get_result_processor)
     1404    0.006    0.000    0.068    0.000 elements.py:1890(and_)
     6764    0.037    0.000    0.067    0.000 base.py:36(_from_objects)
      469    0.004    0.000    0.067    0.000 base.py:2020(contextual_connect)
      469    0.006    0.000    0.066    0.000 session.py:2646(__call__)
     2008    0.039    0.000    0.066    0.000 {method 'fetchall' of 'psycopg2.extensions.cursor' objects}
    72005    0.044    0.000    0.065    0.000 string.py:220(lower)
      467    0.007    0.000    0.065    0.000 relationships.py:1334(_optimized_compare)
    16889    0.064    0.000    0.064    0.000 {method 'match' of '_sre.SRE_Pattern' objects}
     1407    0.011    0.000    0.063    0.000 session.py:169(__init__)
     6028    0.034    0.000    0.063    0.000 _collections.py:747(unique_list)
     3678    0.037    0.000    0.063    0.000 elements.py:2724(__init__)
      935    0.003    0.000    0.063    0.000 {operator.and_}
  735/734    0.009    0.000    0.063    0.000 compiler.py:1803(visit_join)
     4345    0.022    0.000    0.063    0.000 interfaces.py:507(create_row_processor)
     1404    0.022    0.000    0.062    0.000 elements.py:1856(_construct)
     2008    0.016    0.000    0.060    0.000 compiler.py:455(construct_params)
      469    0.010    0.000    0.058    0.000 session.py:512(__init__)
     2944    0.019    0.000    0.058    0.000 elements.py:3624(apply_map)
      467    0.002    0.000    0.058    0.000 visitors.py:280(cloned_traverse)
     2008    0.014    0.000    0.056    0.000 psycopg2.py:435(create_cursor)
 1401/467    0.015    0.000    0.055    0.000 visitors.py:287(clone)
     2010    0.012    0.000    0.054    0.000 query.py:3159(__new__)
      603    0.002    0.000    0.054    0.000 strategy_options.py:781(lazyload)
      467    0.002    0.000    0.053    0.000 util.py:746(_orm_annotate)
     2012    0.021    0.000    0.053    0.000 _collections.py:359(__init__)
     2950    0.013    0.000    0.052    0.000 base.py:285(__get__)
      603    0.002    0.000    0.052    0.000 <string>:1(set_relationship_strategy)
      935    0.002    0.000    0.052    0.000 default_comparator.py:89(_conjunction_operate)
    35768    0.028    0.000    0.051    0.000 inspect.py:51(ismodule)
      467    0.001    0.000    0.050    0.000 annotation.py:106(_deep_annotate)
      604    0.003    0.000    0.050    0.000 base.py:40(_generative)
     2008    0.015    0.000    0.049    0.000 compiler.py:438(_bind_processors)
 1401/467    0.007    0.000    0.049    0.000 annotation.py:113(clone)
      469    0.002    0.000    0.049    0.000 base.py:793(close)
      735    0.013    0.000    0.048    0.000 selectable.py:847(_joincond_scan_left_right)
    12914    0.025    0.000    0.047    0.000 type_api.py:382(_cached_result_processor)
    12914    0.016    0.000    0.047    0.000 result.py:497(_getter)
      469    0.002    0.000    0.046    0.000 pool.py:879(close)
      469    0.006    0.000    0.045    0.000 db.py:69(_format_frame)
      469    0.002    0.000    0.045    0.000 pool.py:756(_checkin)
      467    0.001    0.000    0.044    0.000 elements.py:1168(effective_value)
     3253    0.021    0.000    0.044    0.000 instrumentation.py:311(new_instance)
      467    0.002    0.000    0.043    0.000 relationships.py:1385(_go)
      469    0.004    0.000    0.043    0.000 pool.py:615(_finalize_fairy)
      201    0.003    0.000    0.042    0.000 terminal.py:230(next)
     5013    0.017    0.000    0.042    0.000 base.py:389(_inspect_mapped_class)
    28333    0.024    0.000    0.042    0.000 inspect.py:59(isclass)
     2008    0.007    0.000    0.041    0.000 pool.py:845(cursor)
      469    0.001    0.000    0.041    0.000 base.py:2071(_wrap_pool_connect)
      603    0.004    0.000    0.041    0.000 strategy_options.py:190(set_relationship_strategy)
     1402    0.005    0.000    0.041    0.000 elements.py:291(_annotate)
      469    0.002    0.000    0.040    0.000 pool.py:367(connect)
     2950    0.007    0.000    0.039    0.000 base.py:108(_for_instance)
     2944    0.006    0.000    0.039    0.000 _collections.py:727(__missing__)
   108923    0.039    0.000    0.039    0.000 {method 'append' of 'list' objects}
      201    0.010    0.000    0.039    0.000 bar.py:65(update)
     3585    0.019    0.000    0.039    0.000 arrow.py:118(fromdatetime)
      469    0.005    0.000    0.038    0.000 pool.py:710(_checkout)
    35299    0.022    0.000    0.038    0.000 inspect.py:181(istraceback)
     2009    0.010    0.000    0.038    0.000 base.py:325(_is_mapped_class)
     1407    0.017    0.000    0.037    0.000 session.py:256(_take_snapshot)
     4348    0.015    0.000    0.037    0.000 operators.py:895(is_precedent)
     3412    0.008    0.000    0.036    0.000 elements.py:2783(self_group)
     4753    0.020    0.000    0.036    0.000 abc.py:128(__instancecheck__)
    18806    0.036    0.000    0.036    0.000 weakref.py:314(__getitem__)
    14401    0.035    0.000    0.035    0.000 {imp.get_suffixes}
     2008    0.004    0.000    0.035    0.000 compiler.py:441(<genexpr>)
     2008    0.035    0.000    0.035    0.000 {method 'cursor' of 'psycopg2.extensions.connection' objects}
    39938    0.035    0.000    0.035    0.000 {built-in method __new__ of type object at 0x919120}
    12915    0.013    0.000    0.035    0.000 compiler.py:2722(format_label)
    12913    0.029    0.000    0.034    0.000 strategies.py:141(setup_query)
     2007    0.021    0.000    0.034    0.000 query.py:3190(setup_entity)
     2343    0.011    0.000    0.033    0.000 elements.py:3513(__new__)
     6967    0.009    0.000    0.033    0.000 re.py:188(compile)
     2009    0.030    0.000    0.033    0.000 query.py:3715(__init__)
      469    0.003    0.000    0.033    0.000 session.py:1031(close)
     2944    0.022    0.000    0.033    0.000 compiler.py:1149(_process_anon)
      469    0.006    0.000    0.033    0.000 pool.py:478(checkout)
     2950    0.012    0.000    0.033    0.000 base.py:105(_for_class)
    20751    0.032    0.000    0.032    0.000 {method 'update' of 'dict' objects}
    12914    0.031    0.000    0.031    0.000 result.py:419(_getter)
     1401    0.011    0.000    0.031    0.000 elements.py:3919(__init__)
     4950    0.013    0.000    0.030    0.000 compiler.py:442(<genexpr>)
     6093    0.019    0.000    0.030    0.000 query.py:416(_clone)
      469    0.003    0.000    0.030    0.000 session.py:1076(_close_impl)
        2    0.000    0.000    0.030    0.015 fsutils.py:347(close)
        1    0.000    0.000    0.030    0.030 fsutils.py:366(_replace_current_file)
        1    0.000    0.000    0.029    0.029 fsutils.py:373(_backup_current_file)
    28333    0.019    0.000    0.029    0.000 inspect.py:67(ismethod)
    12916    0.025    0.000    0.028    0.000 selectable.py:3156(name_for_col)
      603    0.002    0.000    0.028    0.000 query.py:1090(options)
     3479    0.013    0.000    0.028    0.000 selectable.py:35(_interpret_as_from)
     6026    0.016    0.000    0.028    0.000 __init__.py:1345(isEnabledFor)
      469    0.004    0.000    0.028    0.000 pool.py:501(checkin)
    28333    0.018    0.000    0.027    0.000 inspect.py:142(isfunction)
        1    0.000    0.000    0.027    0.027 fsutils.py:416(_delete_old_revisions)
    17362    0.027    0.000    0.027    0.000 {hasattr}
    35299    0.021    0.000    0.027    0.000 inspect.py:191(isframe)
     2610    0.011    0.000    0.027    0.000 path_registry.py:62(set)
     6267    0.009    0.000    0.027    0.000 utf_8.py:15(decode)
        1    0.027    0.027    0.027    0.027 {posix.remove}
      603    0.001    0.000    0.027    0.000 <string>:1(_options)
107438/107437    0.026    0.000    0.026    0.000 {len}
    42082    0.026    0.000    0.026    0.000 {method 'get' of 'dict' objects}
     6967    0.018    0.000    0.025    0.000 re.py:226(_compile)
    12914    0.024    0.000    0.024    0.000 compiler.py:271(__init__)
     5098    0.017    0.000    0.023    0.000 posixpath.py:68(join)
      469    0.001    0.000    0.023    0.000 pool.py:388(_return_conn)
      603    0.009    0.000    0.023    0.000 strategy_options.py:110(_generate_path)
    12914    0.017    0.000    0.023    0.000 compiler.py:1272(_add_to_result_map)
     2010    0.019    0.000    0.022    0.000 elements.py:3665(_select_iterables)
     3585    0.022    0.000    0.022    0.000 util.py:25(is_timestamp)
      469    0.002    0.000    0.022    0.000 pool.py:1030(_do_return_conn)
     1002    0.003    0.000    0.022    0.000 schema.py:1635(get_referent)
    28333    0.017    0.000    0.022    0.000 inspect.py:209(iscode)
    72006    0.022    0.000    0.022    0.000 {method 'lower' of 'str' objects}
      469    0.003    0.000    0.022    0.000 <string>:1(and_)
     5013    0.010    0.000    0.021    0.000 base.py:208(manager_of_class)
      469    0.007    0.000    0.021    0.000 base.py:47(__init__)
     4018    0.005    0.000    0.021    0.000 selectable.py:2438(<genexpr>)
     2477    0.014    0.000    0.021    0.000 langhelpers.py:1033(_next)
     3415    0.006    0.000    0.021    0.000 session.py:1970(flush)
     2950    0.015    0.000    0.021    0.000 base.py:74(__init__)
     2008    0.010    0.000    0.021    0.000 query.py:306(_bind_mapper)
      467    0.007    0.000    0.020    0.000 elements.py:1183(_clone)
     2008    0.006    0.000    0.020    0.000 session.py:1279(_autoflush)
        1    0.000    0.000    0.020    0.020 vendors.py:77(get_idents)
      469    0.003    0.000    0.020    0.000 pool.py:1039(_do_get)
      469    0.005    0.000    0.020    0.000 queue.py:87(put)
      201    0.003    0.000    0.020    0.000 attributes.py:1066(set_committed_value)
     3585    0.014    0.000    0.020    0.000 arrow.py:49(__init__)
      603    0.008    0.000    0.020    0.000 query.py:1105(_options)
     3079    0.006    0.000    0.020    0.000 __init__.py:1130(debug)
     1007    0.013    0.000    0.019    0.000 selectable.py:450(corresponding_column)
     2008    0.017    0.000    0.019    0.000 query.py:3107(_adjust_for_single_inheritance)
     2008    0.018    0.000    0.018    0.000 result.py:928(process_rows)
     2942    0.018    0.000    0.018    0.000 compiler.py:1155(bindparam_string)
    17006    0.018    0.000    0.018    0.000 {method 'copy' of 'dict' objects}
      938    0.009    0.000    0.018    0.000 elements.py:235(_clone)
     6267    0.017    0.000    0.017    0.000 {_codecs.utf_8_decode}
      937    0.011    0.000    0.017    0.000 elements.py:1821(_from_objects)
      469    0.010    0.000    0.017    0.000 session.py:358(_prepare_impl)
        1    0.000    0.000    0.017    0.017 controller.py:279(get_vendor_idents)
      469    0.005    0.000    0.017    0.000 queue.py:130(get)
     9775    0.017    0.000    0.017    0.000 attr.py:226(__bool__)
     3884    0.011    0.000    0.017    0.000 session.py:2016(_is_clean)
     2942    0.009    0.000    0.017    0.000 type_api.py:372(_cached_bind_processor)
     3253    0.010    0.000    0.016    0.000 state.py:251(_cleanup)
    14990    0.016    0.000    0.016    0.000 elements.py:3292(_get_table)
     5090    0.016    0.000    0.016    0.000 {posix.getcwd}
     5283    0.007    0.000    0.016    0.000 elements.py:3765(_expression_literal_as_text)
     3253    0.016    0.000    0.016    0.000 state.py:75(__init__)
    12913    0.016    0.000    0.016    0.000 compiler.py:280(type)
     6966    0.009    0.000    0.016    0.000 <string>:8(__new__)
      201    0.003    0.000    0.016    0.000 terminal.py:241(writeln)
     4357    0.013    0.000    0.016    0.000 base.py:89(__getattr__)
        1    0.000    0.000    0.016    0.016 vendors.py:71(length)
     2008    0.015    0.000    0.015    0.000 {method 'encode' of 'unicode' objects}
     2073    0.012    0.000    0.015    0.000 {sorted}
     2348    0.009    0.000    0.015    0.000 elements.py:3469(__new__)
    12915    0.009    0.000    0.015    0.000 elements.py:3839(_interpret_as_column_or_from)
     7359    0.014    0.000    0.014    0.000 elements.py:698(self_group)
      935    0.004    0.000    0.014    0.000 elements.py:1967(self_group)
    20772    0.014    0.000    0.014    0.000 {method 'startswith' of 'str' objects}
     2744    0.007    0.000    0.013    0.000 compiler.py:1788(visit_table)
     2008    0.009    0.000    0.013    0.000 result.py:637(_soft_close)
     3683    0.013    0.000    0.013    0.000 elements.py:2754(_from_objects)
     5628    0.013    0.000    0.013    0.000 weakref.py:282(__init__)
    20081    0.012    0.000    0.012    0.000 {method 'intersection' of 'set' objects}
     4950    0.009    0.000    0.012    0.000 default.py:592(<genexpr>)
     7291    0.007    0.000    0.012    0.000 elements.py:3769(_literal_as_text)
     4753    0.012    0.000    0.012    0.000 _weakrefset.py:70(__contains__)
     5090    0.006    0.000    0.012    0.000 posixpath.py:59(isabs)
     5019    0.011    0.000    0.011    0.000 {method 'get' of 'dictproxy' objects}
        1    0.000    0.000    0.011    0.011 controller.py:289(get_vendor_map_length)
     6026    0.011    0.000    0.011    0.000 __init__.py:1331(getEffectiveLevel)
     1402    0.006    0.000    0.011    0.000 annotation.py:45(__init__)
     3278    0.005    0.000    0.011    0.000 langhelpers.py:750(_reset)
      940    0.008    0.000    0.011    0.000 threading.py:146(acquire)
      603    0.001    0.000    0.011    0.000 <string>:1(params)
    32306    0.011    0.000    0.011    0.000 {method 'add' of 'set' objects}
      469    0.005    0.000    0.011    0.000 pool.py:764(_reset)
      936    0.002    0.000    0.010    0.000 elements.py:1825(self_group)
      469    0.002    0.000    0.010    0.000 base.py:534(begin)
     2008    0.008    0.000    0.010    0.000 session.py:1142(get_bind)
      402    0.001    0.000    0.010    0.000 __init__.py:39(__getitem__)
     2944    0.010    0.000    0.010    0.000 {method 'split' of 'unicode' objects}
     2008    0.008    0.000    0.009    0.000 default.py:692(should_autocommit)
     4618    0.009    0.000    0.009    0.000 elements.py:3657(_expand_cloned)
      603    0.002    0.000    0.009    0.000 <string>:1(_adapt_all_clauses)
      603    0.005    0.000    0.009    0.000 state.py:565(_commit)
      469    0.003    0.000    0.009    0.000 base.py:1595(__init__)
     2009    0.009    0.000    0.009    0.000 query.py:2638(_select_args)
    14335    0.009    0.000    0.009    0.000 {max}
     5097    0.008    0.000    0.008    0.000 {method 'split' of 'str' objects}
     4345    0.008    0.000    0.008    0.000 strategies.py:615(create_row_processor)
     1070    0.005    0.000    0.008    0.000 elements.py:2742(__bool__)
      603    0.002    0.000    0.008    0.000 strategy_options.py:216(_set_path_strategy)
      469    0.005    0.000    0.008    0.000 session.py:1082(expunge_all)
     1872    0.007    0.000    0.008    0.000 type_api.py:424(coerce_compared_value)
      402    0.002    0.000    0.008    0.000 attributes.py:629(set_committed_value)
      603    0.002    0.000    0.008    0.000 path_registry.py:250(entity_path)
      735    0.005    0.000    0.008    0.000 query.py:1983(_prepare_right_side)
     3684    0.006    0.000    0.007    0.000 type_api.py:1137(to_instance)
      202    0.007    0.000    0.007    0.000 {method 'flush' of 'file' objects}
     3253    0.007    0.000    0.007    0.000 {method 'issuperset' of 'frozenset' objects}
      734    0.003    0.000    0.007    0.000 selectable.py:1057(_hide_froms)
     2007    0.006    0.000    0.007    0.000 query.py:3180(__init__)
     2945    0.007    0.000    0.007    0.000 query.py:228(_adapt_clause)
      469    0.003    0.000    0.007    0.000 weakref.py:98(__setitem__)
     2478    0.005    0.000    0.007    0.000 query.py:289(_mapper_zero)
      938    0.005    0.000    0.007    0.000 threading.py:372(notify)
      603    0.001    0.000    0.007    0.000 strategy_options.py:94(process_query)
        1    0.000    0.000    0.007    0.007 query.py:2697(count)
     2008    0.007    0.000    0.007    0.000 {sqlalchemy.cutils._distill_params}
     6966    0.006    0.000    0.007    0.000 linecache.py:33(getlines)
     3120    0.004    0.000    0.007    0.000 identity.py:190(_fast_discard)
      603    0.003    0.000    0.007    0.000 strategy_options.py:86(_generate)
      469    0.003    0.000    0.006    0.000 base.py:359(_entity_descriptor)
     2007    0.006    0.000    0.006    0.000 path_registry.py:70(get)
     3278    0.005    0.000    0.006    0.000 langhelpers.py:753(reset)
     3884    0.006    0.000    0.006    0.000 identity.py:53(check_modified)
      201    0.002    0.000    0.006    0.000 attributes.py:976(_initialize_collection)
     4014    0.006    0.000    0.006    0.000 query.py:3262(_get_entity_clauses)
      201    0.003    0.000    0.006    0.000 __init__.py:91(eta_td)
      603    0.001    0.000    0.006    0.000 <string>:1(_with_invoke_all_eagers)
     2946    0.006    0.000    0.006    0.000 session.py:190(_assert_active)
     1380    0.003    0.000    0.006    0.000 vendors.py:205(__init__)
     2009    0.006    0.000    0.006    0.000 selectable.py:1695(__init__)
     3585    0.003    0.000    0.006    0.000 util.py:37(isstr)
  739/737    0.004    0.000    0.006    0.000 selectable.py:1062(_from_objects)
      603    0.002    0.000    0.006    0.000 path_registry.py:254(__getitem__)
    17873    0.006    0.000    0.006    0.000 {method 'update' of 'set' objects}
      201    0.002    0.000    0.006    0.000 collections.py:659(append_multiple_without_event)
      201    0.001    0.000    0.006    0.000 arrow.py:341(timestamp)
      603    0.003    0.000    0.006    0.000 strategy_options.py:185(_coerce_strat)
      603    0.003    0.000    0.005    0.000 strategy_options.py:100(_process)
        1    0.000    0.000    0.005    0.005 query.py:2484(scalar)
     3253    0.005    0.000    0.005    0.000 identity.py:140(_add_unpresent)
      940    0.004    0.000    0.005    0.000 threading.py:186(release)
      937    0.004    0.000    0.005    0.000 elements.py:716(comparator)
      469    0.004    0.000    0.005    0.000 base.py:642(_begin_impl)
      201    0.005    0.000    0.005    0.000 {method 'writerow' of '_csv.writer' objects}
     3416    0.005    0.000    0.005    0.000 {method 'acquire' of 'thread.lock' objects}
     6306    0.005    0.000    0.005    0.000 {method 'endswith' of 'str' objects}
     4014    0.005    0.000    0.005    0.000 annotation.py:90(__hash__)
      469    0.003    0.000    0.005    0.000 default.py:419(do_rollback)
      603    0.004    0.000    0.005    0.000 _collections.py:805(has_intersection)
      603    0.003    0.000    0.005    0.000 query.py:1254(params)
     1403    0.004    0.000    0.005    0.000 annotation.py:31(__new__)
     1404    0.003    0.000    0.005    0.000 _collections.py:787(coerce_generator_arg)
     2008    0.004    0.000    0.004    0.000 base.py:1220(_safe_close_cursor)
     9316    0.004    0.000    0.004    0.000 {method 'pop' of 'dict' objects}
      733    0.004    0.000    0.004    0.000 controller.py:57(_get_ident)
     1206    0.002    0.000    0.004    0.000 _collections.py:846(flatten_iterator)
     3253    0.004    0.000    0.004    0.000 <string>:1(set)
     7231    0.004    0.000    0.004    0.000 {method 'values' of 'dict' objects}
     5013    0.004    0.000    0.004    0.000 instrumentation.py:94(is_mapped)
     3678    0.004    0.000    0.004    0.000 query.py:389(_no_limit_offset)
     2010    0.003    0.000    0.004    0.000 _collections.py:394(__iter__)
      467    0.004    0.000    0.004    0.000 relationships.py:1363(visit_bindparam)
     3321    0.004    0.000    0.004    0.000 identity.py:145(get)
     3678    0.004    0.000    0.004    0.000 query.py:381(_no_statement_condition)
     1380    0.003    0.000    0.004    0.000 collections.py:1071(append)
      603    0.003    0.000    0.004    0.000 session.py:37(_state_session)
     2008    0.004    0.000    0.004    0.000 {zip}
    12643    0.004    0.000    0.004    0.000 mapper.py:642(mapper)
     7573    0.004    0.000    0.004    0.000 {min}
    12916    0.004    0.000    0.004    0.000 elements.py:758(_select_iterable)
    12914    0.004    0.000    0.004    0.000 elements.py:3521(apply_map)
      469    0.003    0.000    0.004    0.000 base.py:116(_join)
      201    0.001    0.000    0.004    0.000 __init__.py:87(eta)
     6418    0.004    0.000    0.004    0.000 mapper.py:1965(selectable)
      201    0.001    0.000    0.003    0.000 instrumentation.py:290(initialize_collection)
      603    0.002    0.000    0.003    0.000 strategy_options.py:80(__init__)
      469    0.002    0.000    0.003    0.000 query.py:300(_joinpoint_zero)
      603    0.003    0.000    0.003    0.000 base.py:314(_generate)
      469    0.001    0.000    0.003    0.000 log.py:57(_should_log_info)
     2007    0.003    0.000    0.003    0.000 mapper.py:1890(_with_polymorphic_mappers)
      938    0.003    0.000    0.003    0.000 identity.py:14(__init__)
     2942    0.003    0.000    0.003    0.000 {_codecs.utf_8_encode}
     2008    0.003    0.000    0.003    0.000 result.py:632(_cursor_description)
     1611    0.003    0.000    0.003    0.000 attr.py:214(__call__)
     1206    0.003    0.000    0.003    0.000 interfaces.py:486(_get_strategy)
      469    0.002    0.000    0.003    0.000 log.py:54(_should_log_debug)
      603    0.003    0.000    0.003    0.000 path_registry.py:267(__init__)
     2015    0.003    0.000    0.003    0.000 {method 'pop' of 'list' objects}
    13123    0.003    0.000    0.003    0.000 {id}
      603    0.002    0.000    0.003    0.000 path_registry.py:283(__getitem__)
      938    0.002    0.000    0.003    0.000 pool.py:854(__getattr__)
      733    0.002    0.000    0.003    0.000 query.py:3245(corresponds_to)
     4358    0.003    0.000    0.003    0.000 {setattr}
      201    0.003    0.000    0.003    0.000 {method 'utctimetuple' of 'datetime.datetime' objects}
     3542    0.002    0.000    0.003    0.000 {hash}
     1380    0.002    0.000    0.003    0.000 currency.py:219(__init__)
      405    0.003    0.000    0.003    0.000 {print}
     2009    0.003    0.000    0.003    0.000 base.py:1472(get_select_precolumns)
      469    0.002    0.000    0.002    0.000 pool.py:559(get_connection)
      201    0.002    0.000    0.002    0.000 vendors.py:376(abs_moq)
      469    0.002    0.000    0.002    0.000 contextlib.py:82(helper)
      739    0.002    0.000    0.002    0.000 elements.py:269(_cloned_set)
     1474    0.002    0.000    0.002    0.000 {method 'remove' of 'list' objects}
     2477    0.002    0.000    0.002    0.000 {next}
      201    0.001    0.000    0.002    0.000 helpers.py:61(clearln)
      469    0.002    0.000    0.002    0.000 weakref.py:267(__init__)
     1380    0.002    0.000    0.002    0.000 vendors.py:321(add_price)
     2009    0.002    0.000    0.002    0.000 _collections.py:724(__init__)
     4221    0.002    0.000    0.002    0.000 selectable.py:1418(_from_objects)
        2    0.000    0.000    0.002    0.001 fsutils.py:400(_revisions)
      603    0.001    0.000    0.002    0.000 __init__.py:99(progress)
      469    0.002    0.000    0.002    0.000 session.py:297(_remove_snapshot)
        2    0.000    0.000    0.002    0.001 glob.py:18(glob)
     3416    0.002    0.000    0.002    0.000 {method 'release' of 'thread.lock' objects}
        9    0.000    0.000    0.002    0.000 glob.py:29(iglob)
      735    0.002    0.000    0.002    0.000 selectable.py:874(<lambda>)
     2612    0.002    0.000    0.002    0.000 query.py:3746(<genexpr>)
        2    0.000    0.000    0.002    0.001 glob.py:66(glob1)
      470    0.002    0.000    0.002    0.000 {range}
        1    0.000    0.000    0.002    0.002 fsutils.py:393(_current_revision)
     2818    0.002    0.000    0.002    0.000 threading.py:63(_note)
      938    0.001    0.000    0.002    0.000 threading.py:237(_is_owned)
     3683    0.002    0.000    0.002    0.000 {callable}
     1543    0.002    0.000    0.002    0.000 {method 'items' of 'dict' objects}
     1007    0.002    0.000    0.002    0.000 base.py:590(contains_column)
      469    0.001    0.000    0.002    0.000 weakref.py:262(__new__)
      201    0.001    0.000    0.002    0.000 calendar.py:610(timegm)
     2814    0.002    0.000    0.002    0.000 base.py:301(connection)
      469    0.002    0.000    0.002    0.000 {method 'format' of 'str' objects}
     5093    0.002    0.000    0.002    0.000 posixpath.py:51(normcase)
     2477    0.002    0.000    0.002    0.000 query.py:286(_entity_zero)
      469    0.001    0.000    0.001    0.000 identity.py:184(all_states)
        2    0.000    0.000    0.001    0.001 fnmatch.py:45(filter)
     1876    0.001    0.000    0.001    0.000 session.py:225(_is_transaction_boundary)
      201    0.001    0.000    0.001    0.000 __init__.py:44(avg)
      937    0.001    0.000    0.001    0.000 type_api.py:53(__init__)
      404    0.001    0.000    0.001    0.000 {method 'isatty' of 'file' objects}
     2009    0.001    0.000    0.001    0.000 {method 'union' of 'set' objects}
     2008    0.001    0.000    0.001    0.000 compiler.py:215(__str__)
     4345    0.001    0.000    0.001    0.000 interfaces.py:617(setup_query)
     2820    0.001    0.000    0.001    0.000 {thread.get_ident}
     2008    0.001    0.000    0.001    0.000 {method 'keys' of 'dict' objects}
      735    0.001    0.000    0.001    0.000 query.py:2112(_reset_joinpoint)
      603    0.001    0.000    0.001    0.000 weakref.py:69(__getitem__)
     2008    0.001    0.000    0.001    0.000 _collections.py:155(union)
      445    0.001    0.000    0.001    0.000 weakref.py:48(remove)
      469    0.001    0.000    0.001    0.000 queue.py:198(_get)
      469    0.001    0.000    0.001    0.000 queue.py:194(_put)
        1    0.000    0.000    0.001    0.001 query.py:971(from_self)
      201    0.001    0.000    0.001    0.000 instrumentation.py:302(get_impl)
     2746    0.001    0.000    0.001    0.000 selectable.py:170(selectable)
      469    0.001    0.000    0.001    0.000 base.py:255(__init__)
      469    0.001    0.000    0.001    0.000 session.py:239(_iterate_parents)
      469    0.001    0.000    0.001    0.000 queue.py:190(_full)
      603    0.001    0.000    0.001    0.000 query.py:224(_adapt_all_clauses)
      603    0.001    0.000    0.001    0.000 {method 'intersection' of 'frozenset' objects}
      603    0.001    0.000    0.001    0.000 path_registry.py:77(__len__)
        1    0.000    0.000    0.001    0.001 sre_compile.py:493(compile)
     1875    0.001    0.000    0.001    0.000 langhelpers.py:825(<lambda>)
     2011    0.001    0.000    0.001    0.000 {iter}
      201    0.001    0.000    0.001    0.000 state.py:277(dict)
     2008    0.001    0.000    0.001    0.000 default.py:750(post_exec)
     2008    0.001    0.000    0.001    0.000 default.py:747(pre_exec)
      469    0.001    0.000    0.001    0.000 pool.py:677(__init__)
     1380    0.001    0.000    0.001    0.000 vendors.py:488(currency)
      469    0.001    0.000    0.001    0.000 base.py:1532(__init__)
      201    0.001    0.000    0.001    0.000 collections.py:578(__init__)
      201    0.000    0.000    0.001    0.000 __init__.py:95(percent)
     1876    0.001    0.000    0.001    0.000 {method 'setdefault' of 'dict' objects}
     2008    0.001    0.000    0.001    0.000 {method 'close' of 'psycopg2.extensions.cursor' objects}
      467    0.001    0.000    0.001    0.000 interfaces.py:362(adapter)
      201    0.001    0.000    0.001    0.000 {sum}
      469    0.001    0.000    0.001    0.000 {method 'rollback' of 'psycopg2.extensions.connection' objects}
     1869    0.001    0.000    0.001    0.000 elements.py:378(_copy_internals)
      267    0.001    0.000    0.001    0.000 selectable.py:857(<lambda>)
      734    0.001    0.000    0.001    0.000 mapper.py:2278(common_parent)
      603    0.001    0.000    0.001    0.000 {method 'difference_update' of 'set' objects}
     1581    0.001    0.000    0.001    0.000 vendors.py:210(moq)
     1380    0.001    0.000    0.001    0.000 collections.py:1038(__set)
      733    0.001    0.000    0.001    0.000 query.py:3241(entity_zero_or_selectable)
        2    0.001    0.000    0.001    0.000 {posix.rename}
      469    0.001    0.000    0.001    0.000 base.py:1537(_parent)
      470    0.001    0.000    0.001    0.000 {sys._getframe}
      467    0.001    0.000    0.001    0.000 relationships.py:1384(_get_attr_w_warn_on_none)
        1    0.000    0.000    0.001    0.001 sre_parse.py:675(parse)
        1    0.000    0.000    0.001    0.001 __init__.py:1142(info)
        1    0.000    0.000    0.000    0.000 sre_parse.py:301(_parse_sub)
        1    0.000    0.000    0.000    0.000 <string>:1(_from_selectable)
        1    0.000    0.000    0.000    0.000 sre_parse.py:379(_parse)
        1    0.000    0.000    0.000    0.000 query.py:992(_from_selectable)
      5/2    0.000    0.000    0.000    0.000 selectable.py:537(columns)
      469    0.000    0.000    0.000    0.000 queue.py:186(_empty)
        1    0.000    0.000    0.000    0.000 __init__.py:1252(_log)
      201    0.000    0.000    0.000    0.000 __init__.py:103(remaining)
      469    0.000    0.000    0.000    0.000 contextlib.py:12(__init__)
        1    0.000    0.000    0.000    0.000 compiler.py:1244(visit_alias)
        2    0.000    0.000    0.000    0.000 query.py:3693(setup_context)
      475    0.000    0.000    0.000    0.000 {method 'discard' of 'set' objects}
        1    0.000    0.000    0.000    0.000 query.py:422(statement)
        1    0.000    0.000    0.000    0.000 visitors.py:304(replacement_traverse)
      5/1    0.000    0.000    0.000    0.000 visitors.py:311(clone)
        1    0.000    0.000    0.000    0.000 sre_compile.py:478(_code)
        1    0.000    0.000    0.000    0.000 query.py:3656(adapt_to_selectable)
      201    0.000    0.000    0.000    0.000 {math.ceil}
      603    0.000    0.000    0.000    0.000 query.py:906(_with_invoke_all_eagers)
      733    0.000    0.000    0.000    0.000 {method 'strip' of 'str' objects}
        1    0.000    0.000    0.000    0.000 {method 'close' of 'file' objects}
      679    0.000    0.000    0.000    0.000 {method 'append' of 'collections.deque' objects}
      404    0.000    0.000    0.000    0.000 {time.time}
        2    0.000    0.000    0.000    0.000 selectable.py:3179(_populate_column_collection)
        1    0.000    0.000    0.000    0.000 fnmatch.py:81(translate)
        1    0.000    0.000    0.000    0.000 elements.py:3125(_copy_internals)
        3    0.000    0.000    0.000    0.000 schema.py:1346(_make_proxy)
      223    0.000    0.000    0.000    0.000 terminal.py:226(term_width)
      735    0.000    0.000    0.000    0.000 elements.py:405(self_group)
        3    0.000    0.000    0.000    0.000 query.py:3539(__init__)
      469    0.000    0.000    0.000    0.000 interfaces.py:120(create_row_processor)
        5    0.000    0.000    0.000    0.000 query.py:268(replace)
        5    0.000    0.000    0.000    0.000 util.py:492(replace)
        1    0.000    0.000    0.000    0.000 __init__.py:1273(handle)
        1    0.000    0.000    0.000    0.000 selectable.py:3432(__init__)
        2    0.000    0.000    0.000    0.000 {posix.listdir}
        1    0.000    0.000    0.000    0.000 __init__.py:1305(callHandlers)
      201    0.000    0.000    0.000    0.000 ti.py:181(url_base)
      468    0.000    0.000    0.000    0.000 base.py:32(_clone)
      469    0.000    0.000    0.000    0.000 interfaces.py:111(setup)
        1    0.000    0.000    0.000    0.000 selectable.py:1123(_populate_column_collection)
      469    0.000    0.000    0.000    0.000 default.py:416(do_begin)
      201    0.000    0.000    0.000    0.000 vendors.py:364(ident)
      474    0.000    0.000    0.000    0.000 {method 'popleft' of 'collections.deque' objects}
        1    0.000    0.000    0.000    0.000 __init__.py:736(handle)
       46    0.000    0.000    0.000    0.000 re.py:204(escape)
        1    0.000    0.000    0.000    0.000 sre_compile.py:359(_compile_info)
      201    0.000    0.000    0.000    0.000 vendors.py:348(mpartno)
      2/1    0.000    0.000    0.000    0.000 sre_compile.py:32(_compile)
       59    0.000    0.000    0.000    0.000 sre_parse.py:201(get)
      201    0.000    0.000    0.000    0.000 vendors.py:332(vqtyavail)
      201    0.000    0.000    0.000    0.000 tz.py:47(utcoffset)
        1    0.000    0.000    0.000    0.000 __init__.py:1239(makeRecord)
        1    0.000    0.000    0.000    0.000 linecache.py:68(updatecache)
        1    0.000    0.000    0.000    0.000 __init__.py:839(emit)
        1    0.000    0.000    0.000    0.000 __init__.py:242(__init__)
      201    0.000    0.000    0.000    0.000 vendors.py:324(vpno)
      201    0.000    0.000    0.000    0.000 {method 'toordinal' of 'datetime.date' objects}
      201    0.000    0.000    0.000    0.000 vendors.py:340(manufacturer)
        1    0.000    0.000    0.000    0.000 functions.py:155(_copy_internals)
       62    0.000    0.000    0.000    0.000 sre_parse.py:182(__next)
        4    0.000    0.000    0.000    0.000 util.py:476(_corresponding_column)
      201    0.000    0.000    0.000    0.000 vendors.py:356(vpartdesc)
        1    0.000    0.000    0.000    0.000 terminal.py:221(__init__)
        3    0.000    0.000    0.000    0.000 schema.py:861(__init__)
        1    0.000    0.000    0.000    0.000 functions.py:258(__call__)
        1    0.000    0.000    0.000    0.000 type_api.py:395(_dialect_info)
      201    0.000    0.000    0.000    0.000 vendors.py:434(package)
        1    0.000    0.000    0.000    0.000 selectable.py:1118(is_derived_from)
      201    0.000    0.000    0.000    0.000 state.py:225(_pending_mutations)
        1    0.000    0.000    0.000    0.000 functions.py:579(__init__)
        1    0.000    0.000    0.000    0.000 selectable.py:2689(is_derived_from)
        2    0.000    0.000    0.000    0.000 {open}
        1    0.000    0.000    0.000    0.000 {method 'readlines' of 'file' objects}
        1    0.000    0.000    0.000    0.000 functions.py:483(__init__)
        1    0.000    0.000    0.000    0.000 fsutils.py:329(__init__)
        1    0.000    0.000    0.000    0.000 query.py:158(_set_select_from)
        1    0.000    0.000    0.000    0.000 sre_compile.py:178(_compile_charset)
      6/4    0.000    0.000    0.000    0.000 elements.py:767(proxy_set)
        1    0.000    0.000    0.000    0.000 elements.py:2822(_copy_internals)
        2    0.000    0.000    0.000    0.000 genericpath.py:26(isfile)
        2    0.000    0.000    0.000    0.000 {filter}
        4    0.000    0.000    0.000    0.000 elements.py:727(__getattr__)
        1    0.000    0.000    0.000    0.000 langhelpers.py:767(oneshot)
        1    0.000    0.000    0.000    0.000 sre_compile.py:207(_optimize_charset)
        1    0.000    0.000    0.000    0.000 type_api.py:414(adapt)
        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)
      3/2    0.000    0.000    0.000    0.000 sre_parse.py:140(getwidth)
        3    0.000    0.000    0.000    0.000 selectable.py:577(_init_collections)
        1    0.000    0.000    0.000    0.000 terminal.py:65(get_terminal_size)
        1    0.000    0.000    0.000    0.000 selectable.py:2655(locate_all_froms)
        1    0.000    0.000    0.000    0.000 langhelpers.py:1014(constructor_copy)
        2    0.000    0.000    0.000    0.000 elements.py:3136(_from_objects)
        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)
       49    0.000    0.000    0.000    0.000 sre_parse.py:138(append)
        1    0.000    0.000    0.000    0.000 compiler.py:816(function_argspec)
        1    0.000    0.000    0.000    0.000 elements.py:3330(_gen_label)
        1    0.000    0.000    0.000    0.000 terminal.py:175(__init__)
        1    0.000    0.000    0.000    0.000 __init__.py:713(format)
        9    0.000    0.000    0.000    0.000 sre_parse.py:257(_escape)
        4    0.000    0.000    0.000    0.000 elements.py:3189(__init__)
        1    0.000    0.000    0.000    0.000 {method 'write' of 'file' objects}
        6    0.000    0.000    0.000    0.000 glob.py:94(has_magic)
        1    0.000    0.000    0.000    0.000 terminal.py:118(_get_terminal_size_linux)
      6/1    0.000    0.000    0.000    0.000 langhelpers.py:216(get_cls_kwargs)
        1    0.000    0.000    0.000    0.000 helpers.py:53(__init__)
        1    0.000    0.000    0.000    0.000 compiler.py:523(visit_grouping)
        1    0.000    0.000    0.000    0.000 helpers.py:71(finish)
        1    0.000    0.000    0.000    0.000 elements.py:3825(_literal_as_binds)
        1    0.000    0.000    0.000    0.000 __init__.py:451(format)
        2    0.000    0.000    0.000    0.000 __init__.py:693(acquire)
        2    0.000    0.000    0.000    0.000 visitors.py:210(iterate)
        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:500(add)
        3    0.000    0.000    0.000    0.000 base.py:454(__init__)
        1    0.000    0.000    0.000    0.000 __init__.py:828(flush)
        2    0.000    0.000    0.000    0.000 posixpath.py:89(split)
        7    0.000    0.000    0.000    0.000 elements.py:3295(_set_table)
        1    0.000    0.000    0.000    0.000 __init__.py:1218(findCaller)
        2    0.000    0.000    0.000    0.000 functions.py:148(_from_objects)
      133    0.000    0.000    0.000    0.000 state.py:244(_detach)
        3    0.000    0.000    0.000    0.000 base.py:518(__setitem__)
        5    0.000    0.000    0.000    0.000 base.py:594(as_immutable)
        2    0.000    0.000    0.000    0.000 elements.py:3610(__add__)
        1    0.000    0.000    0.000    0.000 selectable.py:392(alias)
       74    0.000    0.000    0.000    0.000 glob.py:77(<lambda>)
        9    0.000    0.000    0.000    0.000 langhelpers.py:785(expire_instance)
        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 selectable.py:1088(__init__)
        6    0.000    0.000    0.000    0.000 {method 'search' of '_sre.SRE_Pattern' objects}
        1    0.000    0.000    0.000    0.000 {_csv.writer}
        1    0.000    0.000    0.000    0.000 <string>:1(correlate)
        1    0.000    0.000    0.000    0.000 elements.py:857(label)
        1    0.000    0.000    0.000    0.000 util.py:34(find_join_source)
        1    0.000    0.000    0.000    0.000 elements.py:3049(__init__)
        6    0.000    0.000    0.000    0.000 base.py:575(__contains__)
        1    0.000    0.000    0.000    0.000 default.py:350(type_descriptor)
        2    0.000    0.000    0.000    0.000 __init__.py:700(release)
        1    0.000    0.000    0.000    0.000 elements.py:2230(literal_column)
        5    0.000    0.000    0.000    0.000 base.py:600(__init__)
        1    0.000    0.000    0.000    0.000 util.py:537(__init__)
        7    0.000    0.000    0.000    0.000 string.py:281(split)
        3    0.000    0.000    0.000    0.000 _collections.py:252(__init__)
        6    0.000    0.000    0.000    0.000 sre_parse.py:130(__getitem__)
        1    0.000    0.000    0.000    0.000 __init__.py:83(__init__)
        1    0.000    0.000    0.000    0.000 posixpath.py:104(splitext)
        1    0.000    0.000    0.000    0.000 selectable.py:1658(_generate)
        1    0.000    0.000    0.000    0.000 type_api.py:1147(adapt_type)
        1    0.000    0.000    0.000    0.000 _collections.py:932(lightweight_named_tuple)
        1    0.000    0.000    0.000    0.000 __init__.py:445(usesTime)
        1    0.000    0.000    0.000    0.000 elements.py:1782(__init__)
        1    0.000    0.000    0.000    0.000 vendors.py:484(map)
        1    0.000    0.000    0.000    0.000 __init__.py:31(__init__)
        1    0.000    0.000    0.000    0.000 query.py:3669(corresponds_to)
        2    0.000    0.000    0.000    0.000 __init__.py:598(filter)
        5    0.000    0.000    0.000    0.000 {method 'rfind' of 'str' objects}
        1    0.000    0.000    0.000    0.000 query.py:3662(setup_entity)
        1    0.000    0.000    0.000    0.000 functions.py:244(__getattr__)
      6/4    0.000    0.000    0.000    0.000 selectable.py:745(is_derived_from)
        9    0.000    0.000    0.000    0.000 sre_parse.py:195(match)
        8    0.000    0.000    0.000    0.000 _collections.py:177(__init__)
       48    0.000    0.000    0.000    0.000 {ord}
        1    0.000    0.000    0.000    0.000 __init__.py:153(getLevelName)
        2    0.000    0.000    0.000    0.000 selectable.py:532(_reset_exported)
        1    0.000    0.000    0.000    0.000 sre_compile.py:354(_simple)
        1    0.000    0.000    0.000    0.000 attributes.py:148(_query_clause_element)
        1    0.000    0.000    0.000    0.000 <string>:1(with_labels)
        1    0.000    0.000    0.000    0.000 posixpath.py:119(basename)
        1    0.000    0.000    0.000    0.000 {fcntl.ioctl}
        1    0.000    0.000    0.000    0.000 query.py:3681(row_processor)
        1    0.000    0.000    0.000    0.000 _collections.py:879(get)
        1    0.000    0.000    0.000    0.000 util.py:464(__init__)
        2    0.000    0.000    0.000    0.000 elements.py:3101(element)
        1    0.000    0.000    0.000    0.000 genericpath.py:85(_splitext)
        2    0.000    0.000    0.000    0.000 sre_compile.py:472(isstring)
        1    0.000    0.000    0.000    0.000 {_struct.unpack}
        1    0.000    0.000    0.000    0.000 sre_parse.py:178(__init__)
        1    0.000    0.000    0.000    0.000 <string>:1(enable_eagerloads)
        1    0.000    0.000    0.000    0.000 __init__.py:311(getMessage)
        2    0.000    0.000    0.000    0.000 stat.py:49(S_ISREG)
        3    0.000    0.000    0.000    0.000 _collections.py:331(__setitem__)
        6    0.000    0.000    0.000    0.000 _collections.py:213(__contains__)
        1    0.000    0.000    0.000    0.000 __init__.py:81(<lambda>)
        2    0.000    0.000    0.000    0.000 vendors.py:472(name)
        1    0.000    0.000    0.000    0.000 {_sre.compile}
        2    0.000    0.000    0.000    0.000 annotation.py:75(_constructor)
       19    0.000    0.000    0.000    0.000 selectable.py:406(is_derived_from)
        2    0.000    0.000    0.000    0.000 fsutils.py:387(_versioned_name)
        1    0.000    0.000    0.000    0.000 platform.py:1326(system)
        1    0.000    0.000    0.000    0.000 fsutils.py:360(__getattr__)
        1    0.000    0.000    0.000    0.000 elements.py:2807(__init__)
        1    0.000    0.000    0.000    0.000 interfaces.py:347(_query_clause_element)
        3    0.000    0.000    0.000    0.000 _collections.py:368(add)
        2    0.000    0.000    0.000    0.000 base.py:353(_is_aliased_class)
        1    0.000    0.000    0.000    0.000 query.py:340(__all_equivs)
        1    0.000    0.000    0.000    0.000 fsutils.py:344(__del__)
        1    0.000    0.000    0.000    0.000 schema.py:1391(get_children)
        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)
        4    0.000    0.000    0.000    0.000 sre_parse.py:126(__len__)
        1    0.000    0.000    0.000    0.000 compiler.py:2725(format_alias)
        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)
        3    0.000    0.000    0.000    0.000 langhelpers.py:1225(set_creation_order)
        1    0.000    0.000    0.000    0.000 type_api.py:226(_has_column_expression)
        3    0.000    0.000    0.000    0.000 elements.py:3633(_as_truncated)
        2    0.000    0.000    0.000    0.000 {method 'replace' of 'str' objects}
        3    0.000    0.000    0.000    0.000 _collections.py:270(__init__)
        1    0.000    0.000    0.000    0.000 elements.py:2832(__getattr__)
        2    0.000    0.000    0.000    0.000 {method 'extend' of 'list' objects}
        1    0.000    0.000    0.000    0.000 elements.py:3095(type)
        1    0.000    0.000    0.000    0.000 weakref.py:320(__setitem__)
        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__)
        1    0.000    0.000    0.000    0.000 weakref.py:284(remove)
        1    0.000    0.000    0.000    0.000 sre_parse.py:67(__init__)
        1    0.000    0.000    0.000    0.000 attributes.py:145(__clause_element__)
        3    0.000    0.000    0.000    0.000 elements.py:257(_constructor)
        1    0.000    0.000    0.000    0.000 query.py:294(_mapper_entities)
        2    0.000    0.000    0.000    0.000 {method 'rstrip' of 'str' objects}
        4    0.000    0.000    0.000    0.000 sre_compile.py:24(_identityfunction)
        1    0.000    0.000    0.000    0.000 platform.py:1189(uname)
        3    0.000    0.000    0.000    0.000 schema.py:67(_init_items)
        2    0.000    0.000    0.000    0.000 functions.py:89(clauses)
        1    0.000    0.000    0.000    0.000 {method 'find' of 'str' objects}
        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 type_api.py:188(result_processor)
        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 {posix.getpid}
        1    0.000    0.000    0.000    0.000 query.py:598(with_labels)
        1    0.000    0.000    0.000    0.000 functions.py:152(get_children)
        1    0.000    0.000    0.000    0.000 {method 'difference' of 'set' objects}
        1    0.000    0.000    0.000    0.000 _collections.py:875(_inc_counter)
        1    0.000    0.000    0.000    0.000 selectable.py:2960(correlate)
        1    0.000    0.000    0.000    0.000 query.py:572(enable_eagerloads)
        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)
        2    0.000    0.000    0.000    0.000 elements.py:3122(get_children)
        1    0.000    0.000    0.000    0.000 selectable.py:1156(_from_objects)
        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 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 functions.py:240(__init__)
        2    0.000    0.000    0.000    0.000 elements.py:391(get_children)
        1    0.000    0.000    0.000    0.000 elements.py:2825(get_children)