explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nNDH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 74.394 ↑ 1.0 1 1

Aggregate (cost=1,928.86..1,928.87 rows=1 width=8) (actual time=74.394..74.394 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.008 0.008 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.007..0.008 rows=1 loops=1)

4. 0.034 0.034 ↑ 1.0 1 1

Index Scan using ews_mrp_job_orders_job_name_uniq on ews_mrp_job_orders (cost=0.28..8.30 rows=1 width=4) (actual time=0.033..0.034 rows=1 loops=1)

  • Index Cond: ((name)::text = '1455'::text)
5. 5.438 74.354 ↓ 10.0 20 1

Hash Right Join (cost=1,696.65..1,920.54 rows=2 width=8) (actual time=64.283..74.354 rows=20 loops=1)

  • Hash Cond: (shipping_outbound_detail.outbound_id = shipping_outbound.id)
6. 15.079 64.546 ↑ 1.3 7,304 1

HashAggregate (cost=1,074.71..1,168.97 rows=9,426 width=8) (actual time=58.671..64.546 rows=7,304 loops=1)

  • Group Key: shipping_outbound_detail.outbound_id
7. 23.359 49.467 ↓ 1.0 9,744 1

Hash Join (cost=423.59..1,027.58 rows=9,426 width=8) (actual time=11.774..49.467 rows=9,744 loops=1)

  • Hash Cond: (shipping_outbound_detail.detail_id = ews_mrp_release_orders.id)
8. 14.362 14.362 ↑ 1.0 18,235 1

Seq Scan on shipping_outbound_detail (cost=0.00..441.35 rows=18,235 width=12) (actual time=0.004..14.362 rows=18,235 loops=1)

9. 4.503 11.746 ↑ 1.0 5,545 1

Hash (cost=354.01..354.01 rows=5,566 width=4) (actual time=11.746..11.746 rows=5,545 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 259kB
10. 7.243 7.243 ↑ 1.0 5,545 1

Seq Scan on ews_mrp_release_orders (cost=0.00..354.01 rows=5,566 width=4) (actual time=0.005..7.243 rows=5,545 loops=1)

  • Filter: ((original_detail_code)::text = '6'::text)
  • Rows Removed by Filter: 1,947
11. 0.022 4.370 ↓ 10.0 20 1

Hash (cost=621.92..621.92 rows=2 width=4) (actual time=4.370..4.370 rows=20 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 4.348 4.348 ↓ 10.0 20 1

Seq Scan on shipping_outbound (cost=0.00..621.92 rows=2 width=4) (actual time=3.228..4.348 rows=20 loops=1)

  • Filter: ((ship_date < $0) AND ((state)::text <> 'cancel'::text) AND (job_id = $1))
  • Rows Removed by Filter: 11,861
Planning time : 0.810 ms
Execution time : 74.519 ms