Pricelist Vendor Get Part (DB) ProfilingΒΆ
Raw execution profile
SVG of execution profile
Execution Profile
pstats Output
Tue May 24 00:38:25 2016 /media/ldata/code/tendril/profiling/sourcing/get_part_db/iedel.profile 102389 function calls (100300 primitive calls) in 0.347 seconds Ordered by: cumulative time ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.347 0.347 vendors.py:74(profile_vendor_get_part_db) 7 0.000 0.000 0.347 0.050 vendors.py:509(get_all_vparts) 68 0.000 0.000 0.227 0.003 query.py:2511(__iter__) 129/19 0.001 0.000 0.211 0.011 db.py:168(inner) 68 0.001 0.000 0.208 0.003 query.py:2525(_execute_and_instances) 68 0.000 0.000 0.202 0.003 base.py:846(execute) 68 0.000 0.000 0.202 0.003 elements.py:322(_execute_on_connection) 68 0.001 0.000 0.202 0.003 base.py:975(_execute_clauseelement) 6 0.000 0.000 0.184 0.031 pricelist.py:247(get_vpart) 6 0.000 0.000 0.183 0.031 pricelist.py:45(__init__) 6 0.000 0.000 0.183 0.031 vendors.py:236(__init__) 6 0.000 0.000 0.183 0.031 vendors.py:248(_populate) 6 0.000 0.000 0.168 0.028 vendors.py:285(load_from_db) 6 0.000 0.000 0.168 0.028 vendors.py:292(_load_from_db) 7 0.000 0.000 0.163 0.023 vendors.py:504(get_all_vpnos) 68 0.001 0.000 0.154 0.002 base.py:1061(_execute_context) 6 0.000 0.000 0.152 0.025 maps.py:73(get_all_partnos) 25 0.001 0.000 0.147 0.006 query.py:2393(all) 68 0.000 0.000 0.135 0.002 default.py:449(do_execute) 68 0.134 0.002 0.135 0.002 {method 'execute' of 'psycopg2.extensions.cursor' objects} 227/215 0.000 0.000 0.120 0.001 attributes.py:229(__get__) 42/30 0.000 0.000 0.119 0.004 attributes.py:556(get) 12 0.000 0.000 0.118 0.010 strategies.py:477(_load_for_state) 12 0.000 0.000 0.118 0.010 strategies.py:550(_emit_lazyload) 12 0.000 0.000 0.111 0.009 controller.py:244(get_map_vpnos) 43 0.001 0.000 0.101 0.002 query.py:2451(one) 6 0.000 0.000 0.083 0.014 vendors.py:88(get_upartnos) 18 0.000 0.000 0.072 0.004 controller.py:215(get_map) 6 0.000 0.000 0.069 0.012 vendors.py:84(get_apartnos) 6 0.000 0.000 0.063 0.010 controller.py:263(get_umap_vpnos) 38 0.000 0.000 0.059 0.002 db.py:111(get_session) 31 0.000 0.000 0.057 0.002 controller.py:45(_get_vendor) 19 0.000 0.000 0.057 0.003 controller.py:94(get_vendor) 19 0.000 0.000 0.049 0.003 contextlib.py:15(__enter__) 6 0.000 0.000 0.049 0.008 controller.py:257(get_amap_vpnos) 6 0.000 0.000 0.048 0.008 controller.py:113(get_vpno_obj) 19 0.000 0.000 0.047 0.002 db.py:83(_get_caller) 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.045 0.001 compiler.py:329(__init__) 19 0.000 0.000 0.045 0.002 inspect.py:1053(stack) 19 0.001 0.000 0.044 0.002 inspect.py:1026(getouterframes) 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) 285 0.003 0.000 0.044 0.000 inspect.py:988(getframeinfo) 68 0.002 0.000 0.043 0.001 compiler.py:1503(visit_select) 285 0.004 0.000 0.029 0.000 inspect.py:518(findsource) 451 0.003 0.000 0.020 0.000 compiler.py:1275(_label_select_column) 589 0.006 0.000 0.019 0.000 inspect.py:440(getsourcefile) 68 0.001 0.000 0.019 0.000 query.py:2953(_compile_context) 135 0.001 0.000 0.018 0.000 loading.py:30(instances) 451 0.004 0.000 0.015 0.000 compiler.py:581(visit_label) 438/153 0.001 0.000 0.014 0.000 operators.py:294(__eq__) 333/183 0.001 0.000 0.014 0.000 {operator.eq} 183 0.001 0.000 0.013 0.000 base.py:196(generate) 68 0.001 0.000 0.012 0.000 compiler.py:1679(_compose_select_body) 93 0.000 0.000 0.012 0.000 attributes.py:174(operate) 7 0.000 0.000 0.011 0.002 vendors.py:500(get_idents) 1 0.000 0.000 0.011 0.011 vendors.py:77(get_idents) 172 0.000 0.000 0.011 0.000 elements.py:738(operate) 172 0.000 0.000 0.010 0.000 <string>:1(<lambda>) 304 0.001 0.000 0.010 0.000 inspect.py:472(getmodule) 19 0.000 0.000 0.010 0.001 contextlib.py:21(__exit__) 68 0.000 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.009 0.000 type_api.py:57(operate) 68 0.000 0.000 0.009 0.000 result.py:488(__init__) 105 0.001 0.000 0.009 0.000 annotation.py:93(__eq__) 874 0.003 0.000 0.009 0.000 inspect.py:398(getfile) 68 0.001 0.000 0.008 0.000 result.py:513(_init_metadata) 19 0.000 0.000 0.008 0.000 session.py:756(commit) 68 0.001 0.000 0.008 0.000 query.py:3282(row_processor) 68 0.002 0.000 0.008 0.000 default.py:515(_init_compiled) 19 0.001 0.000 0.008 0.000 session.py:389(commit) 75 0.000 0.000 0.008 0.000 properties.py:268(operate) 15419 0.007 0.000 0.008 0.000 {isinstance} 68 0.005 0.000 0.008 0.000 result.py:189(__init__) 1 0.000 0.000 0.008 0.008 controller.py:279(get_vendor_idents) 135 0.001 0.000 0.008 0.000 compiler.py:904(visit_binary) 617 0.004 0.000 0.008 0.000 compiler.py:620(visit_column) 68 0.000 0.000 0.008 0.000 query.py:3317(setup_context) 30 0.000 0.000 0.008 0.000 query.py:1511(join) 68 0.001 0.000 0.007 0.000 query.py:3071(_simple_statement) 209 0.001 0.000 0.007 0.000 inspect.py:460(getabsfile) 30 0.000 0.000 0.007 0.000 <string>:1(_join) 68 0.003 0.000 0.007 0.000 loading.py:269(_instance_processor) 68 0.002 0.000 0.007 0.000 loading.py:224(_setup_entity_query) 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:1800(_join) 135 0.001 0.000 0.007 0.000 compiler.py:935(_generate_generic_binary) 209 0.001 0.000 0.006 0.000 posixpath.py:365(abspath) 30 0.000 0.000 0.006 0.000 query.py:1915(_join_left_to_right) 68 0.001 0.000 0.006 0.000 <string>:1(select) 401 0.001 0.000 0.006 0.000 {method 'join' of 'str' objects} 68 0.000 0.000 0.006 0.000 session.py:1245(query) 471 0.001 0.000 0.006 0.000 langhelpers.py:744(__get__) 68 0.001 0.000 0.006 0.000 compiler.py:1654(_setup_select_stack) 68 0.000 0.000 0.006 0.000 query.py:107(__init__) 37 0.000 0.000 0.006 0.000 compiler.py:735(visit_clauselist) 68 0.002 0.000 0.006 0.000 selectable.py:2220(__init__) 68 0.001 0.000 0.005 0.000 query.py:112(_set_entities) 67 0.001 0.000 0.005 0.000 loading.py:360(_instance) 105 0.000 0.000 0.005 0.000 <string>:1(filter) 111 0.000 0.000 0.005 0.000 compiler.py:742(<genexpr>) 111 0.000 0.000 0.005 0.000 compiler.py:744(<genexpr>) 30 0.000 0.000 0.005 0.000 query.py:2068(_join_to_left) 19 0.000 0.000 0.005 0.000 query.py:1310(filter_by) 611 0.002 0.000 0.005 0.000 interfaces.py:498(setup) 68 0.001 0.000 0.005 0.000 selectable.py:2506(_get_display_froms) 30 0.000 0.000 0.005 0.000 util.py:880(join) 30 0.000 0.000 0.005 0.000 util.py:779(__init__) 68 0.000 0.000 0.004 0.000 query.py:2518(_connection_from_session) 135 0.001 0.000 0.004 0.000 default_comparator.py:269(_check_literal) 68 0.000 0.000 0.004 0.000 session.py:811(connection) 19 0.000 0.000 0.004 0.000 base.py:1569(commit) 589 0.001 0.000 0.004 0.000 genericpath.py:15(exists) 19 0.000 0.000 0.004 0.000 base.py:1603(_do_commit) 771 0.004 0.000 0.004 0.000 interfaces.py:466(_get_context_loader) 19 0.000 0.000 0.004 0.000 base.py:679(_commit_impl) 30 0.000 0.000 0.004 0.000 selectable.py:651(__init__) 105 0.001 0.000 0.004 0.000 query.py:1274(filter) 68 0.002 0.000 0.004 0.000 selectable.py:2479(_froms) 555 0.002 0.000 0.004 0.000 compiler.py:1130(_truncated_identifier) 68 0.000 0.000 0.004 0.000 session.py:884(_connection_for_bind) 18 0.000 0.000 0.004 0.000 relationships.py:961(__eq__) 38 0.000 0.000 0.003 0.000 session.py:456(close) 68 0.000 0.000 0.003 0.000 session.py:312(_connection_for_bind) 19 0.000 0.000 0.003 0.000 default.py:422(do_commit) 74 0.000 0.000 0.003 0.000 elements.py:3370(_bind_param) 104 0.000 0.000 0.003 0.000 compiler.py:1048(visit_bindparam) 3191 0.003 0.000 0.003 0.000 {getattr} 67 0.001 0.000 0.003 0.000 loading.py:478(_populate_full) 19 0.003 0.000 0.003 0.000 {method 'commit' of 'psycopg2.extensions.connection' objects} 1784 0.002 0.000 0.003 0.000 compiler.py:2693(quote) 30 0.000 0.000 0.003 0.000 selectable.py:786(_match_primaries) 209 0.002 0.000 0.003 0.000 posixpath.py:336(normpath) 74 0.002 0.000 0.003 0.000 elements.py:913(__init__) 30 0.000 0.000 0.003 0.000 selectable.py:793(_join_condition) 589 0.003 0.000 0.003 0.000 {posix.stat} 160 0.001 0.000 0.003 0.000 interfaces.py:507(create_row_processor) 551 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) 68 0.000 0.000 0.002 0.000 result.py:944(fetchall) 96 0.000 0.000 0.002 0.000 arrow.py:73(process_result_value) 130/94 0.000 0.000 0.002 0.000 annotation.py:71(_compiler_dispatch) 68 0.001 0.000 0.002 0.000 selectable.py:3151(_columns_plus_names) 19 0.000 0.000 0.002 0.000 base.py:2020(contextual_connect) 74/37 0.000 0.000 0.002 0.000 operators.py:43(__and__) 57 0.000 0.000 0.002 0.000 session.py:694(begin) 104 0.000 0.000 0.002 0.000 compiler.py:1117(_truncate_bindparam) 2945 0.002 0.000 0.002 0.000 string.py:220(lower) 84 0.000 0.000 0.002 0.000 api.py:17(get) 684 0.002 0.000 0.002 0.000 {method 'match' of '_sre.SRE_Pattern' objects} 56 0.000 0.000 0.002 0.000 elements.py:1890(and_) 19 0.000 0.000 0.002 0.000 session.py:2646(__call__) 166 0.001 0.000 0.002 0.000 _collections.py:794(to_list) 57 0.000 0.000 0.002 0.000 session.py:169(__init__) 68 0.001 0.000 0.002 0.000 query.py:122(_set_entity_selectables) 84 0.001 0.000 0.002 0.000 factory.py:32(get) 36 0.000 0.000 0.002 0.000 elements.py:2758(_copy_internals) 56 0.001 0.000 0.002 0.000 elements.py:1856(_construct) 37 0.000 0.000 0.002 0.000 {operator.and_} 19 0.000 0.000 0.002 0.000 session.py:512(__init__) 30 0.000 0.000 0.002 0.000 compiler.py:1803(visit_join) 234 0.001 0.000 0.002 0.000 base.py:36(_from_objects) 451 0.001 0.000 0.002 0.000 default.py:753(get_result_processor) 18 0.000 0.000 0.002 0.000 relationships.py:1334(_optimized_compare) 30 0.000 0.000 0.002 0.000 mapper.py:2451(_get_state_attr_by_column) 19 0.000 0.000 0.002 0.000 base.py:793(close) 1463 0.001 0.000 0.002 0.000 inspect.py:51(ismodule) 68 0.001 0.000 0.002 0.000 compiler.py:438(_bind_processors) 135 0.001 0.000 0.002 0.000 elements.py:2724(__init__) 19 0.000 0.000 0.002 0.000 pool.py:879(close) 30 0.000 0.000 0.002 0.000 selectable.py:847(_joincond_scan_left_right) 19 0.000 0.000 0.002 0.000 pool.py:756(_checkin) 204 0.001 0.000 0.002 0.000 _collections.py:747(unique_list) 68 0.000 0.000 0.002 0.000 query.py:3159(__new__) 18 0.000 0.000 0.002 0.000 visitors.py:280(cloned_traverse) 68 0.000 0.000 0.002 0.000 result.py:911(_fetchall_impl) 37 0.000 0.000 0.002 0.000 default_comparator.py:89(_conjunction_operate) 19 0.000 0.000 0.002 0.000 pool.py:615(_finalize_fairy) 18 0.000 0.000 0.002 0.000 util.py:746(_orm_annotate) 54/18 0.000 0.000 0.002 0.000 visitors.py:287(clone) 1159 0.001 0.000 0.002 0.000 inspect.py:59(isclass) 106 0.000 0.000 0.002 0.000 base.py:285(__get__) 68 0.000 0.000 0.002 0.000 psycopg2.py:435(create_cursor) 19 0.000 0.000 0.002 0.000 db.py:69(_format_frame) 18 0.000 0.000 0.002 0.000 annotation.py:106(_deep_annotate) 68 0.000 0.000 0.001 0.000 compiler.py:455(construct_params) 19 0.000 0.000 0.001 0.000 base.py:2071(_wrap_pool_connect) 104 0.000 0.000 0.001 0.000 elements.py:3624(apply_map) 68 0.001 0.000 0.001 0.000 {method 'fetchall' of 'psycopg2.extensions.cursor' objects} 54/18 0.000 0.000 0.001 0.000 annotation.py:113(clone) 19 0.000 0.000 0.001 0.000 pool.py:367(connect) 202 0.001 0.000 0.001 0.000 base.py:389(_inspect_mapped_class) 1444 0.001 0.000 0.001 0.000 inspect.py:181(istraceback) 19 0.000 0.000 0.001 0.000 pool.py:710(_checkout) 68 0.000 0.000 0.001 0.000 _collections.py:359(__init__) 451 0.001 0.000 0.001 0.000 type_api.py:382(_cached_result_processor) 589 0.001 0.000 0.001 0.000 {imp.get_suffixes} 57 0.001 0.000 0.001 0.000 session.py:256(_take_snapshot) 54 0.000 0.000 0.001 0.000 elements.py:291(_annotate) 4034 0.001 0.000 0.001 0.000 {method 'append' of 'list' objects} 68 0.000 0.000 0.001 0.000 base.py:325(_is_mapped_class) 19 0.000 0.000 0.001 0.000 pool.py:478(checkout) 285 0.000 0.000 0.001 0.000 re.py:188(compile) 106 0.000 0.000 0.001 0.000 base.py:108(_for_instance) 68 0.000 0.000 0.001 0.000 pool.py:845(cursor) 18 0.000 0.000 0.001 0.000 elements.py:1168(effective_value) 18 0.000 0.000 0.001 0.000 relationships.py:1385(_go) 19 0.000 0.000 0.001 0.000 session.py:1031(close) 19 0.000 0.000 0.001 0.000 pool.py:501(checkin) 1159 0.001 0.000 0.001 0.000 inspect.py:142(isfunction) 451 0.001 0.000 0.001 0.000 strategies.py:141(setup_query) 161 0.000 0.000 0.001 0.000 operators.py:895(is_precedent) 124 0.000 0.000 0.001 0.000 elements.py:2783(self_group) 166 0.001 0.000 0.001 0.000 abc.py:128(__instancecheck__) 1159 0.001 0.000 0.001 0.000 inspect.py:67(ismethod) 104 0.000 0.000 0.001 0.000 _collections.py:727(__missing__) 92 0.000 0.000 0.001 0.000 elements.py:3513(__new__) 1372 0.001 0.000 0.001 0.000 {built-in method __new__ of type object at 0x919120} 68 0.001 0.000 0.001 0.000 query.py:3190(setup_entity) 68 0.000 0.000 0.001 0.000 compiler.py:441(<genexpr>) 451 0.000 0.000 0.001 0.000 result.py:497(_getter) 1444 0.001 0.000 0.001 0.000 inspect.py:191(isframe) 106 0.000 0.000 0.001 0.000 base.py:105(_for_class) 451 0.000 0.000 0.001 0.000 compiler.py:2722(format_label) 19 0.000 0.000 0.001 0.000 session.py:1076(_close_impl) 68 0.001 0.000 0.001 0.000 {method 'cursor' of 'psycopg2.extensions.connection' objects} 661 0.001 0.000 0.001 0.000 weakref.py:314(__getitem__) 54 0.000 0.000 0.001 0.000 elements.py:3919(__init__) 12 0.000 0.000 0.001 0.000 strategies.py:448(_generate_lazy_clause) 68 0.001 0.000 0.001 0.000 query.py:3715(__init__) 695 0.001 0.000 0.001 0.000 {hasattr} 209 0.001 0.000 0.001 0.000 posixpath.py:68(join) 19 0.000 0.000 0.001 0.000 pool.py:388(_return_conn) 209 0.001 0.000 0.001 0.000 {posix.getcwd} 4063 0.001 0.000 0.001 0.000 {len} 691 0.001 0.000 0.001 0.000 {method 'update' of 'dict' objects} 172 0.000 0.000 0.001 0.000 compiler.py:442(<genexpr>) 285 0.001 0.000 0.001 0.000 re.py:226(_compile) 67 0.000 0.000 0.001 0.000 instrumentation.py:311(new_instance) 104 0.001 0.000 0.001 0.000 compiler.py:1149(_process_anon) 19 0.000 0.000 0.001 0.000 pool.py:1030(_do_return_conn) 128 0.000 0.000 0.001 0.000 selectable.py:35(_interpret_as_from) 1562 0.001 0.000 0.001 0.000 {method 'get' of 'dict' objects} 451 0.001 0.000 0.001 0.000 selectable.py:3156(name_for_col) 42 0.000 0.000 0.001 0.000 schema.py:1635(get_referent) 12 0.000 0.000 0.001 0.000 strategy_options.py:781(lazyload) 19 0.000 0.000 0.001 0.000 base.py:47(__init__) 84 0.000 0.000 0.001 0.000 arrow.py:118(fromdatetime) 12 0.000 0.000 0.001 0.000 <string>:1(set_relationship_strategy) 183 0.000 0.000 0.001 0.000 query.py:416(_clone) 205 0.000 0.000 0.001 0.000 __init__.py:1345(isEnabledFor) 19 0.000 0.000 0.001 0.000 queue.py:87(put) 12 0.000 0.000 0.001 0.000 base.py:40(_generative) 19 0.000 0.000 0.001 0.000 pool.py:1039(_do_get) 19 0.000 0.000 0.001 0.000 <string>:1(and_) 1159 0.001 0.000 0.001 0.000 inspect.py:209(iscode) 2945 0.001 0.000 0.001 0.000 {method 'lower' of 'str' objects} 202 0.000 0.000 0.001 0.000 base.py:208(manager_of_class) 80 0.000 0.000 0.001 0.000 path_registry.py:62(set) 42 0.000 0.000 0.001 0.000 selectable.py:450(corresponding_column) 19 0.000 0.000 0.001 0.000 queue.py:130(get) 106 0.000 0.000 0.001 0.000 base.py:74(__init__) 19 0.000 0.000 0.001 0.000 session.py:358(_prepare_impl) 451 0.001 0.000 0.001 0.000 compiler.py:271(__init__) 451 0.000 0.000 0.001 0.000 compiler.py:1272(_add_to_result_map) 161 0.000 0.000 0.001 0.000 utf_8.py:15(decode) 285 0.000 0.000 0.001 0.000 <string>:8(__new__) 12 0.000 0.000 0.001 0.000 strategy_options.py:190(set_relationship_strategy) 125 0.000 0.000 0.001 0.000 session.py:1970(flush) 87 0.000 0.000 0.001 0.000 langhelpers.py:1033(_next) 136 0.000 0.000 0.001 0.000 selectable.py:2438(<genexpr>) 18 0.000 0.000 0.001 0.000 elements.py:1183(_clone) 451 0.001 0.000 0.001 0.000 result.py:419(_getter) 68 0.000 0.000 0.001 0.000 elements.py:3665(_select_iterables) 68 0.000 0.000 0.001 0.000 query.py:306(_bind_mapper) 68 0.000 0.000 0.001 0.000 session.py:1279(_autoflush) 68 0.000 0.000 0.001 0.000 query.py:3107(_adjust_for_single_inheritance) 99 0.000 0.000 0.001 0.000 __init__.py:1130(debug) 36 0.000 0.000 0.001 0.000 elements.py:235(_clone) 37 0.000 0.000 0.000 0.000 elements.py:1821(_from_objects) 356 0.000 0.000 0.000 0.000 attr.py:226(__bool__) 543 0.000 0.000 0.000 0.000 {method 'copy' of 'dict' objects} 144 0.000 0.000 0.000 0.000 session.py:2016(_is_clean) 6 0.000 0.000 0.000 0.000 attributes.py:1066(set_committed_value) 163 0.000 0.000 0.000 0.000 base.py:89(__getattr__) 84 0.000 0.000 0.000 0.000 util.py:25(is_timestamp) 836 0.000 0.000 0.000 0.000 {method 'startswith' of 'str' objects} 104 0.000 0.000 0.000 0.000 type_api.py:372(_cached_bind_processor) 198 0.000 0.000 0.000 0.000 elements.py:3765(_expression_literal_as_text) 104 0.000 0.000 0.000 0.000 compiler.py:1155(bindparam_string) 72 0.000 0.000 0.000 0.000 {sorted} 209 0.000 0.000 0.000 0.000 posixpath.py:59(isabs) 92 0.000 0.000 0.000 0.000 elements.py:3469(__new__) 37 0.000 0.000 0.000 0.000 elements.py:1967(self_group) 228 0.000 0.000 0.000 0.000 weakref.py:282(__init__) 12 0.000 0.000 0.000 0.000 query.py:1090(options) 523 0.000 0.000 0.000 0.000 elements.py:3292(_get_table) 68 0.000 0.000 0.000 0.000 {method 'encode' of 'unicode' objects} 451 0.000 0.000 0.000 0.000 compiler.py:280(type) 38 0.000 0.000 0.000 0.000 threading.py:146(acquire) 451 0.000 0.000 0.000 0.000 elements.py:3839(_interpret_as_column_or_from) 270 0.000 0.000 0.000 0.000 elements.py:698(self_group) 161 0.000 0.000 0.000 0.000 {_codecs.utf_8_decode} 84 0.000 0.000 0.000 0.000 arrow.py:49(__init__) 12 0.000 0.000 0.000 0.000 <string>:1(_options) 202 0.000 0.000 0.000 0.000 {method 'get' of 'dictproxy' objects} 19 0.000 0.000 0.000 0.000 base.py:534(begin) 19 0.000 0.000 0.000 0.000 pool.py:764(_reset) 68 0.000 0.000 0.000 0.000 result.py:637(_soft_close) 66 0.000 0.000 0.000 0.000 state.py:251(_cleanup) 12 0.000 0.000 0.000 0.000 strategy_options.py:110(_generate_path) 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) 135 0.000 0.000 0.000 0.000 elements.py:2754(_from_objects) 54 0.000 0.000 0.000 0.000 annotation.py:45(__init__) 166 0.000 0.000 0.000 0.000 _weakrefset.py:70(__contains__) 99 0.000 0.000 0.000 0.000 compiler.py:1788(visit_table) 172 0.000 0.000 0.000 0.000 default.py:592(<genexpr>) 19 0.000 0.000 0.000 0.000 base.py:1595(__init__) 126 0.000 0.000 0.000 0.000 langhelpers.py:750(_reset) 709 0.000 0.000 0.000 0.000 {method 'intersection' of 'set' objects} 570 0.000 0.000 0.000 0.000 {max} 205 0.000 0.000 0.000 0.000 __init__.py:1331(getEffectiveLevel) 74 0.000 0.000 0.000 0.000 type_api.py:424(coerce_compared_value) 209 0.000 0.000 0.000 0.000 {method 'split' of 'str' objects} 19 0.000 0.000 0.000 0.000 base.py:359(_entity_descriptor) 37 0.000 0.000 0.000 0.000 elements.py:1825(self_group) 12 0.000 0.000 0.000 0.000 query.py:1105(_options) 1086 0.000 0.000 0.000 0.000 {method 'add' of 'set' objects} 19 0.000 0.000 0.000 0.000 weakref.py:98(__setitem__) 183 0.000 0.000 0.000 0.000 elements.py:3657(_expand_cloned) 68 0.000 0.000 0.000 0.000 session.py:1142(get_bind) 19 0.000 0.000 0.000 0.000 session.py:1082(expunge_all) 30 0.000 0.000 0.000 0.000 query.py:1983(_prepare_right_side) 160 0.000 0.000 0.000 0.000 strategies.py:615(create_row_processor) 104 0.000 0.000 0.000 0.000 {method 'split' of 'unicode' objects} 38 0.000 0.000 0.000 0.000 threading.py:372(notify) 285 0.000 0.000 0.000 0.000 linecache.py:33(getlines) 68 0.000 0.000 0.000 0.000 query.py:2638(_select_args) 30 0.000 0.000 0.000 0.000 selectable.py:1057(_hide_froms) 68 0.000 0.000 0.000 0.000 default.py:692(should_autocommit) 68 0.000 0.000 0.000 0.000 result.py:928(process_rows) 68 0.000 0.000 0.000 0.000 query.py:3180(__init__) 38 0.000 0.000 0.000 0.000 threading.py:186(release) 135 0.000 0.000 0.000 0.000 type_api.py:1137(to_instance) 30 0.000 0.000 0.000 0.000 selectable.py:1062(_from_objects) 87 0.000 0.000 0.000 0.000 query.py:289(_mapper_zero) 6 0.000 0.000 0.000 0.000 attributes.py:976(_initialize_collection) 105 0.000 0.000 0.000 0.000 query.py:228(_adapt_clause) 19 0.000 0.000 0.000 0.000 base.py:642(_begin_impl) 126 0.000 0.000 0.000 0.000 langhelpers.py:753(reset) 136 0.000 0.000 0.000 0.000 query.py:3262(_get_entity_clauses) 144 0.000 0.000 0.000 0.000 identity.py:53(check_modified) 68 0.000 0.000 0.000 0.000 {sqlalchemy.cutils._distill_params} 106 0.000 0.000 0.000 0.000 session.py:190(_assert_active) 12 0.000 0.000 0.000 0.000 state.py:565(_commit) 68 0.000 0.000 0.000 0.000 path_registry.py:70(get) 37 0.000 0.000 0.000 0.000 elements.py:716(comparator) 6 0.000 0.000 0.000 0.000 arrow.py:341(timestamp) 19 0.000 0.000 0.000 0.000 default.py:419(do_rollback) 68 0.000 0.000 0.000 0.000 selectable.py:1695(__init__) 30 0.000 0.000 0.000 0.000 elements.py:2742(__bool__) 125 0.000 0.000 0.000 0.000 {method 'acquire' of 'thread.lock' objects} 233 0.000 0.000 0.000 0.000 {method 'endswith' of 'str' objects} 56 0.000 0.000 0.000 0.000 _collections.py:787(coerce_generator_arg) 12 0.000 0.000 0.000 0.000 <string>:1(params) 54 0.000 0.000 0.000 0.000 annotation.py:31(__new__) 61 0.000 0.000 0.000 0.000 identity.py:190(_fast_discard) 202 0.000 0.000 0.000 0.000 instrumentation.py:94(is_mapped) 19 0.000 0.000 0.000 0.000 base.py:116(_join) 30 0.000 0.000 0.000 0.000 controller.py:57(_get_ident) 67 0.000 0.000 0.000 0.000 {method 'issuperset' of 'frozenset' objects} 625 0.000 0.000 0.000 0.000 {method 'update' of 'set' objects} 19 0.000 0.000 0.000 0.000 query.py:300(_joinpoint_zero) 12 0.000 0.000 0.000 0.000 <string>:1(_adapt_all_clauses) 68 0.000 0.000 0.000 0.000 base.py:1220(_safe_close_cursor) 254 0.000 0.000 0.000 0.000 {method 'values' of 'dict' objects} 25 0.000 0.000 0.000 0.000 {method 'format' of 'str' objects} 285 0.000 0.000 0.000 0.000 {min} 84 0.000 0.000 0.000 0.000 util.py:37(isstr) 135 0.000 0.000 0.000 0.000 query.py:389(_no_limit_offset) 18 0.000 0.000 0.000 0.000 relationships.py:1363(visit_bindparam) 19 0.000 0.000 0.000 0.000 log.py:54(_should_log_debug) 68 0.000 0.000 0.000 0.000 _collections.py:394(__iter__) 12 0.000 0.000 0.000 0.000 path_registry.py:250(entity_path) 6 0.000 0.000 0.000 0.000 vendors.py:408(__repr__) 6 0.000 0.000 0.000 0.000 instrumentation.py:290(initialize_collection) 135 0.000 0.000 0.000 0.000 query.py:381(_no_statement_condition) 6 0.000 0.000 0.000 0.000 attributes.py:629(set_committed_value) 460 0.000 0.000 0.000 0.000 mapper.py:642(mapper) 248 0.000 0.000 0.000 0.000 mapper.py:1965(selectable) 12 0.000 0.000 0.000 0.000 strategy_options.py:216(_set_path_strategy) 68 0.000 0.000 0.000 0.000 mapper.py:1890(_with_polymorphic_mappers) 451 0.000 0.000 0.000 0.000 elements.py:3521(apply_map) 12 0.000 0.000 0.000 0.000 strategy_options.py:94(process_query) 68 0.000 0.000 0.000 0.000 {zip} 38 0.000 0.000 0.000 0.000 pool.py:854(__getattr__) 19 0.000 0.000 0.000 0.000 weakref.py:267(__init__) 289 0.000 0.000 0.000 0.000 {method 'pop' of 'dict' objects} 67 0.000 0.000 0.000 0.000 identity.py:140(_add_unpresent) 63 0.000 0.000 0.000 0.000 attr.py:214(__call__) 12 0.000 0.000 0.000 0.000 <string>:1(_with_invoke_all_eagers) 38 0.000 0.000 0.000 0.000 identity.py:14(__init__) 19 0.000 0.000 0.000 0.000 log.py:57(_should_log_info) 19 0.000 0.000 0.000 0.000 pool.py:559(get_connection) 12 0.000 0.000 0.000 0.000 strategy_options.py:86(_generate) 163 0.000 0.000 0.000 0.000 {setattr} 19 0.000 0.000 0.000 0.000 contextlib.py:82(helper) 132 0.000 0.000 0.000 0.000 annotation.py:90(__hash__) 30 0.000 0.000 0.000 0.000 query.py:3245(corresponds_to) 19 0.000 0.000 0.000 0.000 session.py:297(_remove_snapshot) 451 0.000 0.000 0.000 0.000 elements.py:758(_select_iterable) 12 0.000 0.000 0.000 0.000 path_registry.py:254(__getitem__) 12 0.000 0.000 0.000 0.000 strategy_options.py:100(_process) 68 0.000 0.000 0.000 0.000 result.py:632(_cursor_description) 12 0.000 0.000 0.000 0.000 strategy_options.py:185(_coerce_strat) 68 0.000 0.000 0.000 0.000 {method 'pop' of 'list' objects} 6 0.000 0.000 0.000 0.000 {method 'utctimetuple' of 'datetime.datetime' objects} 67 0.000 0.000 0.000 0.000 identity.py:145(get) 104 0.000 0.000 0.000 0.000 {_codecs.utf_8_encode} 19 0.000 0.000 0.000 0.000 {range} 30 0.000 0.000 0.000 0.000 elements.py:269(_cloned_set) 64 0.000 0.000 0.000 0.000 {method 'remove' of 'list' objects} 67 0.000 0.000 0.000 0.000 <string>:1(set) 30 0.000 0.000 0.000 0.000 selectable.py:874(<lambda>) 388 0.000 0.000 0.000 0.000 {id} 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) 87 0.000 0.000 0.000 0.000 {next} 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) 68 0.000 0.000 0.000 0.000 _collections.py:724(__init__) 159 0.000 0.000 0.000 0.000 selectable.py:1418(_from_objects) 24 0.000 0.000 0.000 0.000 _collections.py:846(flatten_iterator) 12 0.000 0.000 0.000 0.000 session.py:37(_state_session) 125 0.000 0.000 0.000 0.000 {method 'release' of 'thread.lock' objects} 19 0.000 0.000 0.000 0.000 weakref.py:262(__new__) 6 0.000 0.000 0.000 0.000 vendors.py:205(__init__) 209 0.000 0.000 0.000 0.000 posixpath.py:51(normcase) 42 0.000 0.000 0.000 0.000 base.py:590(contains_column) 24 0.000 0.000 0.000 0.000 interfaces.py:486(_get_strategy) 76 0.000 0.000 0.000 0.000 session.py:225(_is_transaction_boundary) 114 0.000 0.000 0.000 0.000 {hash} 114 0.000 0.000 0.000 0.000 threading.py:63(_note) 38 0.000 0.000 0.000 0.000 threading.py:237(_is_owned) 16 0.000 0.000 0.000 0.000 weakref.py:48(remove) 19 0.000 0.000 0.000 0.000 identity.py:184(all_states) 12 0.000 0.000 0.000 0.000 base.py:314(_generate) 6 0.000 0.000 0.000 0.000 calendar.py:610(timegm) 19 0.000 0.000 0.000 0.000 queue.py:198(_get) 12 0.000 0.000 0.000 0.000 strategy_options.py:80(__init__) 50 0.000 0.000 0.000 0.000 {method 'items' of 'dict' objects} 135 0.000 0.000 0.000 0.000 {callable} 12 0.000 0.000 0.000 0.000 path_registry.py:283(__getitem__) 30 0.000 0.000 0.000 0.000 query.py:2112(_reset_joinpoint) 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:194(_put) 68 0.000 0.000 0.000 0.000 {method 'keys' of 'dict' objects} 160 0.000 0.000 0.000 0.000 interfaces.py:617(setup_query) 114 0.000 0.000 0.000 0.000 {thread.get_ident} 68 0.000 0.000 0.000 0.000 {method 'union' of 'set' objects} 37 0.000 0.000 0.000 0.000 type_api.py:53(__init__) 19 0.000 0.000 0.000 0.000 base.py:255(__init__) 76 0.000 0.000 0.000 0.000 langhelpers.py:825(<lambda>) 80 0.000 0.000 0.000 0.000 query.py:3746(<genexpr>) 19 0.000 0.000 0.000 0.000 session.py:239(_iterate_parents) 98 0.000 0.000 0.000 0.000 selectable.py:170(selectable) 19 0.000 0.000 0.000 0.000 queue.py:190(_full) 6 0.000 0.000 0.000 0.000 pricelist.py:257(_pl_get_vpart_dict) 87 0.000 0.000 0.000 0.000 query.py:286(_entity_zero) 19 0.000 0.000 0.000 0.000 base.py:1532(__init__) 6 0.000 0.000 0.000 0.000 state.py:277(dict) 68 0.000 0.000 0.000 0.000 compiler.py:215(__str__) 6 0.000 0.000 0.000 0.000 instrumentation.py:302(get_impl) 19 0.000 0.000 0.000 0.000 pool.py:677(__init__) 68 0.000 0.000 0.000 0.000 default.py:747(pre_exec) 30 0.000 0.000 0.000 0.000 mapper.py:2278(common_parent) 19 0.000 0.000 0.000 0.000 {method 'rollback' of 'psycopg2.extensions.connection' objects} 68 0.000 0.000 0.000 0.000 default.py:750(post_exec) 68 0.000 0.000 0.000 0.000 {iter} 6 0.000 0.000 0.000 0.000 collections.py:1071(append) 76 0.000 0.000 0.000 0.000 {method 'setdefault' of 'dict' objects} 6 0.000 0.000 0.000 0.000 collections.py:578(__init__) 12 0.000 0.000 0.000 0.000 selectable.py:857(<lambda>) 6 0.000 0.000 0.000 0.000 currency.py:219(__init__) 19 0.000 0.000 0.000 0.000 base.py:1537(_parent) 68 0.000 0.000 0.000 0.000 _collections.py:155(union) 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} 19 0.000 0.000 0.000 0.000 queue.py:186(_empty) 18 0.000 0.000 0.000 0.000 interfaces.py:362(adapter) 68 0.000 0.000 0.000 0.000 {method 'close' of 'psycopg2.extensions.cursor' objects} 19 0.000 0.000 0.000 0.000 contextlib.py:12(__init__) 57 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) 18 0.000 0.000 0.000 0.000 relationships.py:1384(_get_attr_w_warn_on_none) 12 0.000 0.000 0.000 0.000 weakref.py:69(__getitem__) 19 0.000 0.000 0.000 0.000 {method 'discard' of 'set' objects} 12 0.000 0.000 0.000 0.000 path_registry.py:77(__len__) 6 0.000 0.000 0.000 0.000 tz.py:47(utcoffset) 12 0.000 0.000 0.000 0.000 query.py:224(_adapt_all_clauses) 6 0.000 0.000 0.000 0.000 vendors.py:321(add_price) 12 0.000 0.000 0.000 0.000 {method 'difference_update' of 'set' objects} 12 0.000 0.000 0.000 0.000 {method 'intersection' of 'frozenset' objects} 19 0.000 0.000 0.000 0.000 interfaces.py:120(create_row_processor) 30 0.000 0.000 0.000 0.000 elements.py:405(self_group) 19 0.000 0.000 0.000 0.000 interfaces.py:111(setup) 6 0.000 0.000 0.000 0.000 vendors.py:488(currency) 19 0.000 0.000 0.000 0.000 {method 'popleft' of 'collections.deque' objects} 19 0.000 0.000 0.000 0.000 {method 'append' of 'collections.deque' objects} 12 0.000 0.000 0.000 0.000 query.py:906(_with_invoke_all_eagers) 19 0.000 0.000 0.000 0.000 default.py:416(do_begin) 18 0.000 0.000 0.000 0.000 base.py:32(_clone) 6 0.000 0.000 0.000 0.000 {method 'toordinal' of 'datetime.date' objects} 6 0.000 0.000 0.000 0.000 collections.py:1038(__set) 6 0.000 0.000 0.000 0.000 {time.time} 6 0.000 0.000 0.000 0.000 state.py:244(_detach) 1 0.000 0.000 0.000 0.000 attributes.py:145(__clause_element__) 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:324(vpno) 1 0.000 0.000 0.000 0.000 {method 'disable' of '_lsprof.Profiler' objects}