From Dev.to
PostgreSQL Indexing Cheat Sheet for Busy Developers
Most slow PostgreSQL queries come down to a missing or wrong index. Here is a compact cheat sheet. EXPLAIN (ANALYZE, BUFFERS) SELECT * FROM orders WHERE customer_id = 42 ORDER BY created_at DESC LIMIT...