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) = 'firstname.lastname@example.org'
buffers would have been super useful recently when I was debugging some queries! And there are more I didn’t know about like
timing off, and
summary off. Next time I’ll be more prepared.