explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WRwb

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

GroupAggregate (cost=3,398.30..3,398.31 rows=1 width=68) (actual rows= loops=)

  • Group Key: day_in_tz
2. 0.000 0.000 ↓ 0.0

Sort (cost=3,398.30..3,398.30 rows=1 width=18) (actual rows= loops=)

  • Sort Key: day_in_tz
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on dw_daily_orders (cost=1,907.61..3,398.30 rows=1 width=18) (actual rows= loops=)

  • Recheck Cond: ((day_in_tz >= '2020-10-07'::date) AND (day_in_tz <= '2020-10-14'::date))
  • Filter: ((NOT is_test) AND (order_type <> 'kiosk'::order_type) AND (dispensary_identifier = 'xLmYvNMy96jPXugQx'::text))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on dw_daily_orders_day_idx (cost=0.00..1,907.61 rows=748 width=0) (actual rows= loops=)

  • Index Cond: ((day_in_tz >= '2020-10-07'::date) AND (day_in_tz <= '2020-10-14'::date))