explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MC1F : Optimization for: plan #ubqv

Settings

Optimization path:

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

Nested Loop Left Join (cost=0.27..16.31 rows=1 width=72) (actual rows= loops=)

  • Join Filter: (order_emails.campaign_entry_id = campaign_entries.id)
  • Filter: (order_emails.id IS NULL)
2. 0.000 0.000 ↓ 0.0

Index Scan using index_campaign_entries_on_entered_at on campaign_entries (cost=0.12..8.14 rows=1 width=72) (actual rows= loops=)

  • Index Cond: (entered_at <= '2019-09-01 13:51:14.245611+00'::timestamp with time zone)
3. 0.000 0.000 ↓ 0.0

Index Scan using index_order_emails_on_state_and_shop_id on order_emails (cost=0.14..8.16 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((state)::text = 'scheduled'::text)