News for hackers. Stuff that matters.

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.

[1]: https://youtu.be/mCwwFAl1pBU

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
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/
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.

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!