TIL about explain (analyze, buffers) in postgresql
🔗 a link post linking to www.pgmustard.com
While reading some
postgres tips today, as one does, I noticed a parameter to explain I
hadn’t seen before:
EXPLAIN (ANALYZE, BUFFERS)
SELECT * FROM users WHERE lower(email) = 'email@example.com'
buffers would have been super useful recently when I was debugging some
queries! And there are more I didn’t know about like costs off,
timing off, and summary off. Next time I’ll be more prepared.