explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rne

Settings
# exclusive inclusive rows x rows loops node
1. 1,415.135 1,420.954 ↓ 1.1 833 1

Bitmap Heap Scan on public.browsehomes (cost=18.66..3,123.13 rows=786 width=64) (actual time=7.472..1,420.954 rows=833 loops=1)

  • Output: url
  • Recheck Cond: (browsehomes.fourclicksleafid = 10047)
  • Heap Blocks: exact=833
2. 5.819 5.819 ↓ 1.1 833 1

Bitmap Index Scan on idx_fourclicks (cost=0.00..18.46 rows=786 width=0) (actual time=5.818..5.819 rows=833 loops=1)

  • Index Cond: (browsehomes.fourclicksleafid = 10047)