explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OAhb : Optimization for: plan #gKKW

Settings

Optimization path:

Optimization(s) for this plan:

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

Hash Left Join (cost=86,061.58..118,850.94 rows=653,110 width=14) (actual rows= loops=)

  • Hash Cond: (y.customerid = s.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on linecustomer y (cost=0.00..16,345.10 rows=653,110 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=78,667.37..78,667.37 rows=402,737 width=22) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on store20191114 s (cost=0.00..78,667.37 rows=402,737 width=22) (actual rows= loops=)