github.com/quay/claircore@v1.5.28/datastore/postgres/migrations/matcher/11-add-update_operation-mv.sql (about)

     1  -- Create materialized view that maintains the lastest update_operation id per updater.
     2  CREATE MATERIALIZED VIEW IF NOT exists latest_update_operations AS
     3  SELECT DISTINCT ON (updater) id, kind, updater FROM update_operation ORDER BY updater, id DESC;