explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ukQY

Settings
# exclusive inclusive rows x rows loops node
1. 14.695 536,436.748 ↑ 1.0 100,000 1

Limit (cost=1,713,013.09..2,233,632.33 rows=100,000 width=33) (actual time=283,252.779..536,436.748 rows=100,000 loops=1)

2. 9,020.674 536,422.053 ↑ 17.4 100,000 1

Hash Join (cost=1,713,013.09..10,746,673.11 rows=1,735,176 width=33) (actual time=283,252.779..536,422.053 rows=100,000 loops=1)

  • Hash Cond: ((ol.c_order_id)::text = (o.c_order_id)::text)
3. 244,153.614 244,153.614 ↑ 1.1 30,862,770 1

Seq Scan on c_orderline ol (cost=0.00..8,048,971.35 rows=33,347,381 width=66) (actual time=0.009..244,153.614 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. 832.742 283,247.765 ↑ 1.0 2,389,356 1

Hash (cost=1,663,562.11..1,663,562.11 rows=2,434,479 width=33) (actual time=283,247.765..283,247.765 rows=2,389,356 loops=1)

  • Buckets: 131072 Batches: 64 Memory Usage: 3396kB
5. 282,415.023 282,415.023 ↑ 1.0 2,389,356 1

Index Scan using em_obpos_order_isdeleted on c_order o (cost=0.56..1,663,562.11 rows=2,434,479 width=33) (actual time=0.054..282,415.023 rows=2,389,356 loops=1)

  • Index Cond: (em_obpos_isdeleted = 'Y'::bpchar)