SQLForge™

AL-DEV-07100% Client-Side In-Memory AST

PostgreSQL & MySQL EXPLAIN visualizer, ORM N+1 loop detector, SQL injection AST auditor, and index advisor. Zero-telemetry database diagnostics.

Aventine Labs

EXPLAIN Execution Plan

[
  {
    "Plan": {
      "Node Type": "Limit",
      "Parallel Aware": false,
      "Async Capable": false,
      "Startup Cost": 8420.50,
      "Total Cost": 8420.75,
      "Plan Rows": 50,
      "Plan Width": 384,
      "Actual Startup Time": 142.150,
      "Actual Total Time": 145.890,
      "Actual Rows": 50,
      "Actual Loops": 1,
      "Shared Hit Blocks": 4120,
      "Shared Read Blocks": 8940,
      "Plans": [
        {
          "Node Type": "Sort",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Startup Cost": 8420.50,
          "Total Cost": 8510.50,
          "Plan Rows": 18000,
          "Plan Width": 384,
          "Actual Startup Time": 142.140,
          "Actual Total Time": 144.920,
          "Actual Rows": 50,
          "Actual Loops": 1,
          "Sort Key": ["orders.created_at DESC"],
          "Sort Method": "external merge",
          "Sort Space Used": 14280,
          "Sort Space Type": "Disk",
          "Plans": [
            {
              "Node Type": "Hash Join",
              "Parent Relationship": "Outer",
              "Parallel Aware": false,
              "Async Capable": false,
              "Startup Cost": 2100.00,
              "Total Cost": 7250.30,
              "Plan Rows": 18000,
              "Plan Width": 384,
              "Actual Startup Time": 38.500,
              "Actual Total Time": 118.250,
              "Actual Rows": 18450,
              "Actual Loops": 1,
              "Join Type": "Inner",
              "Inner Unique": true,
              "Hash Cond": "(orders.customer_id = customers.id)",
              "Plans": [
                {
                  "Node Type": "Seq Scan",
                  "Parent Relationship": "Outer",
                  "Parallel Aware": false,
                  "Async Capable": false,
                  "Relation Name": "orders",
                  "Alias": "orders",
                  "Startup Cost": 0.00,
                  "Total Cost": 4820.00,
                  "Plan Rows": 18450,
                  "Plan Width": 192,
                  "Actual Startup Time": 0.045,
                  "Actual Total Time": 74.320,
                  "Actual Rows": 18450,
                  "Actual Loops": 1,
                  "Filter": "(status = 'COMPLETED'::text)",
                  "Rows Removed by Filter": 381550
                },
                {
                  "Node Type": "Hash",
                  "Parent Relationship": "Inner",
                  "Parallel Aware": false,
                  "Async Capable": false,
                  "Startup Cost": 1450.00,
                  "Total Cost": 1450.00,
                  "Plan Rows": 52000,
                  "Plan Width": 192,
                  "Actual Startup Time": 24.120,
                  "Actual Total Time": 24.120,
                  "Actual Rows": 52000,
                  "Actual Loops": 1,
                  "Hash Buckets": 65536,
                  "Hash Batches": 1,
                  "Original Hash Batches": 1,
                  "Peak Memory Usage": 5240,
                  "Plans": [
                    {
                      "Node Type": "Index Scan",
                      "Parent Relationship": "Outer",
                      "Parallel Aware": false,
                      "Async Capable": false,
                      "Scan Direction": "NoMovement",
                      "Index Name": "idx_customers_tier",
                      "Relation Name": "customers",
                      "Alias": "customers",
                      "Startup Cost": 0.42,
                      "Total Cost": 1450.00,
                      "Plan Rows": 52000,
                      "Plan Width": 192,
                      "Actual Startup Time": 0.080,
                      "Actual Total Time": 16.450,
                      "Actual Rows": 52000,
                      "Actual Loops": 1,
                      "Index Cond": "(tier = 'ENTERPRISE'::text)"
                    }
                  ]
                }
              ]
            }
          ]
        }
      ]
    },
    "Planning Time": 1.250,
    "Execution Time": 146.420
  }
]

Format: JSONEngine: PostgreSQL

3 Critical Bottlenecks Detected

External Disk Sort Spill (14280 KB on Disk)HIGH

Sort operation spilled to disk (14280 kB used). work_mem exhausted.

💡 Fix: Increase Postgres work_mem for this session (e.g. SET work_mem = '64MB';) or create an index matching the sort key.

Sequential Scan on Table "orders"HIGH

Sequential scan on table "orders" (18,450 rows). Entire table read from storage.

💡 Fix: Create an index on orders covering columns referenced in: (status = 'COMPLETED'::text)

Heavy Post-Fetch Filter Discard (381,550 rows)HIGH

Heavy filter discards: 381,550 rows removed while returning only 18,450 rows.

💡 Fix: Consider indexing columns in "(status = 'COMPLETED'::text)" to filter rows at the B-tree index level instead of post-fetch heap filter.

Execution Time

146.42 ms

Total Cost

8420.8

Planning Time

1.25 ms

Bottlenecks

Execution Plan Hierarchy

Click any node to inspect details

Limit

Cost: 8420.8Time: 145.89 msRows: 50

100%

SortBottleneck

Cost: 8510.5Time: 144.92 msRows: 50

100%

Hash Join

Cost: 7250.3Time: 118.25 msRows: 18,450

86%

Seq Scanon ordersBottleneck

Cost: 4820.0Time: 74.32 msRows: 18,450

57%

Hash

Cost: 1450.0Time: 24.12 msRows: 52,000

17%

Index Scanon customersusing idx_customers_tier

Cost: 1450.0Time: 16.45 msRows: 52,000

17%