Replace this orders index?

Situation

The analytics team needs a composite index on orders for a new reporting query. Antigravity generated a script to replace the existing single-column index.

Environment

The orders table has 15 million rows and receives ~2,000 writes per minute during business hours. Queries heavily depend on the existing idx_orders_status index. PostgreSQL 16. Read replicas handle reporting. There is no query planner cache warming in place.

Select suspicious lines in the terminal to flag them before submitting your verdict.

pending review

PSQL="PGPASSWORD=$DB_PASS psql -h $DB_HOST -U admin -d payments -c"
$PSQL "SELECT indexname FROM pg_indexes WHERE tablename = 'orders' AND indexname = 'idx_orders_status';" && \
$PSQL "DROP INDEX idx_orders_status;" && \
$PSQL "CREATE INDEX CONCURRENTLY idx_orders_status_created ON orders(status, created_at);" && \
$PSQL "ANALYZE orders;"