PostgreSQL Indexing Cheat Sheet

• Put the most selective equality filters early in composite indexes.
• Avoid overlapping indexes that increase INSERT/UPDATE overhead.
• For filter + order + limit queries, design indexes to support both filtering and ordering.
• Always verify with EXPLAIN ANALYZE.

CREATE INDEX idx_dms_status_version
ON dms (status, version DESC);

CREATE INDEX idx_dms_variable_dmsid_code_value
ON dms_variable (dms_id, dms_master_codify_code, value);