TI Vendor Get Part ProfilingΒΆ
Raw execution profile
SVG of execution profile
Execution Profile
pstats Output
Tue May 24 00:34:56 2016 /media/ldata/code/tendril/profiling/sourcing/get_part/ti.profile 16420859 function calls (16361427 primitive calls) in 29.848 seconds Ordered by: cumulative time ncalls tottime percall cumtime percall filename:lineno(function) 1 0.014 0.014 29.879 29.879 vendors.py:63(profile_vendor_get_part) 202 0.001 0.000 29.860 0.148 vendors.py:509(get_all_vparts) 201 0.001 0.000 26.120 0.130 vendors.py:519(get_vpart) 201 0.002 0.000 26.119 0.130 ti.py:50(__init__) 201 0.001 0.000 26.117 0.130 vendors.py:415(__init__) 201 0.001 0.000 26.115 0.130 vendors.py:236(__init__) 201 0.005 0.000 26.114 0.130 vendors.py:248(_populate) 201 0.007 0.000 15.502 0.077 ti.py:58(_get_data) 3739/1071 0.024 0.000 11.577 0.011 db.py:168(inner) 201 0.010 0.000 9.930 0.049 ti.py:69(_get_product_soup) 402 0.006 0.000 8.619 0.021 www.py:459(get_soup) 402 0.013 0.000 8.345 0.021 __init__.py:80(__init__) 402 0.002 0.000 8.311 0.021 __init__.py:206(_feed) 402 0.003 0.000 8.304 0.021 _lxml.py:221(feed) 201 0.009 0.000 7.867 0.039 vendors.py:265(commit) 201 0.002 0.000 7.849 0.039 vendors.py:420(_commit_to_db) 2006 0.013 0.000 7.757 0.004 query.py:2511(__iter__) 2207 0.008 0.000 7.152 0.003 base.py:846(execute) 2006 0.020 0.000 7.142 0.004 query.py:2525(_execute_and_instances) 2207 0.006 0.000 7.140 0.003 elements.py:322(_execute_on_connection) 2207 0.029 0.000 7.134 0.003 base.py:975(_execute_clauseelement) 201 0.003 0.000 7.074 0.035 vendors.py:272(_commit_to_db) 6372 0.021 0.000 6.650 0.001 element.py:1165(find_all) 6372 0.465 0.000 6.629 0.001 element.py:478(_find_all) 4389 0.019 0.000 6.374 0.001 element.py:1154(find) 2207 0.050 0.000 5.572 0.003 base.py:1061(_execute_context) 384515 0.589 0.000 5.571 0.000 element.py:1525(search) 870 0.023 0.000 5.559 0.006 query.py:2393(all) 402 1.005 0.002 5.384 0.013 {method 'feed' of 'lxml.etree._FeedParser' objects} 9492/8889 0.017 0.000 5.175 0.001 attributes.py:229(__get__) 3281/2678 0.009 0.000 5.161 0.002 attributes.py:556(get) 603 0.005 0.000 5.129 0.009 strategies.py:477(_load_for_state) 603 0.027 0.000 5.117 0.008 strategies.py:550(_emit_lazyload) 2207 0.005 0.000 4.947 0.002 default.py:449(do_execute) 2207 4.914 0.002 4.941 0.002 {method 'execute' of 'psycopg2.extensions.cursor' objects} 103720 0.906 0.000 4.495 0.000 _lxml.py:126(start) 201 0.018 0.000 4.172 0.021 controller.py:181(populate_vpart_prices) 173068 0.529 0.000 4.034 0.000 element.py:1484(search_tag) 202 0.002 0.000 3.739 0.019 vendors.py:504(get_all_vpnos) 133 0.001 0.000 3.702 0.028 maps.py:73(get_all_partnos) 936 0.010 0.000 3.632 0.004 db.py:111(get_session) 103720 0.367 0.000 3.255 0.000 __init__.py:324(handle_starttag) 1136 0.028 0.000 3.059 0.003 query.py:2451(one) 402 0.422 0.001 2.908 0.007 {method 'close' of 'lxml.etree._FeedParser' objects} 266 0.010 0.000 2.789 0.010 controller.py:244(get_map_vpnos) 188686/188134 0.524 0.000 2.694 0.000 element.py:1551(_matches) 467 0.014 0.000 2.411 0.005 controller.py:215(get_map) 468 0.007 0.000 2.354 0.005 contextlib.py:21(__exit__) 870 0.018 0.000 2.313 0.003 session.py:389(commit) 468 0.007 0.000 2.312 0.005 session.py:756(commit) 3296255 1.099 0.000 2.269 0.000 {isinstance} 201 0.040 0.000 2.217 0.011 ti.py:103(_get_prices) 468 0.003 0.000 2.187 0.005 base.py:1569(commit) 468 0.002 0.000 2.183 0.005 base.py:1603(_do_commit) 468 0.010 0.000 2.181 0.005 base.py:679(_commit_impl) 468 0.004 0.000 2.170 0.005 default.py:422(do_commit) 468 2.164 0.005 2.164 0.005 {method 'commit' of 'psycopg2.extensions.connection' objects} 317592 1.117 0.000 2.110 0.000 __init__.py:260(endData) 201 0.004 0.000 2.095 0.010 ti.py:148(_get_package) 133 0.001 0.000 2.006 0.015 vendors.py:88(get_upartnos) 103720 0.293 0.000 1.982 0.000 _lxml.py:175(end) 201 0.004 0.000 1.827 0.009 controller.py:113(get_vpno_obj) 133 0.001 0.000 1.695 0.013 vendors.py:84(get_apartnos) 2006 0.007 0.000 1.513 0.001 elements.py:431(compile) 2006 0.010 0.000 1.506 0.001 elements.py:496(_compiler) 2006 0.039 0.000 1.496 0.001 compiler.py:329(__init__) 133 0.001 0.000 1.495 0.011 controller.py:263(get_umap_vpnos) 2006 0.009 0.000 1.451 0.001 compiler.py:167(__init__) 2006 0.005 0.000 1.441 0.001 compiler.py:212(process) 35699/2006 0.125 0.000 1.436 0.001 visitors.py:75(_compiler_dispatch) 734 0.003 0.000 1.426 0.002 controller.py:45(_get_vendor) 2006 0.065 0.000 1.422 0.001 compiler.py:1503(visit_select) 468 0.006 0.000 1.421 0.003 controller.py:94(get_vendor) 104122 0.581 0.000 1.420 0.000 element.py:745(__init__) 205066 0.420 0.000 1.380 0.000 element.py:1448(_normalize_search_value) 133 0.001 0.000 1.303 0.010 controller.py:257(get_amap_vpnos) 468 0.001 0.000 1.286 0.003 contextlib.py:15(__enter__) 201 0.003 0.000 1.250 0.006 ti.py:159(_get_description) 468 0.012 0.000 1.217 0.003 db.py:83(_get_caller) 366550 0.733 0.000 1.170 0.000 abc.py:128(__instancecheck__) 468 0.002 0.000 1.164 0.002 inspect.py:1053(stack) 468 0.019 0.000 1.161 0.002 inspect.py:1026(getouterframes) 7221 0.074 0.000 1.140 0.000 inspect.py:988(getframeinfo) 201 0.010 0.000 1.066 0.005 controller.py:128(populate_vpart_detail) 629582 0.724 0.000 1.028 0.000 {hasattr} 5258 0.057 0.000 0.808 0.000 loading.py:30(instances) 103720 0.111 0.000 0.808 0.000 __init__.py:351(handle_endtag) 201 0.009 0.000 0.771 0.004 controller.py:154(populate_vpart_detail_eln) 7221 0.093 0.000 0.751 0.000 inspect.py:518(findsource) 4013 0.012 0.000 0.694 0.000 session.py:1970(flush) 103720 0.402 0.000 0.672 0.000 __init__.py:301(_popToTag) 402 0.021 0.000 0.667 0.002 session.py:2021(_flush) 12906 0.105 0.000 0.645 0.000 compiler.py:1275(_label_select_column) 2006 0.035 0.000 0.584 0.000 query.py:2953(_compile_context) 144069 0.248 0.000 0.579 0.000 __init__.py:290(object_was_parsed) 188374 0.212 0.000 0.559 0.000 {method 'decode' of 'str' objects} 84392 0.328 0.000 0.542 0.000 __init__.py:145(_replace_cdata_list_attribute_values) 402 0.007 0.000 0.513 0.001 unitofwork.py:351(execute) 14910 0.147 0.000 0.502 0.000 inspect.py:440(getsourcefile) 12906 0.120 0.000 0.469 0.000 compiler.py:581(visit_label) 248191 0.420 0.000 0.420 0.000 element.py:188(setup) 11557/4141 0.029 0.000 0.417 0.000 operators.py:294(__eq__) 144069 0.157 0.000 0.404 0.000 element.py:648(__new__) 8953/5211 0.016 0.000 0.399 0.000 {operator.eq} 2006 0.042 0.000 0.389 0.000 compiler.py:1679(_compose_select_body) 6086 0.031 0.000 0.377 0.000 base.py:196(generate) 194636 0.118 0.000 0.371 0.000 utf_8.py:15(decode) 727953 0.366 0.000 0.366 0.000 _weakrefset.py:70(__contains__) 2006 0.082 0.000 0.334 0.000 query.py:3282(row_processor) 2338 0.004 0.000 0.333 0.000 attributes.py:174(operate) 387592 0.140 0.000 0.317 0.000 {next} 4609 0.008 0.000 0.314 0.000 elements.py:738(operate) 7549/2739 0.037 0.000 0.306 0.000 visitors.py:86(_compiler_dispatch) 211447 0.304 0.000 0.304 0.000 element.py:666(__getattr__) 195038 0.301 0.000 0.301 0.000 {_codecs.utf_8_decode} 3320 0.060 0.000 0.295 0.000 loading.py:360(_instance) 2207 0.086 0.000 0.292 0.000 default.py:515(_init_compiled) 104122 0.233 0.000 0.286 0.000 __init__.py:251(pushTag) 603 0.003 0.000 0.285 0.000 unitofwork.py:528(execute) 603 0.013 0.000 0.281 0.000 persistence.py:124(save_obj) 4609 0.010 0.000 0.278 0.000 <string>:1(<lambda>) 4609 0.025 0.000 0.268 0.000 type_api.py:57(operate) 402 0.021 0.000 0.268 0.001 www.py:424(fetch) 2207 0.018 0.000 0.262 0.000 psycopg2.py:466(get_result_proxy) 2941 0.021 0.000 0.257 0.000 annotation.py:93(__eq__) 147017 0.122 0.000 0.257 0.000 _lxml.py:194(data) 3674 0.018 0.000 0.250 0.000 compiler.py:904(visit_binary) 2006 0.152 0.000 0.249 0.000 loading.py:269(_instance_processor) 7689 0.034 0.000 0.248 0.000 inspect.py:472(getmodule) 17314 0.133 0.000 0.243 0.000 compiler.py:620(visit_column) 2006 0.034 0.000 0.242 0.000 query.py:3071(_simple_statement) 2207 0.013 0.000 0.234 0.000 result.py:488(__init__) 2006 0.020 0.000 0.232 0.000 compiler.py:1654(_setup_select_stack) 22131 0.084 0.000 0.226 0.000 inspect.py:398(getfile) 3674 0.020 0.000 0.224 0.000 compiler.py:935(_generate_generic_binary) 2006 0.014 0.000 0.224 0.000 query.py:3317(setup_context) 2207 0.018 0.000 0.221 0.000 result.py:513(_init_metadata) 439592 0.195 0.000 0.211 0.000 element.py:1190(descendants) 603 0.008 0.000 0.210 0.000 persistence.py:597(_emit_update_statements) 1871 0.006 0.000 0.209 0.000 properties.py:268(operate) 2006 0.051 0.000 0.208 0.000 loading.py:224(_setup_entity_query) 190275 0.204 0.000 0.204 0.000 {built-in method __new__ of type object at 0x919120} 2006 0.017 0.000 0.200 0.000 <string>:1(select) 3674 0.029 0.000 0.200 0.000 default_comparator.py:21(_boolean_compare) 2006 0.124 0.000 0.200 0.000 result.py:189(__init__) 2006 0.020 0.000 0.198 0.000 selectable.py:2506(_get_display_froms) 733 0.004 0.000 0.198 0.000 query.py:1511(join) 733 0.002 0.000 0.194 0.000 <string>:1(_join) 733 0.009 0.000 0.184 0.000 query.py:1800(_join) 2006 0.062 0.000 0.183 0.000 selectable.py:2220(__init__) 14569 0.040 0.000 0.183 0.000 langhelpers.py:744(__get__) 5349 0.013 0.000 0.183 0.000 inspect.py:460(getabsfile) 2006 0.007 0.000 0.180 0.000 session.py:1245(query) 2006 0.006 0.000 0.172 0.000 query.py:107(__init__) 546767 0.172 0.000 0.172 0.000 {len} 11799 0.024 0.000 0.170 0.000 {method 'join' of 'str' objects} 623878 0.170 0.000 0.170 0.000 {method 'append' of 'list' objects} 457057 0.169 0.000 0.170 0.000 {getattr} 6372 0.075 0.000 0.169 0.000 element.py:1421(__init__) 2006 0.050 0.000 0.168 0.000 selectable.py:2479(_froms) 2006 0.020 0.000 0.166 0.000 query.py:112(_set_entities) 3320 0.046 0.000 0.166 0.000 loading.py:478(_populate_full) 733 0.012 0.000 0.163 0.000 query.py:1915(_join_left_to_right) 935 0.009 0.000 0.160 0.000 compiler.py:735(visit_clauselist) 1608/1206 0.004 0.000 0.157 0.000 errors.py:254(wrapper) 103720 0.126 0.000 0.156 0.000 __init__.py:242(popTag) 5349 0.023 0.000 0.152 0.000 posixpath.py:365(abspath) 2941 0.007 0.000 0.151 0.000 <string>:1(filter) 2805 0.003 0.000 0.145 0.000 compiler.py:742(<genexpr>) 402 0.011 0.000 0.144 0.000 unitofwork.py:300(_generate_actions) 2805 0.004 0.000 0.142 0.000 compiler.py:744(<genexpr>) 17249 0.052 0.000 0.139 0.000 interfaces.py:498(setup) 149831 0.083 0.000 0.137 0.000 __init__.py:356(handle_data) 373606 0.135 0.000 0.135 0.000 _lxml.py:64(_getNsTag) 733 0.006 0.000 0.133 0.000 query.py:2068(_join_to_left) 468 0.007 0.000 0.123 0.000 query.py:1310(filter_by) 733 0.002 0.000 0.123 0.000 util.py:880(join) 2006 0.007 0.000 0.121 0.000 query.py:2518(_connection_from_session) 733 0.011 0.000 0.121 0.000 util.py:779(__init__) 5166 0.006 0.000 0.120 0.000 type_api.py:1009(process) 2006 0.009 0.000 0.114 0.000 session.py:811(connection) 643309 0.113 0.000 0.113 0.000 element.py:918(__nonzero__) 15312 0.029 0.000 0.113 0.000 genericpath.py:15(exists) 5166 0.009 0.000 0.113 0.000 arrow.py:73(process_result_value) 2412 0.019 0.000 0.112 0.000 unitofwork.py:417(execute) 15846 0.058 0.000 0.112 0.000 compiler.py:1130(_truncated_identifier) 6751 0.085 0.000 0.112 0.000 base.py:36(_from_objects) 3674 0.017 0.000 0.111 0.000 default_comparator.py:269(_check_literal) 467 0.005 0.000 0.111 0.000 relationships.py:961(__eq__) 2941 0.029 0.000 0.106 0.000 query.py:1274(filter) 2940 0.017 0.000 0.106 0.000 compiler.py:1048(visit_bindparam) 3585 0.010 0.000 0.104 0.000 api.py:17(get) 1338 0.015 0.000 0.102 0.000 session.py:456(close) 4418/3212 0.017 0.000 0.098 0.000 session.py:312(_connection_for_bind) 733 0.007 0.000 0.098 0.000 selectable.py:651(__init__) 104590 0.097 0.000 0.097 0.000 {range} 2006 0.005 0.000 0.096 0.000 session.py:884(_connection_for_bind) 30121 0.096 0.000 0.096 0.000 {method 'split' of '_sre.SRE_Pattern' objects} 3585 0.030 0.000 0.095 0.000 factory.py:32(get) 50274 0.055 0.000 0.093 0.000 compiler.py:2693(quote) 603 0.003 0.000 0.093 0.000 session.py:1559(add) 2006 0.009 0.000 0.091 0.000 result.py:944(fetchall) 603 0.005 0.000 0.090 0.000 session.py:1588(_save_or_update_state) 15714 0.088 0.000 0.088 0.000 {posix.stat} 1070 0.017 0.000 0.087 0.000 mapper.py:2451(_get_state_attr_by_column) 1870 0.010 0.000 0.085 0.000 elements.py:3370(_bind_param) 2814 0.007 0.000 0.081 0.000 _lxml.py:202(comment) 252638 0.081 0.000 0.081 0.000 {method 'get' of 'dict' objects} 603 0.030 0.000 0.081 0.000 mapper.py:2555(cascade_iterator) 733 0.003 0.000 0.080 0.000 selectable.py:786(_match_primaries) 402 0.031 0.000 0.079 0.000 {method 'read' of '_io.TextIOWrapper' objects} 733 0.007 0.000 0.077 0.000 selectable.py:793(_join_condition) 5349 0.047 0.000 0.076 0.000 posixpath.py:336(normpath) 16705 0.038 0.000 0.075 0.000 inspection.py:38(inspect) 1806 0.008 0.000 0.075 0.000 session.py:694(begin) 1870 0.044 0.000 0.074 0.000 elements.py:913(__init__) 21592 0.074 0.000 0.074 0.000 interfaces.py:466(_get_context_loader) 2940 0.010 0.000 0.074 0.000 compiler.py:1117(_truncate_bindparam) 2006 0.017 0.000 0.074 0.000 selectable.py:3151(_columns_plus_names) 127099 0.072 0.000 0.072 0.000 {method 'items' of 'dict' objects} 6372 0.021 0.000 0.071 0.000 element.py:1609(__init__) 3273/2339 0.010 0.000 0.070 0.000 annotation.py:71(_compiler_dispatch) 402 0.009 0.000 0.069 0.000 __init__.py:336(getinfo) 104122 0.052 0.000 0.069 0.000 __init__.py:255(set_up_substitutions) 104122 0.068 0.000 0.068 0.000 __init__.py:101(can_be_empty_element) 4745 0.020 0.000 0.067 0.000 _collections.py:794(to_list) 4140 0.021 0.000 0.065 0.000 locale.py:305(atof) 1806 0.013 0.000 0.063 0.000 session.py:169(__init__) 1870/935 0.003 0.000 0.063 0.000 operators.py:43(__and__) 18429 0.063 0.000 0.063 0.000 {method 'match' of '_sre.SRE_Pattern' objects} 2006 0.018 0.000 0.062 0.000 query.py:122(_set_entity_selectables) 468 0.006 0.000 0.062 0.000 base.py:2020(contextual_connect) 934 0.004 0.000 0.061 0.000 elements.py:2758(_copy_internals) 2006 0.004 0.000 0.061 0.000 result.py:911(_fetchall_impl) 74550 0.041 0.000 0.061 0.000 string.py:220(lower) 1809 0.007 0.000 0.061 0.000 persistence.py:1017(_connections_for_states) 733 0.007 0.000 0.060 0.000 compiler.py:1803(visit_join) 12906 0.019 0.000 0.059 0.000 default.py:753(get_result_processor) 603 0.007 0.000 0.058 0.000 strategies.py:448(_generate_lazy_clause) 467 0.007 0.000 0.058 0.000 relationships.py:1334(_optimized_compare) 1403 0.005 0.000 0.057 0.000 elements.py:1890(and_) 468 0.006 0.000 0.057 0.000 session.py:2646(__call__) 2006 0.033 0.000 0.057 0.000 {method 'fetchall' of 'psycopg2.extensions.cursor' objects} 402 0.003 0.000 0.055 0.000 __init__.py:218(open) 6018 0.029 0.000 0.055 0.000 _collections.py:747(unique_list) 3252 0.021 0.000 0.054 0.000 instrumentation.py:311(new_instance) 2207 0.015 0.000 0.053 0.000 compiler.py:455(construct_params) 3674 0.031 0.000 0.053 0.000 elements.py:2724(__init__) 935 0.002 0.000 0.052 0.000 {operator.and_} 1403 0.019 0.000 0.052 0.000 elements.py:1856(_construct) 159767 0.051 0.000 0.051 0.000 {method 'lower' of 'str' objects} 467 0.002 0.000 0.051 0.000 visitors.py:280(cloned_traverse) 468 0.003 0.000 0.051 0.000 base.py:793(close) 2207 0.012 0.000 0.051 0.000 psycopg2.py:435(create_cursor) 6123 0.021 0.000 0.051 0.000 element.py:494(<genexpr>) 468 0.008 0.000 0.050 0.000 session.py:512(__init__) 2006 0.015 0.000 0.050 0.000 compiler.py:438(_bind_processors) 402 0.001 0.000 0.049 0.000 codecs.py:293(decode) 1401/467 0.013 0.000 0.048 0.000 visitors.py:287(clone) 468 0.002 0.000 0.048 0.000 pool.py:879(close) 2006 0.011 0.000 0.048 0.000 query.py:3159(__new__) 2940 0.016 0.000 0.048 0.000 elements.py:3624(apply_map) 37041 0.027 0.000 0.047 0.000 inspect.py:51(ismodule) 10986 0.012 0.000 0.047 0.000 re.py:188(compile) 2942 0.012 0.000 0.047 0.000 base.py:285(__get__) 468 0.002 0.000 0.046 0.000 pool.py:756(_checkin) 603 0.001 0.000 0.046 0.000 strategy_options.py:781(lazyload) 147051 0.046 0.000 0.046 0.000 {method 'join' of 'unicode' objects} 19328 0.046 0.000 0.046 0.000 _abcoll.py:389(keys) 467 0.002 0.000 0.046 0.000 util.py:746(_orm_annotate) 4343 0.019 0.000 0.045 0.000 interfaces.py:507(create_row_processor) 603 0.002 0.000 0.045 0.000 unitofwork.py:557(execute) 603 0.002 0.000 0.045 0.000 <string>:1(set_relationship_strategy) 1206 0.006 0.000 0.044 0.000 persistence.py:256(_organize_states_for_save) 468 0.004 0.000 0.044 0.000 pool.py:615(_finalize_fairy) 467 0.001 0.000 0.044 0.000 annotation.py:106(_deep_annotate) 1401/467 0.006 0.000 0.043 0.000 annotation.py:113(clone) 935 0.002 0.000 0.043 0.000 default_comparator.py:89(_conjunction_operate) 603 0.002 0.000 0.043 0.000 base.py:40(_generative) 603 0.010 0.000 0.043 0.000 persistence.py:223(delete_obj) 733 0.011 0.000 0.043 0.000 selectable.py:847(_joincond_scan_left_right) 4347 0.007 0.000 0.042 0.000 _collections.py:727(__missing__) 2760 0.002 0.000 0.042 0.000 locale.py:318(atoi) 1206 0.009 0.000 0.042 0.000 __init__.py:156(getsyspath) 2006 0.014 0.000 0.042 0.000 _collections.py:359(__init__) 12906 0.022 0.000 0.040 0.000 type_api.py:382(_cached_result_processor) 29352 0.023 0.000 0.040 0.000 inspect.py:59(isclass) 2412 0.018 0.000 0.039 0.000 relationships.py:1504(cascade_iterator) 8280 0.005 0.000 0.038 0.000 locale.py:110(localeconv) 468 0.005 0.000 0.038 0.000 db.py:69(_format_frame) 467 0.001 0.000 0.038 0.000 elements.py:1168(effective_value) 468 0.001 0.000 0.038 0.000 base.py:2071(_wrap_pool_connect) 2207 0.006 0.000 0.037 0.000 pool.py:845(cursor) 402 0.023 0.000 0.037 0.000 {_io.open} 5005 0.015 0.000 0.037 0.000 base.py:389(_inspect_mapped_class) 402 0.004 0.000 0.037 0.000 unitofwork.py:375(finalize_flush_changes) 467 0.001 0.000 0.037 0.000 relationships.py:1385(_go) 402 0.003 0.000 0.037 0.000 _lxml.py:197(doctype) 1806 0.017 0.000 0.037 0.000 session.py:256(_take_snapshot) 468 0.002 0.000 0.036 0.000 pool.py:367(connect) 208740 0.036 0.000 0.036 0.000 {callable} 1206 0.005 0.000 0.036 0.000 unitofwork.py:228(register_object) 36573 0.022 0.000 0.036 0.000 inspect.py:181(istraceback) 1401 0.005 0.000 0.035 0.000 elements.py:291(_annotate) 134 0.000 0.000 0.035 0.000 vendors.py:500(get_idents) 2942 0.006 0.000 0.035 0.000 base.py:108(_for_instance) 603 0.004 0.000 0.035 0.000 strategy_options.py:190(set_relationship_strategy) 1 0.001 0.001 0.035 0.035 vendors.py:77(get_idents) 468 0.004 0.000 0.035 0.000 pool.py:710(_checkout) 2006 0.004 0.000 0.035 0.000 compiler.py:441(<genexpr>) 10986 0.026 0.000 0.034 0.000 re.py:226(_compile) 12906 0.013 0.000 0.034 0.000 result.py:497(_getter) 109746 0.034 0.000 0.034 0.000 {method 'pop' of 'list' objects} 3585 0.016 0.000 0.034 0.000 arrow.py:118(fromdatetime) 2006 0.008 0.000 0.033 0.000 base.py:325(_is_mapped_class) 8280 0.033 0.000 0.033 0.000 {_locale.localeconv} 402 0.009 0.000 0.033 0.000 session.py:1491(_register_newly_persistent) 14910 0.032 0.000 0.032 0.000 {imp.get_suffixes} 468 0.003 0.000 0.032 0.000 session.py:1031(close) 1206 0.011 0.000 0.031 0.000 persistence.py:1052(_sort_states) 3384 0.009 0.000 0.031 0.000 element.py:846(get_text) 2207 0.031 0.000 0.031 0.000 {method 'cursor' of 'psycopg2.extensions.connection' objects} 18788 0.031 0.000 0.031 0.000 weakref.py:314(__getitem__) 86599 0.031 0.000 0.031 0.000 {method 'keys' of 'dict' objects} 4946 0.015 0.000 0.031 0.000 compiler.py:442(<genexpr>) 2006 0.019 0.000 0.030 0.000 query.py:3190(setup_entity) 3409 0.007 0.000 0.030 0.000 elements.py:2783(self_group) 4344 0.013 0.000 0.030 0.000 operators.py:895(is_precedent) 402 0.001 0.000 0.030 0.000 __init__.py:235(exists) 468 0.005 0.000 0.030 0.000 pool.py:478(checkout) 30711 0.021 0.000 0.030 0.000 element.py:890(get) 1 0.000 0.000 0.029 0.029 controller.py:279(get_vendor_idents) 2942 0.010 0.000 0.029 0.000 base.py:105(_for_class) 6555 0.021 0.000 0.029 0.000 posixpath.py:68(join) 468 0.003 0.000 0.029 0.000 session.py:1076(_close_impl) 12906 0.024 0.000 0.029 0.000 strategies.py:141(setup_query) 2006 0.026 0.000 0.028 0.000 query.py:3715(__init__) 468 0.004 0.000 0.028 0.000 pool.py:501(checkin) 12906 0.011 0.000 0.028 0.000 compiler.py:2722(format_label) 29754 0.019 0.000 0.028 0.000 inspect.py:67(ismethod) 20934 0.028 0.000 0.028 0.000 {method 'update' of 'dict' objects} 2337 0.010 0.000 0.027 0.000 elements.py:3513(__new__) 603 0.011 0.000 0.027 0.000 unitofwork.py:257(_per_mapper_flush_actions) 3252 0.027 0.000 0.027 0.000 state.py:75(__init__) 2940 0.018 0.000 0.027 0.000 compiler.py:1149(_process_anon) 1401 0.009 0.000 0.027 0.000 elements.py:3919(__init__) 29754 0.017 0.000 0.026 0.000 inspect.py:142(isfunction) 6086 0.016 0.000 0.026 0.000 query.py:416(_clone) 36573 0.020 0.000 0.026 0.000 inspect.py:191(isframe) 402 0.002 0.000 0.025 0.000 element.py:937(__getattr__) 3015 0.012 0.000 0.025 0.000 unitofwork.py:178(get_attribute_history) 5549 0.009 0.000 0.025 0.000 default.py:592(<genexpr>) 603 0.002 0.000 0.024 0.000 query.py:1090(options) 603 0.001 0.000 0.024 0.000 persistence.py:336(_organize_states_for_delete) 3472 0.012 0.000 0.024 0.000 selectable.py:35(_interpret_as_from) 6220 0.014 0.000 0.024 0.000 __init__.py:1345(isEnabledFor) 3585 0.024 0.000 0.024 0.000 util.py:25(is_timestamp) 4682 0.021 0.000 0.024 0.000 {sorted} 468 0.001 0.000 0.024 0.000 pool.py:388(_return_conn) 12906 0.021 0.000 0.024 0.000 selectable.py:3156(name_for_col) 804 0.013 0.000 0.024 0.000 persistence.py:416(_collect_update_commands) 2609 0.009 0.000 0.023 0.000 path_registry.py:62(set) 103720 0.023 0.000 0.023 0.000 _lxml.py:166(_prefix_for_namespace) 7371 0.009 0.000 0.023 0.000 element.py:821(_all_strings) 603 0.001 0.000 0.023 0.000 <string>:1(_options) 1608 0.006 0.000 0.023 0.000 attributes.py:222(__set__) 468 0.002 0.000 0.022 0.000 pool.py:1030(_do_return_conn) 6030 0.009 0.000 0.022 0.000 unitofwork.py:402(<genexpr>) 603 0.003 0.000 0.022 0.000 dependency.py:445(presort_saves) 5608 0.011 0.000 0.022 0.000 base.py:208(manager_of_class) 402 0.005 0.000 0.022 0.000 urlparse.py:251(urljoin) 12906 0.022 0.000 0.022 0.000 result.py:419(_getter) 3615 0.007 0.000 0.021 0.000 attr.py:214(__call__) 29754 0.017 0.000 0.021 0.000 inspect.py:209(iscode) 1206 0.006 0.000 0.021 0.000 session.py:229(connection) 468 0.006 0.000 0.020 0.000 queue.py:87(put) 603 0.008 0.000 0.020 0.000 strategy_options.py:110(_generate_path) 603 0.006 0.000 0.020 0.000 mapper.py:1774(_is_orphan) 9495 0.020 0.000 0.020 0.000 {method 'search' of '_sre.SRE_Pattern' objects} 12906 0.019 0.000 0.019 0.000 compiler.py:271(__init__) 402 0.015 0.000 0.019 0.000 topological.py:55(find_cycles) 999 0.003 0.000 0.019 0.000 schema.py:1635(get_referent) 3987 0.013 0.000 0.019 0.000 arrow.py:49(__init__) 12777 0.019 0.000 0.019 0.000 attr.py:226(__bool__) 4012 0.004 0.000 0.019 0.000 selectable.py:2438(<genexpr>) 468 0.007 0.000 0.019 0.000 base.py:47(__init__) 12906 0.014 0.000 0.019 0.000 compiler.py:1272(_add_to_result_map) 2942 0.013 0.000 0.019 0.000 base.py:74(__init__) 468 0.002 0.000 0.018 0.000 pool.py:1039(_do_get) 2474 0.012 0.000 0.018 0.000 langhelpers.py:1033(_next) 2412 0.007 0.000 0.018 0.000 dependency.py:230(prop_has_changes) 467 0.006 0.000 0.018 0.000 elements.py:1183(_clone) 201 0.003 0.000 0.018 0.000 attributes.py:1066(set_committed_value) 39486 0.017 0.000 0.017 0.000 {method 'startswith' of 'str' objects} 2006 0.009 0.000 0.017 0.000 query.py:306(_bind_mapper) 468 0.001 0.000 0.017 0.000 <string>:1(and_) 2006 0.014 0.000 0.017 0.000 elements.py:3665(_select_iterables) 2006 0.005 0.000 0.017 0.000 session.py:1279(_autoflush) 603 0.007 0.000 0.017 0.000 query.py:1105(_options) 3077 0.005 0.000 0.017 0.000 __init__.py:1130(debug) 4481 0.011 0.000 0.017 0.000 session.py:2016(_is_clean) 1608 0.008 0.000 0.017 0.000 attributes.py:687(set) 2412 0.003 0.000 0.017 0.000 topological.py:43(sort) 999 0.011 0.000 0.016 0.000 selectable.py:450(corresponding_column) 402 0.001 0.000 0.016 0.000 __init__.py:328(_stat) 4949 0.013 0.000 0.016 0.000 base.py:89(__getattr__) 17182 0.016 0.000 0.016 0.000 {method 'copy' of 'dict' objects} 804 0.002 0.000 0.016 0.000 unitofwork.py:482(execute) 5349 0.016 0.000 0.016 0.000 {posix.getcwd} 870 0.009 0.000 0.016 0.000 session.py:358(_prepare_impl) 2006 0.014 0.000 0.016 0.000 query.py:3107(_adjust_for_single_inheritance) 468 0.005 0.000 0.016 0.000 queue.py:130(get) 934 0.008 0.000 0.016 0.000 elements.py:235(_clone) 935 0.010 0.000 0.016 0.000 elements.py:1821(_from_objects) 5628 0.009 0.000 0.015 0.000 __init__.py:339(<genexpr>) 3212 0.010 0.000 0.015 0.000 session.py:1142(get_bind) 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) 7221 0.008 0.000 0.015 0.000 <string>:8(__new__) 402 0.015 0.000 0.015 0.000 {dir} 402 0.006 0.000 0.015 0.000 dependency.py:68(per_property_flush_actions) 402 0.005 0.000 0.015 0.000 aggregates.py:535(construct_aggregate_queries) 3252 0.009 0.000 0.014 0.000 state.py:251(_cleanup) 3015 0.009 0.000 0.014 0.000 unitofwork.py:399(_mappers) 5279 0.006 0.000 0.014 0.000 elements.py:3765(_expression_literal_as_text) 804 0.004 0.000 0.014 0.000 urlparse.py:137(urlparse) 2408 0.014 0.000 0.014 0.000 {method 'encode' of 'unicode' objects} 9555 0.012 0.000 0.014 0.000 element.py:258(_last_descendant) 14975 0.014 0.000 0.014 0.000 elements.py:3292(_get_table) 1809 0.010 0.000 0.013 0.000 topological.py:16(sort_as_subsets) 12906 0.013 0.000 0.013 0.000 compiler.py:280(type) 1206 0.013 0.000 0.013 0.000 {built-in method fromtimestamp} 402 0.004 0.000 0.013 0.000 inspect.py:804(getargspec) 201 0.000 0.000 0.013 0.000 type_api.py:961(process) 402 0.002 0.000 0.013 0.000 locale.py:608(getpreferredencoding) 4770 0.007 0.000 0.013 0.000 session.py:1967(_contains_state) 12906 0.007 0.000 0.012 0.000 elements.py:3839(_interpret_as_column_or_from) 2337 0.008 0.000 0.012 0.000 elements.py:3469(__new__) 7348 0.012 0.000 0.012 0.000 elements.py:698(self_group) 201 0.001 0.000 0.012 0.000 arrow.py:68(process_bind_param) 2207 0.008 0.000 0.012 0.000 result.py:637(_soft_close) 468 0.005 0.000 0.012 0.000 pool.py:764(_reset) 2740 0.007 0.000 0.012 0.000 compiler.py:1788(visit_table) 5616 0.012 0.000 0.012 0.000 weakref.py:282(__init__) 43527 0.011 0.000 0.011 0.000 {method 'add' of 'set' objects} 5349 0.006 0.000 0.011 0.000 posixpath.py:59(isabs) 5608 0.011 0.000 0.011 0.000 {method 'get' of 'dictproxy' objects} 935 0.003 0.000 0.011 0.000 elements.py:1967(self_group) 21058 0.011 0.000 0.011 0.000 {method 'intersection' of 'set' objects} 804 0.002 0.000 0.011 0.000 dependency.py:581(_pks_changed) 936 0.008 0.000 0.011 0.000 threading.py:146(acquire) 1206 0.004 0.000 0.011 0.000 base.py:288(validatepath) 3674 0.011 0.000 0.011 0.000 elements.py:2754(_from_objects) 402 0.004 0.000 0.011 0.000 __init__.py:216(reset) 2006 0.010 0.000 0.010 0.000 result.py:928(process_rows) 6220 0.010 0.000 0.010 0.000 __init__.py:1331(getEffectiveLevel) 7285 0.006 0.000 0.010 0.000 elements.py:3769(_literal_as_text) 1206 0.002 0.000 0.010 0.000 locale.py:564(setlocale) 402 0.005 0.000 0.010 0.000 state.py:611(_commit_all_states) 468 0.002 0.000 0.010 0.000 base.py:534(begin) 3269 0.004 0.000 0.010 0.000 langhelpers.py:750(_reset) 7766 0.010 0.000 0.010 0.000 session.py:190(_assert_active) 1401 0.005 0.000 0.010 0.000 annotation.py:45(__init__) 603 0.001 0.000 0.009 0.000 <string>:1(params) 1809 0.005 0.000 0.009 0.000 unitofwork.py:293(states_for_mapper_hierarchy) 4020 0.009 0.000 0.009 0.000 state.py:277(dict) 6354 0.009 0.000 0.009 0.000 {method 'split' of 'str' objects} 402 0.005 0.000 0.009 0.000 _lxml.py:45(parser_for) 804 0.004 0.000 0.009 0.000 sync.py:106(source_modified) 603 0.002 0.000 0.009 0.000 instrumentation.py:354(has_parent) 402 0.002 0.000 0.009 0.000 session.py:234(_begin) 8442 0.005 0.000 0.009 0.000 _collections.py:688(<genexpr>) 1206 0.009 0.000 0.009 0.000 {_locale.setlocale} 804 0.005 0.000 0.008 0.000 urlparse.py:168(urlsplit) 468 0.006 0.000 0.008 0.000 session.py:1082(expunge_all) 1206 0.002 0.000 0.008 0.000 path.py:20(normpath) 402 0.003 0.000 0.008 0.000 session.py:1959(__iter__) 468 0.003 0.000 0.008 0.000 base.py:1595(__init__) 4602 0.008 0.000 0.008 0.000 elements.py:3657(_expand_cloned) 935 0.002 0.000 0.008 0.000 elements.py:1825(self_group) 14442 0.008 0.000 0.008 0.000 {max} 201 0.001 0.000 0.008 0.000 default.py:807(_setup_crud_result_proxy) 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) 1206 0.002 0.000 0.008 0.000 unitofwork.py:503(_elements) 2207 0.007 0.000 0.008 0.000 default.py:692(should_autocommit) 402 0.006 0.000 0.008 0.000 inspect.py:744(getargs) 603 0.005 0.000 0.007 0.000 attributes.py:900(get_all_pending) 2006 0.007 0.000 0.007 0.000 query.py:2638(_select_args) 603 0.005 0.000 0.007 0.000 state.py:565(_commit) 1070 0.005 0.000 0.007 0.000 elements.py:2742(__bool__) 603 0.006 0.000 0.007 0.000 mapper.py:2397(_identity_key_from_state) 9660 0.007 0.000 0.007 0.000 {method 'replace' of 'unicode' objects} 1206 0.007 0.000 0.007 0.000 _collections.py:315(values) 1608 0.006 0.000 0.007 0.000 state.py:524(_modified_event) 3855 0.007 0.000 0.007 0.000 {method 'issuperset' of 'frozenset' objects} 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) 5373 0.007 0.000 0.007 0.000 identity.py:106(contains_state) 402 0.005 0.000 0.007 0.000 __init__.py:38(lookup) 2207 0.006 0.000 0.006 0.000 {sqlalchemy.cutils._distill_params} 733 0.005 0.000 0.006 0.000 query.py:1983(_prepare_right_side) 2006 0.005 0.000 0.006 0.000 query.py:3180(__init__) 603 0.001 0.000 0.006 0.000 path_registry.py:250(entity_path) 7221 0.006 0.000 0.006 0.000 linecache.py:33(getlines) 4481 0.006 0.000 0.006 0.000 identity.py:53(check_modified) 936 0.004 0.000 0.006 0.000 threading.py:372(notify) 3674 0.005 0.000 0.006 0.000 type_api.py:1137(to_instance) 468 0.003 0.000 0.006 0.000 weakref.py:98(__setitem__) 3618 0.005 0.000 0.006 0.000 unitofwork.py:454(__new__) 1206 0.001 0.000 0.006 0.000 dependency.py:59(per_property_preprocessors) 201 0.001 0.000 0.006 0.000 dependency.py:541(process_saves) 201 0.002 0.000 0.006 0.000 attributes.py:976(_initialize_collection) 603 0.001 0.000 0.006 0.000 strategy_options.py:94(process_query) 19663 0.006 0.000 0.006 0.000 {method 'update' of 'set' objects} 3987 0.003 0.000 0.006 0.000 util.py:37(isstr) 402 0.001 0.000 0.006 0.000 attributes.py:629(set_committed_value) 603 0.004 0.000 0.006 0.000 persistence.py:918(_finalize_insert_update_commands) 2474 0.005 0.000 0.006 0.000 query.py:289(_mapper_zero) 733 0.003 0.000 0.006 0.000 selectable.py:1057(_hide_froms) 201 0.002 0.000 0.006 0.000 arrow.py:425(to) 4221 0.006 0.000 0.006 0.000 _collections.py:687(__iter__) 468 0.002 0.000 0.006 0.000 base.py:359(_entity_descriptor) 201 0.005 0.000 0.006 0.000 www.py:138(strencode) 3119 0.004 0.000 0.006 0.000 identity.py:190(_fast_discard) 8163 0.006 0.000 0.006 0.000 {method 'endswith' of 'str' objects} 2941 0.006 0.000 0.006 0.000 query.py:228(_adapt_clause) 201 0.001 0.000 0.006 0.000 persistence.py:1047(<lambda>) 603 0.003 0.000 0.006 0.000 strategy_options.py:86(_generate) 1380 0.003 0.000 0.006 0.000 vendors.py:205(__init__) 201 0.002 0.000 0.006 0.000 vendors.py:408(__repr__) 3269 0.004 0.000 0.006 0.000 langhelpers.py:753(reset) 468 0.003 0.000 0.005 0.000 default.py:419(do_rollback) 1608 0.002 0.000 0.005 0.000 type_api.py:276(compare_values) 603 0.003 0.000 0.005 0.000 attributes.py:474(hasparent) 9632 0.005 0.000 0.005 0.000 {method 'values' of 'dict' objects} 4012 0.005 0.000 0.005 0.000 query.py:3262(_get_entity_clauses) 2006 0.005 0.000 0.005 0.000 selectable.py:1695(__init__) 2006 0.005 0.000 0.005 0.000 path_registry.py:70(get) 603 0.001 0.000 0.005 0.000 <string>:1(_with_invoke_all_eagers) 733 0.004 0.000 0.005 0.000 selectable.py:1062(_from_objects) 603 0.000 0.000 0.005 0.000 element.py:841(stripped_strings) 603 0.002 0.000 0.005 0.000 path_registry.py:254(__getitem__) 936 0.004 0.000 0.005 0.000 threading.py:186(release) 603 0.002 0.000 0.005 0.000 dependency.py:708(presort_saves) 402 0.003 0.000 0.005 0.000 identity.py:163(values) 870 0.005 0.000 0.005 0.000 {method 'format' of 'str' objects} 201 0.001 0.000 0.005 0.000 base.py:149(execution_options) 468 0.004 0.000 0.005 0.000 base.py:642(_begin_impl) 1206 0.003 0.000 0.005 0.000 __init__.py:187(getmeta) 3252 0.005 0.000 0.005 0.000 identity.py:140(_add_unpresent) 603 0.003 0.000 0.005 0.000 strategy_options.py:100(_process) 3410 0.005 0.000 0.005 0.000 {method 'acquire' of 'thread.lock' objects} 1206 0.003 0.000 0.005 0.000 unitofwork.py:223(register_preprocessor) 603 0.003 0.000 0.005 0.000 persistence.py:720(_emit_insert_statements) 201 0.001 0.000 0.005 0.000 type_api.py:1057(compare_values) 603 0.003 0.000 0.005 0.000 _collections.py:183(__iter__) 5829 0.005 0.000 0.005 0.000 {method 'difference' of 'set' objects} 2408 0.003 0.000 0.005 0.000 _collections.py:155(union) 1809 0.005 0.000 0.005 0.000 attributes.py:752(get_all_pending) 3252 0.004 0.000 0.004 0.000 <string>:1(set) 1005 0.003 0.000 0.004 0.000 attributes.py:740(get_history) 603 0.002 0.000 0.004 0.000 strategy_options.py:185(_coerce_strat) 935 0.003 0.000 0.004 0.000 elements.py:716(comparator) 2207 0.004 0.000 0.004 0.000 base.py:1220(_safe_close_cursor) 4008 0.004 0.000 0.004 0.000 annotation.py:90(__hash__) 603 0.003 0.000 0.004 0.000 query.py:1254(params) 201 0.002 0.000 0.004 0.000 collections.py:659(append_multiple_without_event) 402 0.001 0.000 0.004 0.000 element.py:69(__new__) 603 0.003 0.000 0.004 0.000 persistence.py:835(_emit_delete_statements) 1401 0.003 0.000 0.004 0.000 annotation.py:31(__new__) 201 0.001 0.000 0.004 0.000 dependency.py:495(process_deletes) 1403 0.003 0.000 0.004 0.000 _collections.py:787(coerce_generator_arg) 2850 0.004 0.000 0.004 0.000 {method 'remove' of 'list' objects} 201 0.000 0.000 0.004 0.000 api.py:25(utcnow) 603 0.001 0.000 0.004 0.000 session.py:1842(_save_or_update_impl) 402 0.003 0.000 0.004 0.000 session.py:1542(_register_altered) 733 0.003 0.000 0.004 0.000 controller.py:57(_get_ident) 1206 0.003 0.000 0.004 0.000 persistence.py:1044(_cached_connection_dict) 5005 0.004 0.000 0.004 0.000 instrumentation.py:94(is_mapped) 8442 0.004 0.000 0.004 0.000 _collections.py:689(<genexpr>) 2207 0.003 0.000 0.004 0.000 _collections.py:394(__iter__) 603 0.003 0.000 0.004 0.000 _collections.py:805(has_intersection) 402 0.000 0.000 0.004 0.000 __init__.py:35(_os_stat) 467 0.003 0.000 0.004 0.000 relationships.py:1363(visit_bindparam) 3320 0.004 0.000 0.004 0.000 identity.py:145(get) 9190 0.004 0.000 0.004 0.000 {method 'pop' of 'dict' objects} 201 0.001 0.000 0.004 0.000 dependency.py:745(process_saves) 402 0.001 0.000 0.004 0.000 element.py:725(for_name_and_ids) 201 0.000 0.000 0.004 0.000 factory.py:206(utcnow) 3674 0.004 0.000 0.004 0.000 query.py:389(_no_limit_offset) 201 0.001 0.000 0.004 0.000 arrow.py:78(_coerce) 1206 0.002 0.000 0.004 0.000 _collections.py:846(flatten_iterator) 402 0.001 0.000 0.004 0.000 attributes.py:675(get_history) 603 0.002 0.000 0.003 0.000 session.py:37(_state_session) 201 0.002 0.000 0.003 0.000 arrow.py:700(__eq__) 3674 0.003 0.000 0.003 0.000 query.py:381(_no_statement_condition) 402 0.003 0.000 0.003 0.000 unitofwork.py:109(__init__) 468 0.002 0.000 0.003 0.000 base.py:116(_join) 12625 0.003 0.000 0.003 0.000 mapper.py:642(mapper) 2006 0.003 0.000 0.003 0.000 {zip} 201 0.001 0.000 0.003 0.000 instrumentation.py:290(initialize_collection) 402 0.003 0.000 0.003 0.000 {time.mktime} 3342 0.003 0.000 0.003 0.000 {_codecs.utf_8_encode} 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:758(_select_iterable) 201 0.001 0.000 0.003 0.000 arrow.py:76(utcnow) 12906 0.003 0.000 0.003 0.000 elements.py:3521(apply_map) 2760 0.003 0.000 0.003 0.000 {method 'group' of '_sre.SRE_Match' objects} 6404 0.003 0.000 0.003 0.000 mapper.py:1965(selectable) 2207 0.003 0.000 0.003 0.000 result.py:632(_cursor_description) 1206 0.003 0.000 0.003 0.000 unitofwork.py:282(<lambda>) 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__) 936 0.002 0.000 0.003 0.000 pool.py:854(__getattr__) 3819 0.003 0.000 0.003 0.000 {method 'difference_update' of 'set' objects} 603 0.002 0.000 0.003 0.000 base.py:314(_generate) 3614 0.003 0.000 0.003 0.000 _collections.py:724(__init__) 1809 0.003 0.000 0.003 0.000 mapper.py:2652(_memo) 4949 0.003 0.000 0.003 0.000 {setattr} 7221 0.003 0.000 0.003 0.000 {min} 13715 0.003 0.000 0.003 0.000 {id} 1206 0.003 0.000 0.003 0.000 interfaces.py:486(_get_strategy) 936 0.003 0.000 0.003 0.000 identity.py:14(__init__) 2412 0.003 0.000 0.003 0.000 relationships.py:1731(_get_cascade) 7634 0.003 0.000 0.003 0.000 {iter} 468 0.001 0.000 0.003 0.000 log.py:54(_should_log_debug) 603 0.002 0.000 0.003 0.000 _collections.py:312(keys) 402 0.003 0.000 0.003 0.000 {method 'timetuple' of 'datetime.datetime' objects} 603 0.002 0.000 0.003 0.000 session.py:1818(_update_impl) 870 0.002 0.000 0.003 0.000 identity.py:184(all_states) 603 0.002 0.000 0.003 0.000 path_registry.py:283(__getitem__) 402 0.002 0.000 0.003 0.000 attributes.py:1303(from_scalar_attribute) 804 0.003 0.000 0.003 0.000 instrumentation.py:302(get_impl) 603 0.003 0.000 0.003 0.000 path_registry.py:267(__init__) 733 0.002 0.000 0.003 0.000 query.py:3245(corresponds_to) 2412 0.002 0.000 0.002 0.000 {method 'startswith' of 'unicode' objects} 468 0.002 0.000 0.002 0.000 session.py:297(_remove_snapshot) 1380 0.002 0.000 0.002 0.000 collections.py:1071(append) 1206 0.002 0.000 0.002 0.000 {method 'replace' of 'str' objects} 468 0.001 0.000 0.002 0.000 log.py:57(_should_log_info) 468 0.002 0.000 0.002 0.000 pool.py:559(get_connection) 3541 0.002 0.000 0.002 0.000 {hash} 201 0.002 0.000 0.002 0.000 persistence.py:959(_postfetch) 1005 0.001 0.000 0.002 0.000 session.py:1533(<genexpr>) 468 0.002 0.000 0.002 0.000 contextlib.py:82(helper) 1380 0.002 0.000 0.002 0.000 currency.py:219(__init__) 2006 0.002 0.000 0.002 0.000 base.py:1472(get_select_precolumns) 402 0.002 0.000 0.002 0.000 codecs.py:284(__init__) 201 0.002 0.000 0.002 0.000 {method 'astimezone' of 'datetime.datetime' objects} 733 0.002 0.000 0.002 0.000 elements.py:269(_cloned_set) 201 0.000 0.000 0.002 0.000 urllib.py:1290(quote_plus) 804 0.002 0.000 0.002 0.000 unitofwork.py:475(__init__) 468 0.002 0.000 0.002 0.000 weakref.py:267(__init__) 402 0.002 0.000 0.002 0.000 {_hashlib.openssl_md5} 1206 0.002 0.000 0.002 0.000 unitofwork.py:411(__init__) 2808 0.002 0.000 0.002 0.000 base.py:301(connection) 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>) 3618 0.002 0.000 0.002 0.000 attributes.py:1251(__bool__) 4206 0.002 0.000 0.002 0.000 selectable.py:1418(_from_objects) 402 0.001 0.000 0.002 0.000 urlparse.py:223(urlunparse) 402 0.002 0.000 0.002 0.000 collections.py:687(__iter__) 402 0.001 0.000 0.002 0.000 six.py:552(iteritems) 2274 0.002 0.000 0.002 0.000 session.py:225(_is_transaction_boundary) 5349 0.002 0.000 0.002 0.000 posixpath.py:51(normcase) 4812 0.002 0.000 0.002 0.000 {method 'strip' of 'unicode' objects} 1206 0.001 0.000 0.002 0.000 identity.py:72(__len__) 1206 0.001 0.000 0.002 0.000 __init__.py:151(_decode_path) 402 0.001 0.000 0.002 0.000 _collections.py:144(__new__) 4422 0.002 0.000 0.002 0.000 {method 'isdisjoint' of 'set' objects} 603 0.002 0.000 0.002 0.000 _collections.py:318(items) 1206 0.001 0.000 0.002 0.000 path.py:140(relpath) 201 0.001 0.000 0.002 0.000 urllib.py:1251(quote) 2808 0.002 0.000 0.002 0.000 threading.py:63(_note) 999 0.002 0.000 0.002 0.000 base.py:590(contains_column) 2609 0.002 0.000 0.002 0.000 query.py:3746(<genexpr>) 201 0.001 0.000 0.001 0.000 attributes.py:1290(as_state) 1206 0.001 0.000 0.001 0.000 {method 'intersection' of 'frozenset' objects} 468 0.001 0.000 0.001 0.000 weakref.py:262(__new__) 936 0.001 0.000 0.001 0.000 threading.py:237(_is_owned) 460 0.001 0.000 0.001 0.000 weakref.py:48(remove) 2207 0.001 0.000 0.001 0.000 compiler.py:215(__str__) 402 0.001 0.000 0.001 0.000 unitofwork.py:271(_mapper_for_dep) 2408 0.001 0.000 0.001 0.000 {method 'union' of 'set' objects} 402 0.001 0.000 0.001 0.000 {method 'hexdigest' of '_hashlib.HASH' objects} 201 0.001 0.000 0.001 0.000 arrow.py:335(naive) 201 0.001 0.000 0.001 0.000 base.py:135(_clone) 1206 0.001 0.000 0.001 0.000 base.py:235(getmeta) 402 0.001 0.000 0.001 0.000 _lxml.py:54(__init__) 2474 0.001 0.000 0.001 0.000 query.py:286(_entity_zero) 201 0.001 0.000 0.001 0.000 _collections.py:879(get) 2808 0.001 0.000 0.001 0.000 {thread.get_ident} 935 0.001 0.000 0.001 0.000 type_api.py:53(__init__) 402 0.001 0.000 0.001 0.000 arrow.py:844(_get_datetime) 468 0.001 0.000 0.001 0.000 queue.py:194(_put) 603 0.001 0.000 0.001 0.000 weakref.py:320(__setitem__) 468 0.001 0.000 0.001 0.000 queue.py:190(_full) 402 0.001 0.000 0.001 0.000 urlparse.py:233(urlunsplit) 1407 0.001 0.000 0.001 0.000 unitofwork.py:524(__init__) 6498 0.001 0.000 0.001 0.000 {method 'popleft' of 'collections.deque' objects} 1380 0.001 0.000 0.001 0.000 vendors.py:321(add_price) 733 0.001 0.000 0.001 0.000 query.py:2112(_reset_joinpoint) 4343 0.001 0.000 0.001 0.000 interfaces.py:617(setup_query) 804 0.001 0.000 0.001 0.000 _lxml.py:72(prepare_markup) 468 0.001 0.000 0.001 0.000 session.py:239(_iterate_parents) 201 0.001 0.000 0.001 0.000 attributes.py:1330(from_object_attribute) 1407 0.001 0.000 0.001 0.000 {method 'rstrip' of 'str' objects} 468 0.001 0.000 0.001 0.000 queue.py:198(_get) 468 0.001 0.000 0.001 0.000 base.py:255(__init__) 603 0.001 0.000 0.001 0.000 weakref.py:69(__getitem__) 1206 0.001 0.000 0.001 0.000 mapper.py:2299(iterate_to_root) 804 0.001 0.000 0.001 0.000 unitofwork.py:164(memo) 467 0.001 0.000 0.001 0.000 interfaces.py:362(adapter) 603 0.001 0.000 0.001 0.000 path_registry.py:77(__len__) 2739 0.001 0.000 0.001 0.000 selectable.py:170(selectable) 2207 0.001 0.000 0.001 0.000 default.py:750(post_exec) 201 0.001 0.000 0.001 0.000 {built-in method utcnow} 603 0.001 0.000 0.001 0.000 query.py:224(_adapt_all_clauses) 603 0.001 0.000 0.001 0.000 _collections.py:309(__iter__) 603 0.001 0.000 0.001 0.000 dependency.py:797(per_property_preprocessors) 804 0.001 0.000 0.001 0.000 __init__.py:220(<genexpr>) 402 0.001 0.000 0.001 0.000 session.py:2506(_dirty_states) 624 0.001 0.000 0.001 0.000 {method 'clear' of 'dict' objects} 201 0.001 0.000 0.001 0.000 dependency.py:594(per_property_dependencies) 2207 0.001 0.000 0.001 0.000 default.py:747(pre_exec) 603 0.001 0.000 0.001 0.000 weakref.py:284(remove) 201 0.001 0.000 0.001 0.000 dependency.py:324(per_property_dependencies) 201 0.001 0.000 0.001 0.000 {method 'replace' of 'datetime.datetime' objects} 1809 0.001 0.000 0.001 0.000 persistence.py:1054(<genexpr>) 1407 0.001 0.000 0.001 0.000 unitofwork.py:553(__init__) 468 0.001 0.000 0.001 0.000 pool.py:677(__init__) 1872 0.001 0.000 0.001 0.000 langhelpers.py:825(<lambda>) 603 0.001 0.000 0.001 0.000 identity.py:109(replace) 201 0.001 0.000 0.001 0.000 result.py:536(rowcount) 1608 0.001 0.000 0.001 0.000 mapper.py:2340(primary_base_mapper) 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} 201 0.001 0.000 0.001 0.000 parser.py:281(parse) 2207 0.001 0.000 0.001 0.000 {method 'close' of 'psycopg2.extensions.cursor' objects} 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} 603 0.001 0.000 0.001 0.000 state.py:234(has_identity) 486 0.001 0.000 0.001 0.000 {method 'find' of 'str' objects} 1206 0.001 0.000 0.001 0.000 persistence.py:184(<genexpr>) 825 0.001 0.000 0.001 0.000 vendors.py:324(vpno) 1071 0.001 0.000 0.001 0.000 {method 'discard' of 'set' objects} 1380 0.001 0.000 0.001 0.000 currency.py:248(source_value) 1380 0.001 0.000 0.001 0.000 vendors.py:488(currency) 266 0.001 0.000 0.001 0.000 selectable.py:857(<lambda>) 402 0.001 0.000 0.001 0.000 _lxml.py:123(close) 1868 0.001 0.000 0.001 0.000 elements.py:378(_copy_internals) 733 0.001 0.000 0.001 0.000 mapper.py:2278(common_parent) 402 0.001 0.000 0.001 0.000 _lxml.py:218(default_parser) 402 0.001 0.000 0.001 0.000 unitofwork.py:154(has_work) 201 0.000 0.000 0.001 0.000 attributes.py:893(get_history) 468 0.001 0.000 0.001 0.000 base.py:1537(_parent) 1380 0.001 0.000 0.001 0.000 collections.py:1038(__set) 468 0.001 0.000 0.001 0.000 {sys._getframe} 1206 0.001 0.000 0.001 0.000 {method 'lstrip' of 'str' objects} 402 0.001 0.000 0.001 0.000 {_locale.nl_langinfo} 733 0.001 0.000 0.001 0.000 query.py:3241(entity_zero_or_selectable) 603 0.000 0.000 0.000 0.000 persistence.py:1057(<lambda>) 201 0.000 0.000 0.000 0.000 ti.py:141(_get_mpartno) 2211 0.000 0.000 0.000 0.000 {method 'remove' of 'set' objects} 201 0.000 0.000 0.000 0.000 attributes.py:1255(empty) 467 0.000 0.000 0.000 0.000 relationships.py:1384(_get_attr_w_warn_on_none) 603 0.000 0.000 0.000 0.000 persistence.py:362(_collect_insert_commands) 1380 0.000 0.000 0.000 0.000 vendors.py:210(moq) 468 0.000 0.000 0.000 0.000 queue.py:186(_empty) 402 0.000 0.000 0.000 0.000 codecs.py:235(__init__) 955 0.000 0.000 0.000 0.000 {method 'strip' of 'str' objects} 201 0.000 0.000 0.000 0.000 persistence.py:632(<lambda>) 402 0.000 0.000 0.000 0.000 element.py:922(__setitem__) 402 0.000 0.000 0.000 0.000 unitofwork.py:388(<genexpr>) 603 0.000 0.000 0.000 0.000 persistence.py:568(_collect_delete_commands) 804 0.000 0.000 0.000 0.000 __init__.py:121(deprecated_argument) 1380 0.000 0.000 0.000 0.000 vendors.py:218(unit_price) 468 0.000 0.000 0.000 0.000 contextlib.py:12(__init__) 1380 0.000 0.000 0.000 0.000 vendors.py:214(oqmultiple) 603 0.000 0.000 0.000 0.000 query.py:906(_with_invoke_all_eagers) 402 0.000 0.000 0.000 0.000 {method 'iteritems' of 'dict' objects} 201 0.000 0.000 0.000 0.000 vendors.py:340(manufacturer) 201 0.000 0.000 0.000 0.000 vendors.py:442(datasheet) 21 0.000 0.000 0.000 0.000 urlparse.py:68(clear_cache) 804 0.000 0.000 0.000 0.000 tz.py:47(utcoffset) 603 0.000 0.000 0.000 0.000 state.py:221(parents) 201 0.000 0.000 0.000 0.000 vendors.py:438(package) 603 0.000 0.000 0.000 0.000 persistence.py:180(<genexpr>) 201 0.000 0.000 0.000 0.000 _collections.py:875(_inc_counter) 201 0.000 0.000 0.000 0.000 vendors.py:434(package) 733 0.000 0.000 0.000 0.000 elements.py:405(self_group) 804 0.000 0.000 0.000 0.000 __init__.py:98(reset) 468 0.000 0.000 0.000 0.000 interfaces.py:120(create_row_processor) 201 0.000 0.000 0.000 0.000 default.py:797(rowcount) 30 0.000 0.000 0.000 0.000 {map} 201 0.000 0.000 0.000 0.000 vendors.py:368(pkgqty) 468 0.000 0.000 0.000 0.000 default.py:416(do_begin) 201 0.000 0.000 0.000 0.000 ti.py:181(url_base) 402 0.000 0.000 0.000 0.000 identity.py:50(_dirty_states) 402 0.000 0.000 0.000 0.000 {time.time} 603 0.000 0.000 0.000 0.000 {method 'pop' of 'collections.deque' objects} 468 0.000 0.000 0.000 0.000 interfaces.py:111(setup) 201 0.000 0.000 0.000 0.000 vendors.py:356(vpartdesc) 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:348(mpartno) 201 0.000 0.000 0.000 0.000 vendors.py:344(manufacturer) 201 0.000 0.000 0.000 0.000 vendors.py:386(prices) 201 0.000 0.000 0.000 0.000 arrow.py:329(datetime) 201 0.000 0.000 0.000 0.000 vendors.py:360(vpartdesc) 201 0.000 0.000 0.000 0.000 vendors.py:332(vqtyavail) 201 0.000 0.000 0.000 0.000 vendors.py:336(vqtyavail) 201 0.000 0.000 0.000 0.000 default.py:401(set_connection_execution_options) 201 0.000 0.000 0.000 0.000 dependency.py:727(process_deletes) 201 0.000 0.000 0.000 0.000 vendors.py:446(datasheet) 402 0.000 0.000 0.000 0.000 _collections.py:149(__init__) 402 0.000 0.000 0.000 0.000 tz.py:50(dst) 21 0.000 0.000 0.000 0.000 urlparse.py:160(_splitnetloc) 201 0.000 0.000 0.000 0.000 base.py:121(_root) 201 0.000 0.000 0.000 0.000 state.py:225(_pending_mutations) 402 0.000 0.000 0.000 0.000 {method 'reverse' of 'list' objects} 201 0.000 0.000 0.000 0.000 vendors.py:352(mpartno) 201 0.000 0.000 0.000 0.000 ti.py:144(_get_manufacturer) 201 0.000 0.000 0.000 0.000 ti.py:155(_get_datasheet_link) 133 0.000 0.000 0.000 0.000 state.py:244(_detach) 21 0.000 0.000 0.000 0.000 {any} 42 0.000 0.000 0.000 0.000 urlparse.py:206(<genexpr>) 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}