explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b2as

Settings
# exclusive inclusive rows x rows loops node
1. 21.841 258.078 ↑ 1.2 12,760 1

Hash Left Join (cost=3,766.73..316,550.85 rows=14,823 width=1,770) (actual time=30.913..258.078 rows=12,760 loops=1)

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

Hash Left Join (cost=1,887.47..191,140.06 rows=14,823 width=1,793) (actual time=8.864..163.271 rows=12,760 loops=1)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
3. 12.487 152.761 ↑ 1.2 12,760 1

Hash Left Join (cost=1,877.24..191,090.93 rows=14,823 width=749) (actual time=8.854..152.761 rows=12,760 loops=1)

  • Hash Cond: ((ps_abseps_t_absda.id = ifca.absda_id) AND (si.currency_id = ifca.currency_id))
4. 9.773 140.234 ↑ 1.2 12,760 1

Hash Left Join (cost=1,875.52..190,914.50 rows=14,823 width=641) (actual time=8.805..140.234 rows=12,760 loops=1)

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

Hash Left Join (cost=1,873.62..190,873.69 rows=14,823 width=627) (actual time=8.762..130.426 rows=12,760 loops=1)

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

Nested Loop Left Join (cost=1,872.49..190,806.17 rows=14,823 width=623) (actual time=8.745..119.602 rows=12,760 loops=1)

7. 10.928 75.625 ↑ 1.2 12,760 1

Hash Left Join (cost=1,872.05..89,535.73 rows=14,823 width=623) (actual time=8.734..75.625 rows=12,760 loops=1)

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

Hash Left Join (cost=1,660.93..89,285.59 rows=14,823 width=613) (actual time=7.316..63.287 rows=12,760 loops=1)

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

Hash Left Join (cost=1,449.80..89,035.46 rows=14,823 width=603) (actual time=5.632..51.189 rows=12,760 loops=1)

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

Hash Left Join (cost=1,441.50..88,823.34 rows=14,823 width=593) (actual time=5.616..41.222 rows=12,760 loops=1)

  • Hash Cond: (ps_absfc_fc_fcb.id = ps_absfc_fc_afc.id)
11. 17.189 28.629 ↑ 1.2 12,760 1

Nested Loop (cost=1,350.25..88,693.18 rows=14,823 width=476) (actual time=4.150..28.629 rows=12,760 loops=1)

12. 0.011 0.011 ↑ 1.0 1 1

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

  • Filter: (id = 6656)
  • Rows Removed by Filter: 24
13. 0.000 11.429 ↑ 1.2 12,760 1

Gather (cost=1,350.25..88,543.63 rows=14,823 width=471) (actual time=4.139..11.429 rows=12,760 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
14. 2.661 42.943 ↑ 1.5 3,190 4 / 4

Nested Loop Left Join (cost=350.25..86,061.33 rows=4,782 width=471) (actual time=2.089..42.943 rows=3,190 loops=4)

15. 2.760 33.902 ↑ 1.5 3,190 4 / 4

Hash Left Join (cost=349.82..83,931.08 rows=4,782 width=455) (actual time=2.077..33.902 rows=3,190 loops=4)

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

Nested Loop Left Join (cost=348.51..83,913.41 rows=4,782 width=447) (actual time=2.043..31.122 rows=3,190 loops=4)

17. 2.745 21.896 ↑ 1.5 3,190 4 / 4

Hash Join (cost=348.08..81,600.87 rows=4,782 width=431) (actual time=2.028..21.896 rows=3,190 loops=4)

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

Hash Left Join (cost=345.73..81,582.16 rows=4,782 width=419) (actual time=1.954..19.123 rows=3,190 loops=4)

  • Hash Cond: (si.nettingbundle_id = nb.id)
  • Filter: ((si.nettingbundle_id IS NULL) OR (si.id = nb.surplus_id))
  • Rows Removed by Filter: 500
19. 5.725 14.807 ↑ 1.3 3,690 4 / 4

Nested Loop Left Join (cost=279.78..81,503.66 rows=4,783 width=427) (actual time=0.285..14.807 rows=3,690 loops=4)

20. 1.490 1.702 ↑ 1.3 3,690 4 / 4

Parallel Bitmap Heap Scan on supplierinvoice si (cost=279.35..47,334.76 rows=4,783 width=215) (actual time=0.267..1.702 rows=3,690 loops=4)

  • Recheck Cond: (lastauction_id = 6656)
  • Heap Blocks: exact=1
21. 0.212 0.212 ↑ 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=0.848..0.848 rows=14,760 loops=1)

  • Index Cond: (lastauction_id = 6656)
22. 7.380 7.380 ↑ 1.0 1 14,760 / 4

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

  • Index Cond: (si.id = invoice_id)
23. 0.759 1.506 ↑ 1.0 2,042 4 / 4

Hash (cost=40.42..40.42 rows=2,042 width=16) (actual time=1.505..1.506 rows=2,042 loops=4)

  • Buckets: 2048 Batches: 1 Memory Usage: 112kB
24. 0.747 0.747 ↑ 1.0 2,042 4 / 4

Seq Scan on nettingbundle nb (cost=0.00..40.42 rows=2,042 width=16) (actual time=0.009..0.747 rows=2,042 loops=4)

25. 0.009 0.028 ↑ 1.0 14 4 / 4

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
26. 0.019 0.019 ↑ 1.0 14 4 / 4

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

  • Filter: (buyer_id = 64608300)
27. 6.380 6.380 ↑ 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.002..0.002 rows=1 loops=12,760)

  • Index Cond: (ps_eps.id = id)
28. 0.009 0.020 ↑ 1.0 14 4 / 4

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.011 0.011 ↑ 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.006..0.011 rows=14 loops=4)

30. 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)
31. 0.686 1.457 ↑ 1.0 2,100 1

Hash (cost=65.00..65.00 rows=2,100 width=133) (actual time=1.457..1.457 rows=2,100 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 197kB
32. 0.771 0.771 ↑ 1.0 2,100 1

Seq Scan on absfinancingcontext ps_absfc_fc_afc (cost=0.00..65.00 rows=2,100 width=133) (actual time=0.003..0.771 rows=2,100 loops=1)

33. 0.002 0.008 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.006 0.006 ↑ 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.006..0.006 rows=1 loops=1)

  • Index Cond: (id = 64608300)
35. 0.632 1.678 ↑ 1.0 1,650 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
36. 1.046 1.046 ↑ 1.0 1,650 1

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

37. 0.610 1.410 ↑ 1.0 1,650 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
38. 0.800 0.800 ↑ 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.002..0.800 rows=1,650 loops=1)

39. 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)
40. 0.005 0.010 ↑ 1.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.005 0.005 ↑ 1.0 6 1

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

42. 0.017 0.035 ↑ 1.0 40 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
43. 0.018 0.018 ↑ 1.0 40 1

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

44. 0.005 0.040 ↑ 1.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
45. 0.009 0.035 ↑ 1.0 6 1

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

  • Merge Cond: (cba.id = ifca.maturitypaymentsaccount_id)
46. 0.010 0.010 ↑ 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.008..0.010 rows=3 loops=1)

47. 0.011 0.016 ↑ 1.0 6 1

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

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

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

49. 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: 1024 Batches: 1 Memory Usage: 8kB
50. 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.001..0.002 rows=0 loops=1)

51. 9.658 21.926 ↑ 1.0 30,234 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1674kB
52. 12.268 12.268 ↑ 1.0 30,234 1

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

53.          

SubPlan (for Hash Left Join)

54. 25.520 51.040 ↑ 1.0 1 12,760

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

55. 25.520 25.520 ↑ 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.002 rows=1 loops=12,760)

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 9.341 ms
Execution time : 261.943 ms