Catch broken queries and performance regressions before production. SQL regression testing, EXPLAIN plan baselines, and CI/CD integration for PostgreSQL.
Display PostgreSQL JSON explain plans graphically! Gain deep insight into your queries.
a JSON schema for postgres EXPLAIN output
Free online EXPLAIN plan visualizer for PostgreSQL, MySQL/MariaDB and SQLite: paste a plan, explore it as an interactive graph, diagram, table and stats. Powered by @tabularis/explain.
MySQL Simulator Pro is a fully interactive, browser-based MySQL database simulation environment that lets you write and execute real SQL queries — including SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, CREATE INDEX, JOINs, transactions (BEGIN/COMMIT/ROLLBACK), and even role-based access control (GRANT/REVOKE)🗄️👨🏿💻.
Model abstraction for MongoDB explain plans.
Diagnose PostGIS performance problems from a PostgreSQL EXPLAIN plan. Parses JSON and text EXPLAIN (ANALYZE, BUFFERS) output, runs ten spatial rules — missing GiST index, ST_Distance instead of ST_DWithin, loose bounding-box rechecks, un-indexed KNN, SRID transforms defeating the index — and prints an annotated tree, JSON or Markdown.
CI gate for SQL performance: EXPLAIN plan fingerprints + noise-aware timings vs a committed baseline. Fails the PR whose migration flips an index scan into a 1M-row seq scan, with a readable plan diff. Timing thresholds grounded in a measured 11–36% run-to-run noise study.
SQL Query Diagnostics & Workload Optimization Platform
To associate your repository with the explain-plan topic, visit your repo's landing page and select "manage topics."