explain.depesz.com

A tool for finding a real cause for slow queries.

Result: WaeO

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=115330.59..3448395.83 rows=133 width=68) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Hash Left Join (cost=115330.59..3171185.23 rows=49436 width=68) (actual time=.. rows= loops=)

  • Hash Cond: (u.id = un.id)
  • Filter: (((un.neverever <> true) OR (un.neverever IS NULL)) AND ((un.product_announcements <> true) OR (un.product_announcements IS NULL)) AND ((un.bouncedisabled <> true) OR (un.bouncedisabled IS NULL)))
3. 0.000 0.000 ↓ 0.0
→

Seq Scan on users u (cost=0.00..1738951.32 rows=41967500 width=68) (actual time=.. rows= loops=)

  • Filter: ((NOT disabled) AND ((banned IS NULL) OR (NOT banned)) AND (upper(email) ~~ '%@%'::text))
4. 0.000 0.000 ↓ 0.0
→

Hash (cost=60920.26..60920.26 rows=3316426 width=7) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0
→

Seq Scan on user_notification un (cost=0.00..60920.26 rows=3316426 width=7) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Index Scan using userinfouser on user_info ui (cost=0.00..5.59 rows=1 width=4) (actual time=.. rows= loops=)

  • Index Cond: (ui."user" = u.id)
  • Filter: ((ui.lastbrowsedate <= 1135987200) AND ((ui.lang)::text = 'en'::text))