EXPLAIN Analyzer

Paste EXPLAIN output, flag performance issues automatically

EXPLAIN Analyzer is a free online Developer tool. Paste EXPLAIN output, flag performance issues automatically Related terms: explain · 执行计划 · query plan · 全表扫描 · seq scan · index scan. Use it on this page without signing in.

识别全表扫描（Seq Scan / ALL）、Using filesort、Using temporary、嵌套循环过深等常见性能问题，并给出 0-100 性能评分。分析在浏览器本地完成，不会上传。

Help

使用说明

  1. 执行 EXPLAIN SELECT ... 获取执行计划
  2. 粘贴到输入框（支持 MySQL/PostgreSQL 格式）
  3. 自动标注：全表扫描、临时表、文件排序、嵌套循环过深等问题
  4. 给出每个节点的风险等级和建议

常见问题

  • 什么是全表扫描？ Seq Scan / ALL 表示扫描整张表，大表上需要加索引
  • Using filesort 严重吗？ 排序使用了磁盘临时文件，需优化 ORDER BY 索引
  • Using temporary 呢？ 创建了临时表，常见于 GROUP BY/DISTINCT，需优化

More Developer

View all

JSON Formatter

Format, minify, validate JSON, convert to Go struct / TS interface

JSON Field Search

Search JSON by field, value or path with highlights, supports jq expressions

Timestamp Converter

Convert between Unix timestamps and dates, seconds and milliseconds

Cron Expression

Generate and parse cron expressions, preview next run time

UUID Generator

Generate UUID v4 / v7 / ULID / NanoID

Hash Calculator

Compute MD5 / SHA1 / SHA256 / SHA512 of text or files

JWT Decoder

Decode JWT header and payload, view expiry time

URL Encoder / Decoder

Encode and decode URL / URI components

FAQ about EXPLAIN Analyzer

What can EXPLAIN Analyzer do?

EXPLAIN Analyzer is a Developer tool. Paste EXPLAIN output, flag performance issues automatically You can finish the job on this page.

Who should use EXPLAIN Analyzer?

Anyone handling explain · 执行计划 · query plan · 全表扫描 · seq scan · index scan who does not want to install desktop software can use EXPLAIN Analyzer in the browser.

Is EXPLAIN Analyzer safe? Is my data uploaded?

This tool runs in your browser. We do not collect the content you enter into EXPLAIN Analyzer just because you used it.

What similar tools exist?

Related tools in the same Developer group are listed at the bottom of this page.