Broken and slow:
galaxy.model.orm.engine_factory DEBUG 2018-03-26 12:35:48,494 Request query: 0.005892(s)
SELECT stored_workflow_user_share_connection.id AS stored_workflow_user_share_connection_id, stored_workflow_user_share_connection.stored_workflow_id AS stored_workflow_user_share_connection_stored_workflow_id, stored_workflow_user_share_connection.user_id AS stored_workflow_user_share_connection_user_id, stored_workflow_tag_association_1.id AS stored_workflow_tag_association_1_id, stored_workflow_tag_association_1.stored_workflow_id AS stored_workflow_tag_association_1_stored_workflow_id, stored_workflow_tag_association_1.tag_id AS stored_workflow_tag_association_1_tag_id, stored_workflow_tag_association_1.user_id AS stored_workflow_tag_association_1_user_id, stored_workflow_tag_association_1.user_tname AS stored_workflow_tag_association_1_user_tname, stored_workflow_tag_association_1.value AS stored_workflow_tag_association_1_value, stored_workflow_tag_association_1.user_value AS stored_workflow_tag_association_1_user_value, galaxy_user_1.id AS galaxy_user_1_id, galaxy_user_1.create_time AS galaxy_user_1_create_time, galaxy_user_1.update_time AS galaxy_user_1_update_time, galaxy_user_1.email AS galaxy_user_1_email, galaxy_user_1.username AS galaxy_user_1_username, galaxy_user_1.password AS galaxy_user_1_password, galaxy_user_1.last_password_change AS galaxy_user_1_last_password_change, galaxy_user_1.external AS galaxy_user_1_external, galaxy_user_1.form_values_id AS galaxy_user_1_form_values_id, galaxy_user_1.deleted AS galaxy_user_1_deleted, galaxy_user_1.purged AS galaxy_user_1_purged, galaxy_user_1.disk_usage AS galaxy_user_1_disk_usage, galaxy_user_1.active AS galaxy_user_1_active, galaxy_user_1.activation_token AS galaxy_user_1_activation_token, (SELECT count(workflow_step.id) AS count_1
FROM workflow_step
WHERE workflow_1.id = workflow_step.workflow_id) AS anon_1, workflow_1.id AS workflow_1_id, workflow_1.create_time AS workflow_1_create_time, workflow_1.update_time AS workflow_1_update_time, workflow_1.stored_workflow_id AS workflow_1_stored_workflow_id, workflow_1.parent_workflow_id AS workflow_1_parent_workflow_id, workflow_1.name AS workflow_1_name, workflow_1.has_cycles AS workflow_1_has_cycles, workflow_1.has_errors AS workflow_1_has_errors, workflow_1.uuid AS workflow_1_uuid, stored_workflow_1.id AS stored_workflow_1_id, stored_workflow_1.create_time AS stored_workflow_1_create_time, stored_workflow_1.update_time AS stored_workflow_1_update_time, stored_workflow_1.user_id AS stored_workflow_1_user_id, stored_workflow_1.latest_workflow_id AS stored_workflow_1_latest_workflow_id, stored_workflow_1.name AS stored_workflow_1_name, stored_workflow_1.deleted AS stored_workflow_1_deleted, stored_workflow_1.importable AS stored_workflow_1_importable, stored_workflow_1.slug AS stored_workflow_1_slug, stored_workflow_1.published AS stored_workflow_1_published
FROM stored_workflow, stored_workflow_user_share_connection LEFT OUTER JOIN stored_workflow AS stored_workflow_1 ON stored_workflow_1.id = stored_workflow_user_share_connection.stored_workflow_id LEFT OUTER JOIN stored_workflow_tag_association AS stored_workflow_tag_association_1 ON stored_workflow_1.id = stored_workflow_tag_association_1.stored_workflow_id LEFT OUTER JOIN galaxy_user AS galaxy_user_1 ON galaxy_user_1.id = stored_workflow_1.user_id LEFT OUTER JOIN workflow AS workflow_1 ON stored_workflow_1.latest_workflow_id = workflow_1.id
WHERE %(param_1)s = stored_workflow_user_share_connection.user_id AND stored_workflow.deleted = false ORDER BY stored_workflow.update_time DESC, stored_workflow_tag_association_1.id
Parameters: {'param_1': 1}
Not broken and fast:
galaxy.model.orm.engine_factory DEBUG 2018-03-26 12:33:20,480 Request query: 0.005692(s)
SELECT stored_workflow_user_share_connection.id AS stored_workflow_user_share_connection_id, stored_workflow_user_share_connection.stored_workflow_id AS stored_workflow_user_share_connection_stored_workflow_id, stored_workflow_user_share_connection.user_id AS stored_workflow_user_share_connection_user_id, stored_workflow_tag_association_1.id AS stored_workflow_tag_association_1_id, stored_workflow_tag_association_1.stored_workflow_id AS stored_workflow_tag_association_1_stored_workflow_id, stored_workflow_tag_association_1.tag_id AS stored_workflow_tag_association_1_tag_id, stored_workflow_tag_association_1.user_id AS stored_workflow_tag_association_1_user_id, stored_workflow_tag_association_1.user_tname AS stored_workflow_tag_association_1_user_tname, stored_workflow_tag_association_1.value AS stored_workflow_tag_association_1_value, stored_workflow_tag_association_1.user_value AS stored_workflow_tag_association_1_user_value, galaxy_user_1.id AS galaxy_user_1_id, galaxy_user_1.create_time AS galaxy_user_1_create_time, galaxy_user_1.update_time AS galaxy_user_1_update_time, galaxy_user_1.email AS galaxy_user_1_email, galaxy_user_1.username AS galaxy_user_1_username, galaxy_user_1.password AS galaxy_user_1_password, galaxy_user_1.last_password_change AS galaxy_user_1_last_password_change, galaxy_user_1.external AS galaxy_user_1_external, galaxy_user_1.form_values_id AS galaxy_user_1_form_values_id, galaxy_user_1.deleted AS galaxy_user_1_deleted, galaxy_user_1.purged AS galaxy_user_1_purged, galaxy_user_1.disk_usage AS galaxy_user_1_disk_usage, galaxy_user_1.active AS galaxy_user_1_active, galaxy_user_1.activation_token AS galaxy_user_1_activation_token, (SELECT count(workflow_step.id) AS count_1
FROM workflow_step
WHERE workflow_1.id = workflow_step.workflow_id) AS anon_1, workflow_1.id AS workflow_1_id, workflow_1.create_time AS workflow_1_create_time, workflow_1.update_time AS workflow_1_update_time, workflow_1.stored_workflow_id AS workflow_1_stored_workflow_id, workflow_1.parent_workflow_id AS workflow_1_parent_workflow_id, workflow_1.name AS workflow_1_name, workflow_1.has_cycles AS workflow_1_has_cycles, workflow_1.has_errors AS workflow_1_has_errors, workflow_1.uuid AS workflow_1_uuid, stored_workflow_1.id AS stored_workflow_1_id, stored_workflow_1.create_time AS stored_workflow_1_create_time, stored_workflow_1.update_time AS stored_workflow_1_update_time, stored_workflow_1.user_id AS stored_workflow_1_user_id, stored_workflow_1.latest_workflow_id AS stored_workflow_1_latest_workflow_id, stored_workflow_1.name AS stored_workflow_1_name, stored_workflow_1.deleted AS stored_workflow_1_deleted, stored_workflow_1.importable AS stored_workflow_1_importable, stored_workflow_1.slug AS stored_workflow_1_slug, stored_workflow_1.published AS stored_workflow_1_published
FROM stored_workflow_user_share_connection JOIN stored_workflow ON stored_workflow.id = stored_workflow_user_share_connection.stored_workflow_id LEFT OUTER JOIN stored_workflow AS stored_workflow_1 ON stored_workflow_1.id = stored_workflow_user_share_connection.stored_workflow_id LEFT OUTER JOIN stored_workflow_tag_association AS stored_workflow_tag_association_1 ON stored_workflow_1.id = stored_workflow_tag_association_1.stored_workflow_id LEFT OUTER JOIN galaxy_user AS galaxy_user_1 ON galaxy_user_1.id = stored_workflow_1.user_id LEFT OUTER JOIN workflow AS workflow_1 ON stored_workflow_1.latest_workflow_id = workflow_1.id
WHERE %(param_1)s = stored_workflow_user_share_connection.user_id AND stored_workflow.deleted = false ORDER BY stored_workflow.update_time DESC, stored_workflow_tag_association_1.id
Parameters: {'param_1': 1}