Project

General

Profile

Actions

Feature #23743

closed

Add index to workflows.tracker_id

Added by Victor Campos over 7 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Category:
Performance
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed

Description

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

Actions #1

Updated by Go MAEDA over 7 years ago

  • Target version set to Candidate for next minor release
Actions #3

Updated by Toshi MARUYAMA over 7 years ago

  • Target version changed from Candidate for next minor release to 3.4.0
Actions #4

Updated by Jean-Philippe Lang over 7 years ago

  • Status changed from New to Closed
  • Assignee set to Jean-Philippe Lang
  • Resolution set to Fixed

Index added in r15859.

Actions

Also available in: Atom PDF