👋 I’m Nathan

TIL about explain (analyze, buffers) in postgresql 🔗

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.