michristofides

4 ms·

1. 1.▲
   Removing PostgreSQL's old_snapshot_threshold(blog.summercat.com)

   1 points by michristofides 2y ago|0 comments
2. 2.▲
   by michristofides 5y ago

   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
3. 3.▲
   by michristofides 5y ago

   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
4. 4.▲
   by michristofides 5y ago

   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.
5. 5.▲
   by michristofides 5y ago

   Thanks for the shout out, I’m half the team behind pgMustard, happy to answer questions here if anyone has any
6. 6.▲
   In depth documentation for terms in Postgres EXPLAIN(pgmustard.com)

   2 points by michristofides 6y ago|0 comments
7. 7.▲
   Show HN: pg_docs_bot – redirects PostgreSQL docs links to the “current” version(github.com)

   1 points by michristofides 6y ago|0 comments
8. 8.▲
   by michristofides 7y ago

   Looks like they have a free tier for the first 50k in revenue: https://www.chargebee.com/launch/
9. 9.▲
   by michristofides 7y ago

   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 ei
10. 10.▲
    by michristofides 7y ago

    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!
11. 11.▲
    Show HN: A user interface for Postgres EXPLAIN that also gives tips(pgmustard.com)

    50 points by michristofides 7y ago|5 comments