explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZSf1 : test1

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 0.342 ↑ 1.0 10 1

Bitmap Heap Scan on tenk1 (cost=25.08..60.21 rows=10 width=244) (actual time=0.323..0.342 rows=10 loops=1)

  • Recheck Cond: ((unique1 < 100) AND (unique2 > 9000))
  • Buffers: shared hit=15
2. 0.039 0.309 ↓ 0.0 0 1

BitmapAnd (cost=25.08..25.08 rows=10 width=0) (actual time=0.309..0.309 rows=0 loops=1)

  • Buffers: shared hit=7
3. 0.043 0.043 ↑ 1.0 100 1

Bitmap Index Scan on tenk1_unique1 (cost=0.00..5.04 rows=101 width=0) (actual time=0.043..0.043 rows=100 loops=1)

  • Index Cond: (unique1 < 100)
  • Buffers: shared hit=2
4. 0.227 0.227 ↑ 1.0 999 1

Bitmap Index Scan on tenk1_unique2 (cost=0.00..19.78 rows=999 width=0) (actual time=0.227..0.227 rows=999 loops=1)

  • Index Cond: (unique2 > 9000)
  • Buffers: shared hit=5