explain.depesz.com

A tool for finding a real cause for slow queries.

Result: WyI

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=1333.33..2686.11 rows=462 width=62) (actual time=.. rows= loops=)

  • Output: ocsdata_entity.accountnumber, ocsdata_entity.company, ocsdata_entity.product, ocsdata_entity.branchshortdesc, ddadata_entity.creditline, ocsdata_entity.customername, ddadata_entity.dateinocs, ddadata_entity.customerucn
  • Hash Cond: ((ocsdata_entity.accountnumber)::text = (ddadata_entity.accountnumber)::text)
2. 0.000 0.000 ↓ 0.0

Seq Scan on public.ocsdata_entity (cost=0.00..1323.21 rows=4991 width=38) (actual time=.. rows= loops=)

  • Output: ocsdata_entity.accountnumber, ocsdata_entity.company, ocsdata_entity.product, ocsdata_entity.acbbranch, ocsdata_entity.activeindicator, ocsdata_entity.additionalphone, ocsdata_entity.address0, ocsdata_entity.address1, ocsdata_entity.address2, ocsdata_entity.adeperrorcode, ocsdata_entity.adeperrorcount, ocsdata_entity.amountcurrentloanbalance, ocsdata_entity.amountlastpayment, ocsdata_entity.amountpaymentsreceived, ocsdata_entity.amountrequiredtogetcurrent, ocsdata_entity.assignedcollector, ocsdata_entity.billingcyclecode, ocsdata_entity.bondcentre, ocsdata_entity.borrowernumber, ocsdata_entity.branchdivision, ocsdata_entity.branchshortdesc, ocsdata_entity.businessphone, ocsdata_entity.camsstatus, ocsdata_entity.cardreasoncodes2, ocsdata_entity.chargeoffindicator, ocsdata_entity.cifriskind, ocsdata_entity.ciscompanyid, ocsdata_entity.cisproductcode, ocsdata_entity.city, ocsdata_entity.collector, ocsdata_entity.collectorworkqueuenumber, ocsdata_entity.coltypecode, ocsdata_entity.contactphone, ocsdata_entity.costincurred, ocsdata_entity.costlimit, ocsdata_entity.costlimitindicator, ocsdata_entity.countrycode, ocsdata_entity.currencycode, ocsdata_entity.currentdue, ocsdata_entity.customercompany, ocsdata_entity.customerkycind, ocsdata_entity.customername, ocsdata_entity.customernumber, ocsdata_entity.cutomertype, ocsdata_entity.cycledateocs, ocsdata_entity.datecollectorassigned, ocsdata_entity.datelastpayment, ocsdata_entity.datelastupdated, ocsdata_entity.dateloanadded, ocsdata_entity.dateloanclosed, ocsdata_entity.dateloanends, ocsdata_entity.dateofbirth, ocsdata_entity.dateoflastbill, ocsdata_entity.deleteindicator, ocsdata_entity.department, ocsdata_entity.drccasenumber, ocsdata_entity.email, ocsdata_entity.employeeindicator, ocsdata_entity.financialinstitutionid, ocsdata_entity.firstdateocs, ocsdata_entity.gender, ocsdata_entity.idnumber, ocsdata_entity.languageindicator, ocsdata_entity.languagepreference, ocsdata_entity.lastactioncode, ocsdata_entity.lastactioncollector, ocsdata_entity.lastactiondate, ocsdata_entity.lastactionlevel, ocsdata_entity.lastmonetarysystemaction, ocsdata_entity.lastmonetarysystemdate, ocsdata_entity.laststatuschangedate, ocsdata_entity.lastupdateby, ocsdata_entity.lastupdatelocation, ocsdata_entity.lastworkeddate, ocsdata_entity.loantype, ocsdata_entity.location, ocsdata_entity.masteraccountnumber, ocsdata_entity.nameaddressproduct, ocsdata_entity.ncacode, ocsdata_entity.ncacodecis, ocsdata_entity.ncacyclestart, ocsdata_entity.nextreviewdate, ocsdata_entity.numberpaymentsreceived, ocsdata_entity.numdayscurrentdelinquent, ocsdata_entity.numdaysdelinquentlastperiod, ocsdata_entity.numofretrycalls, ocsdata_entity.ocsbusinessextension, ocsdata_entity.ocsbusinessphone, ocsdata_entity.ocsdatafiller, ocsdata_entity.ocsoriginatingbranch, ocsdata_entity.ocspersonalphone, ocsdata_entity.oldestduedate, ocsdata_entity.oldreasoncode, ocsdata_entity.origbranchnumber, ocsdata_entity.otheraccountsindicator, ocsdata_entity.permanentcomment, ocsdata_entity.personalphone, ocsdata_entity.postalcode, ocsdata_entity.postncaind, ocsdata_entity.potentialrecoveryind, ocsdata_entity.productfiller, ocsdata_entity.promiseamount1st, ocsdata_entity.promiseamount2nd, ocsdata_entity.promiseamount3rd, ocsdata_entity.promiseamount4th, ocsdata_entity.promiseamount5th, ocsdata_entity.promiseamount6th, ocsdata_entity.promiseamountunpaid, ocsdata_entity.promisedate1st, ocsdata_entity.promisedate2nd, ocsdata_entity.promisedate3rd, ocsdata_entity.promisedate4th, ocsdata_entity.promisedate5th, ocsdata_entity.promisedate6th, ocsdata_entity.promisetopayamount, ocsdata_entity.promisetopaydate, ocsdata_entity.promisetopayindicator, ocsdata_entity.purgedateserv, ocsdata_entity.reasoncode, ocsdata_entity.region, ocsdata_entity.remainingterm, ocsdata_entity.requeuereason, ocsdata_entity.residualaccountnumber, ocsdata_entity.residualcompany, ocsdata_entity.residualproduct, ocsdata_entity.restrictedindicator, ocsdata_entity.restrictioncode, ocsdata_entity.riskreason, ocsdata_entity.s129letterdate, ocsdata_entity.scheduledpaymentamount, ocsdata_entity.section, ocsdata_entity.servicingbranch, ocsdata_entity.substatus, ocsdata_entity.tempreqdate, ocsdata_entity.timelastupdated, ocsdata_entity.timespastdue_10_29_days, ocsdata_entity.timespastdue_120_days, ocsdata_entity.timespastdue_30_59_days, ocsdata_entity.timespastdue_60_89_days, ocsdata_entity.timespastdue_90_119_days, ocsdata_entity.totalamountpastdue, ocsdata_entity.version, ocsdata_entity.willcallusdate
  • Filter: (ocsdata_entity.company <> 15)
3. 0.000 0.000 ↓ 0.0

Hash (cost=1322.21..1322.21 rows=889 width=48) (actual time=.. rows= loops=)

  • Output: ddadata_entity.creditline, ddadata_entity.dateinocs, ddadata_entity.customerucn, ddadata_entity.accountnumber
4. 0.000 0.000 ↓ 0.0

Seq Scan on public.ddadata_entity (cost=0.00..1322.21 rows=889 width=48) (actual time=.. rows= loops=)

  • Output: ddadata_entity.creditline, ddadata_entity.dateinocs, ddadata_entity.customerucn, ddadata_entity.accountnumber
  • Filter: (ddadata_entity.dateinocs > 20120000)