Vote #77778
完了Add index to workflows.tracker_id
開始日:
2022/05/09
期日:
進捗率:
0%
予定工数:
Redmineorg_URL:
category_id:
53
version_id:
119
issue_org_id:
23743
author_id:
118650
assigned_to_id:
1
comments:
3
status_id:
5
tracker_id:
2
plus1:
0
affected_version:
closed_on:
affected_version_id:
説明
Hi,
when I enter in trackers#index the redmine make this query for each tracker:
SELECT COUNT(*) FROM "workflows" WHERE "workflows"."tracker_id" = $1
But there is no index for "workflows"."tracker_id", and each query takes 88ms +-
After add index each query takes 0.3ms
journals
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Index added in r15859.
--------------------------------------------------------------------------------
いいね!0