explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UsFs : Optimization for: Optimization for: Optimization for: plan #LaHU; plan #IaEQ; plan #ewLA

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 325.410 908.954 ↑ 3.9 176 1

HashAggregate (cost=171,875.79..171,882.63 rows=684 width=20) (actual time=908.934..908.954 rows=176 loops=1)

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

Index Scan using widgets_date_idx on widgets (cost=0.44..161,768.38 rows=1,347,655 width=12) (actual time=0.013..583.544 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 : 0.152 ms
Execution time : 908.987 ms