2 ms·
I know the blog post has MySQL in the title, but one point I'll add for those of us working with Postgres: writing it as `EXPLAIN (ANALYZE, BUFFERS)` adds buffe
by firloop 4y ago
I know the blog post has MySQL in the title, but one point I'll add for those of us working with Postgres: writing it as `EXPLAIN (ANALYZE, BUFFERS)` adds buffer hits to each line of the output. I've found that valuable to reveal what parts of a query are hitting the hardware the hardest and there's seemingly no reason to not add buffers to the output each time.
- mateo411 4y agoI didn't know about this. That's really good advice for running EXPLAIN plans on Postgres. Thanks!
- jamesfinlayson 4y agoAh, how long's that been there? That would've been very helpful in a previous job.