Project

General

Profile

Actions

Bug #8058

closed

Bug #8057: Queries on expected reports are really slow with more than 2000 nodes

Add indexes on expected reports table

Added by Nicolas CHARLES over 8 years ago. Updated over 8 years ago.

Status:
Released
Priority:
N/A
Category:
Performance and scalability
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:

Description

We are lacking indexes on expected reports table

These two indexes need to be added

CREATE INDEX nodeconfigids_idx on expectedreportsnodes USING GIN (nodeconfigids);

Actions

Also available in: Atom PDF