github.com/quay/claircore@v1.5.28/datastore/postgres/migrations/indexer/07-index-manifest_index.sql (about)

     1  -- This index is needed when deleting manifests, the cascade will want
     2  -- to delete rows from manifest_index based on the manifest.id. Without
     3  -- this index things get slow.
     4  CREATE INDEX IF NOT EXISTS idx_manifest_index_manifest_id ON manifest_index(manifest_id);