michristofides
Re:PostgreSQL EXPLAIN Output Explained
on Saturday May 29, 2021 @02:37AM (#27323478)
You’re quite right, the example given doesn’t have bad row estimates, and other cells are highlighted in red/orange/yellow for different reasons (proportion of time taken, in the case shown).
For an intro to this that goes through several examples, I highly recommend a conference talk[1] by Josh Berkus in 2015/16 that he gave a few times. It has aged pretty well and I’ve not yet seen the basics covered better.
Re:PostgreSQL EXPLAIN Output Explained
on Friday May 28, 2021 @05:57PM (#27320999)
EXPLAIN ANALYZE would have shown you referential integrity (RI) triggers taking most of the time, but it’s still a bit of a leap to work out that it’s due to missing foreign key indexes if you don’t already know
Re:PostgreSQL EXPLAIN Output Explained
on Friday May 28, 2021 @04:06PM (#27319844)
I hope we’re not truly a consultants nightmare, but we’ve got quite a few of these covered in pgMustard (15+ tip types) and working to add more.
Re:PostgreSQL EXPLAIN Output Explained
on Friday May 28, 2021 @04:01PM (#27319807)
Thanks for the shout out, I’m half the team behind pgMustard, happy to answer questions here if anyone has any
In depth documentation for terms in Postgres EXPLAIN
Show HN: pg_docs_bot – redirects PostgreSQL docs links to the “current” version
Re:Ask HN: How do you process payments?
on Wednesday January 29, 2020 @07:57AM (#22179950)
Looks like they have a free tier for the first 50k in revenue: https://www.chargebee.com/launch/
Re:Show HN: A user interface for Postgres EXPLAIN that also gives tips
on Thursday July 04, 2019 @11:30AM (#20355407)
Thank you, we've heard that a couple of times now!
Versus tatiyants we think the main advantages are if you have a lot of operations in a query plan, or if you need some help working out what to do to speed it up.
If you come across either of those, it'd be great to hear what you think.
Re:Show HN: A user interface for Postgres EXPLAIN that also gives tips
on Wednesday July 03, 2019 @09:03AM (#20343922)
We are inspired by https://explain.depesz.com/ and https://tatiyants.com/pev/ and would be very interested in how people think pgMustard compares. Thanks!