explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oDd6 : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #65ft; plan #i0gM; plan #B5wV; plan #kkvw; plan #Ws7g; plan #j4bP

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 370.232 1,877.958 ↑ 3.9 176 1

HashAggregate (cost=600,403.81..600,410.65 rows=684 width=20) (actual time=1,877.937..1,877.958 rows=176 loops=1)

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

Index Scan using widgets_pkey on widgets (cost=0.57..590,292.18 rows=1,348,217 width=12) (actual time=0.124..1,507.726 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