perf(db): indexes on audit_events and worker_jobs for processing-summary #514
Loading…
Reference in a new issue
No description provided.
Delete branch "fix/processing-summary-indexes"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Summary
Add Flyway migration V100 with two composite indexes to fix slow
GET /api/processing-summary.Indexes added
idx_audit_events_subject_type_id_event_type— speeds upresetCutoff()MAX(created_at) query filtering on subject_type, subject_id, event_typeidx_worker_jobs_job_type_media_status_updated— speeds up activity aggregate queries and discovery join on worker_jobsFiles changed
apps/api/src/main/resources/db/migration/V100__add_processing_summary_indexes.sql(new)gradle.properties— version bump 0.71 → 0.72