Bug #8058: Add indexes on expected reports table - Rudder - Issue Tracker

Actions

Bug #8058

closed

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

Status:

Released

Priority:

N/A

Assignee:

Category:

Performance and scalability

Target version:

Pull Request:

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