explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f4r0

Settings
# exclusive inclusive rows x rows loops node
1. 308.240 11,615.290 ↑ 5.3 653,472 1

Merge Right Join (cost=205,605.84..259,529.68 rows=3,484,146 width=582) (actual time=9,860.918..11,615.290 rows=653,472 loops=1)

  • Output: inglobal.guid, claimindividual.guid, person.guid
  • Merge Cond: ((inglobal.guid)::text = (claimindividual.inglobal_guid)::text)
2.          

CTE inglobal

3. 6.093 39.888 ↑ 1.0 5,593 1

Hash Left Join (cost=236.84..751.60 rows=5,593 width=643) (actual time=9.203..39.888 rows=5,593 loops=1)

  • Output: cg.guid, cg.financialyear, cg.halfyearnb, cg.createtime, cg19.totalclarefcreditorliaison, cg21.totalimorefcreditorliaison, cg22.totalilprefcreditorliaison, cg23.totalrrorefdebtorliaison, cg21.refusalcode, cg21.replycode, cg.flowid, cg.idliaisonbodycreditor_country, cg.idliaisonbodydebtor_country, cg.currencycreditor, cg.flowtype, cg21.lumpsum
  • Hash Cond: ((cg.guid)::text = (cg23.guid)::text)
4. 5.472 33.297 ↑ 1.0 5,593 1

Hash Left Join (cost=223.47..713.53 rows=5,593 width=631) (actual time=8.698..33.297 rows=5,593 loops=1)

  • Output: cg.guid, cg.financialyear, cg.halfyearnb, cg.createtime, cg.flowid, cg.idliaisonbodycreditor_country, cg.idliaisonbodydebtor_country, cg.currencycreditor, cg.flowtype, cg19.totalclarefcreditorliaison, cg21.totalimorefcreditorliaison, cg21.refusalcode, cg21.replycode, cg21.lumpsum, cg22.totalilprefcreditorliaison
  • Hash Cond: ((cg.guid)::text = (cg22.guid)::text)
5. 5.710 27.777 ↑ 1.0 5,593 1

Hash Left Join (cost=221.75..690.52 rows=5,593 width=620) (actual time=8.642..27.777 rows=5,593 loops=1)

  • Output: cg.guid, cg.financialyear, cg.halfyearnb, cg.createtime, cg.flowid, cg.idliaisonbodycreditor_country, cg.idliaisonbodydebtor_country, cg.currencycreditor, cg.flowtype, cg19.totalclarefcreditorliaison, cg21.totalimorefcreditorliaison, cg21.refusalcode, cg21.replycode, cg21.lumpsum
  • Hash Cond: ((cg.guid)::text = (cg21.guid)::text)
6. 9.939 21.685 ↑ 1.0 5,593 1

Hash Left Join (cost=213.78..659.36 rows=5,593 width=87) (actual time=8.250..21.685 rows=5,593 loops=1)

  • Output: cg.guid, cg.financialyear, cg.halfyearnb, cg.createtime, cg.flowid, cg.idliaisonbodycreditor_country, cg.idliaisonbodydebtor_country, cg.currencycreditor, cg.flowtype, cg19.totalclarefcreditorliaison
  • Hash Cond: ((cg.guid)::text = (cg19.guid)::text)
7. 3.529 3.529 ↑ 1.0 5,593 1

Seq Scan on claim_p_engine.claimglobal cg (cost=0.00..374.93 rows=5,593 width=75) (actual time=0.006..3.529 rows=5,593 loops=1)

  • Output: cg.guid, cg.createtime, cg.updatetime, cg.createdby, cg.bic, cg.casenbreceiving, cg.casenbsending, cg.currencycreditor, cg.financialyear, cg.flowid, cg.flowtype, cg.halfyearnb, cg.iban, cg.idliaisonbodycreditor_country, cg.idliaisonbodycreditor_institutioncode, cg.idliaisonbodycreditor_institutionname, cg.idliaisonbodycreditor_organizationcode, cg.idliaisonbodydebtor_country, cg.idliaisonbodydebtor_institutioncode, cg.idliaisonbodydebtor_institutionname, cg.idliaisonbodydebtor_organizationcode, cg.ntlnsedcode, cg.psedtype, cg.receiptdate, cg.receivingci_connection_email, cg.receivingci_connection_fax, cg.receivingci_connection_telefon, cg.receivingci_institutionaddress_country, cg.receivingci_institutionaddress_postalcode, cg.receivingci_institutionaddress_region, cg.receivingci_institutionaddress_street, cg.receivingci_institutionaddress_town, cg.receivingci_institutionbody_country, cg.receivingci_institutionbody_institutioncode, cg.receivingci_institutionbody_institutionname, cg.receivingci_institutionbody_organizationcode, cg.sedid, cg.sendingci_connection_email, cg.sendingci_connection_fax, cg.sendingci_connection_telefon, cg.sendingci_institutionaddress_country, cg.sendingci_institutionaddress_postalcode, cg.sendingci_institutionaddress_region, cg.sendingci_institutionaddress_street, cg.sendingci_institutionaddress_town, cg.sendingci_institutionbody_country, cg.sendingci_institutionbody_institutioncode, cg.sendingci_institutionbody_institutionname, cg.sendingci_institutionbody_organizationcode, cg.submissiondate, cg.submissiondate01, cg.submissiondate02, cg.igmatchingtag1, cg.igmatchingtag2, cg.ogmatchingtag1, cg.ogmatchingtag2
8. 3.650 8.217 ↑ 1.0 4,968 1

Hash (cost=151.68..151.68 rows=4,968 width=45) (actual time=8.217..8.217 rows=4,968 loops=1)

  • Output: cg19.totalclarefcreditorliaison, cg19.guid
  • Buckets: 8192 Batches: 1 Memory Usage: 438kB
9. 4.567 4.567 ↑ 1.0 4,968 1

Seq Scan on claim_p_engine.claimglobalfs019 cg19 (cost=0.00..151.68 rows=4,968 width=45) (actual time=0.006..4.567 rows=4,968 loops=1)

  • Output: cg19.totalclarefcreditorliaison, cg19.guid
10. 0.205 0.382 ↑ 1.0 221 1

Hash (cost=5.21..5.21 rows=221 width=566) (actual time=0.382..0.382 rows=221 loops=1)

  • Output: cg21.totalimorefcreditorliaison, cg21.refusalcode, cg21.replycode, cg21.lumpsum, cg21.guid
  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
11. 0.177 0.177 ↑ 1.0 221 1

Seq Scan on claim_p_engine.claimglobalfs021 cg21 (cost=0.00..5.21 rows=221 width=566) (actual time=0.008..0.177 rows=221 loops=1)

  • Output: cg21.totalimorefcreditorliaison, cg21.refusalcode, cg21.replycode, cg21.lumpsum, cg21.guid
12. 0.021 0.048 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=44) (actual time=0.048..0.048 rows=32 loops=1)

  • Output: cg22.totalilprefcreditorliaison, cg22.guid
  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
13. 0.027 0.027 ↑ 1.0 32 1

Seq Scan on claim_p_engine.claimglobalfs022 cg22 (cost=0.00..1.32 rows=32 width=44) (actual time=0.004..0.027 rows=32 loops=1)

  • Output: cg22.totalilprefcreditorliaison, cg22.guid
14. 0.244 0.498 ↑ 1.0 372 1

Hash (cost=8.72..8.72 rows=372 width=45) (actual time=0.498..0.498 rows=372 loops=1)

  • Output: cg23.totalrrorefdebtorliaison, cg23.guid
  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
15. 0.254 0.254 ↑ 1.0 372 1

Seq Scan on claim_p_engine.claimglobalfs023 cg23 (cost=0.00..8.72 rows=372 width=45) (actual time=0.005..0.254 rows=372 loops=1)

  • Output: cg23.totalrrorefdebtorliaison, cg23.guid
16. 118.692 170.170 ↑ 1.0 5,593 1

Sort (cost=460.01..473.99 rows=5,593 width=516) (actual time=167.688..170.170 rows=5,593 loops=1)

  • Output: inglobal.guid
  • Sort Key: inglobal.guid
  • Sort Method: quicksort Memory: 629kB
17. 51.478 51.478 ↑ 1.0 5,593 1

CTE Scan on inglobal (cost=0.00..111.86 rows=5,593 width=516) (actual time=9.209..51.478 rows=5,593 loops=1)

  • Output: inglobal.guid
18. 315.240 11,136.880 ↑ 1.0 653,472 1

Materialize (cost=204,394.24..207,661.60 rows=653,472 width=99) (actual time=9,693.218..11,136.880 rows=653,472 loops=1)

  • Output: claimindividual.guid, claimindividual.inglobal_guid, person.guid
19. 8,506.229 10,821.640 ↑ 1.0 653,472 1

Sort (cost=204,394.24..206,027.92 rows=653,472 width=99) (actual time=9,693.211..10,821.640 rows=653,472 loops=1)

  • Output: claimindividual.guid, claimindividual.inglobal_guid, person.guid
  • Sort Key: claimindividual.inglobal_guid
  • Sort Method: external merge Disk: 69552kB
20. 1,245.663 2,315.411 ↑ 1.0 653,472 1

Hash Join (cost=30,956.68..105,537.64 rows=653,472 width=99) (actual time=646.989..2,315.411 rows=653,472 loops=1)

  • Output: claimindividual.guid, claimindividual.inglobal_guid, person.guid
  • Hash Cond: ((claimindividual.person_guid)::text = (person.guid)::text)
21. 422.997 422.997 ↑ 1.0 653,472 1

Seq Scan on claim_p_engine.claimindividual (cost=0.00..40,067.72 rows=653,472 width=99) (actual time=0.009..422.997 rows=653,472 loops=1)

  • Output: claimindividual.guid, claimindividual.person_guid, claimindividual.inglobal_guid
22. 352.469 646.751 ↑ 1.0 653,497 1

Hash (cost=17,681.97..17,681.97 rows=653,497 width=33) (actual time=646.751..646.751 rows=653,497 loops=1)

  • Output: person.guid
  • Buckets: 65536 Batches: 16 Memory Usage: 3110kB
23. 294.282 294.282 ↑ 1.0 653,497 1

Seq Scan on claim_p_engine.person (cost=0.00..17,681.97 rows=653,497 width=33) (actual time=0.068..294.282 rows=653,497 loops=1)

  • Output: person.guid