explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AGBa

Settings
# exclusive inclusive rows x rows loops node
1. 13.010 13.949 ↓ 1.1 2,219 1

Bitmap Heap Scan on example1 (cost=40.49..3,604.59 rows=1,954 width=8) (actual time=1.597..13.949 rows=2,219 loops=1)

  • Recheck Cond: ((a = 5) OR (b = 6))
  • Heap Blocks: exact=1048
2. 0.074 0.939 ↓ 0.0 0 1

BitmapOr (cost=40.49..40.49 rows=1,955 width=0) (actual time=0.937..0.939 rows=0 loops=1)

3. 0.336 0.336 ↓ 1.1 1,111 1

Bitmap Index Scan on index_exampl1_a (cost=0.00..19.75 rows=977 width=0) (actual time=0.334..0.336 rows=1,111 loops=1)

  • Index Cond: (a = 5)
4. 0.529 0.529 ↓ 1.1 1,111 1

Bitmap Index Scan on index_exampl1_b (cost=0.00..19.76 rows=978 width=0) (actual time=0.527..0.529 rows=1,111 loops=1)

  • Index Cond: (b = 6)
Planning time : 2.092 ms
Execution time : 22.820 ms