explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xhBJ

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

Seq Scan on loaneligs (cost=0.00..10,580.51 rows=1,649 width=4) (actual time=257.968..257.968 rows=0 loops=1)

  • Filter: (lower((email)::text) = 'williamair1@gmail.com'::text)
  • Rows Removed by Filter: 328651
Planning time : 0.084 ms
Execution time : 258.522 ms