explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h0Ro

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.048 ↓ 0.0 0 1

Bitmap Heap Scan on loaneligs (cost=4.48..35.68 rows=8 width=4) (actual time=0.048..0.048 rows=0 loops=1)

  • Recheck Cond: ((email)::text = 'williamair1@gmail.com'::text)
2. 0.045 0.045 ↓ 0.0 0 1

Bitmap Index Scan on index_loaneligs_on_email (cost=0.00..4.48 rows=8 width=0) (actual time=0.045..0.045 rows=0 loops=1)

  • Index Cond: ((email)::text = 'williamair1@gmail.com'::text)
Planning time : 0.089 ms
Execution time : 0.063 ms