Performance Issue: Add index for clinic_activity_logs.numeric_value - created-by-agentic

[doppleware]

Performance Issue

A significant performance degradation has been detected in queries filtering on the numeric_value column of the clinic_activity_logs table.

Current Behavior

• Query execution time: 2.68 seconds
• Full table scan required for filtering on numeric_value
• Typical duration: 667.7 microseconds
• Current z-score: 11.75 (significant deviation)

Root Cause

The absence of an index on the numeric_value column forces the database to perform full table scans when filtering on this column.

Solution

Added an index on the numeric_value column to optimize query performance:

CREATE INDEX idx_clinic_activity_logs_numeric_value ON clinic_activity_logs(numeric_value);

Impact

• Reduces query execution time
• Eliminates full table scans
• Improves overall application performance

Related

• PR Add index on numeric_value column for clinic_activity_logs table - created-by-agentic #93
• Incident ID: 5aa1fb7a-3656-11f0-8db3-ca59c7e8e81d