EXPLAIN Plan Analyzer

Paste EXPLAIN ANALYZE output and get a breakdown of bottlenecks, index usage, and optimization priorities.

EXPLAIN ANALYZE Output

EXPLAIN ANALYZE output:

Sort  (cost=15234.56..15234.78 rows=89 width=68) (actual time=1245.123..1245.156 rows=89 loops=1)
  Sort Key: o.created_at DESC
  Sort Method: quicksort  Memory: 32kB
  ->  Hash Join  (cost=1234.56..15234.12 rows=89 width=68) (actual time=123.456..1244.789 rows=89 loops=1)
        Hash Cond: (o.user_id = u.id)
        ->  Seq Scan on orders o  (cost=0.00..12345.67 rows=500000 width=44) (actual time=0.012..890.123 rows=500000 loops=1)
              Filter: (created_at > '2024-01-01'::timestamp)
              Rows Removed by Filter: 1500000
        ->  Hash  (cost=1234.00..1234.00 rows=45 width=24) (actual time=12.345..12.345 rows=45 loops=1)
              Buckets: 1024  Batches: 1  Memory Usage: 10kB
              ->  Seq Scan on users u  (cost=0.00..1234.00 rows=45 width=24) (actual time=0.011..12.234 rows=45 loops=1)
                    Filter: ((email)::text ~~ '%@gmail.com'::text)
                    Rows Removed by Filter: 49955
Planning Time: 0.456 ms
Execution Time: 1245.234 ms

Database Access

Give Your AI Agents
Database Access. Securely.

Connect any database. Control permissions. Audit every query. All running locally on your machine.

Download for macOS

EXPLAIN Plan Analyzer

Give Your AI AgentsDatabase Access. Securely.

Give Your AI Agents
Database Access. Securely.