explain.depesz.com

PostgreSQL's explain analyze made readable

Result: diMj

Settings
# exclusive inclusive rows x rows loops node
1. 3,161.787 15,107.799 ↓ 1.0 1,818,930 1

Merge Right Join (cost=3.61..7,124,966.69 rows=1,818,583 width=690) (actual time=0.047..15,107.799 rows=1,818,930 loops=1)

  • Output: ap.applicationid, ap.agreedocid, 'old', '', a.auserid, d.lastname, d.name, d.middlename, to_char(((d.birthday)::date)::timestamp with time zone, 'DD.MM.YYYY'::text), d.passportnum, (SubPlan 1)
  • Merge Cond: (a.auserid = ap.auserid)
  • Buffers: shared hit=11,962,998
2. 903.821 2,259.216 ↓ 1.0 2,317,850 1

Merge Left Join (cost=3.19..228,266.59 rows=2,317,355 width=74) (actual time=0.017..2,259.216 rows=2,317,850 loops=1)

  • Output: a.auserid, d.lastname, d.name, d.middlename, d.birthday, d.passportnum
  • Merge Cond: (a.auserid = d.auserid)
  • Buffers: shared hit=184,013
3. 720.798 720.798 ↓ 1.0 2,317,850 1

Index Only Scan using auser_auserid_idx on client.auser a (cost=0.43..117,607.60 rows=2,317,355 width=4) (actual time=0.010..720.798 rows=2,317,850 loops=1)

  • Output: a.auserid
  • Heap Fetches: 2,317,850
  • Buffers: shared hit=86,947
4. 634.597 634.597 ↑ 1.0 2,207,193 1

Index Scan using auserdata_auserid_idx on client.auserdata d (cost=0.43..77,273.29 rows=2,207,385 width=74) (actual time=0.004..634.597 rows=2,207,193 loops=1)

  • Output: d.id, d.auserid, d.lastname, d.name, d.middlename, d.ts, d.passportnum, d.passportdate, d.birthday, d.snils
  • Buffers: shared hit=97,066
5. 2,411.076 2,411.076 ↓ 1.0 1,818,930 1

Index Scan using application_auserid_idx on admin.application ap (cost=0.43..161,859.33 rows=1,818,583 width=16) (actual time=0.004..2,411.076 rows=1,818,930 loops=1)

  • Output: ap.applicationid, ap.tmscreate, ap.auserid, ap.sum, ap.period, ap.fee, ap.discount, ap.applicationstatusid, ap.sourceid, ap.loandatestart, ap.loandateend, ap.rate, ap.applicationacceptdate, ap.repay, ap.isdownloaded, ap.bazis, ap.balance, ap.ti, ap.tp, ap.lck, ap.lcktime, ap.modnic, ap.applicationsourcetypeid, ap.scoringapplicationid, ap.scoringputapplicationdt, ap.scoringresultdt, ap.scoringresultname, ap.scoringresultdescription, ap.scoringresultdecision, ap.scoringresultpresent, ap.scoringlastresultdt, ap.scoringlastresultstatus, ap.scoringisrescoring, ap.applicationisoverdue, ap.applicationdeclinecause, ap.applicationisconfirm, ap.applicationconfirmdt, ap.applicationlockdt, ap.scoringcardbin, ap.scoringcardbrand, ap.scoringbankname, ap.scoringcardtype, ap.scoringcardlevel, ap.scoringcountryname, ap.scoringcountrya2, ap.scoringcountrya3, ap.applicationsessid, ap.cardsecurepan, ap.cardholdername, ap.signadata, ap.signavalue, ap.loantrackdate, ap.loanistrack, ap.rateid, ap.agreedocid, ap.clientcardid, ap.isfreeze, ap.freezedt, ap.unfreezedt, ap.notified, ap.intention_id, ap.delay, ap.prolongatenum, ap.isannuity, ap.ignorecollectordelay, ap.penalty, ap.iscancel, ap.paymenttype, ap.attrs, ap.sendplatizanewdate, ap.issmsloan, ap.possibilityreturn, ap.loginsessionid, ap.sendbfgdate, ap.bfgfee, ap.psk, ap.partnerid, ap.company_id, ap.limit_scheme, ap.class_prob, ap.predicted_return_sum, ap.is_operator_create
  • Buffers: shared hit=1,741,184
6.          

SubPlan (for Merge Right Join)

7. 0.000 7,275.720 ↑ 1.0 1 1,818,930

Limit (cost=3.68..3.68 rows=1 width=21) (actual time=0.004..0.004 rows=1 loops=1,818,930)

  • Output: t.inn, t.tms
  • Buffers: shared hit=10,037,801
8. 1,818.930 7,275.720 ↑ 2.0 1 1,818,930

Sort (cost=3.68..3.68 rows=2 width=21) (actual time=0.004..0.004 rows=1 loops=1,818,930)

  • Output: t.inn, t.tms
  • Sort Key: t.tms DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10,037,801
9. 5,456.790 5,456.790 ↑ 2.0 1 1,818,930

Index Scan using inn_found_auserid_idx on client.inn_found t (cost=0.43..3.67 rows=2 width=21) (actual time=0.002..0.003 rows=1 loops=1,818,930)

  • Output: t.inn, t.tms
  • Index Cond: (t.auserid = a.auserid)
  • Filter: ((t.inn IS NOT NULL) AND ((t.inn)::text <> '999999999999999'::text) AND ((t.status)::text = 'DONE'::text))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=10,037,801
Planning time : 0.538 ms