explain.depesz.com

A tool for finding a real cause for slow queries.

Result: WaeO

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=115,330.59..3,448,395.83 rows=133 width=68) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=115,330.59..3,171,185.23 rows=49,436 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..1,738,951.32 rows=41,967,500 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=60,920.26..60,920.26 rows=3,316,426 width=7) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on user_notification un (cost=0.00..60,920.26 rows=3,316,426 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))