explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GlRo : Optimization for: replenishment; plan #5LIH

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.006 1.284 ↑ 2.0 1 1

Append (cost=11.48..72.22 rows=2 width=148) (actual time=1.251..1.284 rows=1 loops=1)

2. 0.011 1.261 ↑ 1.0 1 1

Nested Loop Left Join (cost=11.48..35.44 rows=1 width=97) (actual time=1.248..1.261 rows=1 loops=1)

3. 0.009 1.248 ↑ 1.0 1 1

Nested Loop (cost=11.19..31.51 rows=1 width=92) (actual time=1.237..1.248 rows=1 loops=1)

4. 0.665 1.230 ↑ 1.0 1 1

Hash Join (cost=10.92..31.06 rows=1 width=83) (actual time=1.226..1.230 rows=1 loops=1)

  • Hash Cond: (line.ref_orderline_id = sol.c_orderline_id)
5. 0.548 0.548 ↑ 1.0 446 1

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

6. 0.006 0.017 ↑ 3.0 1 1

Hash (cost=10.88..10.88 rows=3 width=12) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.011 0.011 ↑ 3.0 1 1

Index Scan using c_orderline_order on c_orderline sol (cost=0.29..10.88 rows=3 width=12) (actual time=0.009..0.011 rows=1 loops=1)

  • Index Cond: (c_order_id = '1002525'::numeric)
8. 0.009 0.009 ↑ 1.0 1 1

Index Scan using m_requisition_pkey on m_requisition req (cost=0.27..0.44 rows=1 width=15) (actual time=0.005..0.009 rows=1 loops=1)

  • Index Cond: (m_requisition_id = line.m_requisition_id)
9. 0.002 0.002 ↓ 0.0 0 1

Index Scan using c_orderline_pkey on c_orderline poline (cost=0.29..3.40 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (line.c_orderline_id = c_orderline_id)
10. 0.002 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.84..36.76 rows=1 width=96) (actual time=0.017..0.017 rows=0 loops=1)

11. 0.006 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.56..35.80 rows=1 width=47) (actual time=0.015..0.015 rows=0 loops=1)

12. 0.006 0.006 ↑ 3.0 1 1

Index Scan using c_orderline_order on c_orderline sol_1 (cost=0.29..10.88 rows=3 width=12) (actual time=0.004..0.006 rows=1 loops=1)

  • Index Cond: (c_order_id = '1002525'::numeric)
13. 0.003 0.003 ↓ 0.0 0 1

Index Scan using m_movement_soline_id on m_movement mov (cost=0.28..8.30 rows=1 width=41) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (c_orderline_id = sol_1.c_orderline_id)
  • Filter: (docstatus <> 'VO'::bpchar)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using m_movementline_movement on m_movementline line_1 (cost=0.28..0.42 rows=1 width=55) (never executed)

  • Index Cond: (m_movement_id = mov.m_movement_id)
Planning time : 1.427 ms
Execution time : 1.447 ms