explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Tjs

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 11.259 ↓ 0.0 0 1

Limit (cost=8,671.34..8,671.35 rows=3 width=542) (actual time=11.259..11.259 rows=0 loops=1)

2. 0.010 11.257 ↓ 0.0 0 1

Sort (cost=8,671.34..8,671.35 rows=3 width=542) (actual time=11.257..11.257 rows=0 loops=1)

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

WindowAgg (cost=957.75..8,671.32 rows=3 width=542) (actual time=11.247..11.247 rows=0 loops=1)

4. 0.000 11.245 ↓ 0.0 0 1

Nested Loop Left Join (cost=957.75..8,671.19 rows=3 width=1,231) (actual time=11.245..11.245 rows=0 loops=1)

5. 0.001 11.245 ↓ 0.0 0 1

Nested Loop Left Join (cost=957.19..8,645.45 rows=3 width=1,235) (actual time=11.245..11.245 rows=0 loops=1)

6. 0.000 11.244 ↓ 0.0 0 1

Nested Loop (cost=956.77..8,620.13 rows=3 width=1,229) (actual time=11.244..11.244 rows=0 loops=1)

7. 0.000 11.244 ↓ 0.0 0 1

Nested Loop Left Join (cost=956.49..8,595.24 rows=3 width=1,225) (actual time=11.244..11.244 rows=0 loops=1)

8. 0.001 11.244 ↓ 0.0 0 1

Nested Loop Left Join (cost=956.06..8,569.86 rows=3 width=1,153) (actual time=11.244..11.244 rows=0 loops=1)

9. 0.004 11.243 ↓ 0.0 0 1

Nested Loop (cost=955.50..8,544.09 rows=3 width=932) (actual time=11.243..11.243 rows=0 loops=1)

10. 0.017 0.123 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.11..41.87 rows=1 width=53) (actual time=0.117..0.123 rows=1 loops=1)

  • Join Filter: (((co.sfid)::text = (ip.contact__c)::text) AND ((ip.team__c)::text = (ipp.team__c)::text))
  • Rows Removed by Join Filter: 23
11. 0.004 0.069 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.84..16.89 rows=1 width=66) (actual time=0.064..0.069 rows=1 loops=1)

  • Join Filter: ((co.sfid)::text = (ip.contact__c)::text)
12. 0.049 0.049 ↑ 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.048..0.049 rows=1 loops=1)

  • Index Cond: ((sfid)::text = '0030H00004unYPhQAM'::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
13. 0.016 0.016 ↑ 1.0 1 1

Index Scan using hc_idx_internal_app_permissions__c_contact__c on internal_app_permissions__c ip (cost=0.28..8.29 rows=1 width=32) (actual time=0.012..0.016 rows=1 loops=1)

  • Index Cond: ((contact__c)::text = '0030H00004unYPhQAM'::text)
14. 0.037 0.037 ↑ 1.0 23 1

Index Scan using hc_idx_internal_app_permissions__c_user_profile__c on internal_app_permissions__c ipp (cost=0.28..24.64 rows=23 width=32) (actual time=0.012..0.037 rows=23 loops=1)

  • Index Cond: ((user_profile__c)::text = 'Supervisor'::text)
15. 2.642 11.116 ↓ 0.0 0 1

Bitmap Heap Scan on qa_form__c qa (cost=954.39..8,502.19 rows=3 width=917) (actual time=11.116..11.116 rows=0 loops=1)

  • Recheck Cond: ((qa_form_created_date__c >= '2019-04-13 14:20:08'::timestamp without time zone) AND (qa_form_created_date__c < '2019-05-13 14:20:08'::timestamp without time zone) AND ((shop_status__c): (...)
  • Filter: ((NOT dismiss_from_qa__c) AND ((shop_category__c)::text <> 'Calibration'::text) AND ((property_consultant__c)::text = '0030H00004unYPhQAM'::text))
  • Rows Removed by Filter: 874
  • Heap Blocks: exact=450
16. 0.325 8.474 ↓ 0.0 0 1

BitmapAnd (cost=954.39..954.39 rows=5,201 width=0) (actual time=8.474..8.474 rows=0 loops=1)

17. 2.087 2.087 ↑ 1.0 11,350 1

Bitmap Index Scan on hc_idx_qa_form__c_qa_form_created_date__c (cost=0.00..242.25 rows=11,396 width=0) (actual time=2.087..2.087 rows=11,350 loops=1)

  • Index Cond: ((qa_form_created_date__c >= '2019-04-13 14:20:08'::timestamp without time zone) AND (qa_form_created_date__c < '2019-05-13 14:20:08'::timestamp without time zone))
18. 6.062 6.062 ↓ 1.0 31,093 1

Bitmap Index Scan on hc_idx_qa_form__c_shop_status__c (cost=0.00..711.88 rows=30,862 width=0) (actual time=6.062..6.062 rows=31,093 loops=1)

  • Index Cond: ((shop_status__c)::text = 'Completed'::text)
19. 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=259) (never executed)

  • Index Cond: ((qa.case__c)::text = (sfid)::text)
  • Filter: ((qa.case_account__c)::text = (accountid)::text)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using service_request1__c_idx_sfid on service_request1__c sr (cost=0.43..8.45 rows=1 width=109) (never executed)

  • Index Cond: ((qa.service_request_pop__c)::text = (sfid)::text)
  • Filter: ((qa.case_account__c)::text = (account_name__c)::text)
21. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: ((ipp.contact__c)::text = (sfid)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)