explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WDLR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tenk1 (cost=25.01..60.14 rows=10 width=244) (actual rows= loops=)

  • Recheck Cond: ((unique1 < 100) AND (unique2 > 9000))
2. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=25.01..25.01 rows=10 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tenk1_unique1 (cost=0.00..5.01 rows=101 width=0) (actual rows= loops=)

  • Index Cond: (unique1 < 100)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tenk1_unique2 (cost=0.00..19.74 rows=999 width=0) (actual rows= loops=)

  • Index Cond: (unique2 > 9000)