explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uS4U

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

Nested Loop Anti Join (cost=0.43..64.27 rows=1 width=290) (actual time=0.003..0.003 rows=0 loops=1)

  • Join Filter: ((subscribers_maileon_event.email)::text = (ecc.email)::text)
2. 0.001 0.003 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.43..27.73 rows=1 width=290) (actual time=0.002..0.003 rows=0 loops=1)

3. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on event_campaign_contacts ecc (cost=0.00..19.20 rows=1 width=290) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ("unsubscriptionDate" IS NULL)
4. 0.000 0.000 ↓ 0.0 0

Index Scan using subscribers_pkey on subscribers (cost=0.43..8.49 rows=1 width=22) (never executed)

  • Index Cond: ((email)::text = (ecc.email)::text)
  • Filter: ('szallashu'::text = ANY ((list)::text[]))
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on subscribers_maileon_event (cost=0.00..36.50 rows=1 width=32) (never executed)

  • Filter: (("eventID" = 543) AND ("sendDate" < (CURRENT_DATE - 14)))
Planning time : 0.282 ms
Execution time : 0.036 ms