explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D68J

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.241 ↓ 3.0 3 1

Limit (cost=91.81..91.81 rows=1 width=613) (actual time=0.241..0.241 rows=3 loops=1)

2. 0.008 0.240 ↓ 3.0 3 1

Sort (cost=91.81..91.81 rows=1 width=613) (actual time=0.240..0.240 rows=3 loops=1)

  • Sort Key: qa.qa_form_created_date__c DESC, qa.id DESC
  • Sort Method: quicksort Memory: 26kB
3. 0.033 0.232 ↓ 3.0 3 1

WindowAgg (cost=3.23..91.80 rows=1 width=613) (actual time=0.221..0.232 rows=3 loops=1)

4. 0.004 0.199 ↓ 3.0 3 1

Nested Loop Left Join (cost=3.23..91.75 rows=1 width=337) (actual time=0.069..0.199 rows=3 loops=1)

5. 0.001 0.186 ↓ 3.0 3 1

Nested Loop (cost=2.80..83.30 rows=1 width=280) (actual time=0.068..0.186 rows=3 loops=1)

6. 0.002 0.155 ↓ 3.0 3 1

Nested Loop Left Join (cost=2.24..74.72 rows=1 width=284) (actual time=0.057..0.155 rows=3 loops=1)

7. 0.001 0.123 ↓ 3.0 3 1

Nested Loop Left Join (cost=1.68..66.13 rows=1 width=277) (actual time=0.044..0.123 rows=3 loops=1)

8. 0.004 0.092 ↓ 3.0 3 1

Nested Loop (cost=1.26..57.69 rows=1 width=271) (actual time=0.033..0.092 rows=3 loops=1)

9. 0.007 0.076 ↓ 3.0 3 1

Nested Loop Left Join (cost=0.98..49.39 rows=1 width=267) (actual time=0.027..0.076 rows=3 loops=1)

10. 0.048 0.048 ↓ 3.0 3 1

Index Scan using hc_idx_qa_form__c_shop_status__c on qa_form__c qa (cost=0.42..40.81 rows=1 width=201) (actual time=0.011..0.048 rows=3 loops=1)

  • Index Cond: ((shop_status__c)::text = 'Disputed'::text)
  • Filter: ((dispute_date__c >= '2019-04-10 17:54:29'::timestamp without time zone) AND (dispute_date__c < '2019-05-10 17:54:29'::timestamp without time zone) AND ((dispute_status__c)::text = 'Acknowledg (...)
  • Rows Removed by Filter: 18
11. 0.021 0.021 ↑ 1.0 1 3

Index Scan using hcu_idx_case_sfid on "case" c (cost=0.56..8.58 rows=1 width=66) (actual time=0.007..0.007 rows=1 loops=3)

  • Index Cond: ((qa.case__c)::text = (sfid)::text)
12. 0.012 0.012 ↑ 1.0 1 3

Index Scan using account_idx_sfid on account acc (cost=0.28..8.30 rows=1 width=42) (actual time=0.004..0.004 rows=1 loops=3)

  • Index Cond: ((sfid)::text = (qa.case_account__c)::text)
13. 0.030 0.030 ↑ 1.0 1 3

Index Scan using property__c_idx_sfid on property__c pr (cost=0.42..8.44 rows=1 width=44) (actual time=0.010..0.010 rows=1 loops=3)

  • Index Cond: ((qa.case_property__c)::text = (sfid)::text)
14. 0.030 0.030 ↑ 1.0 1 3

Index Scan using contact_idx_sfid on contact cq (cost=0.56..8.58 rows=1 width=26) (actual time=0.010..0.010 rows=1 loops=3)

  • Index Cond: ((qa.qa_reviewer__c)::text = (sfid)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
15. 0.030 0.030 ↑ 1.0 1 3

Index Scan using contact_idx_sfid on contact cp (cost=0.56..8.58 rows=1 width=34) (actual time=0.010..0.010 rows=1 loops=3)

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

Index Scan using service_request1__c_idx_sfid on service_request1__c sr (cost=0.43..8.45 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=3)

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