explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B5wV : Optimization for: Optimization for: plan #65ft; plan #i0gM

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 51.070 3,072.684 ↑ 7.0 93 1

HashAggregate (cost=529,444.59..529,451.09 rows=650 width=20) (actual time=3,072.671..3,072.684 rows=93 loops=1)

  • Group Key: imb_id
2. 3,021.614 3,021.614 ↑ 1.3 193,743 1

Index Scan using widgets_pkey on widgets (cost=0.57..527,613.63 rows=244,128 width=12) (actual time=2.243..3,021.614 rows=193,743 loops=1)

  • Index Cond: ((date >= '2019-05-28'::date) AND (date <= '2019-06-10'::date))
  • Filter: (source_id = 12)
  • Rows Removed by Filter: 1013491
Planning time : 3.165 ms
Execution time : 3,073.241 ms