SQL EXPLAIN 可视化

复制import json
import subprocess

# 模拟 MySQL EXPLAIN 输出（实际从数据库获取）
explain_output = """
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+
| id | select_type | table | partitions | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra |
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+
|  1 | SIMPLE      | users | NULL       | ALL  | NULL          | NULL | NULL    | NULL | 1000 |    10.00 | Using where |
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+
"""

# 解析 MySQL 文本表格格式
lines = explain_output.strip().split('\n')
headers = [h.strip() for h in lines[1].split('|')[1:-1]]
values = [v.strip() for v in lines[3].split('|')[1:-1]]

# 构建结构化数据
parsed = dict(zip(headers, values))
print(json.dumps(parsed, indent=2))
# 输出：{"id": "1", "select_type": "SIMPLE", "table": "users", ...}

# 生成可视化节点（简化版：用 Mermaid 流程图）
node = f"{parsed['id']}[{parsed['table']}]\n{parsed['id']}-->{parsed['type']}"
print(f"Mermaid 流程图:\n{node}")

复制package main

import (
	"encoding/json"
	"fmt"
	"strings"
)

// 模拟 PostgreSQL EXPLAIN (JSON 格式)
func main() {
	// 实际从数据库获取的 EXPLAIN (FORMAT JSON)
	rawJSON := `[
	  {
	    "Plan": {
	      "Node Type": "Seq Scan",
	      "Relation Name": "orders",
	      "Startup Cost": 0.00,
	      "Total Cost": 35.50,
	      "Plan Rows": 1000,
	      "Plan Width": 40
	    }
	  }
	]`

	// 解析 JSON 格式的 EXPLAIN 输出
	var plans []map[string]interface{}
	if err := json.Unmarshal([]byte(rawJSON), &plans); err != nil {
		panic(err)
	}

	plan := plans[0]["Plan"].(map[string]interface{})
	
	// 提取关键字段用于可视化
	fmt.Printf("节点类型: %s\n", plan["Node Type"])
	fmt.Printf("表名: %s\n", plan["Relation Name"])
	fmt.Printf("预估行数: %.0f\n", plan["Plan Rows"].(float64))

	// 生成 DOT 格式（Graphviz 可视化）
	dot := fmt.Sprintf(`digraph {
	  "%s" [label="%s\nrows: %.0f"];
	}`, plan["Relation Name"], plan["Node Type"], plan["Plan Rows"])
	fmt.Println("DOT 格式:\n" + dot)
}

复制// 浏览器端解析 MySQL EXPLAIN 文本格式
const explainText = `
+----+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------+
| id | select_type | table | type  | possible_keys | key     | key_len | ref  | rows | filtered | Extra       |
+----+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------+
|  1 | SIMPLE      | users | range | idx_email     | idx_email | 1022   | NULL |  100 |   100.00 | Using index |
+----+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------+
`;

// 解析表格行
const lines = explainText.trim().split('\n');
const headers = lines[1].split('|').slice(1, -1).map(h => h.trim());
const values = lines[3].split('|').slice(1, -1).map(v => v.trim());

const parsed = {};
headers.forEach((h, i) => { parsed[h] = values[i]; });

console.log('解析结果:', parsed);
// 输出: { id: '1', select_type: 'SIMPLE', table: 'users', type: 'range', ... }

// 生成 SVG 节点（简化版）
const svg = `<svg width="200" height="80">
  <rect x="10" y="10" width="180" height="60" rx="5" fill="#f0f0f0" stroke="#333"/>
  <text x="100" y="35" text-anchor="middle" font-size="14">${parsed.table}</text>
  <text x="100" y="55" text-anchor="middle" font-size="12" fill="#666">${parsed.type}</text>
</svg>`;
console.log('SVG 可视化:', svg);