explain-analyze

OptimizeQL — AI-powered SQL query optimizer

Go library and CLI to parse PostgreSQL EXPLAIN (ANALYZE, FORMAT JSON) output and surface actionable performance findings

PostgreSQL queries from basic joins to window functions, recursive CTEs and measured index optimisation. One e-commerce schema, one Docker command, pure SQL.

PostgreSQL slow query watcher, tails auto_explain log output and reports actionable findings using pgexplain

Per-endpoint performance & Big O for your API: OpenAPI spec + EXPLAIN ANALYZE on Postgres/MySQL

Read PostgreSQL EXPLAIN plans locally: parse, compute self time and estimation error, flag documented problems, compare plans, and guard them in CI. No database connection, deterministic.

Turn PostgreSQL EXPLAIN output into human-readable reports and catch query-plan anti-patterns — every finding tells you exactly how to fix it.

PostgreSQL dimensional data warehouse modeling Romanian national economy across 42 administrative divisions.

PostgreSQL query performance tuning with EXPLAIN ANALYZE, BUFFERS, indexes, joins, materialized views, and correctness verification.

Benchmark common SQL performance patterns on PostgreSQL: warm-up, median timings and the EXPLAIN ANALYZE behind every result

Evidence-first PostgreSQL plan analysis with deterministic diagnostics, workload regression checks, and grounded AI/RAG

Production-grade guides and runbooks for query plan baseline tracking, performance regression detection, and CI/CD gate automation — for database SREs and platform teams.

See the SQL your SQLAlchemy 2.0 statements really run, then read the EXPLAIN ANALYZE plan in plain English — seq scans, stale-stats row mismatches, disk sorts, and expensive nested loops annotated with fixes.

Native desktop tool for SQL execution-plan visualization and analysis. Supports PostgreSQL, MySQL, MariaDB, and SQLite.

Advanced SQL analytics on 20.6K Spotify/YouTube tracks (PostgreSQL): schema design, data-quality cleaning, 15 queries from aggregation to window functions & CTEs, plus EXPLAIN ANALYZE query optimization with B-tree indexing.

PostgreSQL 18 performance and reliability lab on the TopFlow Hub schema: query casebook with plan checks, indexing, partitioning, pgBackRest PITR, switchover and failover drills, RLS and monitoring, all driven by ./lab.

CLI wrapper around pev2 for visualizing PostgreSQL EXPLAIN plans with live reload

Diagnoses slow PostgreSQL/TimescaleDB queries from EXPLAIN ANALYZE plans and writes plain-language, customer-facing reports. Includes 5 support-ticket case studies.

Eight realistic PostgreSQL performance problems, the fix for each, and harness-generated EXPLAIN ANALYZE evidence that the fix worked.

Load-testing a production Supabase/Postgres schema at 100x scale to find where the cost actually is. Found a 60x fix hiding in an unindexed self-referencing foreign key.