explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2yiu

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

Hash Join (cost=12.93..26.27 rows=46 width=4) (actual time=0.005..0.005 rows=0 loops=1)

  • Hash Cond: (sierra.kilo = whiskey.yankee)
2. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on sierra (cost=0.00..12.62 rows=70 width=12) (actual time=0.004..0.005 rows=0 loops=1)

  • Filter: (lima > 'november'::numeric)
3. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.30..11.30 rows=130 width=8) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Seq Scan on whiskey (cost=0.00..11.30 rows=130 width=8) (never executed)