explain.depesz.com

PostgreSQL's explain analyze made readable

Result: olNl : Optimization for: Optimization for: plan #vGYd; plan #eo6U

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.003 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.27..19.98 rows=1 width=1,246) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: users.user_id, users.customer_id, users.email_address, users.first_name, users.country_code, users.subs_status, users.subs_type, users.mbw, users.email_confirmed, users.gender, users.frequency, users.discount, users.totalsum, users.max_open_date_camp
2. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.dm_users users (cost=0.00..12.50 rows=1 width=1,246) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: users.id, users.customer_id, users.email_confirmed, users.subs_type, users.email_address, users.first_name, users.country_code, users.mbw, users.date_of_birth, users.gender, users.last_newsl_subscr_chg_date, users.newsl_registration_date, users.orders_cum, users.frequency, users.telephone, users.sms_status, users.totalsum, users.discount, users.rec_simple_sku2, users.max_open_date_camp, users.user_id, users.subs_status, users.last_order_date, users.first_order_date, users.max_open_date_trans
  • Filter: ((users.subs_status = 1) AND ((date_part('day'::text, ((CURRENT_DATE)::timestamp without time zone - users.max_open_date_camp)) < '180'::double precision) OR (date_part('day'::text, ((CURRENT_DATE)::timestamp without time zone - users.max_open_date_trans)) < '180'::double precision) OR (date_part('day'::text, ((CURRENT_DATE)::timestamp without time zone - users.newsl_registration_date)) < '180'::double precision) OR (date_part('day'::text, ((CURRENT_DATE)::timestamp without time zone - users.last_newsl_subscr_chg_date)) < '180'::double precision)))
3. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dm_blacklist_email_idx on public.dm_blacklist blacklist (cost=0.27..8.29 rows=1 width=19) (never executed)

  • Output: blacklist.email
  • Index Cond: (blacklist.email = (users.email_address)::text)
  • Heap Fetches: 0
Planning time : 0.138 ms
Execution time : 0.040 ms