explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xmQq

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

Limit (cost=62.23..62.23 rows=1 width=581) (actual time=17.265..17.265 rows=0 loops=1)

2. 0.016 17.264 ↓ 0.0 0 1

Sort (cost=62.23..62.23 rows=1 width=581) (actual time=17.264..17.264 rows=0 loops=1)

  • Sort Key: qa.qa_form_created_date__c DESC, qa.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.003 17.248 ↓ 0.0 0 1

WindowAgg (cost=0.78..62.23 rows=1 width=581) (actual time=17.248..17.248 rows=0 loops=1)

4. 0.536 17.245 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.78..62.22 rows=1 width=328) (actual time=17.245..17.245 rows=0 loops=1)

  • Filter: ((((c.createddate >= '2018-10-02 07:00:00'::timestamp without time zone) AND (c.createddate < '2019-04-06 07:00:00'::timestamp without time zone)) OR ((sr.createddate >= '2018-10-02 07:00:00'::timestamp without time zone) AND (s (...)
  • Rows Removed by Filter: 27
5. 0.062 16.250 ↓ 27.0 27 1

Nested Loop (cost=0.67..58.07 rows=1 width=279) (actual time=0.871..16.250 rows=27 loops=1)

  • Join Filter: ((qa.property_consultant__c)::text = (ip.contact__c)::text)
6. 0.060 15.588 ↓ 30.0 30 1

Nested Loop (cost=0.61..57.98 rows=1 width=317) (actual time=0.843..15.588 rows=30 loops=1)

7. 0.071 14.381 ↓ 31.0 31 1

Nested Loop Left Join (cost=0.50..53.86 rows=1 width=283) (actual time=0.765..14.381 rows=31 loops=1)

  • Filter: (((ipq.employment_status__c)::text = 'Active'::text) OR ((COALESCE(ipq.employment_status__c, ''::character varying))::text = ''::text))
  • Rows Removed by Filter: 10
8. 0.077 13.900 ↓ 41.0 41 1

Nested Loop Left Join (cost=0.45..53.76 rows=1 width=302) (actual time=0.729..13.900 rows=41 loops=1)

9. 0.053 12.675 ↓ 41.0 41 1

Nested Loop Left Join (cost=0.33..49.64 rows=1 width=276) (actual time=0.642..12.675 rows=41 loops=1)

10. 0.069 10.777 ↓ 41.0 41 1

Nested Loop Left Join (cost=0.25..45.55 rows=1 width=270) (actual time=0.582..10.777 rows=41 loops=1)

11. 0.092 9.765 ↓ 41.0 41 1

Nested Loop Left Join (cost=0.20..41.49 rows=1 width=266) (actual time=0.536..9.765 rows=41 loops=1)

12. 7.418 7.418 ↓ 41.0 41 1

Index Scan using hc_idx_qa_form__c_shop_status__c on qa_form__c qa (cost=0.08..37.37 rows=1 width=200) (actual time=0.525..7.418 rows=41 loops=1)

  • Index Cond: (((shop_status__c)::text = ANY ('{Queued,"In Progress"}'::text[])) AND ((shop_status__c)::text = 'In Progress'::text))
  • Filter: ((qa_form_created_date__c >= '2017-11-01 07:00:00'::timestamp without time zone) AND (qa_form_created_date__c >= '2017-11-01 07:00:00'::timestamp without time zone) AND (qa_form_cr (...)
  • Rows Removed by Filter: 1123
13. 2.255 2.255 ↑ 1.0 1 41

Index Scan using hcu_idx_case_sfid on "case" c (cost=0.11..4.12 rows=1 width=66) (actual time=0.055..0.055 rows=1 loops=41)

  • Index Cond: ((qa.case__c)::text = (sfid)::text)
14. 0.943 0.943 ↑ 1.0 1 41

Index Scan using account_idx_sfid on account acc (cost=0.06..4.06 rows=1 width=42) (actual time=0.023..0.023 rows=1 loops=41)

  • Index Cond: ((qa.case_account__c)::text = (sfid)::text)
15. 1.845 1.845 ↑ 1.0 1 41

Index Scan using property__c_idx_sfid on property__c pr (cost=0.08..4.09 rows=1 width=44) (actual time=0.045..0.045 rows=1 loops=41)

  • Index Cond: ((qa.case_property__c)::text = (sfid)::text)
16. 1.148 1.148 ↑ 1.0 1 41

Index Scan using contact_idx_sfid on contact cq (cost=0.11..4.12 rows=1 width=26) (actual time=0.028..0.028 rows=1 loops=41)

  • Index Cond: ((qa.qa_reviewer__c)::text = (sfid)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
  • Rows Removed by Filter: 0
17. 0.410 0.410 ↑ 1.0 1 41

Index Scan using hc_idx_internal_app_permissions__c_contact__c on internal_app_permissions__c ipq (cost=0.06..0.09 rows=1 width=26) (actual time=0.009..0.010 rows=1 loops=41)

  • Index Cond: ((contact__c)::text = (cq.sfid)::text)
18. 1.147 1.147 ↑ 1.0 1 31

Index Scan using contact_idx_sfid on contact cp (cost=0.11..4.12 rows=1 width=34) (actual time=0.037..0.037 rows=1 loops=31)

  • Index Cond: ((sfid)::text = (qa.property_consultant__c)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
19. 0.600 0.600 ↑ 1.0 1 30

Index Scan using hc_idx_internal_app_permissions__c_contact__c on internal_app_permissions__c ip (cost=0.06..0.09 rows=1 width=19) (actual time=0.016..0.020 rows=1 loops=30)

  • Index Cond: ((contact__c)::text = (cp.sfid)::text)
  • Filter: ((employment_status__c)::text = 'Active'::text)
  • Rows Removed by Filter: 0
20. 0.459 0.459 ↓ 0.0 0 27

Index Scan using service_request1__c_idx_sfid on service_request1__c sr (cost=0.11..4.12 rows=1 width=57) (actual time=0.017..0.017 rows=0 loops=27)

  • Index Cond: ((qa.service_request_pop__c)::text = (sfid)::text)