explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2GoM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0..0 rows=0 width=0) (never executed)

2.          

Initplan (for Limit)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=0..0 rows=0 width=0) (never executed)

4.          

Initplan (for Aggregate)

5. 0.000 0.000 ↓ 0.0

Index Scan using hcu_idx_account_account_csn__c on account a5 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((account_csn__c)::text = '0070112132'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using hc_idx_servicecontract_accountid on servicecontract svc (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((accountid)::text = ($0)::text)
  • Filter: ((startdate <= CURRENT_DATE) AND (enddate >= CURRENT_DATE))
7. 0.000 0.000 ↓ 0.0

Index Scan using hcu_idx_account_account_csn__c on account a2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((account_csn__c)::text = '0070112132'::text)
8. 0.000 0.000 ↓ 0.0

Index Scan using hcu_idx_account_account_csn__c on account a2_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((account_csn__c)::text = '0070112132'::text)
9. 0.000 0.000 ↓ 0.0

Unique (cost=0..0 rows=0 width=0) (never executed)

10. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: ac.account__c, acc.name, adi.readiness_score__c, (CASE WHEN ((acc.named_account_group__c)::text = 'Named Account'::text) THEN 'True'::text ELSE 'False'::text END), acc.named_account_group__c, acc.type, acc.address1__c, acc.address2__c, acc.address3__c, acc.city__c, acc.country_picklist__c, cc.country_code__c, acc.county__c, acc.geo__c, acc.industry, acc.phone, acc.state_province__c, acc.zip_postal__c, (CASE WHEN (pacc.account_csn__c IS NOT NULL) THEN pacc.account_csn__c ELSE acc.account_csn__c END), (CASE WHEN ((pacc.named_account_group__c)::text = 'Named Account'::text) THEN 'True'::text ELSE 'False'::text END), sfu.name, sfu.email, acc.sales_region__c, acc.status__c, acc.language__c, acc.website, ind.adsk_industry_group__c, ind.adsk_industry_segment__c, ind.adsk_industry_sub_segment__c, acc.account_local_name__c
11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

16. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

17. 0.000 0.000 ↓ 0.0

Seq Scan on country_salesorg_mapping__c cc (cost=0..0 rows=0 width=0) (never executed)

18. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

19. 0.000 0.000 ↓ 0.0

Index Scan using hcu_idx_account_account_csn__c on account acc (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((account_csn__c)::text = '0070112132'::text)
20. 0.000 0.000 ↓ 0.0

Index Scan using hcu_idx_account_diagnostics_information__c_sfid on account_diagnostics_information__c adi (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((acc.account_diagnostics_information__c)::text = (sfid)::text)
21. 0.000 0.000 ↓ 0.0

Index Scan using hcu_idx_industry__c_sfid on industry__c ind (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((acc.sic_code__c)::text = (sfid)::text)
22. 0.000 0.000 ↓ 0.0

Index Scan using hcu_idx_user_sfid on user sfu (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((acc.autodesk_main_contact__c)::text = (sfid)::text)
23. 0.000 0.000 ↓ 0.0

Index Scan using hcu_idx_account_sfid on account pacc (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((acc.parentid)::text = (sfid)::text)
24. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on asset__c ac (cost=0..0 rows=0 width=0) (never executed)

25. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=0..0 rows=0 width=0) (never executed)

26. 0.000 0.000 ↓ 0.0

BitmapOr (cost=0..0 rows=0 width=0) (never executed)

27. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hc_idx_asset__c_reseller_account__c (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((reseller_account__c)::text = (acc.sfid)::text)
28. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hc_idx_asset__c_end_customer_account__c (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((end_customer_account__c)::text = (acc.sfid)::text)
29. 0.000 0.000 ↓ 0.0

BitmapOr (cost=0..0 rows=0 width=0) (never executed)

30. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hc_idx_asset__c_account__c (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((account__c)::text = ($2)::text)
31. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hc_idx_asset__c_reseller_account__c (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((reseller_account__c)::text = ($3)::text)