explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pMvF

Settings
# exclusive inclusive rows x rows loops node
1. 47.407 125.656 ↓ 38.7 43,652 1

Merge Join (cost=0.93..5,962.41 rows=1,129 width=374) (actual time=0.029..125.656 rows=43,652 loops=1)

  • Output: a.id, a.propstrength__type__c, a.propstrength__application__c, b.mailing_city__c, b.country__c, b.mailing_street1__c, b.mailing_street3__c, b.postal_code__c, b.mailing_street2__c, a.applicant_birthdate__c, a.propstrength__applicant_email__c, a.sfid, a.propstrength__customer_name__c, b.propstrength__income_tax_permanent_account_no__c, b.residential_city__c, b.residential_country__c, b.residential_street1__c, b.residential_street3__c, b.residential_post_code__c, b.residential_street2__c, b.mobilephone, a.relationship__c, a.propstrength__active__c, a.applicant_salutation__c, a.lastmodifiedbyid, b.customer_unique_id__c, a.propstrength__applicant_acc__c, a.propstrength__sharing_ratio__c, b.aadhar_card_no__c, b.passport_no__c, a.lastmodifieddate
  • Inner Unique: true
  • Merge Cond: ((a.propstrength__applicant_acc__c)::text = (b.sfid)::text)
2. 32.737 32.737 ↑ 1.0 43,692 1

Index Only Scan using propstrength__applicant_acc__c_id on salesforce.propstrength__applicant_detail__c a (cost=0.08..2,757.22 rows=43,785 width=170) (actual time=0.011..32.737 rows=43,692 loops=1)

  • Output: a.propstrength__applicant_acc__c, a.id, a.propstrength__type__c, a.propstrength__application__c, a.applicant_birthdate__c, a.propstrength__applicant_email__c, a.sfid, a.propstrength__customer_name__c, a.relationship__c, a.propstrength__active__c, a.applicant_salutation__c, a.lastmodifiedbyid, a.propstrength__applicant_acc__c, a.propstrength__sharing_ratio__c, a.lastmodifieddate
  • Heap Fetches: 36
3. 45.512 45.512 ↓ 1.0 55,183 1

Index Only Scan using contact_recordtypeid on salesforce.contact b (cost=0.08..3,184.91 rows=54,706 width=223) (actual time=0.013..45.512 rows=55,183 loops=1)

  • Output: b.sfid, b.mailing_city__c, b.country__c, b.mailing_street1__c, b.mailing_street3__c, b.postal_code__c, b.mailing_street2__c, b.propstrength__income_tax_permanent_account_no__c, b.residential_city__c, b.residential_country__c, b.residential_street1__c, b.residential_street3__c, b.residential_post_code__c, b.residential_street2__c, b.mobilephone, b.customer_unique_id__c, b.aadhar_card_no__c, b.passport_no__c
  • Heap Fetches: 134
Planning time : 0.551 ms
Execution time : 127.194 ms