explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QZhv

Settings
# exclusive inclusive rows x rows loops node
1. 972.415 1,046.251 ↓ 1.0 422,362 1

Bitmap Heap Scan on sampletable (cost=9,661.56..68,931.29 rows=417,178 width=11) (actual time=78.122..1,046.251 rows=422,362 loops=1)

  • Recheck Cond: (x < '423'::numeric)
  • Rows Removed by Index Recheck: 4681634
  • Heap Blocks: exact=27603 lossy=26440
2. 73.836 73.836 ↓ 1.0 422,362 1

Bitmap Index Scan on idx_x (cost=0.00..9,557.27 rows=417,178 width=0) (actual time=73.836..73.836 rows=422,362 loops=1)

  • Index Cond: (x < '423'::numeric)