explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lozd

Settings
# exclusive inclusive rows x rows loops node
1. 227.745 228.740 ↓ 1.5 34,446 1

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

  • Recheck Cond: ((valid = 'Y'::bpchar) AND (email_valid = 'Y'::bpchar))
  • Heap Blocks: exact=966
2. 0.995 0.995 ↓ 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=0.989..0.995 rows=34,446 loops=1)