explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DS0B

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.334 ↑ 1.0 1 1

Aggregate (cost=20.84..20.85 rows=1 width=8) (actual time=0.334..0.334 rows=1 loops=1)

2. 0.002 0.330 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.06..20.84 rows=1 width=0) (actual time=0.329..0.330 rows=0 loops=1)

  • Filter: (cce.sequence_id IS NULL)
3. 0.328 0.328 ↓ 0.0 0 1

Seq Scan on plans (cost=0.00..16.78 rows=1 width=24) (actual time=0.328..0.328 rows=0 loops=1)

  • Filter: ((created_at > (now() - '00:15:00'::interval)) AND (created_at < (now() - '00:03:00'::interval)))
  • Rows Removed by Filter: 136
4. 0.000 0.000 ↓ 0.0 0

Index Scan using campaign_creation_events_profile_id_plan_id_event_type_index on campaign_creation_events cce (cost=0.06..4.06 rows=1 width=32) (never executed)

  • Index Cond: ((plans.profile_id = profile_id) AND (plans.id = plan_id))
  • Filter: ((event_type)::text ~~* 'Enqueue%Email'::text)
Planning time : 2.521 ms
Execution time : 0.477 ms