explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JiM7

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,434.264 ↑ 20.0 1 1

Limit (cost=0.43..1,839.91 rows=20 width=256) (actual time=1,037.994..1,434.264 rows=1 loops=1)

2. 1,434.263 1,434.263 ↑ 2,016.0 1 1

Index Scan using user_pkey on users (cost=0.43..185,419.62 rows=2,016 width=256) (actual time=1,037.993..1,434.263 rows=1 loops=1)

  • Filter: (is_guest AND (pwhash IS NULL) AND (lower((mailing_list_email)::text) = 'dimaofman@gmail.com'::text))
  • Rows Removed by Filter: 3300231
Planning time : 0.089 ms
Execution time : 1,434.279 ms