explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jjT8

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 959.716 73,492.906 ↑ 4.7 176 1

HashAggregate (cost=733,647.86..733,656.07 rows=821 width=20) (actual time=73,492.836..73,492.906 rows=176 loops=1)

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

Index Scan using widgets_pkey on widgets (cost=0.57..723,290.78 rows=1,380,944 width=12) (actual time=1.962..72,533.190 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 : 7.030 ms
Execution time : 73,493.051 ms