Postgres Query Explainer

Paste an EXPLAIN plan. Find out which part is actually expensive, and what to do about it.

…or paste below. Dropping a file on this pane works too.
Query optional — lets pgqe say why an index went unused
Schema optional — turns a guess into a proof

pg_dump -s output, a pgqe snapshot document, or a schema tree pasted together. With this, “no index covers this predicate” stops being a suggestion. Text only — this service will not take a connection string, and will not fetch a schema from a URL.

…or paste below. Dropping a file here works too.
This will analyze at plan only add the query for clause-level findings