explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y5hd

Settings
# exclusive inclusive rows x rows loops node
1. 31.527 349.557 ↑ 1.2 12,760 1

Hash Left Join (cost=3,700.79..316,444.52 rows=14,823 width=1,770) (actual time=124.857..349.557 rows=12,760 loops=1)

  • Hash Cond: (ps_eps.earlypaymentmapping_id = bpt.mapping_id)
2. 12.553 189.227 ↑ 1.2 12,760 1

Hash Left Join (cost=1,821.52..191,033.74 rows=14,823 width=1,793) (actual time=46.940..189.227 rows=12,760 loops=1)

  • Hash Cond: ((ps_abseps_t_absda.id = ifca.absda_id) AND (si.currency_id = ifca.currency_id))
3. 10.291 175.660 ↑ 1.2 12,760 1

Hash Left Join (cost=1,819.80..190,857.31 rows=14,823 width=1,685) (actual time=45.910..175.660 rows=12,760 loops=1)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
4. 9.627 165.366 ↑ 1.2 12,760 1

Hash Left Join (cost=1,809.58..190,808.18 rows=14,823 width=641) (actual time=45.891..165.366 rows=12,760 loops=1)

  • Hash Cond: (ps_eps.earlypaymentadvice_id = eps_epa.id)
5. 10.436 155.205 ↑ 1.2 12,760 1

Hash Left Join (cost=1,807.68..190,767.37 rows=14,823 width=627) (actual time=45.340..155.205 rows=12,760 loops=1)

  • Hash Cond: (si.currency_id = c.id)
6. 22.201 144.291 ↑ 1.2 12,760 1

Nested Loop Left Join (cost=1,806.54..190,699.84 rows=14,823 width=623) (actual time=44.842..144.291 rows=12,760 loops=1)

7. 10.067 96.570 ↑ 1.2 12,760 1

Hash Left Join (cost=1,806.11..89,425.49 rows=14,823 width=623) (actual time=43.052..96.570 rows=12,760 loops=1)

  • Hash Cond: (ps_abseps_t_absda.bank_id = ps_eps_t_bc_cb.id)
8. 10.242 85.203 ↑ 1.2 12,760 1

Hash Left Join (cost=1,594.98..89,175.36 rows=14,823 width=613) (actual time=41.735..85.203 rows=12,760 loops=1)

  • Hash Cond: (si.supplier_id = s_cb.id)
9. 10.199 59.592 ↑ 1.2 12,760 1

Hash Left Join (cost=1,383.86..88,925.22 rows=14,823 width=603) (actual time=26.347..59.592 rows=12,760 loops=1)

  • Hash Cond: (od_db.buyer_id = od_c_cb.id)
10. 15.796 48.902 ↑ 1.2 12,760 1

Nested Loop (cost=1,375.55..88,713.10 rows=14,823 width=593) (actual time=25.837..48.902 rows=12,760 loops=1)

11. 0.605 0.605 ↑ 1.0 1 1

Seq Scan on capfloorauction cfa (cost=0.00..1.31 rows=1 width=21) (actual time=0.600..0.605 rows=1 loops=1)

  • Filter: (id = 6,656)
  • Rows Removed by Filter: 24
12. 0.000 32.501 ↑ 1.2 12,760 1

Gather (cost=1,375.55..88,563.55 rows=14,823 width=588) (actual time=25.232..32.501 rows=12,760 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
13. 3.073 73.604 ↑ 1.5 3,190 4 / 4

Hash Left Join (cost=375.55..86,081.25 rows=4,782 width=588) (actual time=20.043..73.604 rows=3,190 loops=4)

  • Hash Cond: (ps_absfc_fc_fcb.id = ps_absfc_fc_afc.id)
14. 4.255 65.896 ↑ 1.5 3,190 4 / 4

Nested Loop Left Join (cost=284.30..85,977.45 rows=4,782 width=471) (actual time=15.384..65.896 rows=3,190 loops=4)

15. 2.733 55.261 ↑ 1.5 3,190 4 / 4

Hash Left Join (cost=283.88..83,847.20 rows=4,782 width=455) (actual time=14.029..55.261 rows=3,190 loops=4)

  • Hash Cond: (ps_abseps.absda_id = ps_abseps_t_absda.id)
16. 3.250 52.087 ↑ 1.5 3,190 4 / 4

Nested Loop Left Join (cost=282.56..83,829.53 rows=4,782 width=447) (actual time=13.570..52.087 rows=3,190 loops=4)

17. 2.786 39.267 ↑ 1.5 3,190 4 / 4

Hash Join (cost=282.13..81,516.98 rows=4,782 width=431) (actual time=12.002..39.267 rows=3,190 loops=4)

  • Hash Cond: (si.originatordivision_id = od_db.id)
18. 4.790 36.330 ↑ 1.5 3,190 4 / 4

Nested Loop Left Join (cost=279.78..81,498.28 rows=4,782 width=419) (actual time=11.802..36.330 rows=3,190 loops=4)

19. 9.774 12.400 ↑ 1.5 3,190 4 / 4

Parallel Bitmap Heap Scan on supplierinvoice si (cost=279.35..47,334.75 rows=4,782 width=215) (actual time=9.071..12.400 rows=3,190 loops=4)

  • Recheck Cond: (lastauction_id = 6,656)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 500
  • Heap Blocks: exact=1
20. 2.627 2.627 ↑ 1.0 14,760 1 / 4

Bitmap Index Scan on supplierinvoice_lastauction_idx (cost=0.00..275.64 rows=14,828 width=0) (actual time=10.506..10.506 rows=14,760 loops=1)

  • Index Cond: (lastauction_id = 6,656)
21. 19.140 19.140 ↑ 1.0 1 12,760 / 4

Index Scan using earlypaymentsettlement_invoice_uq on earlypaymentsettlement ps_eps (cost=0.43..7.14 rows=1 width=220) (actual time=0.006..0.006 rows=1 loops=12,760)

  • Index Cond: (si.id = invoice_id)
22. 0.010 0.151 ↑ 1.0 14 4 / 4

Hash (cost=2.17..2.17 rows=14 width=28) (actual time=0.150..0.151 rows=14 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
23. 0.141 0.141 ↑ 1.0 14 4 / 4

Seq Scan on divisionbase od_db (cost=0.00..2.17 rows=14 width=28) (actual time=0.132..0.141 rows=14 loops=4)

  • Filter: (buyer_id = 64,608,300)
24. 9.570 9.570 ↑ 1.0 1 12,760 / 4

Index Scan using absearlypaymentsettlement_pkey on absearlypaymentsettlement ps_abseps (cost=0.43..0.48 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=12,760)

  • Index Cond: (ps_eps.id = id)
25. 0.010 0.441 ↑ 1.0 14 4 / 4

Hash (cost=1.14..1.14 rows=14 width=16) (actual time=0.441..0.441 rows=14 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
26. 0.431 0.431 ↑ 1.0 14 4 / 4

Seq Scan on absdebtoragreement ps_abseps_t_absda (cost=0.00..1.14 rows=14 width=16) (actual time=0.427..0.431 rows=14 loops=4)

27. 6.380 6.380 ↑ 1.0 1 12,760 / 4

Index Scan using financingcontextbase_pkey on financingcontextbase ps_absfc_fc_fcb (cost=0.42..0.45 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=12,760)

  • Index Cond: (id = ps_abseps.financingcontext_id)
28. 0.970 4.635 ↑ 1.0 2,100 4 / 4

Hash (cost=65.00..65.00 rows=2,100 width=133) (actual time=4.634..4.635 rows=2,100 loops=4)

  • Buckets: 4,096 Batches: 1 Memory Usage: 197kB
29. 3.665 3.665 ↑ 1.0 2,100 4 / 4

Seq Scan on absfinancingcontext ps_absfc_fc_afc (cost=0.00..65.00 rows=2,100 width=133) (actual time=0.570..3.665 rows=2,100 loops=4)

30. 0.005 0.491 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=26) (actual time=0.490..0.491 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
31. 0.486 0.486 ↑ 1.0 1 1

Index Scan using corporatebase_pkey on corporatebase od_c_cb (cost=0.28..8.29 rows=1 width=26) (actual time=0.485..0.486 rows=1 loops=1)

  • Index Cond: (id = 64,608,300)
32. 0.603 15.369 ↑ 1.0 1,650 1

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=15.369..15.369 rows=1,650 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 119kB
33. 14.766 14.766 ↑ 1.0 1,650 1

Seq Scan on corporatebase s_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=2.300..14.766 rows=1,650 loops=1)

34. 0.577 1.300 ↑ 1.0 1,650 1

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.299..1.300 rows=1,650 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 119kB
35. 0.723 0.723 ↑ 1.0 1,650 1

Seq Scan on corporatebase ps_eps_t_bc_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.005..0.723 rows=1,650 loops=1)

36. 25.520 25.520 ↑ 1.0 1 12,760

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..6.83 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=12,760)

  • Index Cond: (si.importbatch_id = id)
37. 0.006 0.478 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=12) (actual time=0.478..0.478 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
38. 0.472 0.472 ↑ 1.0 6 1

Seq Scan on crxcurrency c (cost=0.00..1.06 rows=6 width=12) (actual time=0.470..0.472 rows=6 loops=1)

39. 0.018 0.534 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=30) (actual time=0.533..0.534 rows=40 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
40. 0.516 0.516 ↑ 1.0 40 1

Seq Scan on earlypaymentadvice eps_epa (cost=0.00..1.40 rows=40 width=30) (actual time=0.505..0.516 rows=40 loops=1)

41. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=10.10..10.10 rows=10 width=1,052) (actual time=0.002..0.003 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
42. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on invoicepaymentadvice ipa (cost=0.00..10.10 rows=10 width=1,052) (actual time=0.002..0.002 rows=0 loops=1)

43. 0.007 1.014 ↑ 1.0 6 1

Hash (cost=1.63..1.63 rows=6 width=140) (actual time=1.014..1.014 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
44. 0.009 1.007 ↑ 1.0 6 1

Merge Right Join (cost=1.42..1.63 rows=6 width=140) (actual time=1.000..1.007 rows=6 loops=1)

  • Merge Cond: (cba.id = ifca.maturitypaymentsaccount_id)
45. 0.489 0.489 ↑ 544.3 3 1

Index Scan using corporatebankaccount_pkey on corporatebankaccount cba (cost=0.28..99.78 rows=1,633 width=132) (actual time=0.488..0.489 rows=3 loops=1)

46. 0.041 0.509 ↑ 1.0 6 1

Sort (cost=1.14..1.15 rows=6 width=24) (actual time=0.507..0.509 rows=6 loops=1)

  • Sort Key: ifca.maturitypaymentsaccount_id
  • Sort Method: quicksort Memory: 25kB
47. 0.468 0.468 ↑ 1.0 6 1

Seq Scan on fiduciarycashaccount ifca (cost=0.00..1.06 rows=6 width=24) (actual time=0.466..0.468 rows=6 loops=1)

48. 9.531 77.763 ↑ 1.0 30,234 1

Hash (cost=1,501.34..1,501.34 rows=30,234 width=16) (actual time=77.763..77.763 rows=30,234 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,674kB
49. 68.232 68.232 ↑ 1.0 30,234 1

Seq Scan on bankpaymenttransaction bpt (cost=0.00..1,501.34 rows=30,234 width=16) (actual time=32.825..68.232 rows=30,234 loops=1)

50.          

SubPlan (for Hash Left Join)

51. 12.760 51.040 ↑ 1.0 1 12,760

Aggregate (cost=8.31..8.32 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=12,760)

52. 38.280 38.280 ↑ 1.0 1 12,760

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt_1 (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=12,760)

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 162.973 ms
Execution time : 353.541 ms