explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K7G

Settings
# exclusive inclusive rows x rows loops node
1. 0.400 739.042 ↓ 307.0 307 1

Sort (cost=3,201.13..3,201.14 rows=1 width=581) (actual time=739.027..739.042 rows=307 loops=1)

  • Sort Key: qa.qa_form_created_date__c DESC, qa.id DESC
  • Sort Method: quicksort Memory: 117kB
2. 1.557 738.642 ↓ 307.0 307 1

WindowAgg (cost=0.73..3,201.13 rows=1 width=581) (actual time=737.744..738.642 rows=307 loops=1)

3. 0.289 737.085 ↓ 307.0 307 1

Nested Loop Left Join (cost=0.73..3,201.12 rows=1 width=329) (actual time=17.071..737.085 rows=307 loops=1)

4. 0.230 735.568 ↓ 307.0 307 1

Nested Loop Left Join (cost=0.61..3,197.03 rows=1 width=272) (actual time=16.972..735.568 rows=307 loops=1)

  • Filter: (((ipq.employment_status__c)::text = 'Active'::text) OR ((COALESCE(ipq.employment_status__c, ''::character varying))::text = ''::text))
5. 0.324 734.724 ↓ 307.0 307 1

Nested Loop Left Join (cost=0.56..3,196.94 rows=1 width=291) (actual time=16.959..734.724 rows=307 loops=1)

6. 0.294 733.479 ↓ 307.0 307 1

Nested Loop Left Join (cost=0.45..3,192.83 rows=1 width=265) (actual time=16.945..733.479 rows=307 loops=1)

7. 0.330 724.589 ↓ 307.0 307 1

Nested Loop Left Join (cost=0.36..3,188.89 rows=1 width=259) (actual time=16.863..724.589 rows=307 loops=1)

8. 0.428 720.575 ↓ 307.0 307 1

Nested Loop Left Join (cost=0.31..3,186.96 rows=1 width=255) (actual time=16.813..720.575 rows=307 loops=1)

9. 10.942 708.481 ↓ 307.0 307 1

Nested Loop (cost=0.20..3,182.85 rows=1 width=189) (actual time=16.797..708.481 rows=307 loops=1)

  • Join Filter: ((cp.sfid)::text = (qa.property_consultant__c)::text)
  • Rows Removed by Join Filter: 108985
10. 0.587 11.883 ↓ 356.0 356 1

Nested Loop (cost=0.11..1,561.88 rows=1 width=53) (actual time=0.110..11.883 rows=356 loops=1)

11. 1.684 1.684 ↑ 1.0 356 1

Seq Scan on internal_app_permissions__c ip (cost=0.00..96.23 rows=356 width=19) (actual time=0.030..1.684 rows=356 loops=1)

  • Filter: ((employment_status__c)::text = 'Active'::text)
  • Rows Removed by Filter: 280
12. 9.612 9.612 ↑ 1.0 1 356

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

  • Index Cond: ((sfid)::text = (ip.contact__c)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
13. 685.656 685.656 ↑ 3.4 307 356

Index Scan using hc_idx_qa_form__c_shop_status__c on qa_form__c qa (cost=0.08..1,617.35 rows=1,034 width=193) (actual time=0.008..1.926 rows=307 loops=356)

  • Index Cond: ((shop_status__c)::text = ANY ('{Queued,"In Progress"}'::text[]))
  • Filter: ((qa_form_created_date__c >= '2019-03-11 18:30:24'::timestamp without time zone) AND (qa_form_created_date__c < '2019-04-10 18:30:24'::timestamp without time zone))
  • Rows Removed by Filter: 1885
14. 11.666 11.666 ↑ 1.0 1 307

Index Scan using hcu_idx_case_sfid on "case" c (cost=0.11..4.11 rows=1 width=66) (actual time=0.038..0.038 rows=1 loops=307)

  • Index Cond: ((qa.case__c)::text = (sfid)::text)
15. 3.684 3.684 ↑ 1.0 1 307

Index Scan using account_idx_sfid on account acc (cost=0.06..1.93 rows=1 width=42) (actual time=0.012..0.012 rows=1 loops=307)

  • Index Cond: ((qa.case_account__c)::text = (sfid)::text)
16. 8.596 8.596 ↑ 1.0 1 307

Index Scan using property__c_idx_sfid on property__c pr (cost=0.08..3.93 rows=1 width=44) (actual time=0.028..0.028 rows=1 loops=307)

  • Index Cond: ((qa.case_property__c)::text = (sfid)::text)
17. 0.921 0.921 ↓ 0.0 0 307

Index Scan using contact_idx_sfid on contact cq (cost=0.11..4.11 rows=1 width=26) (actual time=0.003..0.003 rows=0 loops=307)

  • Index Cond: ((qa.qa_reviewer__c)::text = (sfid)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
18. 0.614 0.614 ↓ 0.0 0 307

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.002..0.002 rows=0 loops=307)

  • Index Cond: ((contact__c)::text = (cq.sfid)::text)
19. 1.228 1.228 ↓ 0.0 0 307

Index Scan using service_request1__c_idx_sfid on service_request1__c sr (cost=0.11..4.09 rows=1 width=57) (actual time=0.004..0.004 rows=0 loops=307)

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