explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 618.335 36,161.696 ↑ 3.7 176 1

HashAggregate (cost=624,750.60..624,757.10 rows=650 width=20) (actual time=36,161.670..36,161.696 rows=176 loops=1)

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

Index Scan using widgets_pkey on widgets (cost=0.57..614,121.84 rows=1,417,168 width=12) (actual time=0.721..35,543.361 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
Planning time : 6.028 ms
Execution time : 36,161.806 ms