explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YqIn

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

Hash Left Join (cost=8.17..29.32 rows=1 width=72) (actual rows= loops=)

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

Seq Scan on campaign_entries (cost=0.00..20.12 rows=270 width=72) (actual rows= loops=)

  • Filter: (entered_at < '2019-09-01 13:45:04.087964+00'::timestamp with time zone)
3. 0.000 0.000 ↓ 0.0

Hash (cost=8.16..8.16 rows=1 width=12) (actual rows= loops=)

4. 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)