explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JAri

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.022 ↓ 0.0 0 1

Limit (cost=2.67..50.83 rows=1 width=461) (actual time=0.022..0.022 rows=0 loops=1)

2. 0.002 0.021 ↓ 0.0 0 1

WindowAgg (cost=2.67..50.83 rows=1 width=461) (actual time=0.021..0.021 rows=0 loops=1)

3. 0.000 0.019 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.67..50.79 rows=1 width=210) (actual time=0.019..0.019 rows=0 loops=1)

4. 0.000 0.019 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.11..42.21 rows=1 width=214) (actual time=0.019..0.019 rows=0 loops=1)

5. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=1.55..33.63 rows=1 width=207) (actual time=0.018..0.019 rows=0 loops=1)

6. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=1.13..25.19 rows=1 width=201) (actual time=0.018..0.018 rows=0 loops=1)

7. 0.001 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.85..16.89 rows=1 width=178) (actual time=0.018..0.018 rows=0 loops=1)

8. 0.017 0.017 ↓ 0.0 0 1

Index Scan Backward using hc_idx_call_analysis__c_call_created_date__c on call_analysis__c ca (cost=0.29..8.31 rows=1 width=161) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((call_created_date__c >= '2019-05-01 07:00:00'::timestamp without time zone) AND (call_created_date__c < '2019-05-15 07:00:00'::timestamp without time zone))
  • Filter: ((status__c)::text = ANY ('{Assigned,Pending}'::text[]))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using hcu_idx_case_sfid on "case" c (cost=0.56..8.58 rows=1 width=36) (never executed)

  • Index Cond: ((sfid)::text = (ca.case__c)::text)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using account_idx_sfid on account acc (cost=0.28..8.30 rows=1 width=42) (never executed)

  • Index Cond: ((sfid)::text = (ca.account__c)::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using property__c_idx_sfid on property__c pr (cost=0.42..8.44 rows=1 width=44) (never executed)

  • Index Cond: ((sfid)::text = (ca.property__c)::text)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_idx_sfid on contact co (cost=0.56..8.58 rows=1 width=26) (never executed)

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

Index Scan using contact_idx_sfid on contact co1 (cost=0.56..8.58 rows=1 width=34) (never executed)

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