explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wlFW

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 6,486.807 6,500.287 ↑ 16.7 80,016 1

Bitmap Heap Scan on sandbox (cost=24,961.76..63,250.42 rows=1,333,333 width=12) (actual time=16.733..6,500.287 rows=80,016 loops=1)

  • Recheck Cond: (x < '0.02'::double precision)
  • Heap Blocks: exact=21141
  • Buffers: shared hit=60 read=21302 written=1055
2. 13.480 13.480 ↑ 16.7 80,016 1

Bitmap Index Scan on sandbox_x_idx (cost=0.00..24,628.43 rows=1,333,333 width=0) (actual time=13.473..13.480 rows=80,016 loops=1)

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