explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lJKg

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.199 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.79..117.64 rows=1 width=762) (actual time=0.193..0.199 rows=1 loops=1)

2. 0.002 0.180 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.23..109.31 rows=1 width=372) (actual time=0.175..0.180 rows=1 loops=1)

3. 0.002 0.173 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.67..100.99 rows=1 width=330) (actual time=0.168..0.173 rows=1 loops=1)

4. 0.002 0.166 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.11..92.67 rows=1 width=288) (actual time=0.161..0.166 rows=1 loops=1)

5. 0.002 0.157 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.55..84.36 rows=1 width=246) (actual time=0.152..0.157 rows=1 loops=1)

6. 0.002 0.150 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.99..76.04 rows=1 width=204) (actual time=0.146..0.150 rows=1 loops=1)

7. 0.002 0.143 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.43..67.72 rows=1 width=162) (actual time=0.139..0.143 rows=1 loops=1)

8. 0.001 0.134 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.14..59.42 rows=1 width=162) (actual time=0.131..0.134 rows=1 loops=1)

9. 0.002 0.125 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.86..51.11 rows=1 width=161) (actual time=0.122..0.125 rows=1 loops=1)

10. 0.001 0.118 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.57..42.81 rows=1 width=161) (actual time=0.115..0.118 rows=1 loops=1)

11. 0.002 0.110 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.29..34.51 rows=1 width=161) (actual time=0.107..0.110 rows=1 loops=1)

12. 0.002 0.103 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.00..26.20 rows=1 width=160) (actual time=0.100..0.103 rows=1 loops=1)

13. 0.017 0.090 ↑ 1.0 1 1

Nested Loop (cost=0.72..17.90 rows=1 width=160) (actual time=0.088..0.090 rows=1 loops=1)

14. 0.046 0.046 ↑ 1.0 1 1

Index Scan using service_request1__c_idx_sfid on service_request1__c sr (cost=0.43..8.45 rows=1 width=66) (actual time=0.043..0.046 rows=1 loops=1)

  • Index Cond: ((sfid)::text = 'a0c0H00000fQ6bNQAS'::text)
15. 0.027 0.027 ↑ 1.0 1 1

Index Scan using work_order_dispatch__c_idx_sfid on work_order_dispatch__c wodc (cost=0.29..8.30 rows=1 width=131) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((sfid)::text = (sr.work_order_dispatch__c)::text)
  • Filter: ((account__c)::text = '001i000001j9eWYAAY'::text)
16. 0.011 0.011 ↓ 0.0 0 1

Index Scan using service_technician__c_idx_sfid on service_technician__c st1 (cost=0.29..8.30 rows=1 width=38) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (wodc.service_technician__c)::text)
17. 0.005 0.005 ↓ 0.0 0 1

Index Scan using service_technician__c_idx_sfid on service_technician__c st2 (cost=0.29..8.30 rows=1 width=38) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (wodc.phone_tree_2__c)::text)
18. 0.007 0.007 ↓ 0.0 0 1

Index Scan using service_technician__c_idx_sfid on service_technician__c st3 (cost=0.29..8.30 rows=1 width=38) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (wodc.phone_tree_3__c)::text)
19. 0.005 0.005 ↓ 0.0 0 1

Index Scan using service_technician__c_idx_sfid on service_technician__c st4 (cost=0.29..8.30 rows=1 width=38) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (wodc.phone_tree_4__c)::text)
20. 0.008 0.008 ↓ 0.0 0 1

Index Scan using service_technician__c_idx_sfid on service_technician__c st5 (cost=0.29..8.30 rows=1 width=38) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (wodc.phone_tree_5__c)::text)
21. 0.007 0.007 ↓ 0.0 0 1

Index Scan using service_technician__c_idx_sfid on service_technician__c st6 (cost=0.29..8.30 rows=1 width=38) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (wodc.phone_tree_6__c)::text)
22. 0.005 0.005 ↓ 0.0 0 1

Index Scan using contact_idx_sfid on contact c1 (cost=0.56..8.32 rows=1 width=80) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (st1.contact__c)::text)
23. 0.005 0.005 ↓ 0.0 0 1

Index Scan using contact_idx_sfid on contact c2 (cost=0.56..8.32 rows=1 width=80) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (st2.contact__c)::text)
24. 0.007 0.007 ↓ 0.0 0 1

Index Scan using contact_idx_sfid on contact c3 (cost=0.56..8.32 rows=1 width=80) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (st3.contact__c)::text)
25. 0.005 0.005 ↓ 0.0 0 1

Index Scan using contact_idx_sfid on contact c4 (cost=0.56..8.32 rows=1 width=80) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (st4.contact__c)::text)
26. 0.005 0.005 ↓ 0.0 0 1

Index Scan using contact_idx_sfid on contact c5 (cost=0.56..8.32 rows=1 width=80) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (st5.contact__c)::text)
27. 0.008 0.008 ↓ 0.0 0 1

Index Scan using contact_idx_sfid on contact c6 (cost=0.56..8.32 rows=1 width=80) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (st6.contact__c)::text)
Planning time : 21.734 ms
Execution time : 1.586 ms