explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i0gM : Optimization for: plan #65ft

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 312.667 73,563.330 ↑ 6.6 123 1

HashAggregate (cost=1,352,086.88..1,352,095.03 rows=815 width=20) (actual time=73,563.277..73,563.330 rows=123 loops=1)

  • Group Key: imb_id
2. 73,250.663 73,250.663 ↑ 4.6 584,059 1

Index Scan using widgets_pkey on widgets (cost=0.57..1,331,919.62 rows=2,688,968 width=12) (actual time=1.026..73,250.663 rows=584,059 loops=1)

  • Index Cond: ((date >= '2019-05-28'::date) AND (date <= '2019-06-10'::date))
  • Filter: (source_id = 12)
  • Rows Removed by Filter: 2761757
Planning time : 0.194 ms
Execution time : 73,563.385 ms