explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wk6J : Title1

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

Limit (cost=0.85..867.63 rows=1 width=824) (actual time=0.16..0.16 rows=0 loops=1)

2. 0.002 0.159 ↓ 0.0 0 1

Nested Loop (cost=0.85..867.63 rows=1 width=824) (actual time=0.159..0.159 rows=0 loops=1)

3. 0.113 0.113 ↓ 22.0 22 1

Index Scan using leads_campaignid_idx on Leads Leads (cost=0.43..862.76 rows=1 width=824) (actual time=0.022..0.113 rows=22 loops=1)

  • Index Cond: ("CAMPAIGN_ID" = 7,821)
  • Filter: (("ID" <> 34793155) AND (("COMPANY_DOMAIN")::text = 'avinty.com'::text))
4. 0.044 0.044 ↓ 0.0 0 22

Index Scan using lead_steps_lead_id_idx on lead_steps x58 (cost=0.42..4.85 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=22)

  • Index Cond: (lead_id = "Leads"."ID")
  • Filter: (((step_type)::text = 'AUTOMATIC_EMAIL'::text) AND ((status)::text = 'COMPLETED'::text))
Planning time : 0.57 ms
Execution time : 0.23 ms