explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WRni

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 25.676 ↓ 0.0 0 1

Sort (cost=1,643.36..1,643.36 rows=1 width=581) (actual time=25.676..25.676 rows=0 loops=1)

  • Sort Key: qa.qa_form_created_date__c DESC, qa.id DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.002 25.664 ↓ 0.0 0 1

WindowAgg (cost=0.78..1,643.36 rows=1 width=581) (actual time=25.664..25.664 rows=0 loops=1)

3. 0.001 25.662 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.78..1,643.35 rows=1 width=329) (actual time=25.662..25.662 rows=0 loops=1)

4. 0.000 25.661 ↓ 0.0 0 1

Nested Loop (cost=0.67..1,639.23 rows=1 width=272) (actual time=25.661..25.661 rows=0 loops=1)

  • Join Filter: ((qa.property_consultant__c)::text = (ip.contact__c)::text)
5. 0.001 25.661 ↓ 0.0 0 1

Nested Loop (cost=0.61..1,639.14 rows=1 width=310) (actual time=25.661..25.661 rows=0 loops=1)

6. 0.000 25.660 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.50..1,635.02 rows=1 width=276) (actual time=25.660..25.660 rows=0 loops=1)

  • Filter: (((ipq.employment_status__c)::text = 'Active'::text) OR ((COALESCE(ipq.employment_status__c, ''::character varying))::text = ''::text))
7. 0.001 25.660 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.45..1,634.92 rows=1 width=295) (actual time=25.660..25.660 rows=0 loops=1)

8. 0.000 25.659 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.34..1,630.80 rows=1 width=269) (actual time=25.659..25.659 rows=0 loops=1)

9. 0.001 25.659 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.25..1,626.71 rows=1 width=263) (actual time=25.659..25.659 rows=0 loops=1)

10. 0.001 25.658 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.20..1,622.65 rows=1 width=259) (actual time=25.658..25.658 rows=0 loops=1)

11. 25.657 25.657 ↓ 0.0 0 1

Index Scan using hc_idx_qa_form__c_shop_status__c on qa_form__c qa (cost=0.08..1,618.53 rows=1 width=193) (actual time=25.657..25.657 rows=0 loops=1)

  • Index Cond: ((shop_status__c)::text = ANY ('{Queued,"In Progress"}'::text[]))
  • Filter: (((shop_status__c)::text ~~* '%04/03/2019 03:57 pm%'::text) AND (qa_form_created_date__c >= '2019-03-11 18:30:24'::timestamp without time zone) AND (qa_form_created_date__c < '2019-04-10 (...)
  • Rows Removed by Filter: 2193
12. 0.000 0.000 ↓ 0.0 0

Index Scan using hcu_idx_case_sfid on "case" c (cost=0.11..4.12 rows=1 width=66) (never executed)

  • Index Cond: ((qa.case__c)::text = (sfid)::text)
13. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((qa.case_account__c)::text = (sfid)::text)
14. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((qa.case_property__c)::text = (sfid)::text)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_idx_sfid on contact cq (cost=0.11..4.12 rows=1 width=26) (never executed)

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

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) (never executed)

  • Index Cond: ((contact__c)::text = (cq.sfid)::text)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_idx_sfid on contact cp (cost=0.11..4.12 rows=1 width=34) (never executed)

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

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) (never executed)

  • Index Cond: ((contact__c)::text = (cp.sfid)::text)
  • Filter: ((employment_status__c)::text = 'Active'::text)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using service_request1__c_idx_sfid on service_request1__c sr (cost=0.11..4.12 rows=1 width=57) (never executed)

  • Index Cond: ((qa.service_request_pop__c)::text = (sfid)::text)
Planning time : 13.801 ms
Execution time : 26.115 ms