TI Vendor Get Part (DB) ProfilingΒΆ
Raw execution profile
SVG of execution profile
Execution Profile
pstats Output
Tue May 24 00:35:07 2016 /media/ldata/code/tendril/profiling/sourcing/get_part_db/ti.profile 2827331 function calls (2770059 primitive calls) in 10.793 seconds Ordered by: cumulative time ncalls tottime percall cumtime percall filename:lineno(function) 1 0.012 0.012 10.820 10.820 vendors.py:74(profile_vendor_get_part_db) 202 0.001 0.000 10.803 0.053 vendors.py:509(get_all_vparts) 201 0.001 0.000 7.387 0.037 vendors.py:519(get_vpart) 201 0.002 0.000 7.386 0.037 ti.py:50(__init__) 201 0.001 0.000 7.384 0.037 vendors.py:415(__init__) 201 0.001 0.000 7.383 0.037 vendors.py:236(__init__) 201 0.003 0.000 7.382 0.037 vendors.py:248(_populate) 2006 0.013 0.000 7.319 0.004 query.py:2511(__iter__) 201 0.008 0.000 6.725 0.033 vendors.py:285(load_from_db) 2006 0.020 0.000 6.717 0.003 query.py:2525(_execute_and_instances) 201 0.003 0.000 6.710 0.033 vendors.py:427(_load_from_db) 2006 0.007 0.000 6.560 0.003 base.py:846(execute) 2006 0.005 0.000 6.549 0.003 elements.py:322(_execute_on_connection) 2006 0.026 0.000 6.544 0.003 base.py:975(_execute_clauseelement) 201 0.019 0.000 6.188 0.031 vendors.py:292(_load_from_db) 870 0.023 0.000 5.324 0.006 query.py:2393(all) 3136/468 0.020 0.000 5.160 0.011 db.py:168(inner) 2006 0.044 0.000 5.059 0.003 base.py:1061(_execute_context) 11100/10497 0.020 0.000 4.930 0.000 attributes.py:229(__get__) 1673/1070 0.007 0.000 4.911 0.005 attributes.py:556(get) 603 0.004 0.000 4.882 0.008 strategies.py:477(_load_for_state) 603 0.026 0.000 4.870 0.008 strategies.py:550(_emit_lazyload) 2006 0.005 0.000 4.459 0.002 default.py:449(do_execute) 2006 4.430 0.002 4.455 0.002 {method 'execute' of 'psycopg2.extensions.cursor' objects} 202 0.001 0.000 3.414 0.017 vendors.py:504(get_all_vpnos) 133 0.001 0.000 3.383 0.025 maps.py:73(get_all_partnos) 1136 0.027 0.000 2.723 0.002 query.py:2451(one) 266 0.010 0.000 2.505 0.009 controller.py:244(get_map_vpnos) 467 0.013 0.000 2.102 0.005 controller.py:215(get_map) 133 0.001 0.000 1.779 0.013 vendors.py:88(get_upartnos) 201 0.004 0.000 1.746 0.009 controller.py:113(get_vpno_obj) 133 0.001 0.000 1.603 0.012 vendors.py:84(get_apartnos) 936 0.009 0.000 1.510 0.002 db.py:111(get_session) 2006 0.007 0.000 1.443 0.001 elements.py:431(compile) 2006 0.010 0.000 1.436 0.001 elements.py:496(_compiler) 2006 0.039 0.000 1.426 0.001 compiler.py:329(__init__) 2006 0.009 0.000 1.380 0.001 compiler.py:167(__init__) 2006 0.005 0.000 1.371 0.001 compiler.py:212(process) 35699/2006 0.114 0.000 1.366 0.001 visitors.py:75(_compiler_dispatch) 2006 0.064 0.000 1.348 0.001 compiler.py:1503(visit_select) 133 0.001 0.000 1.301 0.010 controller.py:263(get_umap_vpnos) 734 0.003 0.000 1.292 0.002 controller.py:45(_get_vendor) 468 0.006 0.000 1.286 0.003 controller.py:94(get_vendor) 468 0.001 0.000 1.272 0.003 contextlib.py:15(__enter__) 133 0.001 0.000 1.213 0.009 controller.py:257(get_amap_vpnos) 468 0.012 0.000 1.204 0.003 db.py:83(_get_caller) 468 0.002 0.000 1.150 0.002 inspect.py:1053(stack) 468 0.018 0.000 1.148 0.002 inspect.py:1026(getouterframes) 7221 0.073 0.000 1.128 0.000 inspect.py:988(getframeinfo) 7221 0.092 0.000 0.742 0.000 inspect.py:518(findsource) 5258 0.048 0.000 0.678 0.000 loading.py:30(instances) 12906 0.101 0.000 0.630 0.000 compiler.py:1275(_label_select_column) 2006 0.034 0.000 0.573 0.000 query.py:2953(_compile_context) 14910 0.148 0.000 0.501 0.000 inspect.py:440(getsourcefile) 12906 0.119 0.000 0.458 0.000 compiler.py:581(visit_label) 11557/4141 0.026 0.000 0.396 0.000 operators.py:294(__eq__) 8953/5211 0.015 0.000 0.379 0.000 {operator.eq} 2006 0.042 0.000 0.376 0.000 compiler.py:1679(_compose_select_body) 6086 0.031 0.000 0.359 0.000 base.py:196(generate) 2338 0.004 0.000 0.318 0.000 attributes.py:174(operate) 4609 0.008 0.000 0.300 0.000 elements.py:738(operate) 2006 0.016 0.000 0.293 0.000 psycopg2.py:466(get_result_proxy) 7549/2739 0.037 0.000 0.292 0.000 visitors.py:86(_compiler_dispatch) 2006 0.011 0.000 0.268 0.000 result.py:488(__init__) 4609 0.010 0.000 0.268 0.000 <string>:1(<lambda>) 2006 0.056 0.000 0.262 0.000 query.py:3282(row_processor) 4609 0.024 0.000 0.258 0.000 type_api.py:57(operate) 2006 0.017 0.000 0.257 0.000 result.py:513(_init_metadata) 2006 0.077 0.000 0.248 0.000 default.py:515(_init_compiled) 2941 0.020 0.000 0.246 0.000 annotation.py:93(__eq__) 468 0.006 0.000 0.245 0.001 contextlib.py:21(__exit__) 7689 0.033 0.000 0.244 0.000 inspect.py:472(getmodule) 3674 0.018 0.000 0.241 0.000 compiler.py:904(visit_binary) 3320 0.048 0.000 0.239 0.000 loading.py:360(_instance) 17314 0.129 0.000 0.238 0.000 compiler.py:620(visit_column) 2006 0.108 0.000 0.237 0.000 result.py:189(__init__) 2006 0.034 0.000 0.237 0.000 query.py:3071(_simple_statement) 410828 0.205 0.000 0.235 0.000 {isinstance} 22131 0.085 0.000 0.225 0.000 inspect.py:398(getfile) 2006 0.013 0.000 0.220 0.000 query.py:3317(setup_context) 3674 0.021 0.000 0.215 0.000 compiler.py:935(_generate_generic_binary) 468 0.007 0.000 0.207 0.000 session.py:756(commit) 2006 0.050 0.000 0.205 0.000 loading.py:224(_setup_entity_query) 2006 0.095 0.000 0.202 0.000 loading.py:269(_instance_processor) 1871 0.006 0.000 0.202 0.000 properties.py:268(operate) 468 0.013 0.000 0.201 0.000 session.py:389(commit) 2006 0.017 0.000 0.195 0.000 <string>:1(select) 3674 0.025 0.000 0.192 0.000 default_comparator.py:21(_boolean_compare) 2006 0.035 0.000 0.189 0.000 compiler.py:1654(_setup_select_stack) 733 0.004 0.000 0.186 0.000 query.py:1511(join) 733 0.002 0.000 0.182 0.000 <string>:1(_join) 5349 0.013 0.000 0.180 0.000 inspect.py:460(getabsfile) 2006 0.060 0.000 0.178 0.000 selectable.py:2220(__init__) 733 0.008 0.000 0.173 0.000 query.py:1800(_join) 2006 0.006 0.000 0.172 0.000 session.py:1245(query) 10764 0.024 0.000 0.169 0.000 {method 'join' of 'str' objects} 2006 0.005 0.000 0.166 0.000 query.py:107(__init__) 13162 0.034 0.000 0.163 0.000 langhelpers.py:744(__get__) 2006 0.018 0.000 0.161 0.000 query.py:112(_set_entities) 935 0.005 0.000 0.156 0.000 compiler.py:735(visit_clauselist) 733 0.011 0.000 0.154 0.000 query.py:1915(_join_left_to_right) 5349 0.024 0.000 0.150 0.000 posixpath.py:365(abspath) 2805 0.002 0.000 0.145 0.000 compiler.py:742(<genexpr>) 2941 0.007 0.000 0.144 0.000 <string>:1(filter) 2805 0.004 0.000 0.142 0.000 compiler.py:744(<genexpr>) 2006 0.019 0.000 0.140 0.000 selectable.py:2506(_get_display_froms) 3320 0.032 0.000 0.140 0.000 loading.py:478(_populate_full) 17249 0.051 0.000 0.138 0.000 interfaces.py:498(setup) 733 0.006 0.000 0.125 0.000 query.py:2068(_join_to_left) 2006 0.007 0.000 0.118 0.000 query.py:2518(_connection_from_session) 468 0.007 0.000 0.116 0.000 query.py:1310(filter_by) 733 0.002 0.000 0.116 0.000 util.py:880(join) 733 0.010 0.000 0.113 0.000 util.py:779(__init__) 12906 0.018 0.000 0.113 0.000 default.py:753(get_result_processor) 2006 0.009 0.000 0.111 0.000 session.py:811(connection) 15846 0.057 0.000 0.111 0.000 compiler.py:1130(_truncated_identifier) 2006 0.049 0.000 0.111 0.000 selectable.py:2479(_froms) 3674 0.016 0.000 0.109 0.000 default_comparator.py:269(_check_literal) 5166 0.006 0.000 0.108 0.000 type_api.py:1009(process) 2940 0.016 0.000 0.106 0.000 compiler.py:1048(visit_bindparam) 467 0.005 0.000 0.104 0.000 relationships.py:961(__eq__) 14910 0.027 0.000 0.102 0.000 genericpath.py:15(exists) 5166 0.007 0.000 0.102 0.000 arrow.py:73(process_result_value) 2941 0.025 0.000 0.100 0.000 query.py:1274(filter) 2006 0.009 0.000 0.097 0.000 result.py:944(fetchall) 88418 0.096 0.000 0.097 0.000 {getattr} 3585 0.008 0.000 0.095 0.000 api.py:17(get) 12906 0.021 0.000 0.095 0.000 type_api.py:382(_cached_result_processor) 468 0.003 0.000 0.093 0.000 base.py:1569(commit) 2006 0.005 0.000 0.093 0.000 session.py:884(_connection_for_bind) 50274 0.055 0.000 0.093 0.000 compiler.py:2693(quote) 733 0.007 0.000 0.092 0.000 selectable.py:651(__init__) 468 0.001 0.000 0.090 0.000 base.py:1603(_do_commit) 936 0.012 0.000 0.089 0.000 session.py:456(close) 468 0.007 0.000 0.089 0.000 base.py:679(_commit_impl) 2006 0.012 0.000 0.088 0.000 session.py:312(_connection_for_bind) 3585 0.028 0.000 0.087 0.000 factory.py:32(get) 18788 0.087 0.000 0.087 0.000 weakref.py:314(__getitem__) 1870 0.010 0.000 0.083 0.000 elements.py:3370(_bind_param) 1070 0.017 0.000 0.082 0.000 mapper.py:2451(_get_state_attr_by_column) 468 0.004 0.000 0.081 0.000 default.py:422(do_commit) 21592 0.079 0.000 0.079 0.000 interfaces.py:466(_get_context_loader) 468 0.076 0.000 0.076 0.000 {method 'commit' of 'psycopg2.extensions.connection' objects} 733 0.003 0.000 0.075 0.000 selectable.py:786(_match_primaries) 5349 0.047 0.000 0.075 0.000 posixpath.py:336(normpath) 14910 0.075 0.000 0.075 0.000 {posix.stat} 2940 0.012 0.000 0.074 0.000 compiler.py:1117(_truncate_bindparam) 1870 0.043 0.000 0.073 0.000 elements.py:913(__init__) 2006 0.017 0.000 0.072 0.000 selectable.py:3151(_columns_plus_names) 733 0.006 0.000 0.072 0.000 selectable.py:793(_join_condition) 3273/2339 0.010 0.000 0.070 0.000 annotation.py:71(_compiler_dispatch) 15499 0.035 0.000 0.070 0.000 inspection.py:38(inspect) 4745 0.017 0.000 0.064 0.000 _collections.py:794(to_list) 1870/935 0.003 0.000 0.061 0.000 operators.py:43(__and__) 1404 0.006 0.000 0.061 0.000 session.py:694(begin) 74550 0.041 0.000 0.061 0.000 string.py:220(lower) 2006 0.004 0.000 0.061 0.000 result.py:911(_fetchall_impl) 468 0.003 0.000 0.060 0.000 base.py:2020(contextual_connect) 2006 0.018 0.000 0.060 0.000 query.py:122(_set_entity_selectables) 934 0.003 0.000 0.058 0.000 elements.py:2758(_copy_internals) 603 0.007 0.000 0.057 0.000 strategies.py:448(_generate_lazy_clause) 2006 0.033 0.000 0.057 0.000 {method 'fetchall' of 'psycopg2.extensions.cursor' objects} 17049 0.057 0.000 0.057 0.000 {method 'match' of '_sre.SRE_Pattern' objects} 468 0.005 0.000 0.057 0.000 session.py:2646(__call__) 6751 0.031 0.000 0.056 0.000 base.py:36(_from_objects) 1403 0.005 0.000 0.056 0.000 elements.py:1890(and_) 1404 0.010 0.000 0.055 0.000 session.py:169(__init__) 467 0.006 0.000 0.054 0.000 relationships.py:1334(_optimized_compare) 6018 0.028 0.000 0.053 0.000 _collections.py:747(unique_list) 3674 0.030 0.000 0.051 0.000 elements.py:2724(__init__) 1403 0.018 0.000 0.051 0.000 elements.py:1856(_construct) 935 0.002 0.000 0.051 0.000 {operator.and_} 4343 0.019 0.000 0.050 0.000 interfaces.py:507(create_row_processor) 733 0.007 0.000 0.050 0.000 compiler.py:1803(visit_join) 468 0.008 0.000 0.050 0.000 session.py:512(__init__) 467 0.002 0.000 0.048 0.000 visitors.py:280(cloned_traverse) 2006 0.012 0.000 0.047 0.000 psycopg2.py:435(create_cursor) 2940 0.016 0.000 0.047 0.000 elements.py:3624(apply_map) 2006 0.013 0.000 0.047 0.000 compiler.py:455(construct_params) 37041 0.027 0.000 0.046 0.000 inspect.py:51(ismodule) 603 0.002 0.000 0.046 0.000 strategy_options.py:781(lazyload) 2006 0.010 0.000 0.046 0.000 query.py:3159(__new__) 1401/467 0.012 0.000 0.045 0.000 visitors.py:287(clone) 2942 0.011 0.000 0.044 0.000 base.py:285(__get__) 603 0.002 0.000 0.044 0.000 <string>:1(set_relationship_strategy) 468 0.002 0.000 0.044 0.000 base.py:793(close) 467 0.002 0.000 0.044 0.000 util.py:746(_orm_annotate) 603 0.002 0.000 0.043 0.000 base.py:40(_generative) 468 0.002 0.000 0.042 0.000 pool.py:879(close) 935 0.002 0.000 0.042 0.000 default_comparator.py:89(_conjunction_operate) 467 0.001 0.000 0.042 0.000 annotation.py:106(_deep_annotate) 12906 0.013 0.000 0.041 0.000 result.py:497(_getter) 1401/467 0.006 0.000 0.041 0.000 annotation.py:113(clone) 2006 0.014 0.000 0.041 0.000 _collections.py:359(__init__) 2006 0.011 0.000 0.041 0.000 compiler.py:438(_bind_processors) 468 0.002 0.000 0.040 0.000 pool.py:756(_checkin) 29352 0.023 0.000 0.040 0.000 inspect.py:59(isclass) 733 0.011 0.000 0.040 0.000 selectable.py:847(_joincond_scan_left_right) 468 0.005 0.000 0.039 0.000 db.py:69(_format_frame) 468 0.001 0.000 0.039 0.000 base.py:2071(_wrap_pool_connect) 468 0.004 0.000 0.039 0.000 pool.py:615(_finalize_fairy) 468 0.001 0.000 0.038 0.000 pool.py:367(connect) 3252 0.018 0.000 0.037 0.000 instrumentation.py:311(new_instance) 468 0.004 0.000 0.036 0.000 pool.py:710(_checkout) 5005 0.014 0.000 0.035 0.000 base.py:389(_inspect_mapped_class) 36573 0.021 0.000 0.035 0.000 inspect.py:181(istraceback) 2006 0.005 0.000 0.035 0.000 pool.py:845(cursor) 603 0.004 0.000 0.035 0.000 strategy_options.py:190(set_relationship_strategy) 467 0.001 0.000 0.034 0.000 elements.py:1168(effective_value) 1401 0.004 0.000 0.034 0.000 elements.py:291(_annotate) 2942 0.006 0.000 0.033 0.000 base.py:108(_for_instance) 467 0.001 0.000 0.033 0.000 relationships.py:1385(_go) 1404 0.014 0.000 0.033 0.000 session.py:256(_take_snapshot) 3585 0.016 0.000 0.033 0.000 arrow.py:118(fromdatetime) 110699 0.032 0.000 0.032 0.000 {method 'append' of 'list' objects} 2006 0.008 0.000 0.032 0.000 base.py:325(_is_mapped_class) 14910 0.032 0.000 0.032 0.000 {imp.get_suffixes} 468 0.005 0.000 0.031 0.000 pool.py:478(checkout) 2940 0.005 0.000 0.031 0.000 _collections.py:727(__missing__) 4745 0.016 0.000 0.030 0.000 abc.py:128(__instancecheck__) 3409 0.007 0.000 0.030 0.000 elements.py:2783(self_group) 4344 0.012 0.000 0.030 0.000 operators.py:895(is_precedent) 2006 0.004 0.000 0.030 0.000 compiler.py:441(<genexpr>) 134 0.000 0.000 0.030 0.000 vendors.py:500(get_idents) 468 0.003 0.000 0.030 0.000 session.py:1031(close) 2006 0.030 0.000 0.030 0.000 {method 'cursor' of 'psycopg2.extensions.connection' objects} 40155 0.029 0.000 0.029 0.000 {built-in method __new__ of type object at 0x919120} 7221 0.008 0.000 0.029 0.000 re.py:188(compile) 1 0.000 0.000 0.029 0.029 vendors.py:77(get_idents) 2006 0.018 0.000 0.029 0.000 query.py:3190(setup_entity) 12906 0.028 0.000 0.029 0.000 result.py:419(_getter) 12906 0.011 0.000 0.029 0.000 compiler.py:2722(format_label) 12906 0.024 0.000 0.028 0.000 strategies.py:141(setup_query) 2006 0.025 0.000 0.027 0.000 query.py:3715(__init__) 2942 0.010 0.000 0.027 0.000 base.py:105(_for_class) 20733 0.027 0.000 0.027 0.000 {method 'update' of 'dict' objects} 468 0.003 0.000 0.027 0.000 session.py:1076(_close_impl) 29352 0.018 0.000 0.027 0.000 inspect.py:67(ismethod) 2337 0.009 0.000 0.027 0.000 elements.py:3513(__new__) 6086 0.016 0.000 0.026 0.000 query.py:416(_clone) 2940 0.017 0.000 0.026 0.000 compiler.py:1149(_process_anon) 4946 0.011 0.000 0.026 0.000 compiler.py:442(<genexpr>) 1401 0.009 0.000 0.026 0.000 elements.py:3919(__init__) 29352 0.017 0.000 0.026 0.000 inspect.py:142(isfunction) 36573 0.019 0.000 0.025 0.000 inspect.py:191(isframe) 1 0.000 0.000 0.025 0.025 controller.py:279(get_vendor_idents) 468 0.003 0.000 0.025 0.000 pool.py:501(checkin) 603 0.002 0.000 0.025 0.000 query.py:1090(options) 3472 0.011 0.000 0.024 0.000 selectable.py:35(_interpret_as_from) 17852 0.024 0.000 0.024 0.000 {hasattr} 6262 0.008 0.000 0.024 0.000 utf_8.py:15(decode) 12906 0.021 0.000 0.023 0.000 selectable.py:3156(name_for_col) 603 0.001 0.000 0.023 0.000 <string>:1(_options) 108481 0.023 0.000 0.023 0.000 {len} 6019 0.013 0.000 0.023 0.000 __init__.py:1345(isEnabledFor) 2609 0.009 0.000 0.022 0.000 path_registry.py:62(set) 42544 0.022 0.000 0.022 0.000 {method 'get' of 'dict' objects} 5349 0.016 0.000 0.022 0.000 posixpath.py:68(join) 7221 0.017 0.000 0.022 0.000 re.py:226(_compile) 468 0.001 0.000 0.021 0.000 pool.py:388(_return_conn) 468 0.004 0.000 0.020 0.000 pool.py:1039(_do_get) 29352 0.016 0.000 0.020 0.000 inspect.py:209(iscode) 2474 0.012 0.000 0.020 0.000 langhelpers.py:1033(_next) 74550 0.020 0.000 0.020 0.000 {method 'lower' of 'str' objects} 468 0.002 0.000 0.020 0.000 pool.py:1030(_do_return_conn) 603 0.007 0.000 0.020 0.000 strategy_options.py:110(_generate_path) 3585 0.019 0.000 0.019 0.000 util.py:25(is_timestamp) 12906 0.019 0.000 0.019 0.000 compiler.py:271(__init__) 12906 0.014 0.000 0.019 0.000 compiler.py:1272(_add_to_result_map) 4012 0.004 0.000 0.018 0.000 selectable.py:2438(<genexpr>) 468 0.005 0.000 0.018 0.000 queue.py:87(put) 3410 0.006 0.000 0.018 0.000 session.py:1970(flush) 5005 0.008 0.000 0.018 0.000 base.py:208(manager_of_class) 468 0.006 0.000 0.018 0.000 base.py:47(__init__) 999 0.003 0.000 0.018 0.000 schema.py:1635(get_referent) 2006 0.009 0.000 0.018 0.000 query.py:306(_bind_mapper) 468 0.001 0.000 0.017 0.000 <string>:1(and_) 2006 0.005 0.000 0.017 0.000 session.py:1279(_autoflush) 2942 0.012 0.000 0.017 0.000 base.py:74(__init__) 2006 0.014 0.000 0.017 0.000 elements.py:3665(_select_iterables) 16981 0.017 0.000 0.017 0.000 {method 'copy' of 'dict' objects} 3585 0.012 0.000 0.017 0.000 arrow.py:49(__init__) 467 0.006 0.000 0.017 0.000 elements.py:1183(_clone) 3077 0.005 0.000 0.017 0.000 __init__.py:1130(debug) 468 0.006 0.000 0.017 0.000 queue.py:130(get) 201 0.003 0.000 0.017 0.000 attributes.py:1066(set_committed_value) 603 0.007 0.000 0.016 0.000 query.py:1105(_options) 2006 0.016 0.000 0.016 0.000 result.py:928(process_rows) 2006 0.014 0.000 0.016 0.000 query.py:3107(_adjust_for_single_inheritance) 468 0.008 0.000 0.016 0.000 session.py:358(_prepare_impl) 6262 0.015 0.000 0.015 0.000 {_codecs.utf_8_decode} 999 0.010 0.000 0.015 0.000 selectable.py:450(corresponding_column) 2940 0.008 0.000 0.015 0.000 type_api.py:372(_cached_bind_processor) 2940 0.015 0.000 0.015 0.000 compiler.py:1155(bindparam_string) 934 0.008 0.000 0.015 0.000 elements.py:235(_clone) 3878 0.009 0.000 0.015 0.000 session.py:2016(_is_clean) 7221 0.008 0.000 0.015 0.000 <string>:8(__new__) 9762 0.015 0.000 0.015 0.000 attr.py:226(__bool__) 5349 0.015 0.000 0.015 0.000 {posix.getcwd} 3252 0.009 0.000 0.014 0.000 state.py:251(_cleanup) 935 0.009 0.000 0.014 0.000 elements.py:1821(_from_objects) 3252 0.014 0.000 0.014 0.000 state.py:75(__init__) 4346 0.011 0.000 0.014 0.000 base.py:89(__getattr__) 5279 0.006 0.000 0.014 0.000 elements.py:3765(_expression_literal_as_text) 14975 0.013 0.000 0.013 0.000 elements.py:3292(_get_table) 12906 0.013 0.000 0.013 0.000 compiler.py:280(type) 2006 0.013 0.000 0.013 0.000 {method 'encode' of 'unicode' objects} 21396 0.013 0.000 0.013 0.000 {method 'startswith' of 'str' objects} 2069 0.010 0.000 0.013 0.000 {sorted} 12906 0.007 0.000 0.012 0.000 elements.py:3839(_interpret_as_column_or_from) 2337 0.007 0.000 0.012 0.000 elements.py:3469(__new__) 7348 0.012 0.000 0.012 0.000 elements.py:698(self_group) 935 0.003 0.000 0.011 0.000 elements.py:1967(self_group) 5349 0.006 0.000 0.011 0.000 posixpath.py:59(isabs) 2006 0.007 0.000 0.011 0.000 result.py:637(_soft_close) 5616 0.011 0.000 0.011 0.000 weakref.py:282(__init__) 3674 0.011 0.000 0.011 0.000 elements.py:2754(_from_objects) 2740 0.005 0.000 0.011 0.000 compiler.py:1788(visit_table) 4946 0.007 0.000 0.010 0.000 default.py:592(<genexpr>) 7285 0.006 0.000 0.010 0.000 elements.py:3769(_literal_as_text) 4745 0.010 0.000 0.010 0.000 _weakrefset.py:70(__contains__) 1401 0.005 0.000 0.010 0.000 annotation.py:45(__init__) 6019 0.010 0.000 0.010 0.000 __init__.py:1331(getEffectiveLevel) 468 0.004 0.000 0.010 0.000 pool.py:764(_reset) 936 0.007 0.000 0.010 0.000 threading.py:146(acquire) 5005 0.010 0.000 0.010 0.000 {method 'get' of 'dictproxy' objects} 20053 0.009 0.000 0.009 0.000 {method 'intersection' of 'set' objects} 468 0.001 0.000 0.009 0.000 base.py:534(begin) 603 0.001 0.000 0.009 0.000 <string>:1(params) 3269 0.004 0.000 0.009 0.000 langhelpers.py:750(_reset) 32271 0.009 0.000 0.009 0.000 {method 'add' of 'set' objects} 2006 0.006 0.000 0.009 0.000 session.py:1142(get_bind) 935 0.002 0.000 0.008 0.000 elements.py:1825(self_group) 14442 0.008 0.000 0.008 0.000 {max} 468 0.002 0.000 0.008 0.000 base.py:1595(__init__) 5349 0.008 0.000 0.008 0.000 {method 'split' of 'str' objects} 2940 0.008 0.000 0.008 0.000 {method 'split' of 'unicode' objects} 603 0.001 0.000 0.008 0.000 <string>:1(_adapt_all_clauses) 4602 0.007 0.000 0.007 0.000 elements.py:3657(_expand_cloned) 2006 0.007 0.000 0.007 0.000 query.py:2638(_select_args) 468 0.005 0.000 0.007 0.000 session.py:1082(expunge_all) 603 0.005 0.000 0.007 0.000 state.py:565(_commit) 1070 0.004 0.000 0.007 0.000 elements.py:2742(__bool__) 2006 0.006 0.000 0.007 0.000 default.py:692(should_autocommit) 4343 0.007 0.000 0.007 0.000 strategies.py:615(create_row_processor) 603 0.001 0.000 0.007 0.000 strategy_options.py:216(_set_path_strategy) 1870 0.006 0.000 0.007 0.000 type_api.py:424(coerce_compared_value) 603 0.001 0.000 0.006 0.000 path_registry.py:250(entity_path) 733 0.004 0.000 0.006 0.000 query.py:1983(_prepare_right_side) 2474 0.005 0.000 0.006 0.000 query.py:289(_mapper_zero) 468 0.003 0.000 0.006 0.000 weakref.py:98(__setitem__) 7221 0.006 0.000 0.006 0.000 linecache.py:33(getlines) 3252 0.006 0.000 0.006 0.000 {method 'issuperset' of 'frozenset' objects} 402 0.001 0.000 0.006 0.000 attributes.py:629(set_committed_value) 3674 0.005 0.000 0.006 0.000 type_api.py:1137(to_instance) 603 0.001 0.000 0.006 0.000 strategy_options.py:94(process_query) 2006 0.005 0.000 0.006 0.000 query.py:3180(__init__) 733 0.003 0.000 0.006 0.000 selectable.py:1057(_hide_froms) 936 0.004 0.000 0.006 0.000 threading.py:372(notify) 468 0.002 0.000 0.006 0.000 base.py:359(_entity_descriptor) 3119 0.004 0.000 0.006 0.000 identity.py:190(_fast_discard) 2006 0.006 0.000 0.006 0.000 {sqlalchemy.cutils._distill_params} 603 0.001 0.000 0.006 0.000 <string>:1(_with_invoke_all_eagers) 603 0.003 0.000 0.006 0.000 strategy_options.py:86(_generate) 201 0.002 0.000 0.006 0.000 attributes.py:976(_initialize_collection) 2941 0.005 0.000 0.005 0.000 query.py:228(_adapt_clause) 1380 0.003 0.000 0.005 0.000 vendors.py:205(__init__) 3878 0.005 0.000 0.005 0.000 identity.py:53(check_modified) 3269 0.004 0.000 0.005 0.000 langhelpers.py:753(reset) 2006 0.005 0.000 0.005 0.000 selectable.py:1695(__init__) 4012 0.005 0.000 0.005 0.000 query.py:3262(_get_entity_clauses) 2942 0.005 0.000 0.005 0.000 session.py:190(_assert_active) 2006 0.005 0.000 0.005 0.000 path_registry.py:70(get) 3585 0.003 0.000 0.005 0.000 util.py:37(isstr) 603 0.002 0.000 0.005 0.000 path_registry.py:254(__getitem__) 733 0.004 0.000 0.005 0.000 selectable.py:1062(_from_objects) 17854 0.005 0.000 0.005 0.000 {method 'update' of 'set' objects} 603 0.003 0.000 0.005 0.000 strategy_options.py:100(_process) 936 0.004 0.000 0.005 0.000 threading.py:186(release) 603 0.002 0.000 0.005 0.000 strategy_options.py:185(_coerce_strat) 201 0.001 0.000 0.005 0.000 arrow.py:341(timestamp) 468 0.004 0.000 0.005 0.000 base.py:642(_begin_impl) 3252 0.005 0.000 0.005 0.000 identity.py:140(_add_unpresent) 6555 0.005 0.000 0.005 0.000 {method 'endswith' of 'str' objects} 201 0.002 0.000 0.004 0.000 vendors.py:408(__repr__) 3410 0.004 0.000 0.004 0.000 {method 'acquire' of 'thread.lock' objects} 468 0.002 0.000 0.004 0.000 default.py:419(do_rollback) 935 0.003 0.000 0.004 0.000 elements.py:716(comparator) 201 0.002 0.000 0.004 0.000 collections.py:659(append_multiple_without_event) 4008 0.004 0.000 0.004 0.000 annotation.py:90(__hash__) 603 0.003 0.000 0.004 0.000 _collections.py:805(has_intersection) 603 0.002 0.000 0.004 0.000 query.py:1254(params) 2006 0.003 0.000 0.004 0.000 base.py:1220(_safe_close_cursor) 1401 0.003 0.000 0.004 0.000 annotation.py:31(__new__) 1403 0.002 0.000 0.004 0.000 _collections.py:787(coerce_generator_arg) 669 0.004 0.000 0.004 0.000 {method 'format' of 'str' objects} 5005 0.004 0.000 0.004 0.000 instrumentation.py:94(is_mapped) 2474 0.004 0.000 0.004 0.000 {next} 2006 0.003 0.000 0.004 0.000 _collections.py:394(__iter__) 9190 0.004 0.000 0.004 0.000 {method 'pop' of 'dict' objects} 3252 0.004 0.000 0.004 0.000 <string>:1(set) 733 0.003 0.000 0.004 0.000 controller.py:57(_get_ident) 7220 0.004 0.000 0.004 0.000 {method 'values' of 'dict' objects} 3674 0.004 0.000 0.004 0.000 query.py:389(_no_limit_offset) 467 0.003 0.000 0.003 0.000 relationships.py:1363(visit_bindparam) 3320 0.003 0.000 0.003 0.000 identity.py:145(get) 1206 0.002 0.000 0.003 0.000 _collections.py:846(flatten_iterator) 3674 0.003 0.000 0.003 0.000 query.py:381(_no_statement_condition) 603 0.002 0.000 0.003 0.000 session.py:37(_state_session) 2006 0.003 0.000 0.003 0.000 {zip} 12625 0.003 0.000 0.003 0.000 mapper.py:642(mapper) 468 0.002 0.000 0.003 0.000 base.py:116(_join) 201 0.001 0.000 0.003 0.000 instrumentation.py:290(initialize_collection) 6404 0.003 0.000 0.003 0.000 mapper.py:1965(selectable) 468 0.002 0.000 0.003 0.000 query.py:300(_joinpoint_zero) 12906 0.003 0.000 0.003 0.000 elements.py:3521(apply_map) 2006 0.003 0.000 0.003 0.000 mapper.py:1890(_with_polymorphic_mappers) 603 0.002 0.000 0.003 0.000 strategy_options.py:80(__init__) 603 0.002 0.000 0.003 0.000 base.py:314(_generate) 1605 0.003 0.000 0.003 0.000 attr.py:214(__call__) 12906 0.003 0.000 0.003 0.000 elements.py:758(_select_iterable) 7221 0.003 0.000 0.003 0.000 {min} 2006 0.003 0.000 0.003 0.000 result.py:632(_cursor_description) 936 0.003 0.000 0.003 0.000 identity.py:14(__init__) 2940 0.003 0.000 0.003 0.000 {_codecs.utf_8_encode} 468 0.001 0.000 0.003 0.000 log.py:54(_should_log_debug) 1206 0.003 0.000 0.003 0.000 interfaces.py:486(_get_strategy) 2006 0.003 0.000 0.003 0.000 {method 'pop' of 'list' objects} 603 0.003 0.000 0.003 0.000 path_registry.py:267(__init__) 936 0.001 0.000 0.003 0.000 pool.py:854(__getattr__) 13112 0.003 0.000 0.003 0.000 {id} 603 0.002 0.000 0.002 0.000 path_registry.py:283(__getitem__) 1380 0.002 0.000 0.002 0.000 collections.py:1071(append) 4346 0.002 0.000 0.002 0.000 {setattr} 3541 0.002 0.000 0.002 0.000 {hash} 733 0.002 0.000 0.002 0.000 query.py:3245(corresponds_to) 201 0.002 0.000 0.002 0.000 {method 'utctimetuple' of 'datetime.datetime' objects} 468 0.001 0.000 0.002 0.000 log.py:57(_should_log_info) 2006 0.002 0.000 0.002 0.000 base.py:1472(get_select_precolumns) 468 0.002 0.000 0.002 0.000 pool.py:559(get_connection) 1380 0.002 0.000 0.002 0.000 currency.py:219(__init__) 1470 0.002 0.000 0.002 0.000 {method 'remove' of 'list' objects} 468 0.002 0.000 0.002 0.000 {range} 468 0.002 0.000 0.002 0.000 contextlib.py:82(helper) 1380 0.002 0.000 0.002 0.000 vendors.py:321(add_price) 468 0.002 0.000 0.002 0.000 session.py:297(_remove_snapshot) 468 0.002 0.000 0.002 0.000 weakref.py:267(__init__) 733 0.002 0.000 0.002 0.000 elements.py:269(_cloned_set) 4206 0.002 0.000 0.002 0.000 selectable.py:1418(_from_objects) 3410 0.002 0.000 0.002 0.000 {method 'release' of 'thread.lock' objects} 733 0.002 0.000 0.002 0.000 selectable.py:874(<lambda>) 2006 0.002 0.000 0.002 0.000 _collections.py:724(__init__) 1539 0.001 0.000 0.001 0.000 {method 'items' of 'dict' objects} 2808 0.001 0.000 0.001 0.000 base.py:301(connection) 5349 0.001 0.000 0.001 0.000 posixpath.py:51(normcase) 468 0.001 0.000 0.001 0.000 weakref.py:262(__new__) 2609 0.001 0.000 0.001 0.000 query.py:3746(<genexpr>) 468 0.001 0.000 0.001 0.000 identity.py:184(all_states) 2808 0.001 0.000 0.001 0.000 threading.py:63(_note) 3674 0.001 0.000 0.001 0.000 {callable} 201 0.001 0.000 0.001 0.000 calendar.py:610(timegm) 999 0.001 0.000 0.001 0.000 base.py:590(contains_column) 936 0.001 0.000 0.001 0.000 threading.py:237(_is_owned) 2474 0.001 0.000 0.001 0.000 query.py:286(_entity_zero) 1872 0.001 0.000 0.001 0.000 session.py:225(_is_transaction_boundary) 2006 0.001 0.000 0.001 0.000 compiler.py:215(__str__) 935 0.001 0.000 0.001 0.000 type_api.py:53(__init__) 2006 0.001 0.000 0.001 0.000 {method 'union' of 'set' objects} 468 0.001 0.000 0.001 0.000 queue.py:194(_put) 2006 0.001 0.000 0.001 0.000 {method 'keys' of 'dict' objects} 2808 0.001 0.000 0.001 0.000 {thread.get_ident} 603 0.001 0.000 0.001 0.000 path_registry.py:77(__len__) 4343 0.001 0.000 0.001 0.000 interfaces.py:617(setup_query) 468 0.001 0.000 0.001 0.000 queue.py:198(_get) 2006 0.001 0.000 0.001 0.000 _collections.py:155(union) 733 0.001 0.000 0.001 0.000 query.py:2112(_reset_joinpoint) 468 0.001 0.000 0.001 0.000 queue.py:190(_full) 468 0.001 0.000 0.001 0.000 session.py:239(_iterate_parents) 201 0.001 0.000 0.001 0.000 instrumentation.py:302(get_impl) 459 0.001 0.000 0.001 0.000 weakref.py:48(remove) 468 0.001 0.000 0.001 0.000 base.py:255(__init__) 2739 0.001 0.000 0.001 0.000 selectable.py:170(selectable) 603 0.001 0.000 0.001 0.000 weakref.py:69(__getitem__) 603 0.001 0.000 0.001 0.000 {method 'intersection' of 'frozenset' objects} 603 0.001 0.000 0.001 0.000 query.py:224(_adapt_all_clauses) 2006 0.001 0.000 0.001 0.000 {iter} 201 0.001 0.000 0.001 0.000 state.py:277(dict) 2006 0.001 0.000 0.001 0.000 default.py:750(post_exec) 2006 0.001 0.000 0.001 0.000 default.py:747(pre_exec) 1872 0.001 0.000 0.001 0.000 langhelpers.py:825(<lambda>) 468 0.001 0.000 0.001 0.000 base.py:1532(__init__) 1872 0.001 0.000 0.001 0.000 {method 'setdefault' of 'dict' objects} 1380 0.001 0.000 0.001 0.000 vendors.py:488(currency) 468 0.001 0.000 0.001 0.000 pool.py:677(__init__) 201 0.001 0.000 0.001 0.000 collections.py:578(__init__) 468 0.001 0.000 0.001 0.000 {method 'rollback' of 'psycopg2.extensions.connection' objects} 467 0.001 0.000 0.001 0.000 interfaces.py:362(adapter) 2006 0.001 0.000 0.001 0.000 {method 'close' of 'psycopg2.extensions.cursor' objects} 603 0.001 0.000 0.001 0.000 {method 'difference_update' of 'set' objects} 266 0.001 0.000 0.001 0.000 selectable.py:857(<lambda>) 733 0.001 0.000 0.001 0.000 mapper.py:2278(common_parent) 468 0.001 0.000 0.001 0.000 base.py:1537(_parent) 1868 0.001 0.000 0.001 0.000 elements.py:378(_copy_internals) 1380 0.001 0.000 0.001 0.000 collections.py:1038(__set) 468 0.000 0.000 0.000 0.000 {sys._getframe} 733 0.000 0.000 0.000 0.000 query.py:3241(entity_zero_or_selectable) 467 0.000 0.000 0.000 0.000 relationships.py:1384(_get_attr_w_warn_on_none) 468 0.000 0.000 0.000 0.000 queue.py:186(_empty) 468 0.000 0.000 0.000 0.000 {method 'discard' of 'set' objects} 468 0.000 0.000 0.000 0.000 contextlib.py:12(__init__) 733 0.000 0.000 0.000 0.000 {method 'strip' of 'str' objects} 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 elements.py:405(self_group) 468 0.000 0.000 0.000 0.000 interfaces.py:120(create_row_processor) 201 0.000 0.000 0.000 0.000 ti.py:181(url_base) 468 0.000 0.000 0.000 0.000 interfaces.py:111(setup) 468 0.000 0.000 0.000 0.000 default.py:416(do_begin) 468 0.000 0.000 0.000 0.000 {method 'popleft' of 'collections.deque' objects} 467 0.000 0.000 0.000 0.000 base.py:32(_clone) 468 0.000 0.000 0.000 0.000 {method 'append' of 'collections.deque' objects} 201 0.000 0.000 0.000 0.000 vendors.py:324(vpno) 201 0.000 0.000 0.000 0.000 tz.py:47(utcoffset) 201 0.000 0.000 0.000 0.000 {time.time} 201 0.000 0.000 0.000 0.000 {method 'toordinal' of 'datetime.date' objects} 201 0.000 0.000 0.000 0.000 state.py:225(_pending_mutations) 133 0.000 0.000 0.000 0.000 state.py:244(_detach) 1 0.000 0.000 0.000 0.000 attributes.py:145(__clause_element__) 1 0.000 0.000 0.000 0.000 {method 'disable' of '_lsprof.Profiler' objects}