explain.depesz.com

PostgreSQL's explain analyze made readable

Result: McP6

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.485 ↓ 1.9 13 1

Group (cost=140.02..140.05 rows=7 width=8) (actual time=0.478..0.485 rows=13 loops=1)

  • Group Key: cc.business_id
2. 0.046 0.478 ↓ 2.9 20 1

Sort (cost=140.02..140.03 rows=7 width=8) (actual time=0.475..0.478 rows=20 loops=1)

  • Sort Key: cc.business_id
  • Sort Method: quicksort Memory: 25kB
3. 0.033 0.432 ↓ 2.9 20 1

Nested Loop (cost=1.13..139.92 rows=7 width=8) (actual time=0.163..0.432 rows=20 loops=1)

4. 0.014 0.299 ↓ 1.2 20 1

Nested Loop (cost=0.85..133.76 rows=16 width=16) (actual time=0.133..0.299 rows=20 loops=1)

5. 0.072 0.187 ↑ 1.0 14 1

Nested Loop (cost=0.56..115.81 rows=14 width=16) (actual time=0.110..0.187 rows=14 loops=1)

6. 0.045 0.045 ↑ 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.031..0.045 rows=14 loops=1)

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

Index Only Scan using idx_business_user_id_status on business_user bu (cost=0.28..7.44 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=14)

  • Index Cond: (id = ubl.user_id)
  • Heap Fetches: 14
8. 0.098 0.098 ↑ 32.0 1 14

Index Scan using idx_carrier_contact_user_id on carrier_contact cc (cost=0.28..0.96 rows=32 width=24) (actual time=0.005..0.007 rows=1 loops=14)

  • Index Cond: (user_id = bu.id)
9. 0.100 0.100 ↑ 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.005..0.005 rows=1 loops=20)

  • Index Cond: (id = cc.carrier_contact_business_id)
  • Filter: (network_type = 4800)
Planning time : 1.736 ms
Execution time : 0.628 ms