explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 72jG

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.078 ↑ 233.5 2 1

Sort (cost=2,158.73..2,159.90 rows=467 width=254) (actual time=0.077..0.078 rows=2 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
2. 0.043 0.067 ↑ 233.5 2 1

Bitmap Heap Scan on users (cost=23.98..2,138.02 rows=467 width=254) (actual time=0.062..0.067 rows=2 loops=1)

  • Recheck Cond: (lower((mailing_list_email)::text) = 'dimaofman@gmail.com'::text)
  • Filter: (is_guest AND (pwhash IS NULL))
  • Rows Removed by Filter: 77
  • Heap Blocks: exact=15
3. 0.024 0.024 ↑ 12.6 79 1

Bitmap Index Scan on ix_user_mailing_list_email (cost=0.00..23.87 rows=993 width=0) (actual time=0.023..0.024 rows=79 loops=1)

  • Index Cond: (lower((mailing_list_email)::text) = 'dimaofman@gmail.com'::text)
Planning time : 0.366 ms
Execution time : 0.110 ms