PL
Plan Studio
Pro · SponsorFrom slow query to concrete fix.
EXPLAIN ANALYZE in a notebook cell opens interactive plan trees, flame graphs, and diff between runs. Index recommendations tie back to your schema.
1 / 4
workspace / performanceEXPLAIN · plansPL
Run EXPLAIN from a notebook cell
CodeLens Explain Analyze appends a plan cell. Text plan for quick scan; Visual tab for structure.
EXPLAIN (ANALYZE, BUFFERS) SELECT * FROM orders WHERE created_at >= NOW() - INTERVAL '30 days';
CONNECTIONS
orders_prod
orders_dev
public
▸ customers
▸ orders
▸ payments
SELECT date_trunc('day', created_at) AS day,
COUNT(*) AS orders
FROM orders GROUP BY 1;
COUNT(*) AS orders
FROM orders GROUP BY 1;
| day | orders | revenue |
|---|---|---|
| Apr 07 | 142 | $18,420 |
| Apr 08 | 158 | $21,340 |
| Apr 09 | 131 | $17,890 |
SELECT … FROM orders
GROUP BY day;
GROUP BY day;
top customers by revenue this quarter
Grounded in customers + orders. Review before running.
DEVSTAGEPROD
Risk scoreHIGH
DELETE without WHERE — confirm to continue
customersid · name · email
ordersid · customer_id · total
Designer · Diff · ERD · Import
Seq Scan on orders4 511 ms
Hash Join214 ms
Index Scan (after fix)88 ms
12active
2locks
99.2%cache hit
48msp95
orders_dev · Neon · SSL
orders_stage · SSH tunnel
orders_prod · read-only
Visual EXPLAINPlan diffFlame graphIndex hints