Pricelist Vendor Get Part ProfilingΒΆ

Raw execution profile SVG of execution profile

Execution Profile

../../../_images/iedel.profile2.svg

pstats Output

Tue May 24 00:38:24 2016    /media/ldata/code/tendril/profiling/sourcing/get_part/iedel.profile

         108501 function calls (106388 primitive calls) in 0.424 seconds

   Ordered by: cumulative time

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    0.425    0.425 vendors.py:63(profile_vendor_get_part)
        7    0.000    0.000    0.425    0.061 vendors.py:509(get_all_vparts)
   141/31    0.001    0.000    0.352    0.011 db.py:168(inner)
        6    0.000    0.000    0.258    0.043 pricelist.py:247(get_vpart)
        6    0.000    0.000    0.258    0.043 pricelist.py:45(__init__)
        6    0.000    0.000    0.258    0.043 vendors.py:236(__init__)
        6    0.000    0.000    0.258    0.043 vendors.py:248(_populate)
       68    0.000    0.000    0.235    0.003 query.py:2511(__iter__)
       68    0.001    0.000    0.216    0.003 query.py:2525(_execute_and_instances)
       74    0.000    0.000    0.215    0.003 base.py:846(execute)
       74    0.000    0.000    0.215    0.003 elements.py:322(_execute_on_connection)
       74    0.001    0.000    0.215    0.003 base.py:975(_execute_clauseelement)
        6    0.000    0.000    0.186    0.031 vendors.py:265(commit)
        6    0.000    0.000    0.186    0.031 vendors.py:272(_commit_to_db)
        7    0.000    0.000    0.167    0.024 vendors.py:504(get_all_vpnos)
       74    0.002    0.000    0.167    0.002 base.py:1061(_execute_context)
       25    0.001    0.000    0.155    0.006 query.py:2393(all)
        6    0.000    0.000    0.155    0.026 maps.py:73(get_all_partnos)
       74    0.000    0.000    0.145    0.002 default.py:449(do_execute)
       74    0.144    0.002    0.145    0.002 {method 'execute' of 'psycopg2.extensions.cursor' objects}
  191/179    0.000    0.000    0.125    0.001 attributes.py:229(__get__)
    78/66    0.000    0.000    0.124    0.002 attributes.py:556(get)
       12    0.000    0.000    0.124    0.010 strategies.py:477(_load_for_state)
       12    0.000    0.000    0.123    0.010 strategies.py:550(_emit_lazyload)
       12    0.000    0.000    0.117    0.010 controller.py:244(get_map_vpnos)
        6    0.000    0.000    0.113    0.019 controller.py:181(populate_vpart_prices)
       38    0.000    0.000    0.112    0.003 db.py:111(get_session)
       43    0.001    0.000    0.099    0.002 query.py:2451(one)
        6    0.000    0.000    0.088    0.015 vendors.py:88(get_upartnos)
       18    0.001    0.000    0.075    0.004 controller.py:215(get_map)
        6    0.000    0.000    0.068    0.011 controller.py:263(get_umap_vpnos)
       19    0.000    0.000    0.068    0.004 contextlib.py:21(__exit__)
        6    0.000    0.000    0.067    0.011 vendors.py:84(get_apartnos)
       19    0.000    0.000    0.066    0.003 session.py:756(commit)
       25    0.001    0.000    0.066    0.003 session.py:389(commit)
       19    0.000    0.000    0.061    0.003 base.py:1569(commit)
       19    0.000    0.000    0.061    0.003 base.py:1603(_do_commit)
       19    0.000    0.000    0.061    0.003 base.py:679(_commit_impl)
       19    0.000    0.000    0.060    0.003 default.py:422(do_commit)
       19    0.060    0.003    0.060    0.003 {method 'commit' of 'psycopg2.extensions.connection' objects}
       31    0.000    0.000    0.052    0.002 controller.py:45(_get_vendor)
       19    0.000    0.000    0.052    0.003 controller.py:94(get_vendor)
        6    0.000    0.000    0.050    0.008 controller.py:257(get_amap_vpnos)
       68    0.000    0.000    0.046    0.001 elements.py:431(compile)
       68    0.000    0.000    0.046    0.001 elements.py:496(_compiler)
       68    0.001    0.000    0.046    0.001 compiler.py:329(__init__)
        6    0.000    0.000    0.045    0.008 controller.py:113(get_vpno_obj)
       19    0.000    0.000    0.045    0.002 contextlib.py:15(__enter__)
       68    0.000    0.000    0.044    0.001 compiler.py:167(__init__)
       68    0.000    0.000    0.044    0.001 compiler.py:212(process)
  1265/68    0.003    0.000    0.044    0.001 visitors.py:75(_compiler_dispatch)
       68    0.002    0.000    0.044    0.001 compiler.py:1503(visit_select)
       19    0.000    0.000    0.042    0.002 db.py:83(_get_caller)
       19    0.000    0.000    0.040    0.002 inspect.py:1053(stack)
       19    0.001    0.000    0.040    0.002 inspect.py:1026(getouterframes)
      285    0.003    0.000    0.039    0.000 inspect.py:988(getframeinfo)
        6    0.000    0.000    0.027    0.005 controller.py:128(populate_vpart_detail)
      285    0.003    0.000    0.026    0.000 inspect.py:518(findsource)
      451    0.003    0.000    0.020    0.000 compiler.py:1275(_label_select_column)
      135    0.001    0.000    0.018    0.000 loading.py:30(instances)
       68    0.001    0.000    0.018    0.000 query.py:2953(_compile_context)
      589    0.005    0.000    0.017    0.000 inspect.py:440(getsourcefile)
  438/153    0.001    0.000    0.015    0.000 operators.py:294(__eq__)
      451    0.004    0.000    0.015    0.000 compiler.py:581(visit_label)
  333/183    0.001    0.000    0.015    0.000 {operator.eq}
      183    0.001    0.000    0.014    0.000 base.py:196(generate)
      137    0.000    0.000    0.014    0.000 session.py:1970(flush)
        6    0.000    0.000    0.013    0.002 session.py:2021(_flush)
       68    0.001    0.000    0.013    0.000 compiler.py:1679(_compose_select_body)
       93    0.000    0.000    0.013    0.000 attributes.py:174(operate)
        7    0.000    0.000    0.012    0.002 vendors.py:500(get_idents)
        1    0.000    0.000    0.012    0.012 vendors.py:77(get_idents)
      172    0.000    0.000    0.011    0.000 elements.py:738(operate)
        6    0.000    0.000    0.011    0.002 unitofwork.py:351(execute)
      172    0.000    0.000    0.010    0.000 <string>:1(<lambda>)
       74    0.001    0.000    0.010    0.000 psycopg2.py:466(get_result_proxy)
   276/98    0.001    0.000    0.010    0.000 visitors.py:86(_compiler_dispatch)
      172    0.001    0.000    0.010    0.000 type_api.py:57(operate)
       74    0.000    0.000    0.009    0.000 result.py:488(__init__)
       74    0.002    0.000    0.009    0.000 default.py:515(_init_compiled)
      304    0.001    0.000    0.009    0.000 inspect.py:472(getmodule)
       74    0.001    0.000    0.009    0.000 result.py:513(_init_metadata)
      105    0.001    0.000    0.009    0.000 annotation.py:93(__eq__)
       30    0.000    0.000    0.009    0.000 query.py:1511(join)
       30    0.000    0.000    0.008    0.000 <string>:1(_join)
    15551    0.007    0.000    0.008    0.000 {isinstance}
       68    0.006    0.000    0.008    0.000 result.py:189(__init__)
      135    0.001    0.000    0.008    0.000 compiler.py:904(visit_binary)
       30    0.000    0.000    0.008    0.000 query.py:1800(_join)
       75    0.000    0.000    0.008    0.000 properties.py:268(operate)
      874    0.003    0.000    0.008    0.000 inspect.py:398(getfile)
      617    0.004    0.000    0.008    0.000 compiler.py:620(visit_column)
       68    0.001    0.000    0.008    0.000 query.py:3282(row_processor)
        1    0.000    0.000    0.008    0.008 controller.py:279(get_vendor_idents)
      135    0.001    0.000    0.007    0.000 compiler.py:935(_generate_generic_binary)
       68    0.001    0.000    0.007    0.000 query.py:3071(_simple_statement)
       68    0.000    0.000    0.007    0.000 query.py:3317(setup_context)
      135    0.001    0.000    0.007    0.000 default_comparator.py:21(_boolean_compare)
       30    0.000    0.000    0.007    0.000 query.py:1915(_join_left_to_right)
       68    0.002    0.000    0.007    0.000 loading.py:224(_setup_entity_query)
       12    0.000    0.000    0.007    0.001 unitofwork.py:528(execute)
      209    0.000    0.000    0.007    0.000 inspect.py:460(getabsfile)
       12    0.000    0.000    0.007    0.001 persistence.py:124(save_obj)
      401    0.001    0.000    0.006    0.000 {method 'join' of 'str' objects}
       68    0.003    0.000    0.006    0.000 loading.py:269(_instance_processor)
      501    0.001    0.000    0.006    0.000 langhelpers.py:744(__get__)
       37    0.000    0.000    0.006    0.000 compiler.py:735(visit_clauselist)
       68    0.001    0.000    0.006    0.000 <string>:1(select)
       30    0.000    0.000    0.006    0.000 query.py:2068(_join_to_left)
       68    0.001    0.000    0.006    0.000 compiler.py:1654(_setup_select_stack)
       67    0.001    0.000    0.006    0.000 loading.py:360(_instance)
      111    0.000    0.000    0.006    0.000 compiler.py:742(<genexpr>)
       68    0.000    0.000    0.006    0.000 session.py:1245(query)
      209    0.001    0.000    0.006    0.000 posixpath.py:365(abspath)
      111    0.000    0.000    0.006    0.000 compiler.py:744(<genexpr>)
       12    0.000    0.000    0.005    0.000 persistence.py:597(_emit_update_statements)
      105    0.000    0.000    0.005    0.000 <string>:1(filter)
       30    0.000    0.000    0.005    0.000 util.py:880(join)
       68    0.002    0.000    0.005    0.000 selectable.py:2220(__init__)
       68    0.000    0.000    0.005    0.000 query.py:107(__init__)
       30    0.000    0.000    0.005    0.000 util.py:779(__init__)
       68    0.001    0.000    0.005    0.000 query.py:112(_set_entities)
       68    0.001    0.000    0.005    0.000 selectable.py:2506(_get_display_froms)
      611    0.002    0.000    0.005    0.000 interfaces.py:498(setup)
       30    0.000    0.000    0.004    0.000 selectable.py:651(__init__)
       18    0.000    0.000    0.004    0.000 relationships.py:961(__eq__)
      135    0.001    0.000    0.004    0.000 default_comparator.py:269(_check_literal)
       44    0.001    0.000    0.004    0.000 session.py:456(close)
       19    0.000    0.000    0.004    0.000 query.py:1310(filter_by)
      105    0.001    0.000    0.004    0.000 query.py:1274(filter)
       68    0.000    0.000    0.004    0.000 query.py:2518(_connection_from_session)
      589    0.001    0.000    0.004    0.000 genericpath.py:15(exists)
       68    0.000    0.000    0.004    0.000 session.py:811(connection)
      555    0.002    0.000    0.004    0.000 compiler.py:1130(_truncated_identifier)
       30    0.000    0.000    0.004    0.000 selectable.py:786(_match_primaries)
       68    0.002    0.000    0.004    0.000 selectable.py:2479(_froms)
       30    0.000    0.000    0.003    0.000 selectable.py:793(_join_condition)
     3203    0.003    0.000    0.003    0.000 {getattr}
      104    0.001    0.000    0.003    0.000 compiler.py:1048(visit_bindparam)
       67    0.001    0.000    0.003    0.000 loading.py:478(_populate_full)
       74    0.000    0.000    0.003    0.000 elements.py:3370(_bind_param)
       68    0.000    0.000    0.003    0.000 session.py:884(_connection_for_bind)
   116/92    0.000    0.000    0.003    0.000 session.py:312(_connection_for_bind)
     1784    0.002    0.000    0.003    0.000 compiler.py:2693(quote)
        6    0.000    0.000    0.003    0.000 unitofwork.py:300(_generate_actions)
      589    0.003    0.000    0.003    0.000 {posix.stat}
       74    0.002    0.000    0.003    0.000 elements.py:913(__init__)
       63    0.000    0.000    0.003    0.000 session.py:694(begin)
      575    0.001    0.000    0.003    0.000 inspection.py:38(inspect)
       96    0.000    0.000    0.003    0.000 type_api.py:1009(process)
    74/37    0.000    0.000    0.003    0.000 operators.py:43(__and__)
      209    0.002    0.000    0.003    0.000 posixpath.py:336(normpath)
   130/94    0.000    0.000    0.003    0.000 annotation.py:71(_compiler_dispatch)
       96    0.000    0.000    0.003    0.000 arrow.py:73(process_result_value)
       68    0.000    0.000    0.002    0.000 result.py:944(fetchall)
      771    0.002    0.000    0.002    0.000 interfaces.py:466(_get_context_loader)
      104    0.000    0.000    0.002    0.000 compiler.py:1117(_truncate_bindparam)
       63    0.000    0.000    0.002    0.000 session.py:169(__init__)
       84    0.000    0.000    0.002    0.000 api.py:17(get)
       36    0.000    0.000    0.002    0.000 elements.py:2758(_copy_internals)
       68    0.001    0.000    0.002    0.000 selectable.py:3151(_columns_plus_names)
       60    0.000    0.000    0.002    0.000 unitofwork.py:417(execute)
       56    0.000    0.000    0.002    0.000 elements.py:1890(and_)
       18    0.000    0.000    0.002    0.000 relationships.py:1334(_optimized_compare)
       37    0.000    0.000    0.002    0.000 {operator.and_}
       84    0.001    0.000    0.002    0.000 factory.py:32(get)
       19    0.000    0.000    0.002    0.000 session.py:2646(__call__)
       19    0.000    0.000    0.002    0.000 base.py:2020(contextual_connect)
       56    0.001    0.000    0.002    0.000 elements.py:1856(_construct)
      166    0.001    0.000    0.002    0.000 _collections.py:794(to_list)
       19    0.000    0.000    0.002    0.000 base.py:793(close)
     2945    0.001    0.000    0.002    0.000 string.py:220(lower)
       30    0.000    0.000    0.002    0.000 compiler.py:1803(visit_join)
       18    0.000    0.000    0.002    0.000 visitors.py:280(cloned_traverse)
      720    0.002    0.000    0.002    0.000 {method 'match' of '_sre.SRE_Pattern' objects}
       19    0.000    0.000    0.002    0.000 pool.py:879(close)
      451    0.001    0.000    0.002    0.000 default.py:753(get_result_processor)
       68    0.001    0.000    0.002    0.000 query.py:122(_set_entity_selectables)
      234    0.001    0.000    0.002    0.000 base.py:36(_from_objects)
       68    0.000    0.000    0.002    0.000 compiler.py:438(_bind_processors)
       30    0.000    0.000    0.002    0.000 selectable.py:847(_joincond_scan_left_right)
       30    0.000    0.000    0.002    0.000 mapper.py:2451(_get_state_attr_by_column)
    54/18    0.001    0.000    0.002    0.000 visitors.py:287(clone)
       19    0.000    0.000    0.002    0.000 session.py:512(__init__)
       19    0.000    0.000    0.002    0.000 pool.py:756(_checkin)
       18    0.000    0.000    0.002    0.000 util.py:746(_orm_annotate)
       37    0.000    0.000    0.002    0.000 default_comparator.py:89(_conjunction_operate)
      135    0.001    0.000    0.002    0.000 elements.py:2724(__init__)
       18    0.000    0.000    0.002    0.000 annotation.py:106(_deep_annotate)
       19    0.000    0.000    0.002    0.000 pool.py:615(_finalize_fairy)
    54/18    0.000    0.000    0.002    0.000 annotation.py:113(clone)
       12    0.000    0.000    0.002    0.000 session.py:1559(add)
       68    0.000    0.000    0.002    0.000 result.py:911(_fetchall_impl)
       74    0.000    0.000    0.002    0.000 compiler.py:455(construct_params)
       68    0.000    0.000    0.002    0.000 query.py:3159(__new__)
      104    0.001    0.000    0.002    0.000 elements.py:3624(apply_map)
      204    0.001    0.000    0.002    0.000 _collections.py:747(unique_list)
       12    0.000    0.000    0.002    0.000 session.py:1588(_save_or_update_state)
     1463    0.001    0.000    0.002    0.000 inspect.py:51(ismodule)
       74    0.000    0.000    0.002    0.000 psycopg2.py:435(create_cursor)
      661    0.002    0.000    0.002    0.000 weakref.py:314(__getitem__)
      160    0.001    0.000    0.002    0.000 interfaces.py:507(create_row_processor)
       68    0.000    0.000    0.002    0.000 compiler.py:441(<genexpr>)
      106    0.000    0.000    0.002    0.000 base.py:285(__get__)
       68    0.001    0.000    0.001    0.000 {method 'fetchall' of 'psycopg2.extensions.cursor' objects}
       63    0.001    0.000    0.001    0.000 session.py:256(_take_snapshot)
      202    0.001    0.000    0.001    0.000 base.py:389(_inspect_mapped_class)
      172    0.000    0.000    0.001    0.000 compiler.py:442(<genexpr>)
       12    0.001    0.000    0.001    0.000 mapper.py:2555(cascade_iterator)
       54    0.000    0.000    0.001    0.000 elements.py:291(_annotate)
       19    0.000    0.000    0.001    0.000 db.py:69(_format_frame)
     1159    0.001    0.000    0.001    0.000 inspect.py:59(isclass)
       19    0.000    0.000    0.001    0.000 base.py:2071(_wrap_pool_connect)
      140    0.000    0.000    0.001    0.000 _collections.py:727(__missing__)
      451    0.001    0.000    0.001    0.000 type_api.py:382(_cached_result_processor)
       19    0.000    0.000    0.001    0.000 pool.py:367(connect)
       19    0.000    0.000    0.001    0.000 session.py:1031(close)
     1444    0.001    0.000    0.001    0.000 inspect.py:181(istraceback)
       68    0.000    0.000    0.001    0.000 _collections.py:359(__init__)
       19    0.000    0.000    0.001    0.000 pool.py:710(_checkout)
      589    0.001    0.000    0.001    0.000 {imp.get_suffixes}
       18    0.000    0.000    0.001    0.000 elements.py:1168(effective_value)
       19    0.000    0.000    0.001    0.000 session.py:1076(_close_impl)
       74    0.000    0.000    0.001    0.000 pool.py:845(cursor)
       18    0.000    0.000    0.001    0.000 relationships.py:1385(_go)
       68    0.000    0.000    0.001    0.000 base.py:325(_is_mapped_class)
     4130    0.001    0.000    0.001    0.000 {method 'append' of 'list' objects}
      106    0.000    0.000    0.001    0.000 base.py:108(_for_instance)
       19    0.000    0.000    0.001    0.000 pool.py:501(checkin)
      291    0.000    0.000    0.001    0.000 re.py:188(compile)
       54    0.000    0.000    0.001    0.000 elements.py:3919(__init__)
      172    0.001    0.000    0.001    0.000 abc.py:128(__instancecheck__)
       19    0.000    0.000    0.001    0.000 pool.py:478(checkout)
      104    0.000    0.000    0.001    0.000 type_api.py:372(_cached_bind_processor)
       92    0.000    0.000    0.001    0.000 elements.py:3513(__new__)
      161    0.000    0.000    0.001    0.000 operators.py:895(is_precedent)
     1159    0.001    0.000    0.001    0.000 inspect.py:67(ismethod)
     1468    0.001    0.000    0.001    0.000 {built-in method __new__ of type object at 0x919120}
      451    0.000    0.000    0.001    0.000 result.py:497(_getter)
       74    0.001    0.000    0.001    0.000 {method 'cursor' of 'psycopg2.extensions.connection' objects}
      124    0.000    0.000    0.001    0.000 elements.py:2783(self_group)
      106    0.000    0.000    0.001    0.000 base.py:105(_for_class)
      451    0.001    0.000    0.001    0.000 strategies.py:141(setup_query)
      209    0.001    0.000    0.001    0.000 {posix.getcwd}
      451    0.000    0.000    0.001    0.000 compiler.py:2722(format_label)
       19    0.000    0.000    0.001    0.000 pool.py:388(_return_conn)
       42    0.000    0.000    0.001    0.000 schema.py:1635(get_referent)
      104    0.001    0.000    0.001    0.000 compiler.py:1149(_process_anon)
     1159    0.001    0.000    0.001    0.000 inspect.py:142(isfunction)
       68    0.001    0.000    0.001    0.000 query.py:3190(setup_entity)
       67    0.000    0.000    0.001    0.000 instrumentation.py:311(new_instance)
      697    0.001    0.000    0.001    0.000 {method 'update' of 'dict' objects}
       12    0.000    0.000    0.001    0.000 strategies.py:448(_generate_lazy_clause)
       36    0.000    0.000    0.001    0.000 persistence.py:1017(_connections_for_states)
       68    0.001    0.000    0.001    0.000 query.py:3715(__init__)
       19    0.000    0.000    0.001    0.000 pool.py:1030(_do_return_conn)
     1444    0.001    0.000    0.001    0.000 inspect.py:191(isframe)
      695    0.001    0.000    0.001    0.000 {hasattr}
     1676    0.001    0.000    0.001    0.000 {method 'get' of 'dict' objects}
      128    0.000    0.000    0.001    0.000 selectable.py:35(_interpret_as_from)
       84    0.000    0.000    0.001    0.000 arrow.py:118(fromdatetime)
     4111    0.001    0.000    0.001    0.000 {len}
      291    0.001    0.000    0.001    0.000 re.py:226(_compile)
       42    0.001    0.000    0.001    0.000 selectable.py:450(corresponding_column)
       19    0.000    0.000    0.001    0.000 queue.py:87(put)
      214    0.000    0.000    0.001    0.000 base.py:208(manager_of_class)
      451    0.001    0.000    0.001    0.000 selectable.py:3156(name_for_col)
      183    0.000    0.000    0.001    0.000 query.py:416(_clone)
      209    0.001    0.000    0.001    0.000 posixpath.py:68(join)
       12    0.000    0.000    0.001    0.000 strategy_options.py:781(lazyload)
      211    0.000    0.000    0.001    0.000 __init__.py:1345(isEnabledFor)
       12    0.000    0.000    0.001    0.000 <string>:1(set_relationship_strategy)
      190    0.000    0.000    0.001    0.000 default.py:592(<genexpr>)
       18    0.000    0.000    0.001    0.000 elements.py:1183(_clone)
     1159    0.001    0.000    0.001    0.000 inspect.py:209(iscode)
       25    0.000    0.000    0.001    0.000 session.py:358(_prepare_impl)
       12    0.000    0.000    0.001    0.000 base.py:40(_generative)
       80    0.000    0.000    0.001    0.000 path_registry.py:62(set)
       24    0.000    0.000    0.001    0.000 persistence.py:256(_organize_states_for_save)
      126    0.001    0.000    0.001    0.000 {sorted}
       19    0.000    0.000    0.001    0.000 base.py:47(__init__)
      451    0.001    0.000    0.001    0.000 compiler.py:271(__init__)
       19    0.000    0.000    0.001    0.000 pool.py:1039(_do_get)
       87    0.000    0.000    0.001    0.000 langhelpers.py:1033(_next)
      161    0.000    0.000    0.001    0.000 utf_8.py:15(decode)
      106    0.000    0.000    0.001    0.000 base.py:74(__init__)
       12    0.000    0.000    0.001    0.000 unitofwork.py:557(execute)
       36    0.000    0.000    0.001    0.000 elements.py:235(_clone)
     2945    0.001    0.000    0.001    0.000 {method 'lower' of 'str' objects}
      451    0.000    0.000    0.001    0.000 compiler.py:1272(_add_to_result_map)
      416    0.001    0.000    0.001    0.000 attr.py:226(__bool__)
       24    0.000    0.000    0.001    0.000 unitofwork.py:228(register_object)
       19    0.000    0.000    0.001    0.000 <string>:1(and_)
      451    0.001    0.000    0.001    0.000 result.py:419(_getter)
       12    0.000    0.000    0.001    0.000 persistence.py:223(delete_obj)
       18    0.000    0.000    0.001    0.000 dependency.py:445(presort_saves)
      156    0.000    0.000    0.001    0.000 session.py:2016(_is_clean)
       12    0.000    0.000    0.001    0.000 strategy_options.py:190(set_relationship_strategy)
       48    0.000    0.000    0.001    0.000 relationships.py:1504(cascade_iterator)
       68    0.000    0.000    0.001    0.000 elements.py:3665(_select_iterables)
      181    0.000    0.000    0.001    0.000 base.py:89(__getattr__)
      136    0.000    0.000    0.001    0.000 selectable.py:2438(<genexpr>)
       19    0.000    0.000    0.001    0.000 queue.py:130(get)
       68    0.000    0.000    0.001    0.000 query.py:306(_bind_mapper)
       84    0.000    0.000    0.001    0.000 unitofwork.py:178(get_attribute_history)
      549    0.001    0.000    0.001    0.000 {method 'copy' of 'dict' objects}
       37    0.000    0.000    0.001    0.000 elements.py:1821(_from_objects)
       68    0.000    0.000    0.001    0.000 session.py:1279(_autoflush)
      285    0.000    0.000    0.001    0.000 <string>:8(__new__)
       68    0.000    0.000    0.001    0.000 query.py:3107(_adjust_for_single_inheritance)
        6    0.000    0.000    0.001    0.000 attributes.py:1066(set_committed_value)
      198    0.000    0.000    0.000    0.000 elements.py:3765(_expression_literal_as_text)
       99    0.000    0.000    0.000    0.000 __init__.py:1130(debug)
      228    0.000    0.000    0.000    0.000 weakref.py:282(__init__)
        6    0.000    0.000    0.000    0.000 unitofwork.py:375(finalize_flush_changes)
      104    0.000    0.000    0.000    0.000 compiler.py:1155(bindparam_string)
       84    0.000    0.000    0.000    0.000 util.py:25(is_timestamp)
       18    0.000    0.000    0.000    0.000 persistence.py:416(_collect_update_commands)
       19    0.000    0.000    0.000    0.000 pool.py:764(_reset)
       12    0.000    0.000    0.000    0.000 unitofwork.py:257(_per_mapper_flush_actions)
       96    0.000    0.000    0.000    0.000 arrow.py:49(__init__)
      451    0.000    0.000    0.000    0.000 compiler.py:280(type)
       92    0.000    0.000    0.000    0.000 elements.py:3469(__new__)
       24    0.000    0.000    0.000    0.000 persistence.py:1052(_sort_states)
       37    0.000    0.000    0.000    0.000 elements.py:1967(self_group)
      836    0.000    0.000    0.000    0.000 {method 'startswith' of 'str' objects}
        6    0.000    0.000    0.000    0.000 session.py:1491(_register_newly_persistent)
      523    0.000    0.000    0.000    0.000 elements.py:3292(_get_table)
      156    0.000    0.000    0.000    0.000 unitofwork.py:402(<genexpr>)
       74    0.000    0.000    0.000    0.000 {method 'encode' of 'unicode' objects}
        6    0.000    0.000    0.000    0.000 topological.py:55(find_cycles)
      161    0.000    0.000    0.000    0.000 {_codecs.utf_8_decode}
       38    0.000    0.000    0.000    0.000 threading.py:146(acquire)
       54    0.000    0.000    0.000    0.000 annotation.py:45(__init__)
      214    0.000    0.000    0.000    0.000 {method 'get' of 'dictproxy' objects}
       12    0.000    0.000    0.000    0.000 query.py:1090(options)
      270    0.000    0.000    0.000    0.000 elements.py:698(self_group)
       12    0.000    0.000    0.000    0.000 dependency.py:68(per_property_flush_actions)
       24    0.000    0.000    0.000    0.000 unitofwork.py:482(execute)
       66    0.000    0.000    0.000    0.000 state.py:251(_cleanup)
       74    0.000    0.000    0.000    0.000 result.py:637(_soft_close)
      451    0.000    0.000    0.000    0.000 elements.py:3839(_interpret_as_column_or_from)
       36    0.000    0.000    0.000    0.000 attributes.py:222(__set__)
      209    0.000    0.000    0.000    0.000 posixpath.py:59(isabs)
       12    0.000    0.000    0.000    0.000 <string>:1(_options)
       99    0.000    0.000    0.000    0.000 compiler.py:1788(visit_table)
      126    0.000    0.000    0.000    0.000 langhelpers.py:750(_reset)
       92    0.000    0.000    0.000    0.000 session.py:1142(get_bind)
       67    0.000    0.000    0.000    0.000 state.py:75(__init__)
      266    0.000    0.000    0.000    0.000 elements.py:3769(_literal_as_text)
        6    0.000    0.000    0.000    0.000 pricelist.py:51(_get_data)
      135    0.000    0.000    0.000    0.000 elements.py:2754(_from_objects)
      178    0.000    0.000    0.000    0.000 _weakrefset.py:70(__contains__)
       12    0.000    0.000    0.000    0.000 persistence.py:336(_organize_states_for_delete)
       12    0.000    0.000    0.000    0.000 strategy_options.py:110(_generate_path)
      727    0.000    0.000    0.000    0.000 {method 'intersection' of 'set' objects}
       19    0.000    0.000    0.000    0.000 base.py:534(begin)
     1368    0.000    0.000    0.000    0.000 {method 'add' of 'set' objects}
       37    0.000    0.000    0.000    0.000 elements.py:1825(self_group)
        6    0.000    0.000    0.000    0.000 type_api.py:961(process)
        6    0.000    0.000    0.000    0.000 arrow.py:68(process_bind_param)
      211    0.000    0.000    0.000    0.000 __init__.py:1331(getEffectiveLevel)
       60    0.000    0.000    0.000    0.000 dependency.py:230(prop_has_changes)
      183    0.000    0.000    0.000    0.000 elements.py:3657(_expand_cloned)
       12    0.000    0.000    0.000    0.000 mapper.py:1774(_is_orphan)
       24    0.000    0.000    0.000    0.000 session.py:229(connection)
       19    0.000    0.000    0.000    0.000 session.py:1082(expunge_all)
      209    0.000    0.000    0.000    0.000 {method 'split' of 'str' objects}
       54    0.000    0.000    0.000    0.000 topological.py:43(sort)
       78    0.000    0.000    0.000    0.000 unitofwork.py:399(_mappers)
       99    0.000    0.000    0.000    0.000 attr.py:214(__call__)
       19    0.000    0.000    0.000    0.000 base.py:1595(__init__)
      570    0.000    0.000    0.000    0.000 {max}
       24    0.000    0.000    0.000    0.000 dependency.py:581(_pks_changed)
      104    0.000    0.000    0.000    0.000 {method 'split' of 'unicode' objects}
       12    0.000    0.000    0.000    0.000 query.py:1105(_options)
       36    0.000    0.000    0.000    0.000 attributes.py:687(set)
       74    0.000    0.000    0.000    0.000 type_api.py:424(coerce_compared_value)
       30    0.000    0.000    0.000    0.000 query.py:1983(_prepare_right_side)
        6    0.000    0.000    0.000    0.000 pricelist.py:61(_get_prices)
       30    0.000    0.000    0.000    0.000 selectable.py:1057(_hide_froms)
       74    0.000    0.000    0.000    0.000 default.py:692(should_autocommit)
       36    0.000    0.000    0.000    0.000 topological.py:16(sort_as_subsets)
      196    0.000    0.000    0.000    0.000 session.py:190(_assert_active)
      160    0.000    0.000    0.000    0.000 strategies.py:615(create_row_processor)
       68    0.000    0.000    0.000    0.000 query.py:2638(_select_args)
       19    0.000    0.000    0.000    0.000 weakref.py:98(__setitem__)
       38    0.000    0.000    0.000    0.000 threading.py:372(notify)
       24    0.000    0.000    0.000    0.000 sync.py:106(source_modified)
      156    0.000    0.000    0.000    0.000 identity.py:53(check_modified)
      126    0.000    0.000    0.000    0.000 langhelpers.py:753(reset)
      135    0.000    0.000    0.000    0.000 type_api.py:1137(to_instance)
      285    0.000    0.000    0.000    0.000 linecache.py:33(getlines)
       68    0.000    0.000    0.000    0.000 result.py:928(process_rows)
        6    0.000    0.000    0.000    0.000 attributes.py:976(_initialize_collection)
       19    0.000    0.000    0.000    0.000 base.py:359(_entity_descriptor)
       74    0.000    0.000    0.000    0.000 {sqlalchemy.cutils._distill_params}
       30    0.000    0.000    0.000    0.000 selectable.py:1062(_from_objects)
       37    0.000    0.000    0.000    0.000 elements.py:716(comparator)
       19    0.000    0.000    0.000    0.000 default.py:419(do_rollback)
       68    0.000    0.000    0.000    0.000 query.py:3180(__init__)
        6    0.000    0.000    0.000    0.000 default.py:807(_setup_crud_result_proxy)
      673    0.000    0.000    0.000    0.000 {method 'update' of 'set' objects}
       87    0.000    0.000    0.000    0.000 query.py:289(_mapper_zero)
       38    0.000    0.000    0.000    0.000 threading.py:186(release)
       90    0.000    0.000    0.000    0.000 state.py:277(dict)
       36    0.000    0.000    0.000    0.000 unitofwork.py:503(_elements)
      105    0.000    0.000    0.000    0.000 query.py:228(_adapt_clause)
      136    0.000    0.000    0.000    0.000 query.py:3262(_get_entity_clauses)
       19    0.000    0.000    0.000    0.000 base.py:642(_begin_impl)
      125    0.000    0.000    0.000    0.000 {method 'acquire' of 'thread.lock' objects}
       30    0.000    0.000    0.000    0.000 elements.py:2742(__bool__)
       68    0.000    0.000    0.000    0.000 path_registry.py:70(get)
      204    0.000    0.000    0.000    0.000 _collections.py:688(<genexpr>)
       54    0.000    0.000    0.000    0.000 annotation.py:31(__new__)
       68    0.000    0.000    0.000    0.000 selectable.py:1695(__init__)
        6    0.000    0.000    0.000    0.000 persistence.py:1047(<lambda>)
        6    0.000    0.000    0.000    0.000 arrow.py:425(to)
       12    0.000    0.000    0.000    0.000 state.py:565(_commit)
       24    0.000    0.000    0.000    0.000 _collections.py:315(values)
       56    0.000    0.000    0.000    0.000 _collections.py:787(coerce_generator_arg)
        6    0.000    0.000    0.000    0.000 dependency.py:541(process_saves)
       79    0.000    0.000    0.000    0.000 {method 'issuperset' of 'frozenset' objects}
        6    0.000    0.000    0.000    0.000 state.py:611(_commit_all_states)
       30    0.000    0.000    0.000    0.000 controller.py:57(_get_ident)
       96    0.000    0.000    0.000    0.000 util.py:37(isstr)
       12    0.000    0.000    0.000    0.000 <string>:1(params)
      290    0.000    0.000    0.000    0.000 {method 'values' of 'dict' objects}
      202    0.000    0.000    0.000    0.000 instrumentation.py:94(is_mapped)
        6    0.000    0.000    0.000    0.000 aggregates.py:535(construct_aggregate_queries)
       18    0.000    0.000    0.000    0.000 relationships.py:1363(visit_bindparam)
      233    0.000    0.000    0.000    0.000 {method 'endswith' of 'str' objects}
       74    0.000    0.000    0.000    0.000 base.py:1220(_safe_close_cursor)
       42    0.000    0.000    0.000    0.000 session.py:1967(_contains_state)
       61    0.000    0.000    0.000    0.000 identity.py:190(_fast_discard)
       38    0.000    0.000    0.000    0.000 pool.py:854(__getattr__)
       12    0.000    0.000    0.000    0.000 instrumentation.py:354(has_parent)
        6    0.000    0.000    0.000    0.000 base.py:149(execution_options)
       36    0.000    0.000    0.000    0.000 unitofwork.py:293(states_for_mapper_hierarchy)
       80    0.000    0.000    0.000    0.000 _collections.py:155(union)
      135    0.000    0.000    0.000    0.000 query.py:389(_no_limit_offset)
       19    0.000    0.000    0.000    0.000 base.py:116(_join)
       96    0.000    0.000    0.000    0.000 unitofwork.py:454(__new__)
        6    0.000    0.000    0.000    0.000 type_api.py:1057(compare_values)
        6    0.000    0.000    0.000    0.000 vendors.py:408(__repr__)
      460    0.000    0.000    0.000    0.000 mapper.py:642(mapper)
       74    0.000    0.000    0.000    0.000 _collections.py:394(__iter__)
       25    0.000    0.000    0.000    0.000 {method 'format' of 'str' objects}
       12    0.000    0.000    0.000    0.000 <string>:1(_adapt_all_clauses)
        6    0.000    0.000    0.000    0.000 instrumentation.py:290(initialize_collection)
       30    0.000    0.000    0.000    0.000 dependency.py:59(per_property_preprocessors)
      135    0.000    0.000    0.000    0.000 query.py:381(_no_statement_condition)
       36    0.000    0.000    0.000    0.000 type_api.py:276(compare_values)
       68    0.000    0.000    0.000    0.000 {zip}
       36    0.000    0.000    0.000    0.000 state.py:524(_modified_event)
       12    0.000    0.000    0.000    0.000 path_registry.py:250(entity_path)
      289    0.000    0.000    0.000    0.000 {method 'pop' of 'dict' objects}
       30    0.000    0.000    0.000    0.000 query.py:3245(corresponds_to)
       12    0.000    0.000    0.000    0.000 attributes.py:900(get_all_pending)
      102    0.000    0.000    0.000    0.000 _collections.py:687(__iter__)
       19    0.000    0.000    0.000    0.000 contextlib.py:82(helper)
       38    0.000    0.000    0.000    0.000 identity.py:14(__init__)
      170    0.000    0.000    0.000    0.000 {method 'pop' of 'list' objects}
      248    0.000    0.000    0.000    0.000 mapper.py:1965(selectable)
       12    0.000    0.000    0.000    0.000 persistence.py:918(_finalize_insert_update_commands)
      132    0.000    0.000    0.000    0.000 annotation.py:90(__hash__)
       67    0.000    0.000    0.000    0.000 identity.py:140(_add_unpresent)
       19    0.000    0.000    0.000    0.000 query.py:300(_joinpoint_zero)
       12    0.000    0.000    0.000    0.000 strategy_options.py:216(_set_path_strategy)
      116    0.000    0.000    0.000    0.000 {_codecs.utf_8_encode}
       19    0.000    0.000    0.000    0.000 session.py:297(_remove_snapshot)
        6    0.000    0.000    0.000    0.000 dependency.py:495(process_deletes)
       19    0.000    0.000    0.000    0.000 log.py:54(_should_log_debug)
        6    0.000    0.000    0.000    0.000 session.py:234(_begin)
        6    0.000    0.000    0.000    0.000 api.py:25(utcnow)
      181    0.000    0.000    0.000    0.000 {setattr}
        6    0.000    0.000    0.000    0.000 arrow.py:78(_coerce)
       12    0.000    0.000    0.000    0.000 strategy_options.py:94(process_query)
      285    0.000    0.000    0.000    0.000 {min}
       24    0.000    0.000    0.000    0.000 attributes.py:740(get_history)
       74    0.000    0.000    0.000    0.000 result.py:632(_cursor_description)
        6    0.000    0.000    0.000    0.000 factory.py:206(utcnow)
       70    0.000    0.000    0.000    0.000 {method 'remove' of 'list' objects}
       12    0.000    0.000    0.000    0.000 mapper.py:2397(_identity_key_from_state)
       12    0.000    0.000    0.000    0.000 attributes.py:675(get_history)
      126    0.000    0.000    0.000    0.000 {method 'difference' of 'set' objects}
      451    0.000    0.000    0.000    0.000 elements.py:3521(apply_map)
        6    0.000    0.000    0.000    0.000 dependency.py:745(process_saves)
       68    0.000    0.000    0.000    0.000 mapper.py:1890(_with_polymorphic_mappers)
        6    0.000    0.000    0.000    0.000 arrow.py:700(__eq__)
       12    0.000    0.000    0.000    0.000 attributes.py:474(hasparent)
       12    0.000    0.000    0.000    0.000 strategy_options.py:86(_generate)
       36    0.000    0.000    0.000    0.000 attributes.py:752(get_all_pending)
       19    0.000    0.000    0.000    0.000 log.py:57(_should_log_info)
       30    0.000    0.000    0.000    0.000 unitofwork.py:223(register_preprocessor)
       12    0.000    0.000    0.000    0.000 path_registry.py:254(__getitem__)
        6    0.000    0.000    0.000    0.000 arrow.py:76(utcnow)
       19    0.000    0.000    0.000    0.000 pool.py:559(get_connection)
       12    0.000    0.000    0.000    0.000 session.py:1842(_save_or_update_impl)
       19    0.000    0.000    0.000    0.000 {range}
       12    0.000    0.000    0.000    0.000 strategy_options.py:100(_process)
      400    0.000    0.000    0.000    0.000 {id}
       54    0.000    0.000    0.000    0.000 identity.py:106(contains_state)
       12    0.000    0.000    0.000    0.000 <string>:1(_with_invoke_all_eagers)
       12    0.000    0.000    0.000    0.000 dependency.py:708(presort_saves)
      451    0.000    0.000    0.000    0.000 elements.py:758(_select_iterable)
       67    0.000    0.000    0.000    0.000 identity.py:145(get)
       30    0.000    0.000    0.000    0.000 elements.py:269(_cloned_set)
       30    0.000    0.000    0.000    0.000 selectable.py:874(<lambda>)
        6    0.000    0.000    0.000    0.000 attributes.py:629(set_committed_value)
       12    0.000    0.000    0.000    0.000 _collections.py:183(__iter__)
       67    0.000    0.000    0.000    0.000 <string>:1(set)
       12    0.000    0.000    0.000    0.000 persistence.py:720(_emit_insert_statements)
      114    0.000    0.000    0.000    0.000 {hash}
       87    0.000    0.000    0.000    0.000 {next}
      194    0.000    0.000    0.000    0.000 {iter}
       19    0.000    0.000    0.000    0.000 weakref.py:267(__init__)
      204    0.000    0.000    0.000    0.000 _collections.py:689(<genexpr>)
      159    0.000    0.000    0.000    0.000 selectable.py:1418(_from_objects)
        6    0.000    0.000    0.000    0.000 session.py:1959(__iter__)
       25    0.000    0.000    0.000    0.000 identity.py:184(all_states)
       82    0.000    0.000    0.000    0.000 session.py:225(_is_transaction_boundary)
      114    0.000    0.000    0.000    0.000 threading.py:63(_note)
       12    0.000    0.000    0.000    0.000 strategy_options.py:185(_coerce_strat)
       42    0.000    0.000    0.000    0.000 base.py:590(contains_column)
       12    0.000    0.000    0.000    0.000 attributes.py:1303(from_scalar_attribute)
       12    0.000    0.000    0.000    0.000 _collections.py:805(has_intersection)
      114    0.000    0.000    0.000    0.000 base.py:301(connection)
        6    0.000    0.000    0.000    0.000 collections.py:659(append_multiple_without_event)
       12    0.000    0.000    0.000    0.000 query.py:1254(params)
       68    0.000    0.000    0.000    0.000 base.py:1472(get_select_precolumns)
       98    0.000    0.000    0.000    0.000 _collections.py:724(__init__)
       12    0.000    0.000    0.000    0.000 pricelist.py:257(_pl_get_vpart_dict)
       48    0.000    0.000    0.000    0.000 relationships.py:1731(_get_cascade)
      125    0.000    0.000    0.000    0.000 {method 'release' of 'thread.lock' objects}
       18    0.000    0.000    0.000    0.000 instrumentation.py:302(get_impl)
       12    0.000    0.000    0.000    0.000 persistence.py:835(_emit_delete_statements)
       24    0.000    0.000    0.000    0.000 _collections.py:846(flatten_iterator)
       24    0.000    0.000    0.000    0.000 interfaces.py:486(_get_strategy)
       30    0.000    0.000    0.000    0.000 unitofwork.py:282(<lambda>)
       37    0.000    0.000    0.000    0.000 type_api.py:53(__init__)
       12    0.000    0.000    0.000    0.000 session.py:37(_state_session)
       24    0.000    0.000    0.000    0.000 persistence.py:1044(_cached_connection_dict)
       12    0.000    0.000    0.000    0.000 session.py:1818(_update_impl)
       24    0.000    0.000    0.000    0.000 unitofwork.py:475(__init__)
        6    0.000    0.000    0.000    0.000 persistence.py:959(_postfetch)
       19    0.000    0.000    0.000    0.000 weakref.py:262(__new__)
       86    0.000    0.000    0.000    0.000 {method 'keys' of 'dict' objects}
       19    0.000    0.000    0.000    0.000 queue.py:194(_put)
       38    0.000    0.000    0.000    0.000 threading.py:237(_is_owned)
        6    0.000    0.000    0.000    0.000 session.py:1542(_register_altered)
        6    0.000    0.000    0.000    0.000 {method 'astimezone' of 'datetime.datetime' objects}
       76    0.000    0.000    0.000    0.000 langhelpers.py:825(<lambda>)
       78    0.000    0.000    0.000    0.000 {method 'difference_update' of 'set' objects}
       12    0.000    0.000    0.000    0.000 base.py:314(_generate)
       74    0.000    0.000    0.000    0.000 compiler.py:215(__str__)
       30    0.000    0.000    0.000    0.000 query.py:2112(_reset_joinpoint)
       96    0.000    0.000    0.000    0.000 attributes.py:1251(__bool__)
      114    0.000    0.000    0.000    0.000 {thread.get_ident}
       12    0.000    0.000    0.000    0.000 _collections.py:144(__new__)
       36    0.000    0.000    0.000    0.000 mapper.py:2652(_memo)
       12    0.000    0.000    0.000    0.000 strategy_options.py:80(__init__)
      209    0.000    0.000    0.000    0.000 posixpath.py:51(normcase)
       56    0.000    0.000    0.000    0.000 {method 'items' of 'dict' objects}
       19    0.000    0.000    0.000    0.000 queue.py:190(_full)
        6    0.000    0.000    0.000    0.000 unitofwork.py:109(__init__)
       87    0.000    0.000    0.000    0.000 query.py:286(_entity_zero)
       12    0.000    0.000    0.000    0.000 path_registry.py:267(__init__)
       19    0.000    0.000    0.000    0.000 queue.py:198(_get)
      135    0.000    0.000    0.000    0.000 {callable}
       12    0.000    0.000    0.000    0.000 path_registry.py:283(__getitem__)
      160    0.000    0.000    0.000    0.000 interfaces.py:617(setup_query)
        6    0.000    0.000    0.000    0.000 attributes.py:1290(as_state)
       74    0.000    0.000    0.000    0.000 default.py:750(post_exec)
       19    0.000    0.000    0.000    0.000 session.py:239(_iterate_parents)
        6    0.000    0.000    0.000    0.000 vendors.py:205(__init__)
       74    0.000    0.000    0.000    0.000 {method 'union' of 'set' objects}
       98    0.000    0.000    0.000    0.000 selectable.py:170(selectable)
       80    0.000    0.000    0.000    0.000 query.py:3746(<genexpr>)
        6    0.000    0.000    0.000    0.000 collections.py:687(__iter__)
        6    0.000    0.000    0.000    0.000 base.py:135(_clone)
       12    0.000    0.000    0.000    0.000 _collections.py:312(keys)
       19    0.000    0.000    0.000    0.000 base.py:255(__init__)
        6    0.000    0.000    0.000    0.000 identity.py:163(values)
      114    0.000    0.000    0.000    0.000 {method 'isdisjoint' of 'set' objects}
        6    0.000    0.000    0.000    0.000 arrow.py:335(naive)
       18    0.000    0.000    0.000    0.000 session.py:1533(<genexpr>)
       74    0.000    0.000    0.000    0.000 default.py:747(pre_exec)
       17    0.000    0.000    0.000    0.000 weakref.py:48(remove)
        6    0.000    0.000    0.000    0.000 _collections.py:879(get)
       12    0.000    0.000    0.000    0.000 arrow.py:844(_get_datetime)
       30    0.000    0.000    0.000    0.000 unitofwork.py:411(__init__)
       19    0.000    0.000    0.000    0.000 {method 'rollback' of 'psycopg2.extensions.connection' objects}
       12    0.000    0.000    0.000    0.000 weakref.py:284(remove)
       19    0.000    0.000    0.000    0.000 base.py:1532(__init__)
       18    0.000    0.000    0.000    0.000 dependency.py:797(per_property_preprocessors)
        6    0.000    0.000    0.000    0.000 attributes.py:1330(from_object_attribute)
        6    0.000    0.000    0.000    0.000 collections.py:1071(append)
       12    0.000    0.000    0.000    0.000 selectable.py:857(<lambda>)
       74    0.000    0.000    0.000    0.000 {method 'close' of 'psycopg2.extensions.cursor' objects}
       19    0.000    0.000    0.000    0.000 pool.py:677(__init__)
       48    0.000    0.000    0.000    0.000 mapper.py:2340(primary_base_mapper)
        6    0.000    0.000    0.000    0.000 pricelist.py:244(get_vpdict)
        6    0.000    0.000    0.000    0.000 {built-in method utcnow}
        6    0.000    0.000    0.000    0.000 collections.py:578(__init__)
       12    0.000    0.000    0.000    0.000 _collections.py:318(items)
       24    0.000    0.000    0.000    0.000 unitofwork.py:164(memo)
      139    0.000    0.000    0.000    0.000 {method 'popleft' of 'collections.deque' objects}
       76    0.000    0.000    0.000    0.000 {method 'setdefault' of 'dict' objects}
        6    0.000    0.000    0.000    0.000 dependency.py:594(per_property_dependencies)
       18    0.000    0.000    0.000    0.000 interfaces.py:362(adapter)
       24    0.000    0.000    0.000    0.000 {method 'intersection' of 'frozenset' objects}
       31    0.000    0.000    0.000    0.000 {method 'discard' of 'set' objects}
       24    0.000    0.000    0.000    0.000 identity.py:72(__len__)
       19    0.000    0.000    0.000    0.000 base.py:1537(_parent)
       78    0.000    0.000    0.000    0.000 {method 'strip' of 'str' objects}
       72    0.000    0.000    0.000    0.000 elements.py:378(_copy_internals)
        6    0.000    0.000    0.000    0.000 parser.py:281(parse)
        6    0.000    0.000    0.000    0.000 dependency.py:324(per_property_dependencies)
       19    0.000    0.000    0.000    0.000 contextlib.py:12(__init__)
       36    0.000    0.000    0.000    0.000 unitofwork.py:524(__init__)
        6    0.000    0.000    0.000    0.000 {method 'replace' of 'datetime.datetime' objects}
        6    0.000    0.000    0.000    0.000 result.py:536(rowcount)
       30    0.000    0.000    0.000    0.000 mapper.py:2278(common_parent)
       30    0.000    0.000    0.000    0.000 query.py:3241(entity_zero_or_selectable)
       19    0.000    0.000    0.000    0.000 {sys._getframe}
        6    0.000    0.000    0.000    0.000 currency.py:219(__init__)
       18    0.000    0.000    0.000    0.000 relationships.py:1384(_get_attr_w_warn_on_none)
        6    0.000    0.000    0.000    0.000 six.py:552(iteritems)
        6    0.000    0.000    0.000    0.000 unitofwork.py:271(_mapper_for_dep)
       12    0.000    0.000    0.000    0.000 path_registry.py:77(__len__)
       24    0.000    0.000    0.000    0.000 mapper.py:2299(iterate_to_root)
       12    0.000    0.000    0.000    0.000 weakref.py:69(__getitem__)
       12    0.000    0.000    0.000    0.000 query.py:224(_adapt_all_clauses)
       12    0.000    0.000    0.000    0.000 weakref.py:320(__setitem__)
        6    0.000    0.000    0.000    0.000 attributes.py:893(get_history)
       12    0.000    0.000    0.000    0.000 _collections.py:309(__iter__)
       36    0.000    0.000    0.000    0.000 unitofwork.py:553(__init__)
       12    0.000    0.000    0.000    0.000 state.py:234(has_identity)
       19    0.000    0.000    0.000    0.000 queue.py:186(_empty)
        6    0.000    0.000    0.000    0.000 persistence.py:632(<lambda>)
       30    0.000    0.000    0.000    0.000 elements.py:405(self_group)
       36    0.000    0.000    0.000    0.000 persistence.py:1054(<genexpr>)
       12    0.000    0.000    0.000    0.000 identity.py:109(replace)
        6    0.000    0.000    0.000    0.000 session.py:2506(_dirty_states)
       19    0.000    0.000    0.000    0.000 interfaces.py:120(create_row_processor)
        6    0.000    0.000    0.000    0.000 attributes.py:1255(empty)
        6    0.000    0.000    0.000    0.000 currency.py:248(source_value)
       12    0.000    0.000    0.000    0.000 {method 'clear' of 'dict' objects}
       12    0.000    0.000    0.000    0.000 query.py:906(_with_invoke_all_eagers)
        6    0.000    0.000    0.000    0.000 vendors.py:332(vqtyavail)
       19    0.000    0.000    0.000    0.000 interfaces.py:111(setup)
       12    0.000    0.000    0.000    0.000 persistence.py:1057(<lambda>)
        6    0.000    0.000    0.000    0.000 unitofwork.py:154(has_work)
       24    0.000    0.000    0.000    0.000 persistence.py:184(<genexpr>)
       66    0.000    0.000    0.000    0.000 {method 'remove' of 'set' objects}
       18    0.000    0.000    0.000    0.000 base.py:32(_clone)
       12    0.000    0.000    0.000    0.000 {method 'iteritems' of 'dict' objects}
       19    0.000    0.000    0.000    0.000 default.py:416(do_begin)
        6    0.000    0.000    0.000    0.000 vendors.py:321(add_price)
       12    0.000    0.000    0.000    0.000 persistence.py:568(_collect_delete_commands)
        6    0.000    0.000    0.000    0.000 _collections.py:875(_inc_counter)
       12    0.000    0.000    0.000    0.000 persistence.py:362(_collect_insert_commands)
        6    0.000    0.000    0.000    0.000 vendors.py:368(pkgqty)
        6    0.000    0.000    0.000    0.000 base.py:121(_root)
        6    0.000    0.000    0.000    0.000 default.py:797(rowcount)
       12    0.000    0.000    0.000    0.000 _collections.py:149(__init__)
        6    0.000    0.000    0.000    0.000 collections.py:1038(__set)
        6    0.000    0.000    0.000    0.000 unitofwork.py:388(<genexpr>)
        6    0.000    0.000    0.000    0.000 vendors.py:324(vpno)
       24    0.000    0.000    0.000    0.000 tz.py:47(utcoffset)
        6    0.000    0.000    0.000    0.000 vendors.py:488(currency)
        6    0.000    0.000    0.000    0.000 vendors.py:386(prices)
       19    0.000    0.000    0.000    0.000 {method 'append' of 'collections.deque' objects}
        6    0.000    0.000    0.000    0.000 vendors.py:372(pkgqty)
        6    0.000    0.000    0.000    0.000 vendors.py:356(vpartdesc)
        6    0.000    0.000    0.000    0.000 arrow.py:329(datetime)
        6    0.000    0.000    0.000    0.000 vendors.py:340(manufacturer)
        6    0.000    0.000    0.000    0.000 vendors.py:210(moq)
       12    0.000    0.000    0.000    0.000 {method 'pop' of 'collections.deque' objects}
        6    0.000    0.000    0.000    0.000 default.py:401(set_connection_execution_options)
       12    0.000    0.000    0.000    0.000 tz.py:50(dst)
        6    0.000    0.000    0.000    0.000 vendors.py:348(mpartno)
        6    0.000    0.000    0.000    0.000 state.py:244(_detach)
       12    0.000    0.000    0.000    0.000 state.py:221(parents)
        6    0.000    0.000    0.000    0.000 dependency.py:727(process_deletes)
        6    0.000    0.000    0.000    0.000 state.py:225(_pending_mutations)
        6    0.000    0.000    0.000    0.000 vendors.py:214(oqmultiple)
        6    0.000    0.000    0.000    0.000 identity.py:50(_dirty_states)
        1    0.000    0.000    0.000    0.000 attributes.py:145(__clause_element__)
       12    0.000    0.000    0.000    0.000 persistence.py:180(<genexpr>)
        1    0.000    0.000    0.000    0.000 {method 'disable' of '_lsprof.Profiler' objects}
        6    0.000    0.000    0.000    0.000 vendors.py:218(unit_price)