Digi-Key Vendor Get Part (DB) ProfilingΒΆ
Raw execution profile
SVG of execution profile
Execution Profile
pstats Output
Tue May 24 00:32:52 2016 /media/ldata/code/tendril/profiling/sourcing/get_part_db/digikey.profile 94228891 function calls (92311487 primitive calls) in 495.304 seconds Ordered by: cumulative time ncalls tottime percall cumtime percall filename:lineno(function) 1 0.738 0.738 496.533 496.533 vendors.py:74(profile_vendor_get_part_db) 11484 0.075 0.000 495.540 0.043 vendors.py:509(get_all_vparts) 11483 0.068 0.000 468.891 0.041 vendors.py:519(get_vpart) 11483 0.073 0.000 468.823 0.041 digikey.py:215(__init__) 11483 0.056 0.000 468.750 0.041 vendors.py:415(__init__) 11483 0.083 0.000 468.694 0.041 vendors.py:236(__init__) 11483 0.219 0.000 468.611 0.041 vendors.py:248(_populate) 11483 0.464 0.000 425.602 0.037 vendors.py:285(load_from_db) 11483 0.135 0.000 424.681 0.037 vendors.py:427(_load_from_db) 11483 1.115 0.000 393.969 0.034 vendors.py:292(_load_from_db) 74348 0.526 0.000 362.262 0.005 query.py:2511(__iter__) 74348 0.876 0.000 336.993 0.005 query.py:2525(_execute_and_instances) 74348 0.288 0.000 331.249 0.004 base.py:846(execute) 74348 0.227 0.000 330.783 0.004 elements.py:322(_execute_on_connection) 74348 1.122 0.000 330.556 0.004 base.py:975(_execute_clauseelement) 521732/487283 1.102 0.000 311.072 0.001 attributes.py:229(__get__) 82197/47748 0.452 0.000 310.008 0.006 attributes.py:556(get) 34449 0.273 0.000 308.247 0.009 strategies.py:477(_load_for_state) 34449 1.693 0.000 307.542 0.009 strategies.py:550(_emit_lazyload) 36266 1.112 0.000 297.681 0.008 query.py:2393(all) 74348 1.906 0.000 270.381 0.004 base.py:1061(_execute_context) 74348 0.198 0.000 247.690 0.003 default.py:449(do_execute) 74348 246.402 0.003 247.492 0.003 {method 'execute' of 'psycopg2.extensions.cursor' objects} 71946/13300 0.517 0.000 138.216 0.010 db.py:168(inner) 11483 0.292 0.000 111.396 0.010 controller.py:113(get_vpno_obj) 38082 1.068 0.000 99.395 0.003 query.py:2451(one) 13299 0.462 0.000 84.305 0.006 controller.py:215(get_map) 74348 0.299 0.000 58.409 0.001 elements.py:431(compile) 74348 0.439 0.000 58.110 0.001 elements.py:496(_compiler) 74348 1.570 0.000 57.671 0.001 compiler.py:329(__init__) 74348 0.353 0.000 55.831 0.001 compiler.py:167(__init__) 74348 0.220 0.000 55.478 0.001 compiler.py:212(process) 1274813/74348 4.384 0.000 55.258 0.001 visitors.py:75(_compiler_dispatch) 74348 2.762 0.000 54.710 0.001 compiler.py:1503(visit_select) 26600 0.273 0.000 48.804 0.002 db.py:111(get_session) 13300 0.043 0.000 41.240 0.003 contextlib.py:15(__enter__) 15116 0.088 0.000 40.008 0.003 controller.py:45(_get_vendor) 13300 0.178 0.000 39.855 0.003 controller.py:94(get_vendor) 13300 0.376 0.000 39.119 0.003 db.py:83(_get_caller) 13300 0.053 0.000 37.482 0.003 inspect.py:1053(stack) 13300 0.595 0.000 37.414 0.003 inspect.py:1026(getouterframes) 210983 2.344 0.000 36.745 0.000 inspect.py:988(getframeinfo) 218242 2.073 0.000 32.621 0.000 loading.py:30(instances) 482354 4.348 0.000 26.852 0.000 compiler.py:1275(_label_select_column) 11484 0.028 0.000 26.573 0.002 vendors.py:504(get_all_vpnos) 908 0.008 0.000 26.253 0.029 maps.py:73(get_all_partnos) 210983 2.959 0.000 24.243 0.000 inspect.py:518(findsource) 74348 1.420 0.000 24.008 0.000 query.py:2953(_compile_context) 1816 0.108 0.000 19.823 0.011 controller.py:244(get_map_vpnos) 482354 5.045 0.000 19.484 0.000 compiler.py:581(visit_label) 435266 4.861 0.000 16.286 0.000 inspect.py:440(getsourcefile) 154469 2.437 0.000 14.620 0.000 loading.py:360(_instance) 74348 1.753 0.000 14.334 0.000 compiler.py:1679(_compose_select_body) 351821/129361 0.957 0.000 13.751 0.000 operators.py:294(__eq__) 908 0.005 0.000 13.619 0.015 vendors.py:84(get_apartnos) 283507/177109 0.526 0.000 13.114 0.000 {operator.eq} 908 0.006 0.000 12.625 0.014 vendors.py:88(get_upartnos) 253858 1.336 0.000 11.761 0.000 base.py:196(generate) 243607/89463 1.435 0.000 11.044 0.000 visitors.py:86(_compiler_dispatch) 142661 0.286 0.000 10.556 0.000 elements.py:738(operate) 908 0.004 0.000 10.530 0.012 controller.py:257(get_amap_vpnos) 66498 0.160 0.000 10.359 0.000 attributes.py:174(operate) 74348 1.929 0.000 10.281 0.000 query.py:3282(row_processor) 74348 1.433 0.000 10.085 0.000 query.py:3071(_simple_statement) 74348 0.688 0.000 10.079 0.000 psycopg2.py:466(get_result_proxy) 74348 3.152 0.000 10.016 0.000 default.py:515(_init_compiled) 613532 5.278 0.000 9.776 0.000 compiler.py:620(visit_column) 142661 0.354 0.000 9.386 0.000 <string>:1(<lambda>) 908 0.004 0.000 9.357 0.010 controller.py:263(get_umap_vpnos) 100947 0.811 0.000 9.220 0.000 annotation.py:93(__eq__) 116062 0.671 0.000 9.186 0.000 compiler.py:904(visit_binary) 74348 0.549 0.000 9.047 0.000 query.py:3317(setup_context) 142661 0.854 0.000 9.033 0.000 type_api.py:57(operate) 74348 0.473 0.000 9.011 0.000 result.py:488(__init__) 13004248 7.665 0.000 8.887 0.000 {isinstance} 154469 2.371 0.000 8.806 0.000 loading.py:478(_populate_full) 74348 0.704 0.000 8.538 0.000 result.py:513(_init_metadata) 74348 2.032 0.000 8.409 0.000 loading.py:224(_setup_entity_query) 74348 0.714 0.000 8.331 0.000 <string>:1(select) 116062 0.784 0.000 8.227 0.000 compiler.py:935(_generate_generic_binary) 74348 4.053 0.000 8.215 0.000 loading.py:269(_instance_processor) 224283 1.081 0.000 8.011 0.000 inspect.py:472(getmodule) 13300 0.189 0.000 7.795 0.001 contextlib.py:21(__exit__) 74348 4.628 0.000 7.719 0.000 result.py:189(__init__) 74348 2.556 0.000 7.617 0.000 selectable.py:2220(__init__) 646249 2.685 0.000 7.283 0.000 inspect.py:398(getfile) 74348 0.269 0.000 7.068 0.000 session.py:1245(query) 74348 0.863 0.000 6.934 0.000 compiler.py:1654(_setup_select_stack) 443682 1.413 0.000 6.875 0.000 langhelpers.py:744(__get__) 116062 0.994 0.000 6.803 0.000 default_comparator.py:21(_boolean_compare) 74348 0.220 0.000 6.799 0.000 query.py:107(__init__) 74348 0.765 0.000 6.579 0.000 query.py:112(_set_entities) 13300 0.203 0.000 6.549 0.000 session.py:756(commit) 53199 0.188 0.000 6.541 0.000 properties.py:268(operate) 238222 0.300 0.000 6.429 0.000 type_api.py:1009(process) 13300 0.399 0.000 6.346 0.000 session.py:389(commit) 238222 0.355 0.000 6.129 0.000 arrow.py:73(process_result_value) 157783 0.438 0.000 5.933 0.000 inspect.py:460(getabsfile) 346378 0.945 0.000 5.805 0.000 {method 'join' of 'str' objects} 156284 0.460 0.000 5.774 0.000 api.py:17(get) 623199 2.174 0.000 5.690 0.000 interfaces.py:498(setup) 74348 0.766 0.000 5.582 0.000 selectable.py:2506(_get_display_froms) 156284 1.387 0.000 5.313 0.000 factory.py:32(get) 100947 0.275 0.000 5.279 0.000 <string>:1(filter) 26599 0.167 0.000 5.218 0.000 compiler.py:735(visit_clauselist) 157783 0.777 0.000 4.970 0.000 posixpath.py:365(abspath) 79797 0.078 0.000 4.860 0.000 compiler.py:742(<genexpr>) 79797 0.143 0.000 4.782 0.000 compiler.py:744(<genexpr>) 583300 2.462 0.000 4.705 0.000 compiler.py:1130(_truncated_identifier) 74348 2.051 0.000 4.523 0.000 selectable.py:2479(_froms) 47748 0.850 0.000 4.399 0.000 mapper.py:2451(_get_state_attr_by_column) 15115 0.088 0.000 4.338 0.000 query.py:1511(join) 74348 0.374 0.000 4.337 0.000 result.py:944(fetchall) 100946 0.659 0.000 4.280 0.000 compiler.py:1048(visit_bindparam) 15115 0.039 0.000 4.238 0.000 <string>:1(_join) 74348 0.293 0.000 4.114 0.000 query.py:2518(_connection_from_session) 15115 0.195 0.000 4.020 0.000 query.py:1800(_join) 1798882 2.269 0.000 3.876 0.000 compiler.py:2693(quote) 74348 0.385 0.000 3.821 0.000 session.py:811(connection) 34449 0.422 0.000 3.778 0.000 strategies.py:448(_generate_lazy_clause) 2999402 3.733 0.000 3.769 0.000 {getattr} 13300 0.219 0.000 3.643 0.000 query.py:1310(filter_by) 116062 0.579 0.000 3.588 0.000 default_comparator.py:269(_check_literal) 15115 0.272 0.000 3.534 0.000 query.py:1915(_join_left_to_right) 100947 0.954 0.000 3.530 0.000 query.py:1274(filter) 13299 0.155 0.000 3.382 0.000 relationships.py:961(__eq__) 435266 0.911 0.000 3.319 0.000 genericpath.py:15(exists) 74348 0.711 0.000 3.116 0.000 selectable.py:3151(_columns_plus_names) 764044 3.104 0.000 3.106 0.000 interfaces.py:466(_get_context_loader) 74348 0.209 0.000 3.075 0.000 session.py:884(_connection_for_bind) 100946 0.415 0.000 3.019 0.000 compiler.py:1117(_truncate_bindparam) 34449 0.093 0.000 3.006 0.000 strategy_options.py:781(lazyload) 26600 0.397 0.000 2.940 0.000 session.py:456(close) 34449 0.117 0.000 2.912 0.000 <string>:1(set_relationship_strategy) 74348 0.477 0.000 2.866 0.000 session.py:312(_connection_for_bind) 13300 0.082 0.000 2.845 0.000 base.py:1569(commit) 15115 0.129 0.000 2.837 0.000 query.py:2068(_join_to_left) 34449 0.157 0.000 2.796 0.000 base.py:40(_generative) 13300 0.044 0.000 2.747 0.000 base.py:1603(_do_commit) 74348 0.165 0.000 2.737 0.000 result.py:911(_fetchall_impl) 13300 0.209 0.000 2.703 0.000 base.py:679(_commit_impl) 53198 0.334 0.000 2.687 0.000 elements.py:3370(_bind_param) 143894 1.369 0.000 2.653 0.000 instrumentation.py:311(new_instance) 163811 0.689 0.000 2.626 0.000 _collections.py:794(to_list) 15115 0.056 0.000 2.626 0.000 util.py:880(join) 74348 1.525 0.000 2.571 0.000 {method 'fetchall' of 'psycopg2.extensions.cursor' objects} 15115 0.243 0.000 2.570 0.000 util.py:779(__init__) 157783 1.577 0.000 2.504 0.000 posixpath.py:336(normpath) 13300 0.112 0.000 2.465 0.000 default.py:422(do_commit) 74348 0.752 0.000 2.448 0.000 query.py:122(_set_entity_selectables) 435266 2.408 0.000 2.408 0.000 {posix.stat} 482354 0.764 0.000 2.388 0.000 default.py:753(get_result_processor) 223044 1.290 0.000 2.357 0.000 _collections.py:747(unique_list) 53198 1.388 0.000 2.353 0.000 elements.py:913(__init__) 510179 1.269 0.000 2.334 0.000 inspection.py:38(inspect) 13300 2.309 0.000 2.309 0.000 {method 'commit' of 'psycopg2.extensions.connection' objects} 34449 0.240 0.000 2.292 0.000 strategy_options.py:190(set_relationship_strategy) 93097/66499 0.327 0.000 2.266 0.000 annotation.py:71(_compiler_dispatch) 238159 1.265 0.000 2.145 0.000 base.py:36(_from_objects) 15115 0.161 0.000 2.034 0.000 selectable.py:651(__init__) 53198/26599 0.110 0.000 2.017 0.000 operators.py:43(__and__) 74348 0.484 0.000 2.016 0.000 psycopg2.py:435(create_cursor) 140845 0.752 0.000 2.006 0.000 interfaces.py:507(create_row_processor) 116062 1.196 0.000 1.996 0.000 elements.py:2724(__init__) 39900 0.199 0.000 1.981 0.000 session.py:694(begin) 156284 1.968 0.000 1.974 0.000 util.py:25(is_timestamp) 2176330 1.298 0.000 1.940 0.000 string.py:220(lower) 100946 0.651 0.000 1.916 0.000 elements.py:3624(apply_map) 26598 0.108 0.000 1.913 0.000 elements.py:2758(_copy_internals) 13300 0.105 0.000 1.816 0.000 base.py:2020(contextual_connect) 39899 0.162 0.000 1.811 0.000 elements.py:1890(and_) 490283 1.803 0.000 1.803 0.000 {method 'match' of '_sre.SRE_Pattern' objects} 74348 0.431 0.000 1.798 0.000 query.py:3159(__new__) 39900 0.331 0.000 1.782 0.000 session.py:169(__init__) 74348 0.586 0.000 1.777 0.000 _collections.py:359(__init__) 13300 0.167 0.000 1.763 0.000 session.py:2646(__call__) 13299 0.202 0.000 1.746 0.000 relationships.py:1334(_optimized_compare) 74348 0.546 0.000 1.736 0.000 compiler.py:438(_bind_processors) 100948 0.417 0.000 1.726 0.000 base.py:285(__get__) 26599 0.072 0.000 1.673 0.000 {operator.and_} 39899 0.591 0.000 1.649 0.000 elements.py:1856(_construct) 15115 0.063 0.000 1.648 0.000 selectable.py:786(_match_primaries) 482354 0.881 0.000 1.623 0.000 type_api.py:382(_cached_result_processor) 156284 0.762 0.000 1.600 0.000 arrow.py:118(fromdatetime) 74348 0.461 0.000 1.593 0.000 compiler.py:455(construct_params) 15115 0.153 0.000 1.572 0.000 selectable.py:793(_join_condition) 13300 0.259 0.000 1.555 0.000 session.py:512(__init__) 13299 0.066 0.000 1.544 0.000 visitors.py:280(cloned_traverse) 34449 0.095 0.000 1.522 0.000 query.py:1090(options) 1081515 0.852 0.000 1.496 0.000 inspect.py:51(ismodule) 74348 0.226 0.000 1.491 0.000 pool.py:845(cursor) 482354 0.521 0.000 1.482 0.000 result.py:497(_getter) 39897/13299 0.399 0.000 1.472 0.000 visitors.py:287(clone) 13299 0.055 0.000 1.443 0.000 util.py:746(_orm_annotate) 13300 0.073 0.000 1.438 0.000 base.py:793(close) 34449 0.082 0.000 1.427 0.000 <string>:1(_options) 13299 0.028 0.000 1.389 0.000 annotation.py:106(_deep_annotate) 26599 0.067 0.000 1.377 0.000 default_comparator.py:89(_conjunction_operate) 13300 0.053 0.000 1.365 0.000 pool.py:879(close) 39897/13299 0.187 0.000 1.361 0.000 annotation.py:113(clone) 13300 0.059 0.000 1.313 0.000 pool.py:756(_checkin) 100948 0.237 0.000 1.309 0.000 base.py:108(_for_instance) 857232 0.720 0.000 1.287 0.000 inspect.py:59(isclass) 34449 0.482 0.000 1.282 0.000 strategy_options.py:110(_generate_path) 74348 1.266 0.000 1.266 0.000 {method 'cursor' of 'psycopg2.extensions.connection' objects} 100946 0.198 0.000 1.265 0.000 _collections.py:727(__missing__) 13300 0.143 0.000 1.254 0.000 pool.py:615(_finalize_fairy) 3737872 1.254 0.000 1.254 0.000 {method 'append' of 'list' objects} 253858 0.777 0.000 1.242 0.000 query.py:416(_clone) 482354 0.463 0.000 1.238 0.000 compiler.py:2722(format_label) 684248 1.227 0.000 1.228 0.000 weakref.py:314(__getitem__) 74348 0.367 0.000 1.223 0.000 base.py:325(_is_mapped_class) 163811 0.693 0.000 1.223 0.000 abc.py:128(__instancecheck__) 74348 0.758 0.000 1.210 0.000 query.py:3190(setup_entity) 13300 0.139 0.000 1.197 0.000 db.py:69(_format_frame) 15115 0.168 0.000 1.195 0.000 compiler.py:1803(visit_join) 74348 0.145 0.000 1.191 0.000 compiler.py:441(<genexpr>) 482354 1.009 0.000 1.185 0.000 strategies.py:141(setup_query) 74348 1.077 0.000 1.184 0.000 query.py:3715(__init__) 114247 0.260 0.000 1.184 0.000 elements.py:2783(self_group) 1447125 1.173 0.000 1.173 0.000 {built-in method __new__ of type object at 0x919120} 808745 1.169 0.000 1.169 0.000 {method 'update' of 'dict' objects} 13300 0.035 0.000 1.153 0.000 base.py:2071(_wrap_pool_connect) 140846 0.472 0.000 1.136 0.000 operators.py:895(is_precedent) 1068215 0.678 0.000 1.130 0.000 inspect.py:181(istraceback) 13299 0.040 0.000 1.125 0.000 elements.py:1168(effective_value) 13300 0.045 0.000 1.119 0.000 pool.py:367(connect) 39897 0.140 0.000 1.112 0.000 elements.py:291(_annotate) 13299 0.041 0.000 1.085 0.000 relationships.py:1385(_go) 13300 0.125 0.000 1.074 0.000 pool.py:710(_checkout) 100948 0.393 0.000 1.072 0.000 base.py:105(_for_class) 100946 0.708 0.000 1.067 0.000 compiler.py:1149(_process_anon) 125143 0.408 0.000 1.065 0.000 base.py:389(_inspect_mapped_class) 39900 0.482 0.000 1.052 0.000 session.py:256(_take_snapshot) 34449 0.450 0.000 1.049 0.000 query.py:1105(_options) 175294 0.429 0.000 1.046 0.000 compiler.py:442(<genexpr>) 266826 0.357 0.000 1.046 0.000 utf_8.py:15(decode) 108797 0.423 0.000 1.042 0.000 path_registry.py:62(set) 435266 1.037 0.000 1.037 0.000 {imp.get_suffixes} 482354 0.894 0.000 1.015 0.000 selectable.py:3156(name_for_col) 143894 0.999 0.000 1.001 0.000 state.py:75(__init__) 210983 0.259 0.000 0.989 0.000 re.py:188(compile) 11483 0.156 0.000 0.979 0.000 attributes.py:1066(set_committed_value) 13300 0.085 0.000 0.968 0.000 session.py:1031(close) 482354 0.960 0.000 0.962 0.000 result.py:419(_getter) 223045 0.562 0.000 0.953 0.000 __init__.py:1345(isEnabledFor) 13300 0.156 0.000 0.918 0.000 pool.py:478(checkout) 3449640 0.896 0.000 0.896 0.000 {len} 13300 0.083 0.000 0.882 0.000 session.py:1076(_close_impl) 66497 0.303 0.000 0.876 0.000 elements.py:3513(__new__) 857232 0.574 0.000 0.870 0.000 inspect.py:67(ismethod) 39897 0.292 0.000 0.846 0.000 elements.py:3919(__init__) 536214 0.840 0.000 0.844 0.000 {hasattr} 1068215 0.655 0.000 0.844 0.000 inspect.py:191(isframe) 156284 0.591 0.000 0.838 0.000 arrow.py:49(__init__) 104578 0.421 0.000 0.832 0.000 selectable.py:35(_interpret_as_from) 857232 0.537 0.000 0.829 0.000 inspect.py:142(isfunction) 482354 0.827 0.000 0.827 0.000 compiler.py:271(__init__) 1362269 0.814 0.000 0.814 0.000 {method 'get' of 'dict' objects} 13300 0.111 0.000 0.792 0.000 pool.py:501(checkin) 482354 0.592 0.000 0.790 0.000 compiler.py:1272(_add_to_result_map) 15115 0.272 0.000 0.784 0.000 selectable.py:847(_joincond_scan_left_right) 148696 0.171 0.000 0.783 0.000 selectable.py:2438(<genexpr>) 74348 0.759 0.000 0.762 0.000 result.py:928(process_rows) 74348 0.386 0.000 0.753 0.000 query.py:306(_bind_mapper) 74348 0.607 0.000 0.737 0.000 elements.py:3665(_select_iterables) 74348 0.228 0.000 0.736 0.000 session.py:1279(_autoflush) 87648 0.480 0.000 0.736 0.000 langhelpers.py:1033(_next) 210983 0.548 0.000 0.731 0.000 re.py:226(_compile) 157783 0.514 0.000 0.719 0.000 posixpath.py:68(join) 122097 0.224 0.000 0.715 0.000 __init__.py:1130(debug) 114248 0.214 0.000 0.703 0.000 session.py:1970(flush) 143894 0.422 0.000 0.693 0.000 state.py:251(_cleanup) 266826 0.689 0.000 0.689 0.000 {_codecs.utf_8_decode} 100948 0.474 0.000 0.679 0.000 base.py:74(__init__) 857232 0.538 0.000 0.672 0.000 inspect.py:209(iscode) 661859 0.668 0.000 0.668 0.000 {method 'copy' of 'dict' objects} 13300 0.037 0.000 0.663 0.000 pool.py:388(_return_conn) 74348 0.574 0.000 0.660 0.000 query.py:3107(_adjust_for_single_inheritance) 2176330 0.642 0.000 0.642 0.000 {method 'lower' of 'str' objects} 13300 0.057 0.000 0.627 0.000 pool.py:1030(_do_return_conn) 100946 0.602 0.000 0.602 0.000 compiler.py:1155(bindparam_string) 100946 0.318 0.000 0.598 0.000 type_api.py:372(_cached_bind_processor) 13300 0.077 0.000 0.577 0.000 pool.py:1039(_do_get) 13300 0.159 0.000 0.570 0.000 queue.py:87(put) 34449 0.075 0.000 0.569 0.000 <string>:1(params) 482354 0.568 0.000 0.568 0.000 compiler.py:280(type) 547033 0.566 0.000 0.566 0.000 elements.py:3292(_get_table) 74348 0.564 0.000 0.564 0.000 {method 'encode' of 'unicode' objects} 329444 0.563 0.000 0.563 0.000 attr.py:226(__bool__) 127548 0.361 0.000 0.559 0.000 session.py:2016(_is_clean) 13300 0.194 0.000 0.558 0.000 base.py:47(__init__) 125143 0.268 0.000 0.551 0.000 base.py:208(manager_of_class) 13299 0.190 0.000 0.545 0.000 elements.py:1183(_clone) 482354 0.336 0.000 0.545 0.000 elements.py:3839(_interpret_as_column_or_from) 13300 0.034 0.000 0.535 0.000 <string>:1(and_) 34449 0.084 0.000 0.519 0.000 <string>:1(_adapt_all_clauses) 167445 0.212 0.000 0.507 0.000 elements.py:3765(_expression_literal_as_text) 140848 0.416 0.000 0.503 0.000 base.py:89(__getattr__) 13300 0.135 0.000 0.500 0.000 queue.py:130(get) 13300 0.266 0.000 0.494 0.000 session.py:358(_prepare_impl) 26599 0.317 0.000 0.485 0.000 elements.py:1821(_from_objects) 210983 0.260 0.000 0.480 0.000 <string>:8(__new__) 26598 0.249 0.000 0.478 0.000 elements.py:235(_clone) 157783 0.475 0.000 0.475 0.000 {posix.getcwd} 74348 0.306 0.000 0.464 0.000 result.py:637(_soft_close) 232124 0.457 0.000 0.457 0.000 elements.py:698(self_group) 34449 0.085 0.000 0.445 0.000 strategy_options.py:216(_set_path_strategy) 34449 0.281 0.000 0.436 0.000 state.py:565(_commit) 34449 0.102 0.000 0.427 0.000 path_registry.py:250(entity_path) 702995 0.427 0.000 0.427 0.000 {method 'intersection' of 'set' objects} 89464 0.228 0.000 0.420 0.000 compiler.py:1788(visit_table) 175294 0.311 0.000 0.419 0.000 default.py:592(<genexpr>) 116062 0.417 0.000 0.417 0.000 elements.py:2754(_from_objects) 631132 0.415 0.000 0.415 0.000 {method 'startswith' of 'str' objects} 66497 0.247 0.000 0.394 0.000 elements.py:3469(__new__) 64679 0.339 0.000 0.392 0.000 {sorted} 223045 0.391 0.000 0.391 0.000 __init__.py:1331(getEffectiveLevel) 163811 0.389 0.000 0.389 0.000 _weakrefset.py:70(__contains__) 241793 0.212 0.000 0.379 0.000 elements.py:3769(_literal_as_text) 34449 0.074 0.000 0.371 0.000 strategy_options.py:94(process_query) 22966 0.092 0.000 0.369 0.000 attributes.py:629(set_committed_value) 26599 0.104 0.000 0.369 0.000 elements.py:1967(self_group) 157783 0.196 0.000 0.366 0.000 posixpath.py:59(isabs) 74348 0.268 0.000 0.362 0.000 session.py:1142(get_bind) 1211365 0.359 0.000 0.359 0.000 {method 'add' of 'set' objects} 47748 0.230 0.000 0.355 0.000 elements.py:2742(__bool__) 34449 0.068 0.000 0.353 0.000 <string>:1(_with_invoke_all_eagers) 11483 0.125 0.000 0.351 0.000 attributes.py:976(_initialize_collection) 159600 0.347 0.000 0.347 0.000 weakref.py:282(__init__) 34449 0.169 0.000 0.347 0.000 strategy_options.py:86(_generate) 34449 0.124 0.000 0.325 0.000 path_registry.py:254(__getitem__) 11483 0.065 0.000 0.325 0.000 arrow.py:341(timestamp) 34449 0.141 0.000 0.324 0.000 strategy_options.py:185(_coerce_strat) 39897 0.178 0.000 0.319 0.000 annotation.py:45(__init__) 100946 0.314 0.000 0.314 0.000 {method 'split' of 'unicode' objects} 13300 0.047 0.000 0.312 0.000 base.py:534(begin) 143894 0.310 0.000 0.310 0.000 {method 'issuperset' of 'frozenset' objects} 13300 0.136 0.000 0.307 0.000 pool.py:764(_reset) 26600 0.219 0.000 0.302 0.000 threading.py:146(acquire) 70455 0.172 0.000 0.300 0.000 vendors.py:205(__init__) 74348 0.300 0.000 0.300 0.000 query.py:2638(_select_args) 74348 0.261 0.000 0.297 0.000 default.py:692(should_autocommit) 34449 0.168 0.000 0.297 0.000 strategy_options.py:100(_process) 93093 0.121 0.000 0.296 0.000 langhelpers.py:750(_reset) 909 0.001 0.000 0.293 0.000 vendors.py:500(get_idents) 1 0.003 0.003 0.291 0.291 vendors.py:77(get_idents) 125143 0.284 0.000 0.284 0.000 {method 'get' of 'dictproxy' objects} 1 0.000 0.000 0.282 0.282 controller.py:279(get_vendor_idents) 142986 0.184 0.000 0.270 0.000 identity.py:190(_fast_discard) 140845 0.269 0.000 0.269 0.000 strategies.py:615(create_row_processor) 13300 0.076 0.000 0.265 0.000 base.py:1595(__init__) 26599 0.053 0.000 0.265 0.000 elements.py:1825(self_group) 34449 0.205 0.000 0.264 0.000 _collections.py:805(has_intersection) 16931 0.055 0.000 0.262 0.000 schema.py:1635(get_referent) 157783 0.258 0.000 0.258 0.000 {method 'split' of 'str' objects} 11483 0.099 0.000 0.254 0.000 vendors.py:408(__repr__) 421966 0.253 0.000 0.253 0.000 {max} 34449 0.152 0.000 0.252 0.000 query.py:1254(params) 156284 0.133 0.000 0.247 0.000 util.py:37(isstr) 74348 0.200 0.000 0.241 0.000 query.py:3180(__init__) 143894 0.241 0.000 0.241 0.000 identity.py:140(_add_unpresent) 87648 0.183 0.000 0.234 0.000 query.py:289(_mapper_zero) 13300 0.157 0.000 0.232 0.000 session.py:1082(expunge_all) 74348 0.229 0.000 0.229 0.000 selectable.py:1695(__init__) 116062 0.181 0.000 0.229 0.000 type_api.py:1137(to_instance) 74348 0.225 0.000 0.225 0.000 {sqlalchemy.cutils._distill_params} 11395 0.092 0.000 0.222 0.000 collections.py:659(append_multiple_without_event) 148696 0.219 0.000 0.219 0.000 query.py:3262(_get_entity_clauses) 68898 0.113 0.000 0.218 0.000 _collections.py:846(flatten_iterator) 74348 0.217 0.000 0.217 0.000 path_registry.py:70(get) 100947 0.214 0.000 0.214 0.000 query.py:228(_adapt_clause) 34449 0.147 0.000 0.210 0.000 session.py:37(_state_session) 100948 0.209 0.000 0.209 0.000 session.py:190(_assert_active) 16931 0.151 0.000 0.207 0.000 selectable.py:450(corresponding_column) 148692 0.204 0.000 0.204 0.000 annotation.py:90(__hash__) 26600 0.147 0.000 0.204 0.000 threading.py:372(notify) 53198 0.174 0.000 0.202 0.000 type_api.py:424(coerce_compared_value) 127548 0.198 0.000 0.198 0.000 identity.py:53(check_modified) 657650 0.194 0.000 0.194 0.000 {method 'update' of 'set' objects} 210983 0.189 0.000 0.189 0.000 linecache.py:33(getlines) 11483 0.080 0.000 0.188 0.000 instrumentation.py:290(initialize_collection) 34449 0.123 0.000 0.188 0.000 strategy_options.py:80(__init__) 226681 0.186 0.000 0.186 0.000 {method 'endswith' of 'str' objects} 143894 0.181 0.000 0.181 0.000 <string>:1(set) 102176 0.180 0.000 0.180 0.000 elements.py:3657(_expand_cloned) 13300 0.081 0.000 0.180 0.000 weakref.py:98(__setitem__) 34449 0.139 0.000 0.177 0.000 base.py:314(_generate) 93093 0.142 0.000 0.175 0.000 langhelpers.py:753(reset) 11483 0.165 0.000 0.174 0.000 {method 'utctimetuple' of 'datetime.datetime' objects} 154469 0.173 0.000 0.173 0.000 identity.py:145(get) 24783 0.173 0.000 0.173 0.000 {method 'format' of 'str' objects} 13300 0.072 0.000 0.172 0.000 base.py:359(_entity_descriptor) 74348 0.136 0.000 0.171 0.000 _collections.py:394(__iter__) 68898 0.170 0.000 0.170 0.000 interfaces.py:486(_get_strategy) 34449 0.169 0.000 0.169 0.000 path_registry.py:267(__init__) 13300 0.118 0.000 0.166 0.000 base.py:642(_begin_impl) 114248 0.165 0.000 0.165 0.000 {method 'acquire' of 'thread.lock' objects} 26600 0.130 0.000 0.159 0.000 threading.py:186(release) 74348 0.130 0.000 0.158 0.000 base.py:1220(_safe_close_cursor) 34449 0.108 0.000 0.156 0.000 path_registry.py:283(__getitem__) 315873 0.150 0.000 0.150 0.000 {method 'pop' of 'dict' objects} 15115 0.104 0.000 0.145 0.000 query.py:1983(_prepare_right_side) 251460 0.143 0.000 0.143 0.000 {method 'values' of 'dict' objects} 26599 0.101 0.000 0.140 0.000 elements.py:716(comparator) 13300 0.081 0.000 0.138 0.000 default.py:419(do_rollback) 74348 0.136 0.000 0.136 0.000 {zip} 15115 0.061 0.000 0.136 0.000 selectable.py:1057(_hide_froms) 482354 0.132 0.000 0.132 0.000 elements.py:3521(apply_map) 70455 0.103 0.000 0.131 0.000 collections.py:1071(append) 482354 0.130 0.000 0.130 0.000 elements.py:758(_select_iterable) 116062 0.130 0.000 0.130 0.000 query.py:389(_no_limit_offset) 70455 0.110 0.000 0.129 0.000 currency.py:219(__init__) 399567 0.127 0.000 0.127 0.000 mapper.py:642(mapper) 39897 0.097 0.000 0.127 0.000 annotation.py:31(__new__) 39899 0.080 0.000 0.126 0.000 _collections.py:787(coerce_generator_arg) 116062 0.124 0.000 0.124 0.000 query.py:381(_no_statement_condition) 74348 0.124 0.000 0.124 0.000 mapper.py:1890(_with_polymorphic_mappers) 15115 0.083 0.000 0.119 0.000 selectable.py:1062(_from_objects) 74348 0.115 0.000 0.115 0.000 result.py:632(_cursor_description) 13299 0.097 0.000 0.112 0.000 relationships.py:1363(visit_bindparam) 135393 0.085 0.000 0.110 0.000 {hash} 51383 0.110 0.000 0.110 0.000 attr.py:214(__call__) 74348 0.108 0.000 0.108 0.000 {method 'pop' of 'list' objects} 100946 0.107 0.000 0.107 0.000 {_codecs.utf_8_encode} 125143 0.106 0.000 0.106 0.000 instrumentation.py:94(is_mapped) 70455 0.079 0.000 0.105 0.000 vendors.py:321(add_price) 165038 0.101 0.000 0.101 0.000 mapper.py:1965(selectable) 13300 0.068 0.000 0.099 0.000 base.py:116(_join) 484551 0.098 0.000 0.098 0.000 {id} 15115 0.080 0.000 0.095 0.000 controller.py:57(_get_ident) 74348 0.092 0.000 0.092 0.000 base.py:1472(get_select_precolumns) 210983 0.091 0.000 0.091 0.000 {min} 13300 0.046 0.000 0.090 0.000 query.py:300(_joinpoint_zero) 13300 0.076 0.000 0.089 0.000 session.py:297(_remove_snapshot) 140848 0.087 0.000 0.087 0.000 {setattr} 11483 0.079 0.000 0.086 0.000 calendar.py:610(timegm) 26600 0.083 0.000 0.083 0.000 identity.py:14(__init__) 13300 0.041 0.000 0.083 0.000 log.py:54(_should_log_debug) 26600 0.047 0.000 0.080 0.000 pool.py:854(__getattr__) 74348 0.079 0.000 0.079 0.000 _collections.py:724(__init__) 87648 0.078 0.000 0.078 0.000 {next} 79800 0.070 0.000 0.070 0.000 base.py:301(connection) 13300 0.057 0.000 0.070 0.000 contextlib.py:82(helper) 13300 0.030 0.000 0.069 0.000 log.py:57(_should_log_info) 13300 0.069 0.000 0.069 0.000 pool.py:559(get_connection) 108797 0.069 0.000 0.069 0.000 query.py:3746(<genexpr>) 114248 0.066 0.000 0.066 0.000 {method 'release' of 'thread.lock' objects} 34449 0.063 0.000 0.063 0.000 weakref.py:69(__getitem__) 119694 0.063 0.000 0.063 0.000 selectable.py:1418(_from_objects) 11483 0.062 0.000 0.062 0.000 instrumentation.py:302(get_impl) 61049 0.060 0.000 0.060 0.000 {method 'items' of 'dict' objects} 15115 0.044 0.000 0.059 0.000 query.py:3245(corresponds_to) 34449 0.058 0.000 0.058 0.000 {method 'intersection' of 'frozenset' objects} 34449 0.048 0.000 0.058 0.000 path_registry.py:77(__len__) 13300 0.058 0.000 0.058 0.000 {range} 30234 0.058 0.000 0.058 0.000 {method 'remove' of 'list' objects} 34449 0.057 0.000 0.057 0.000 query.py:224(_adapt_all_clauses) 13300 0.055 0.000 0.055 0.000 weakref.py:267(__init__) 87648 0.052 0.000 0.052 0.000 query.py:286(_entity_zero) 11483 0.051 0.000 0.051 0.000 state.py:277(dict) 74348 0.050 0.000 0.050 0.000 compiler.py:215(__str__) 15115 0.049 0.000 0.049 0.000 selectable.py:874(<lambda>) 157783 0.048 0.000 0.048 0.000 posixpath.py:51(normcase) 116062 0.048 0.000 0.048 0.000 {callable} 74348 0.047 0.000 0.047 0.000 {method 'keys' of 'dict' objects} 79800 0.046 0.000 0.046 0.000 threading.py:63(_note) 11483 0.045 0.000 0.045 0.000 collections.py:578(__init__) 74348 0.045 0.000 0.045 0.000 {method 'union' of 'set' objects} 13300 0.032 0.000 0.044 0.000 weakref.py:262(__new__) 74348 0.043 0.000 0.043 0.000 _collections.py:155(union) 15115 0.038 0.000 0.043 0.000 elements.py:269(_cloned_set) 13300 0.035 0.000 0.041 0.000 identity.py:184(all_states) 26600 0.033 0.000 0.041 0.000 threading.py:237(_is_owned) 53200 0.041 0.000 0.041 0.000 session.py:225(_is_transaction_boundary) 140845 0.040 0.000 0.040 0.000 interfaces.py:617(setup_query) 26599 0.039 0.000 0.039 0.000 type_api.py:53(__init__) 70455 0.039 0.000 0.039 0.000 vendors.py:488(currency) 74348 0.038 0.000 0.038 0.000 default.py:750(post_exec) 13282 0.038 0.000 0.038 0.000 weakref.py:48(remove) 89463 0.036 0.000 0.036 0.000 selectable.py:170(selectable) 74348 0.036 0.000 0.036 0.000 {iter} 34449 0.035 0.000 0.035 0.000 {method 'difference_update' of 'set' objects} 79800 0.034 0.000 0.034 0.000 {thread.get_ident} 13300 0.028 0.000 0.034 0.000 queue.py:194(_put) 74348 0.033 0.000 0.033 0.000 default.py:747(pre_exec) 13300 0.033 0.000 0.033 0.000 session.py:239(_iterate_parents) 13300 0.028 0.000 0.033 0.000 queue.py:198(_get) 13300 0.027 0.000 0.032 0.000 queue.py:190(_full) 13300 0.031 0.000 0.031 0.000 base.py:255(__init__) 16931 0.028 0.000 0.028 0.000 base.py:590(contains_column) 74348 0.027 0.000 0.027 0.000 {method 'close' of 'psycopg2.extensions.cursor' objects} 70455 0.027 0.000 0.027 0.000 collections.py:1038(__set) 15115 0.024 0.000 0.024 0.000 query.py:2112(_reset_joinpoint) 13300 0.024 0.000 0.024 0.000 base.py:1532(__init__) 53200 0.024 0.000 0.024 0.000 langhelpers.py:825(<lambda>) 53200 0.024 0.000 0.024 0.000 {method 'setdefault' of 'dict' objects} 13300 0.023 0.000 0.023 0.000 pool.py:677(__init__) 13300 0.022 0.000 0.022 0.000 {method 'rollback' of 'psycopg2.extensions.connection' objects} 13299 0.020 0.000 0.020 0.000 interfaces.py:362(adapter) 34449 0.020 0.000 0.020 0.000 query.py:906(_with_invoke_all_eagers) 11483 0.017 0.000 0.017 0.000 vendors.py:324(vpno) 53196 0.017 0.000 0.017 0.000 elements.py:378(_copy_internals) 13300 0.016 0.000 0.016 0.000 base.py:1537(_parent) 13300 0.015 0.000 0.015 0.000 {sys._getframe} 13299 0.015 0.000 0.015 0.000 relationships.py:1384(_get_attr_w_warn_on_none) 15115 0.014 0.000 0.014 0.000 mapper.py:2278(common_parent) 13300 0.013 0.000 0.013 0.000 queue.py:186(_empty) 13300 0.012 0.000 0.012 0.000 contextlib.py:12(__init__) 13300 0.012 0.000 0.012 0.000 {method 'discard' of 'set' objects} 15115 0.011 0.000 0.011 0.000 query.py:3241(entity_zero_or_selectable) 11483 0.009 0.000 0.009 0.000 tz.py:47(utcoffset) 11483 0.008 0.000 0.008 0.000 {time.time} 15115 0.008 0.000 0.008 0.000 {method 'strip' of 'str' objects} 13300 0.007 0.000 0.007 0.000 interfaces.py:120(create_row_processor) 11483 0.007 0.000 0.007 0.000 {method 'toordinal' of 'datetime.date' objects} 13300 0.006 0.000 0.006 0.000 interfaces.py:111(setup) 13300 0.006 0.000 0.006 0.000 default.py:416(do_begin) 15115 0.006 0.000 0.006 0.000 elements.py:405(self_group) 11483 0.006 0.000 0.006 0.000 state.py:225(_pending_mutations) 13300 0.005 0.000 0.005 0.000 {method 'append' of 'collections.deque' objects} 13299 0.005 0.000 0.005 0.000 base.py:32(_clone) 13300 0.005 0.000 0.005 0.000 {method 'popleft' of 'collections.deque' objects} 1816 0.004 0.000 0.004 0.000 selectable.py:857(<lambda>) 908 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}