Skip to content

Draft: Add async index finding_data on security_findings

Andy Schoenen requested to merge andysoiron/add-async-index-finding-data-on-security-findings into master

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

  1. Run bin/rails db:migrate
  2. Open the database console gdk psql
  3. Run SELECT * FROM postgres_async_indexes WHERE name = 'index_finding_data_on_security_findings';
  4. 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.

Merge request reports