Consider a covering index for SELECT list:
Use a "Current vs. New" comparison to make the change obvious. new dba date desc
CREATE TABLE db_audit ( dbname TEXT, created_at TIMESTAMPTZ DEFAULT NOW() ); Consider a covering index for SELECT list: Use
CREATE INDEX idx_dba_date_desc ON your_table (dba_date DESC); created_at TIMESTAMPTZ DEFAULT NOW() )
Ensures the most recent updates or errors are reviewed first to catch live issues. Key Focus: created_at