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.