About explainViewer
Paste EXPLAIN or EXPLAIN (ANALYZE, BUFFERS) output from PostgreSQL, as text or JSON. Get the plan as a tree with the time spent in each node (loops included), the slowest node highlighted, and warnings for bad row estimates, filters that throw rows away, sorts or hashes that spill to disk, writes whose WAL is mostly full-page images, and trigger time that no node shows, such as a foreign key whose child table has no index. Paste a second plan to compare before and after, node by node and trigger by trigger, so an index on a foreign key shows up in the trigger time.
Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.
From the makers
Pilotbase: one client for every database you run (PostgreSQL, MySQL, MongoDB, Redis and more), with an AI agent built in.
Get Pilotbase freeMore free data tools
sqlBeautify
Format, highlight and fix SQL as you type
sqlCompare
Diff two SQL files like git, after formatting both
downtimeAlert
We check your URL, API or stats page every 30 seconds and email you when it's down
sqlTranslate
Convert SQL between 14 dialects
keysetBuilder
Keyset pagination queries from your ORDER BY
testData
Realistic fake rows for your tables, as one INSERT for Postgres, MySQL or SQLite