explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g0X6

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.194 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.67..53.96 rows=1 width=2,938) (actual time=0.188..0.194 rows=1 loops=1)

2. 0.007 0.180 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.11..45.37 rows=1 width=2,851) (actual time=0.174..0.180 rows=1 loops=1)

3. 0.010 0.143 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.55..36.79 rows=1 width=2,855) (actual time=0.138..0.143 rows=1 loops=1)

4. 0.004 0.106 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.99..28.21 rows=1 width=2,630) (actual time=0.101..0.106 rows=1 loops=1)

5. 0.007 0.072 ↑ 1.0 1 1

Nested Loop (cost=0.57..19.77 rows=1 width=2,605) (actual time=0.066..0.072 rows=1 loops=1)

6. 0.006 0.043 ↑ 1.0 1 1

Nested Loop (cost=0.29..11.47 rows=1 width=2,582) (actual time=0.040..0.043 rows=1 loops=1)

7. 0.018 0.018 ↑ 1.0 1 1

Index Scan using call_analysis__c_pkey on call_analysis__c ca (cost=0.29..8.31 rows=1 width=487) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: (id = 23596)
  • Filter: ((account__c)::text = '001i0000019uqZDAAY'::text)
8. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on ca_scorecard__c cas (cost=0.00..3.15 rows=1 width=2,114) (actual time=0.017..0.019 rows=1 loops=1)

  • Filter: ((account__c)::text = '001i0000019uqZDAAY'::text)
  • Rows Removed by Filter: 11
9. 0.022 0.022 ↑ 1.0 1 1

Index Scan using account_idx_sfid on account acc (cost=0.28..8.30 rows=1 width=42) (actual time=0.020..0.022 rows=1 loops=1)

  • Index Cond: ((sfid)::text = '001i0000019uqZDAAY'::text)
10. 0.030 0.030 ↑ 1.0 1 1

Index Scan using property__c_idx_sfid on property__c pr (cost=0.42..8.44 rows=1 width=44) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((ca.property__c)::text = (sfid)::text)
11. 0.027 0.027 ↑ 1.0 1 1

Index Scan using hcu_idx_case_sfid on "case" c (cost=0.56..8.58 rows=1 width=244) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((ca.case__c)::text = (sfid)::text)
12. 0.030 0.030 ↑ 1.0 1 1

Index Scan using contact_idx_sfid on contact co (cost=0.56..8.58 rows=1 width=34) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((sfid)::text = (ca.reviewer__c)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
13. 0.004 0.004 ↓ 0.0 0 1

Index Scan using contact_idx_sfid on contact co1 (cost=0.56..8.58 rows=1 width=34) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((sfid)::text = (ca.agent__c)::text)