explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gf00

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: (orders.o_custkey = customer.c_custkey)
2. 0.005 0.005 ↓ 0.0 0 1

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

  • Filter: (o_totalprice > '0'::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 customer (cost=0.00..11.30 rows=130 width=8) (never executed)