Draft: Add async index finding_data on security_findings
What does this MR do and why?
This adds an index to support the queries in !123965 (merged).
See related discussion: !123965 (comment 1452372978)
How to set up and validate locally
- Run
bin/rails db:migrate
- Open the database console
gdk psql
- Run
SELECT * FROM postgres_async_indexes WHERE name = 'index_finding_data_on_security_findings';
- There should now be an entry for the new index in
postgres_async_indexes
.
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.