explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DFRkS

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 1.508 ↑ 1.0 1 1

Aggregate (cost=48,041.70..48,041.71 rows=1 width=8) (actual time=1.507..1.508 rows=1 loops=1)

  • Buffers: shared hit=3 read=4
2. 0.037 1.499 ↑ 50,000.0 1 1

Bitmap Heap Scan on test (cost=939.93..47,916.70 rows=50,000 width=0) (actual time=1.497..1.499 rows=1 loops=1)

  • Recheck Cond: (i = ?)
  • Heap Blocks: exact=1
  • Buffers: shared hit=3 read=4
3. 1.462 1.462 ↑ 50,000.0 1 1

Bitmap Index Scan on test_i_idx (cost=0.00..927.43 rows=50,000 width=0) (actual time=1.461..1.462 rows=1 loops=1)

  • Index Cond: (i = ?)
  • Buffers: shared hit=3 read=3