pgMustard — review Postgres query plans quickly
source link: https://www.pgmustard.com/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Reading EXPLAIN ANALYZE
output can be tough.
Even if you know how, Postgres includes so much useful information, it is easy to miss something important. And for queries that do a lot, the plans are even more useful-yet-time-consuming.
pgMustard speeds up your journey from knowing which query is a problem to working out what can be done about it.
You’ll be able to see at a glance where the time is going, as well as jump straight to the important statistics. If you need a refresher on what something means, or want to read up on how it works, those are there for you too.
We have also put effort into minimizing red-herrings, helping you avoid distractions like a sequential scan on a small table, or a bad row estimate on a fast subplan.
In short, pgMustard makes it quick and easy to understand a query plan, while staying focused on your main aim: making the query faster.
Features wise, you’ll get
Per-operation timings¹
The number of rows¹ returned by each operation
Performance advice – scored by estimated time-saving potential
A timing bar – that pins to keep it in context
Collapsible subtrees – with fast ones collapsed by default
Descriptions of operations
Links to blog posts for further reading
¹ Taking loops, threads, subplans, and CTEs into account.
The screenshot below shows an example where a large amount of the work could potentially be avoided, and there’s a conspicuous bad row estimate to boot.
Recommend
-
6
Explaining Your Postgres Query Performance March 22, 2021 Kat Batuigas ...
-
2
Do you want to know why a PostgreSQL query is slow? Then EXPLAIN ANALYZE is a great starting point. But query plans can depend on other server activity, can take a while to run, and can change over time, so if you want to see the actual execu...
-
4
Tricking Postgres into using an insane – but 200x faster – query planJacob Martin30 Dec 2021·8 min read
-
3
Multiple databases in a single query in your Rails apps - Postgres Foreign Data Wrappers to the rescue Jun 27, 2021 Imagine that you are building a separate applic...
-
8
Query Postgres Route to Snowflake Singlestore Clickhouse...
-
5
Postgres query to list all table names advertisements Is there any query available to list all tables in my Pos...
-
7
How Postgres Chooses Which Index To Use For A QueryBy Lukas FittlApril 01, 2022
-
2
On a recent project, I found myself needing to ingest a few hundred tables that were almost the same schema into one larger table in our PostgreSQL database. Here’s how you can lev...
-
3
Citus 11 for Postgres goes fully open source, with query from any node Written by M...
-
8
October 25, 2021 /
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK