explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IKZo0 : Optimization for: storage; plan #8xkU

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.599 29.429 ↓ 1.0 446 1

Hash Join (cost=46.96..966.84 rows=445 width=91) (actual time=3.406..29.429 rows=446 loops=1)

  • Hash Cond: (line.m_requisition_id = req.m_requisition_id)
2. 13.505 26.497 ↑ 1.0 446 1

Hash Right Join (cost=24.04..706.39 rows=446 width=82) (actual time=2.057..26.497 rows=446 loops=1)

  • Hash Cond: (poline.c_orderline_id = line.c_orderline_id)
3. 11.615 11.615 ↑ 1.0 9,132 1

Seq Scan on c_orderline poline (cost=0.00..631.65 rows=9,365 width=12) (actual time=0.003..11.615 rows=9,132 loops=1)

4. 0.688 1.377 ↑ 1.0 446 1

Hash (cost=18.46..18.46 rows=446 width=77) (actual time=1.377..1.377 rows=446 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 63kB
5. 0.689 0.689 ↑ 1.0 446 1

Seq Scan on m_requisitionline line (cost=0.00..18.46 rows=446 width=77) (actual time=0.004..0.689 rows=446 loops=1)

6. 0.669 1.333 ↓ 1.0 442 1

Hash (cost=17.41..17.41 rows=441 width=15) (actual time=1.333..1.333 rows=442 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 30kB
7. 0.664 0.664 ↓ 1.0 442 1

Seq Scan on m_requisition req (cost=0.00..17.41 rows=441 width=15) (actual time=0.006..0.664 rows=442 loops=1)

Planning time : 0.372 ms
Execution time : 29.965 ms