Project

General

Profile

Actions

Bug #18110

closed

Unused index on table Ruddersysevents

Added by Nicolas CHARLES over 4 years ago. Updated almost 4 years ago.

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

Description

We have an index on keyvalue, dating from when we searched on keyvalue for compliance (pre 5.0)
0 query use it, we can safely remove it
It saves about 10%-20% of table ruddersysevent


Related issues 1 (0 open1 closed)

Related to Rudder - Bug #18111: create migration script to remove index on keyvalueReleasedAlexis MoussetActions
Actions

Also available in: Atom PDF