explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tW0V

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=17,050,572.23..17,050,572.24 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on oms_order_item (cost=455,448.44..16,903,835.77 rows=58,694,586 width=8) (actual rows= loops=)

  • Recheck Cond: (update_ts < '2018-12-10 00:00:00'::timestamp without time zone)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on oms_order_item_update_ts_idx (cost=0.00..440,774.80 rows=58,694,586 width=0) (actual rows= loops=)

  • Index Cond: (update_ts < '2018-12-10 00:00:00'::timestamp without time zone)