explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y8oi

Settings
# exclusive inclusive rows x rows loops node
1. 7.970 491,302.893 ↑ 1.0 100,000 1

Limit (cost=6,501,922.43..7,071,195.54 rows=100,000 width=33) (actual time=491,140.355..491,302.893 rows=100,000 loops=1)

2. 13,100.363 491,294.923 ↑ 21.3 100,000 1

Hash Join (cost=6,501,922.43..18,601,662.94 rows=2,125,472 width=33) (actual time=491,140.354..491,294.923 rows=100,000 loops=1)

  • Hash Cond: ((ol.c_order_id)::text = (o.c_order_id)::text)
  • Join Filter: ((o.em_obpos_isdeleted = 'Y'::bpchar) OR (ol.em_obpos_isdeleted = 'Y'::bpchar) OR ((o.dateordered < to_date('01-01-2018'::text, 'dd-MM-yyyy'::text)) AND (ol.qtydelivered = ol.qtyordered)))
  • Rows Removed by Join Filter: 92323
3. 256,946.067 256,946.067 ↑ 1.1 30,862,770 1

Seq Scan on c_orderline ol (cost=0.00..8,048,971.35 rows=33,347,381 width=76) (actual time=20.687..256,946.067 rows=30,862,770 loops=1)

  • Filter: (((em_obrdc_delivery_condition)::text = 'DeferredCarriedAwayDate'::text) AND ((ad_client_id)::text = '9404134F8B374DEE92E79CD87B834E19'::text))
  • Rows Removed by Filter: 59497858
4. 15,552.187 221,248.493 ↓ 1.0 46,786,909 1

Hash (cost=5,505,872.08..5,505,872.08 rows=46,786,908 width=43) (actual time=221,248.493..221,248.493 rows=46,786,909 loops=1)

  • Buckets: 65536 Batches: 1024 Memory Usage: 4092kB
5. 205,696.306 205,696.306 ↓ 1.0 46,786,909 1

Seq Scan on c_order o (cost=0.00..5,505,872.08 rows=46,786,908 width=43) (actual time=0.453..205,696.306 rows=46,786,909 loops=1)