explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JFjx : Optimization for: plan #wlFW

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 598.795 601.661 ↓ 1.0 80,016 1

Bitmap Heap Scan on sandbox (cost=1,487.35..24,101.17 rows=79,345 width=12) (actual time=2.927..601.661 rows=80,016 loops=1)

  • Recheck Cond: (x < '0.02'::double precision)
  • Heap Blocks: exact=433
  • Buffers: shared hit=654
2. 2.866 2.866 ↓ 1.0 80,016 1

Bitmap Index Scan on sandbox_x_idx (cost=0.00..1,467.52 rows=79,345 width=0) (actual time=2.859..2.866 rows=80,016 loops=1)

  • Index Cond: (x < '0.02'::double precision)
  • Buffers: shared hit=221