explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7AAX

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.193 ↓ 2.9 20 1

Nested Loop (cost=1.13..124.82 rows=7 width=8) (actual time=0.023..0.193 rows=20 loops=1)

  • Join Filter: (ubl.user_id = bu.id)
2. 0.001 0.132 ↓ 2.9 20 1

Nested Loop (cost=0.85..121.97 rows=7 width=24) (actual time=0.016..0.132 rows=20 loops=1)

3. 0.015 0.071 ↓ 1.2 20 1

Nested Loop (cost=0.56..115.81 rows=16 width=32) (actual time=0.011..0.071 rows=20 loops=1)

4. 0.014 0.014 ↑ 1.0 14 1

Index Scan using idx_user_business_link_business_id on user_business_link ubl (cost=0.28..11.47 rows=14 width=8) (actual time=0.007..0.014 rows=14 loops=1)

  • Index Cond: (business_id = '1703858125129385245'::bigint)
5. 0.042 0.042 ↑ 1.0 1 14

Index Scan using idx_carrier_contact_user_id on carrier_contact cc (cost=0.28..7.44 rows=1 width=24) (actual time=0.002..0.003 rows=1 loops=14)

  • Index Cond: (user_id = ubl.user_id)
6. 0.060 0.060 ↑ 1.0 1 20

Index Scan using carrier_contact_business_pkey on carrier_contact_business ccb (cost=0.28..0.37 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=20)

  • Index Cond: (id = cc.carrier_contact_business_id)
  • Filter: (network_type = 4800)
7. 0.060 0.060 ↑ 1.0 1 20

Index Only Scan using idx_business_user_id on business_user bu (cost=0.28..0.39 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=20)

  • Index Cond: (id = cc.user_id)
  • Heap Fetches: 20