explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fDya

Settings
# exclusive inclusive rows x rows loops node
1. 220.570 223.481 ↓ 1.5 34,446 1

Bitmap Heap Scan on users (cost=380.78..2,164.05 rows=22,951 width=337) (actual time=3.037..223.481 rows=34,446 loops=1)

  • Recheck Cond: ((valid = 'Y'::bpchar) AND (email_valid = 'Y'::bpchar))
  • Heap Blocks: exact=966
2. 2.911 2.911 ↓ 1.5 34,446 1

Bitmap Index Scan on users_valid_email_valid_idx (cost=0.00..375.05 rows=22,951 width=0) (actual time=2.905..2.911 rows=34,446 loops=1)