PostgreSQL & TimescaleDB
EXPLAIN (ANALYZE, BUFFERS, WAL, VERBOSE, FORMAT JSON)
SELECT * FROM orders WHERE status = 'paid';Paste the JSON array or plain text output from psql, pgAdmin, DataGrip, or DBeaver.
拖入执行计划或死锁日志,即刻生成交互式算子流程图、性能瓶颈修复建议、缓存与磁盘 I/O 分析及前后对比。100% 浏览器本地运行。
在您的 SQL 客户端中运行以下命令,并将输出结果粘贴或拖放到上方编辑器。
EXPLAIN (ANALYZE, BUFFERS, WAL, VERBOSE, FORMAT JSON)
SELECT * FROM orders WHERE status = 'paid';Paste the JSON array or plain text output from psql, pgAdmin, DataGrip, or DBeaver.
SET STATISTICS XML ON;
GO
SELECT TOP 50 * FROM dbo.orders WHERE status = 'paid';
GODrop a saved .sqlplan file from SSMS / Azure Data Studio or paste the raw ShowPlanXML string.
EXPLAIN FORMAT=JSON SELECT * FROM orders WHERE status = 'paid';
-- or MySQL 8.0.18+ actual timings:
EXPLAIN ANALYZE SELECT * FROM orders WHERE status = 'paid';Supports both EXPLAIN FORMAT=JSON (MySQL & MariaDB) and EXPLAIN ANALYZE tree text.
EXPLAIN (ANALYZE, DIST, VERBOSE, FORMAT JSON)
SELECT * FROM orders WHERE created_at >= now() - interval '1 day';Include DIST to inspect DocDB storage read requests, RPC roundtrips, and catalog reads.
EXPLAIN QUERY PLAN
SELECT * FROM orders WHERE customer_id = 42 ORDER BY created_at DESC;Paste the EXPLAIN QUERY PLAN output from the sqlite3 CLI or your SQLite client.
绝不会。Culprit Explain 基于编译为 WebAssembly 的 Rust 引擎 (@culpritsql/plans) 100% 在您的浏览器本地运行。您的执行计划、SQL 语句和死锁日志绝不会离开您的设备。
支持 SQL Server (.sqlplan XML)、PostgreSQL (EXPLAIN FORMAT JSON 及 ANALYZE 文本)、MySQL 与 MariaDB (EXPLAIN FORMAT=JSON 及 EXPLAIN ANALYZE 树形文本)、YugabyteDB (DocDB 指标) 和 SQLite (EXPLAIN QUERY PLAN),以及 SQL Server、PostgreSQL 和 InnoDB 死锁日志。
所有解析引擎、React 可视化组件与诊断工具均基于 MIT 协议开源。