explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q9sLD : Optimization for: Optimization for: plan #gKKW; plan #OAhb

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 374.216 5,473.594 ↑ 1.0 653,110 1

Hash Left Join (cost=86,061.58..118,850.94 rows=653,110 width=14) (actual time=4,579.914..5,473.594 rows=653,110 loops=1)

  • Hash Cond: (y.customerid = s.id)
2. 520.150 520.150 ↑ 1.0 653,110 1

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

3. 305.827 4,579.228 ↑ 1.0 402,737 1

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

  • Buckets: 65536 Batches: 8 Memory Usage: 3345kB
4. 4,273.401 4,273.401 ↑ 1.0 402,737 1

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

Planning time : 0.127 ms
Execution time : 5,495.720 ms