Hacker News new | ask | show | jobs
by skunkworker 1846 days ago
It's good to auto explain but I would also add that going in and running explain (analyze, buffers) is really beneficial to seeing how much the query uses buffers and how many pages it has to load from disk.