explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3DX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 0 1

Result (cost=1.06..17.20 rows=314 width=201) (actual rows=0 loops=1)

  • One-Time Filter: ($0 > 100)
2.          

Initplan (forResult)

3. 0.000 0.000 ↑ 1.0 1 1

Aggregate (cost=1.05..1.06 rows=1 width=0) (actual rows=1 loops=1)

4. 0.000 0.000 ↑ 1.0 4 1

Seq Scan on pg_language (cost=0.00..1.04 rows=4 width=0) (actual rows=4 loops=1)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on pg_class (cost=0.00..16.14 rows=314 width=201) (never executed)