The Postgres indexes you're not using

DUMMY CONTENT. Replace before launch. Target 1400 words.

Placeholder opening.

Partial indexes

Placeholder.

CREATE INDEX idx_orders_pending
  ON orders (created_at)
  WHERE status = 'pending';

Covering indexes

Placeholder.

Expression indexes

Placeholder.

How to tell which you need

Placeholder — reading EXPLAIN ANALYZE.