Hi, Our team has been intensively using SQLAlchemy for five years now. Over the years, we've accumulated a large number of models (roughly 350).
Over time, our app start-up has also slowed quite a bit. This has some negative effects since it's tied to several dev processes like starting up a shell environment, locally reloading our web server, and running our tests. I have been doing some profiling to try to identify why, and it turns out a large portion of this time (~4.5s) is taken up setting up the model classes and configuring the mappers: - 2.1s is spent setting up the initial mappings: sqlalchemy/ext/declarative/base.py:106(setup_mapping) - 2.4s is spent configuring the mapping: sqlalchemy/orm/mapper.py:2945(configure_mappers) While each individual call does not take much time, it ends up taking a long time cumulatively for our hundreds of models. Does anybody have advice on changes we can make to our app or models to improve the performance here? Attached some SQLAlchemy perf files. Happy to dive more into these if they might be tackleable on my end! -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
ncalls tottime percall cumtime percall filename:lineno(function) 344 0.004 0.000 9.466 0.028 /home/aurelia/.venv/local/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py:534(__init__) 344 0.003 0.000 9.461 0.028 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/api.py:62(__init__) 343 0.004 0.000 9.457 0.028 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:79(_as_declarative) 343 0.006 0.000 9.430 0.027 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:106(setup_mapping) 343 0.019 0.000 9.402 0.027 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:118(__init__) 343 0.002 0.000 4.527 0.013 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:150(_early_mapping) 343 0.008 0.000 4.525 0.013 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:565(map) 343 0.036 0.000 4.490 0.013 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:90(__init__) 343 0.070 0.000 2.812 0.008 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1368(_configure_properties) 4225 0.222 0.000 2.583 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1617(_configure_property) 6382/5455 0.155 0.000 2.422 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:429(_set_parent_with_dispatch) 2552 0.027 0.000 2.218 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:85(_init_items) 343 0.014 0.000 2.162 0.006 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:401(_setup_table) 332 0.019 0.000 2.121 0.006 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:400(__new__) 332 0.025 0.000 2.069 0.006 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:478(_init) 343 0.277 0.001 1.735 0.005 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:164(_scan_attributes) 343 0.185 0.001 0.981 0.003 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1183(_configure_class_instrumentation) 2220 0.190 0.000 0.969 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:920(__init__) 861 0.007 0.000 0.845 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:250(__call__) 4159 0.062 0.000 0.791 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:1528(register_descriptor) 1202 0.008 0.000 0.720 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1608(_adapt_inherited_property) 2145 0.067 0.000 0.684 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1720(_property_from_column) 1366/1193 0.016 0.000 0.642 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/api.py:189(__get__) 1797 0.020 0.000 0.593 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/api.py:31(listen) 2924 0.034 0.000 0.582 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/properties.py:173(instrument_class) 737 0.029 0.000 0.565 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1931(_set_table) 2177 0.057 0.000 0.515 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1340(_set_parent) 343 0.147 0.000 0.513 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:301(_extract_mappable_attributes) 1813 0.059 0.000 0.458 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:187(listen) 2178 0.121 0.000 0.453 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/properties.py:44(__init__) 4159 0.059 0.000 0.404 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:55(__init__) 2357 0.101 0.000 0.386 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:275(_produce_column_copies) 8288/5236 0.064 0.000 0.378 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:764(__get__) 343 0.004 0.000 0.368 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:455(register_class) 343 0.009 0.000 0.361 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:406(create_manager_for_cls) 343 0.031 0.000 0.355 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1283(_configure_pks) 1 0.002 0.002 0.346 0.346 /home/aurelia/.venv/local/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py:10(<module>) 343 0.024 0.000 0.345 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:55(__init__) 918 0.010 0.000 0.338 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1410(_on_table_attach) 1804 0.104 0.000 0.336 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:135(_update) 8698 0.068 0.000 0.313 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:285(__get__) 9037 0.171 0.000 0.302 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:805(expire_instance) 176 0.003 0.000 0.287 0.002 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:557(__call__) 1811 0.031 0.000 0.285 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:227(base_listen) 4225 0.064 0.000 0.284 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:209(instrument_attribute) 737 0.008 0.000 0.283 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1910(_set_parent) 1235 0.014 0.000 0.273 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:878(instrument_class) 2673 0.050 0.000 0.268 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2588(__init__) 8592 0.057 0.000 0.245 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:108(_for_instance) 3443 0.036 0.000 0.229 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:27(_declared_mapping_info) 8864/4077 0.111 0.000 0.219 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:833(__getattr__) 343 0.004 0.000 0.212 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:160(_instrument_init) 1 0.000 0.000 0.211 0.211 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/__init__.py:9(<module>) 1 0.000 0.000 0.200 0.200 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/__init__.py:8(<module>) 343 0.044 0.000 0.193 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:486(_generate_init) 1165 0.024 0.000 0.192 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2675(__init__) 589 0.015 0.000 0.190 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:337(format_argspec_plus) 797 0.033 0.000 0.190 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:3385(__init__) 2914/2773 0.074 0.000 0.189 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1399(_setup_on_memoized_fks) 8592 0.067 0.000 0.188 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:105(_for_class) 5357 0.047 0.000 0.185 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:584(corresponding_column) 13253 0.056 0.000 0.185 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:214(__call__) 389 0.010 0.000 0.185 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1416(copy) 471 0.009 0.000 0.179 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2748(__init__) 4978 0.060 0.000 0.178 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1853(_log) 16270 0.098 0.000 0.176 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:100(_event_descriptors) 1068 0.007 0.000 0.175 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:237(_listen) 1787 0.012 0.000 0.173 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:326(append) 16779 0.112 0.000 0.172 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/base.py:208(manager_of_class) 111 0.004 0.000 0.168 0.002 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/sqltypes.py:1626(_set_table) 3291 0.026 0.000 0.164 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:360(__init__) 16317 0.112 0.000 0.163 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:89(__getattr__) 343 0.063 0.000 0.161 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:361(_extract_declared_columns) 15478 0.112 0.000 0.160 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:332(__setitem__) 1787 0.024 0.000 0.160 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:246(append_to_list) 9668 0.095 0.000 0.159 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:570(__contains__) 3023 0.066 0.000 0.157 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/clsregistry.py:309(_deferred_relationship) 4397 0.032 0.000 0.156 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3769(_set_table) 711 0.016 0.000 0.153 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:3043(_set_parent) 2183 0.017 0.000 0.152 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/util.py:821(_orm_full_deannotate) 3443 0.024 0.000 0.149 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/base.py:325(_is_mapped_class) 2735 0.077 0.000 0.148 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:53(_get_immediate_cls_attr) 343 0.003 0.000 0.143 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:414(format_argspec_init) 2904 0.070 0.000 0.138 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:748(unique_list) 2220 0.027 0.000 0.136 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3663(__init__) 2183 0.081 0.000 0.135 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:140(_deep_deannotate) 779 0.011 0.000 0.134 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py:77(newfn) 2181/2179 0.016 0.000 0.131 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:721(proxy_set) 2431 0.040 0.000 0.130 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/naming.py:130(_constraint_name) 1 0.002 0.002 0.129 0.129 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/__init__.py:14(<module>) 916 0.023 0.000 0.128 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1784(_resolve_col_tokens) 1 0.001 0.001 0.127 0.127 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/expression.py:15(<module>) 1813 0.036 0.000 0.126 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:65(_stored_in_collection) 946 0.010 0.000 0.126 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:264(traverse) 3562 0.043 0.000 0.125 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/inspection.py:38(inspect) 1797 0.022 0.000 0.122 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/api.py:21(_event_key) 8605 0.069 0.000 0.121 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:74(__init__) 697 0.008 0.000 0.120 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/events.py:194(_listen) 3315 0.048 0.000 0.118 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:680(__getattr__) 274 0.003 0.000 0.118 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:691(operate) 343 0.008 0.000 0.117 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:449(_setup_inheritance) 343 0.029 0.000 0.114 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/clsregistry.py:29(add_class) 41 0.002 0.000 0.114 0.003 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/sqltypes.py:1436(_set_table) 2831 0.022 0.000 0.112 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:795(to_list) 4225 0.031 0.000 0.109 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:264(install_descriptor) 779 0.021 0.000 0.108 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:95(__init__) 387 0.003 0.000 0.108 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:671(columns) 2491 0.035 0.000 0.107 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:461(replace) 3370 0.040 0.000 0.106 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:2395(_should_exclude) 2101 0.015 0.000 0.106 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:494(add) 274 0.003 0.000 0.106 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py:60(operate) 2431 0.024 0.000 0.105 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2665(_set_parent) 304/152 0.002 0.000 0.101 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/operators.py:494(in_) 1354 0.032 0.000 0.100 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2616(_check_attach) 23552 0.087 0.000 0.098 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:609(iterate_attributes) 737 0.012 0.000 0.098 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1817(_link_to_col_by_colstring) 8693 0.057 0.000 0.096 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/api.py:67(__setattr__) 152 0.001 0.000 0.096 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/operators.py:1146(in_op) 1831 0.019 0.000 0.095 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2707(_set_parent) 3392 0.029 0.000 0.095 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:452(__init__) 55 0.002 0.000 0.094 0.002 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:893(_populate_column_collection) 2101 0.029 0.000 0.092 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:512(__setitem__) 152 0.009 0.000 0.091 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.py:126(_in_impl) 916 0.011 0.000 0.089 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:422(intersection) 374 0.014 0.000 0.088 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:3167(_set_parent) 343 0.005 0.000 0.087 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1839(_expire_memoizations) 734 0.011 0.000 0.082 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:716(base_columns) 13 0.000 0.000 0.080 0.006 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:153(__init__) 13 0.003 0.000 0.080 0.006 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:158(_create_dispatcher_class) 946 0.039 0.000 0.080 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:210(iterate) 24191 0.079 0.000 0.079 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3766(_get_table) 343 0.006 0.000 0.079 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:958(_configure_inheritance) 779 0.007 0.000 0.078 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1765(_set_cascade) 389 0.004 0.000 0.077 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:122(_schema_item_copy) 332 0.011 0.000 0.075 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/util.py:468(reduce_columns) 96 0.002 0.000 0.075 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:56(__init__) 711 0.016 0.000 0.075 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2831(__init__) 4366 0.044 0.000 0.075 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4177(_labeled) 3701 0.033 0.000 0.074 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/base.py:389(_inspect_mapped_class) 1 0.000 0.000 0.073 0.073 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/__init__.py:81(__go) 600 0.012 0.000 0.073 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:3449(_set_parent) 3735 0.044 0.000 0.072 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:253(__init__) 1558/779 0.024 0.000 0.071 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/util.py:37(__new__) 1 0.002 0.002 0.071 0.071 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/functions.py:10(<module>) 1692 0.023 0.000 0.070 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:193(for_modify) 66 0.007 0.000 0.067 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.py:29(instrument_class) 2279 0.035 0.000 0.065 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/naming.py:110(_constraint_name_for_table) 96 0.002 0.000 0.063 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/legacy.py:145(_augment_fn_docs) 779 0.009 0.000 0.061 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/util.py:71(from_string) 55 0.003 0.000 0.059 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:546(update) 156 0.002 0.000 0.059 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/sqltypes.py:1001(_set_parent) 1 0.001 0.001 0.059 0.059 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/__init__.py:283(__go) 852 0.010 0.000 0.059 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:3004(_validate_dest_table) 737 0.011 0.000 0.059 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1850(_set_target_column) 347 0.021 0.000 0.058 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1362(<genexpr>) 1 0.000 0.000 0.056 0.056 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/naming.py:11(<module>) 3036 0.033 0.000 0.056 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:184(__iter__) 5828 0.037 0.000 0.055 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:641(key) 1 0.001 0.001 0.055 0.055 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/events.py:8(<module>) 70 0.003 0.000 0.054 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:245(create_proxied_attribute) 2186/2183 0.025 0.000 0.054 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:145(clone) 2924 0.021 0.000 0.052 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:190(__setitem__) 107 0.005 0.000 0.052 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:120(decorate) 1060 0.011 0.000 0.051 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:212(_accept_with) 1 0.000 0.000 0.051 0.051 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/events.py:10(<module>) 70 0.018 0.000 0.051 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:625(monkeypatch_proxied_specials) 113 0.011 0.000 0.050 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/deprecations.py:133(inject_docstring_text) 55 0.002 0.000 0.048 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:933(_join_condition) 343 0.004 0.000 0.048 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:153(_setup_declared_events) 686 0.022 0.000 0.047 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/events.py:472(populate) 233 0.005 0.000 0.047 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/functions.py:305(__call__) 374 0.005 0.000 0.047 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:3163(__init__) 878 0.008 0.000 0.046 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1724(_table_key) 685 0.007 0.000 0.044 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2956(_append_element) 41 0.002 0.000 0.044 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/sqltypes.py:1012(_set_table) 1 0.002 0.002 0.042 0.042 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/dialects/postgresql/__init__.py:8(<module>) 1863 0.012 0.000 0.041 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2711(__contains__) 4231 0.027 0.000 0.040 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:689(<genexpr>) 8693 0.039 0.000 0.039 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:646(_add_attribute) 7525 0.039 0.000 0.039 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:583(contains_column) 2372 0.020 0.000 0.039 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:669(comparator) 1 0.000 0.000 0.038 0.038 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:25(<module>) 3423 0.017 0.000 0.038 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/clsregistry.py:160(get_module) 3030/2895 0.024 0.000 0.038 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py:1362(to_instance) 1 0.014 0.014 0.038 0.038 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/__init__.py:8(<module>) 343 0.003 0.000 0.037 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/util.py:120(find_tables) 1868 0.023 0.000 0.037 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:147(__init__) 2024 0.022 0.000 0.036 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3955(__new__) 946 0.016 0.000 0.036 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:252(traverse_using) 1692 0.024 0.000 0.036 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:284(__init__) 1876 0.022 0.000 0.036 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2485(__init__) 356 0.003 0.000 0.036 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:697(_bind_param) 3443 0.025 0.000 0.036 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:601(has_cls) 1 0.001 0.001 0.036 0.036 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:30(<module>) 770 0.003 0.000 0.036 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:900(<genexpr>) 883 0.006 0.000 0.036 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:38(_resolve_for_abstract) 377 0.009 0.000 0.035 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:867(__init__) 3056 0.022 0.000 0.033 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:2387(_is_userland_descriptor) 9668 0.033 0.000 0.033 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:214(__contains__) 737 0.018 0.000 0.033 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1753(_column_tokens) 1629 0.017 0.000 0.032 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2567(_to_schema_column_or_string) 9865 0.032 0.000 0.032 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:242(_listen_fn) 55 0.003 0.000 0.031 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:987(_joincond_scan_left_right) 141 0.001 0.000 0.031 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1397(<lambda>) 4978 0.023 0.000 0.031 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1843(_log_desc) 210 0.007 0.000 0.031 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/functions.py:531(__init__) 3210 0.021 0.000 0.031 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:395(__iter__) 343 0.003 0.000 0.031 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/events.py:572(_new_mapper_instance) 141 0.002 0.000 0.030 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1918(_set_remote_table) 291 0.002 0.000 0.030 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3796(_label) 1 0.002 0.002 0.029 0.029 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/sqltypes.py:10(<module>) 46 0.002 0.000 0.029 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:898(__call__) 291 0.007 0.000 0.028 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3804(_gen_label) 1356 0.011 0.000 0.028 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/clsregistry.py:168(add_class) 7119 0.026 0.000 0.026 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:1247(set_creation_order) 8287 0.026 0.000 0.026 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:61(_get_table_key) 2542 0.018 0.000 0.025 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2551(_set_parent) 344 0.002 0.000 0.025 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1742(get_referent) 779 0.014 0.000 0.025 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/clsregistry.py:297(_resolver) 343 0.003 0.000 0.025 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:289(sort) 1651 0.012 0.000 0.024 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:2597(_extract_col_expression_collection) 314 0.004 0.000 0.024 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:3227(_replace) 737 0.008 0.000 0.024 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:225(get) 1 0.001 0.001 0.024 0.024 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:11(<module>) 909 0.010 0.000 0.024 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4257(_literal_as_text) 259 0.003 0.000 0.023 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py:950(_set_parent_with_dispatch) 1 0.001 0.001 0.023 0.023 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.py:12(<module>) 1468 0.007 0.000 0.023 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:718(<genexpr>) 2111 0.016 0.000 0.023 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:342(__delitem__) 47 0.000 0.000 0.023 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/api.py:123(decorate) 387 0.010 0.000 0.023 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:1801(__init__) 264 0.004 0.000 0.023 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.py:22(_boolean_compare) 344 0.004 0.000 0.022 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py:515(__new__) 1 0.001 0.001 0.022 0.022 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/dialects/postgresql/base.py:905(<module>) 429 0.009 0.000 0.022 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:292(update) 343 0.002 0.000 0.022 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/events.py:170(_new_classmanager_instance) 2186 0.015 0.000 0.022 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:250(_deannotate) 2145 0.014 0.000 0.021 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4186(_is_column) 113 0.002 0.000 0.021 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/deprecations.py:121(_dedent_docstring) 47 0.003 0.000 0.021 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:148(public_factory) 1202 0.013 0.000 0.021 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/clsregistry.py:134(__init__) 408 0.004 0.000 0.021 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:436(difference) 1 0.001 0.001 0.021 0.021 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:16(<module>) 665 0.007 0.000 0.021 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3999(__new__) 1 0.000 0.000 0.020 0.020 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py:20(<module>) 1 0.001 0.001 0.020 0.020 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/__init__.py:52(<module>) 6175 0.020 0.000 0.020 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:2454(iterate_to_root) 385 0.004 0.000 0.020 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:1844(self_group) 1 0.000 0.000 0.020 0.020 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py:50(Query) 1 0.001 0.001 0.020 0.020 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:11(<module>) 1870 0.013 0.000 0.019 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:163(with_wrapper) 4229 0.019 0.000 0.019 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:688(__iter__) 19 0.000 0.000 0.019 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/deprecations.py:98(_decorate_with_warning) 189 0.002 0.000 0.019 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:83(<genexpr>) 18 0.000 0.000 0.018 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/deprecations.py:48(decorate) 1789 0.012 0.000 0.018 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:167(_adjust_fn_spec)
ncalls tottime percall cumtime percall filename:lineno(function) 1 0.010 0.010 13.316 13.316 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:2945(configure_mappers) 343 0.057 0.000 13.166 0.038 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1796(_post_configure_properties) 3384/3023 0.027 0.000 9.972 0.003 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/interfaces.py:177(init) 1140/779 0.047 0.000 9.662 0.012 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1653(do_init) 1140 0.026 0.000 6.248 0.005 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1714(_setup_join_conditions) 1140 0.058 0.000 6.006 0.005 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1964(__init__) 4477 0.048 0.000 3.717 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/interfaces.py:541(post_instrument_class) 3318 0.169 0.000 3.607 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py:30(_register_attribute) 1140/779 0.034 0.000 3.456 0.004 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1827(_generate_backref) 441/386 0.022 0.000 3.243 0.008 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1617(_configure_property) 1140 0.013 0.000 2.721 0.002 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py:486(init_class_attribute) 6192 0.096 0.000 2.544 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:304(replacement_traverse) 18636/6192 0.398 0.000 2.406 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:311(clone) 8000 0.088 0.000 2.190 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/api.py:31(listen) 39135/37714 0.220 0.000 1.913 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:764(__get__) 7582 0.087 0.000 1.889 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:2987(_copy_internals) 8000 0.262 0.000 1.790 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:187(listen) 4624 0.058 0.000 1.617 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/interfaces.py:507(_get_strategy) 1651 0.030 0.000 1.543 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:23(track_cascade_events) 3318 0.029 0.000 1.433 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/interfaces.py:537(do_init) 1140 0.043 0.000 1.343 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py:451(__init__) 7976 0.084 0.000 1.166 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/events.py:1872(_listen) 1140 0.030 0.000 1.093 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2634(_setup_pairs) 8000 0.136 0.000 1.057 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:227(base_listen) 9773 0.501 0.000 1.052 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:210(iterate) 1140 0.023 0.000 1.039 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2296(_annotate_remote) 4499 0.116 0.000 1.037 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:1493(register_attribute_impl) 2280 0.038 0.000 0.986 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2833(create_lazy_clause) 1140 0.012 0.000 0.986 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2639(go) 1140 0.013 0.000 0.974 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/util.py:60(visit_binary_product) 8002/1140 0.105 0.000 0.962 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/util.py:97(visit) 1140 0.073 0.000 0.954 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2011(_log_joins) 2148 0.025 0.000 0.911 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py:167(init_class_attribute) 11995 0.114 0.000 0.849 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:583(contains_column) 12102/6043 0.084 0.000 0.831 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/operators.py:337(__eq__) 1141 0.023 0.000 0.796 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2640(visit_binary) 6049 0.055 0.000 0.791 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:691(operate) 4922 0.056 0.000 0.757 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:103(__eq__) 2282 0.034 0.000 0.726 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1813(_columns_are_mapped) 1140 0.099 0.000 0.685 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1664(_process_dependent_arguments) 1140 0.022 0.000 0.684 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2438(_annotate_local) 4590 0.106 0.000 0.652 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2754(_gather_columns_with_annotation) 8000 0.053 0.000 0.648 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:326(append) 1140 0.013 0.000 0.641 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2185(_annotate_fks) 1140 0.009 0.000 0.633 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2037(_determine_joins) 765 0.022 0.000 0.617 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:933(_join_condition) 8000 0.106 0.000 0.595 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:246(append_to_list) 1336 0.011 0.000 0.588 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py:67(<lambda>) 1336 0.020 0.000 0.577 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:1128(backref_listeners) 3968 0.065 0.000 0.568 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:669(__init__) 7616 0.201 0.000 0.561 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:180(_clone) 3420 0.038 0.000 0.559 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2742(_gather_join_annotations) 6049 0.054 0.000 0.538 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py:60(operate) 1116 0.010 0.000 0.522 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2414(_annotate_remote_distinct_selectables) 4499 0.247 0.000 0.521 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:387(__init__) 765 0.030 0.000 0.483 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:987(_joincond_scan_left_right) 6046 0.099 0.000 0.482 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.py:22(_boolean_compare) 8000 0.133 0.000 0.438 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:65(_stored_in_collection) 1140 0.012 0.000 0.431 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2466(_annotate_parentmapper) 6864 0.060 0.000 0.428 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2851(col_to_bind) 3420 0.030 0.000 0.399 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2170(_has_annotation) 2900 0.021 0.000 0.384 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1742(get_referent) 2940 0.170 0.000 0.364 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py:584(corresponding_column) 21125 0.142 0.000 0.353 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:770(_reset) 12071/7513 0.185 0.000 0.349 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:833(__getattr__) 2657 0.065 0.000 0.347 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:867(__init__) 1763 0.019 0.000 0.338 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:264(traverse) 8000 0.094 0.000 0.312 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/api.py:21(_event_key) 1140 0.032 0.000 0.296 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2545(_determine_direction) 636 0.007 0.000 0.290 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:280(cloned_traverse) 618 0.007 0.000 0.288 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2215(_annotate_present_fks) 2178 0.025 0.000 0.286 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/properties.py:185(do_init) 3440 0.048 0.000 0.285 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:58(_annotate) 3360 0.038 0.000 0.284 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2420(repl) 1920/636 0.052 0.000 0.281 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:287(clone) 153 0.002 0.000 0.278 0.002 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py:1275(init_class_attribute) 888 0.014 0.000 0.270 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/clsregistry.py:279(__call__) 3426 0.025 0.000 0.262 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2458(locals_) 6046 0.123 0.000 0.255 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:2953(__init__) 2671 0.193 0.000 0.254 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3999(__new__) 2417 0.029 0.000 0.249 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:236(_annotate) 8249 0.078 0.000 0.247 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:795(to_list) 1134 0.010 0.000 0.227 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2263(_refers_to_parent_table) 22095 0.157 0.000 0.227 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1498(get_children) 655 0.018 0.000 0.226 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:2346(_equivalent_columns) 5153 0.073 0.000 0.214 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:193(for_modify) 3473 0.053 0.000 0.214 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4414(_with_annotations) 21125 0.142 0.000 0.211 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:773(reset) 3432 0.022 0.000 0.209 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2470(parentmappers_) 1140 0.008 0.000 0.196 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2730(remote_columns) 1140 0.008 0.000 0.195 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2734(local_columns) 2417 0.066 0.000 0.193 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4407(__init__) 6848 0.104 0.000 0.193 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py:1294(__str__) 2148 0.025 0.000 0.192 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py:148(__init__) 1140 0.008 0.000 0.192 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2738(foreign_key_columns) 516 0.005 0.000 0.188 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2199(_annotate_from_fk_list) 5490 0.063 0.000 0.183 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1853(_log) 1140 0.010 0.000 0.173 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2491(_check_foreign_cols) 159 0.006 0.000 0.158 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/clsregistry.py:207(__getattr__) 4915 0.071 0.000 0.153 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:2971(__bool__) 1140 0.024 0.000 0.152 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1618(mapper) 48093 0.152 0.000 0.152 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:242(_listen_fn) 555 0.009 0.000 0.149 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1839(_expire_memoizations) 1214 0.078 0.000 0.148 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:805(expire_instance) 44170 0.144 0.000 0.144 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:100(__hash__) 1140 0.008 0.000 0.143 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2177(_has_foreign_annotations) 1140 0.008 0.000 0.142 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2181(_has_remote_annotations) 113 0.008 0.000 0.138 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:2214(all_orm_descriptors) 8111 0.085 0.000 0.138 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:147(__init__) 621 0.018 0.000 0.136 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2235(visit_binary) 754 0.006 0.000 0.130 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:140(_deep_deannotate) 1964 0.071 0.000 0.130 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:118(_all_sqla_attributes) 13025 0.085 0.000 0.129 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:689(<genexpr>) 354 0.008 0.000 0.125 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:2334(_get_clause) 2230/754 0.033 0.000 0.125 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:145(clone) 10955 0.079 0.000 0.124 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/base.py:208(manager_of_class) 3176 0.029 0.000 0.121 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:285(__get__) 1763 0.034 0.000 0.118 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py:252(traverse_using) 19740 0.081 0.000 0.116 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4143(_expand_cloned) 108 0.001 0.000 0.108 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py:53(<lambda>) 5153 0.070 0.000 0.108 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:284(__init__) 108 0.002 0.000 0.107 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/util.py:81(_validator_events) 1119 0.008 0.000 0.107 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2290(_tables_overlap) 6046 0.062 0.000 0.103 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.py:307(_check_literal) 2281 0.018 0.000 0.099 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2020(<genexpr>) 691 0.012 0.000 0.099 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:2994(compare) 1119 0.019 0.000 0.098 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/util.py:257(selectables_overlap) 421 0.005 0.000 0.097 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:878(instrument_class) 441 0.007 0.000 0.092 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:1528(register_descriptor) 3174 0.024 0.000 0.092 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:108(_for_instance) 3473 0.038 0.000 0.091 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:63(_with_annotations) 1548 0.009 0.000 0.085 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2200(check_fk) 531 0.017 0.000 0.084 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:866(__init__) 7976 0.053 0.000 0.082 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/events.py:1864(_accept_with) 8000 0.055 0.000 0.081 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py:167(_adjust_fn_spec) 8111 0.054 0.000 0.081 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:163(with_wrapper) 987 0.011 0.000 0.080 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:4303(_only_column_elements) 8000 0.054 0.000 0.079 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/registry.py:159(_key) 3459 0.040 0.000 0.076 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:184(__iter__) 21849 0.074 0.000 0.074 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3766(_get_table) 2281 0.016 0.000 0.071 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2026(<genexpr>) 2004 0.023 0.000 0.071 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:773(compare) 704 0.021 0.000 0.070 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:2460(self_and_descendants) 22129 0.070 0.000 0.070 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:339(get_children) 3 0.000 0.000 0.070 0.023 /home/aurelia/.venv/local/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py:534(__init__) 3 0.000 0.000 0.070 0.023 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/api.py:62(__init__) 3 0.000 0.000 0.070 0.023 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:79(_as_declarative) 3 0.000 0.000 0.069 0.023 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:106(setup_mapping) 3176 0.028 0.000 0.069 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:105(_for_class) 20637 0.069 0.000 0.069 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:2991(get_children) 3 0.000 0.000 0.069 0.023 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/ext/declarative/base.py:118(__init__) 375 0.003 0.000 0.069 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/util.py:807(_orm_deannotate) 1483 0.010 0.000 0.069 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:250(_deannotate) 361 0.003 0.000 0.068 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2137(primaryjoin_reverse_remote) 4754 0.042 0.000 0.068 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/util.py:227(surface_selectables) 5890 0.043 0.000 0.063 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:38(__new__) 4499 0.040 0.000 0.062 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:232(post_configure_attribute) 6105/6104 0.041 0.000 0.061 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py:1362(to_instance) 3420 0.033 0.000 0.060 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2624(_deannotate_pairs) 5509 0.040 0.000 0.058 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/event/base.py:89(__getattr__) 366 0.012 0.000 0.057 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:95(__init__) 1140 0.010 0.000 0.057 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1894(_post_init) 1137 0.027 0.000 0.055 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2272(visit_binary) 12139 0.051 0.000 0.051 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:646(self_group) 2417 0.028 0.000 0.051 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/annotation.py:52(__init__) 506/441 0.010 0.000 0.051 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/instrumentation.py:209(instrument_attribute) 904 0.019 0.000 0.050 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:1598(_add_reverse_property) 55/45 0.000 0.000 0.049 0.001 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py:1608(_adapt_inherited_property) 2703 0.030 0.000 0.049 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:3955(__new__) 14028 0.049 0.000 0.049 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py:366(__init__) 907 0.007 0.000 0.049 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/_collections.py:728(__missing__) 4009 0.033 0.000 0.048 0.000 /home/aurelia/.venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:669(comparator)