explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R0k : Optimization for: plan #jjT8

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 906.662 22,212.508 ↑ 4.7 176 1

HashAggregate (cost=226,327.23..226,335.44 rows=821 width=20) (actual time=22,212.469..22,212.508 rows=176 loops=1)

  • Group Key: imb_id
2. 21,305.846 21,305.846 ↓ 1.3 1,772,282 1

Index Scan using widgets_date_idx on widgets (cost=0.44..215,890.91 rows=1,391,509 width=12) (actual time=0.891..21,305.846 rows=1,772,282 loops=1)

  • Index Cond: ((date >= '2019-04-28'::date) AND (date <= '2019-05-10'::date))
  • Filter: (source_id = 12)
  • Rows Removed by Filter: 9099