explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kr2W

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.042 ↑ 1.0 1 1

Nested Loop Left Join (cost=17.59..25.66 rows=1 width=215) (actual time=0.040..0.042 rows=1 loops=1)

2.          

CTE cc_record

3. 0.001 0.015 ↑ 1.0 1 1

Limit (cost=0.85..16.89 rows=1 width=16) (actual time=0.014..0.015 rows=1 loops=1)

4. 0.001 0.014 ↑ 1.0 1 1

Nested Loop (cost=0.85..16.89 rows=1 width=16) (actual time=0.014..0.014 rows=1 loops=1)

5. 0.008 0.008 ↑ 1.0 1 1

Index Scan using campaign_contact_pkey on campaign_contact (cost=0.57..8.59 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = 181403618)
6. 0.005 0.005 ↑ 1.0 1 1

Index Scan using campaign_pkey on campaign (cost=0.28..8.30 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = campaign_contact.campaign_id)
7. 0.016 0.016 ↑ 1.0 1 1

CTE Scan on cc_record (cost=0.00..0.02 rows=1 width=36) (actual time=0.015..0.016 rows=1 loops=1)

8. 0.002 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.70..8.74 rows=1 width=196) (actual time=0.024..0.025 rows=1 loops=1)

9. 0.020 0.020 ↑ 1.0 1 1

Index Scan using messaging_service_stick_cell_organization_unique_constraint on messaging_service_stick (cost=0.56..8.58 rows=1 width=53) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((cell = cc_record.cell) AND (organization_id = cc_record.organization_id))
10. 0.003 0.003 ↑ 1.0 1 1

Index Scan using messaging_service_pkey on messaging_service (cost=0.14..0.16 rows=1 width=179) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (messaging_service_sid = messaging_service_stick.messaging_service_sid)
Planning time : 44.130 ms
Execution time : 0.078 ms