explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 428.026 12,249.089 ↑ 3.7 176 1

HashAggregate (cost=1,321,495.19..1,321,501.69 rows=650 width=20) (actual time=12,249.068..12,249.089 rows=176 loops=1)

  • Group Key: imb_id
2. 11,514.462 11,821.063 ↓ 1.3 1,772,282 1

Bitmap Heap Scan on widgets (cost=43,403.87..1,310,866.43 rows=1,417,168 width=12) (actual time=315.616..11,821.063 rows=1,772,282 loops=1)

  • Recheck Cond: ((date >= '2019-04-28'::date) AND (date <= '2019-05-10'::date))
  • Rows Removed by Index Recheck: 11280150
  • Filter: (source_id = 12)
  • Rows Removed by Filter: 9099
  • Heap Blocks: exact=44345 lossy=188041
3. 306.601 306.601 ↓ 1.1 1,781,381 1

Bitmap Index Scan on widgets_pkey (cost=0.00..43,049.58 rows=1,686,101 width=0) (actual time=306.601..306.601 rows=1,781,381 loops=1)

  • Index Cond: ((date >= '2019-04-28'::date) AND (date <= '2019-05-10'::date))
Planning time : 0.662 ms
Execution time : 12,249.656 ms