explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bbh : sloooooow

Settings
# exclusive inclusive rows x rows loops node
1. 16,931.874 17,055.046 ↓ 1.0 218,965 1

Bitmap Heap Scan on foo (cost=4,081.37..248,297.73 rows=217,910 width=4) (actual time=211.433..17,055.046 rows=218,965 loops=1)

  • Recheck Cond: (val = 55)
2. 123.172 123.172 ↓ 1.0 218,965 1

Bitmap Index Scan on val_index (cost=0.00..4,026.89 rows=217,910 width=0) (actual time=123.172..123.172 rows=218,965 loops=1)

  • Index Cond: (val = 55)