Overview

This document contains the results of testing scenario to create order with PO lines plus create invoice with invoice Lines for both Poppy and Quesnelia environments. Tickets: PERF-788 and PERF-891

PERF-788 - Getting issue details... STATUS PERF-891 - Getting issue details... STATUS

Summary

When comparing Test №1 (Poppy) and Test №4 (Quesnelia), we observed an overall improvement in performance across all requests. Additionally, during the same 1.5-hour test duration, Test №3 (Quesnelia) processed 39 more orders, totaling 390 order lines, and 39 more invoices, totaling 379 invoice lines, compared to Test №1 (Poppy).
Comparing Test №2 (Poppy) and Test №5 (Quesnelia), we observed a similar improvement in performance across all requests. Moreover, we noted improvements ranging from 20 to 57 seconds for certain requests. Additionally, Test №2 (Poppy) lasted 3 hours and 10 minutes, while Test №5 (Quesnelia) lasted 1 hour and 8 minutes under the same test conditions.
In the comparison between Test №3 (Poppy) and Test №6 (Quesnelia), we found that all requests showed an improvement in performance, some requests improving by more than 10 seconds. Furthermore, during the same 1-hour test duration, Test №6 (Quesnelia) processed 26 more invoices and 12,580 more blank invoice lines compared to Test №3 (Poppy).

Test Runs

Test №	Date	Test Conditions	Results
1	Mar 30, 2024, 8:21 AM UTC	Test environment Poppy(ocp3), PO with PO Lines(10)+Invoice with PO lines(10 from Order)	Completed
2	Mar 30, 2024, 8:14 PM UTC	Test environment Poppy(ocp3), PO with PO Lines(500)+Invoice with PO lines(500 from Order)	Completed
3	Apr 2, 2024, 8:34 AM UTC	Test environment Poppy(ocp3), Invoice with blank invoice lines(500)	Completed
4	Apr 5, 2024, 11:04 AM UTC	Test environment Quesnelia(qcp1), PO with PO Lines(10)+Invoice with PO lines(10 from Order)	Completed
5	Apr 5, 2024, 2:03 PM UTC	Test environment Quesnelia(qcp1), PO with PO Lines(500)+Invoice with PO lines(500 from Order)	Completed
6	Apr 5, 2024, 4:00 PM UTC	Test environment Quesnelia(qcp1), Invoice with blank invoice line(500)	Completed

Test Results

Test №1

Test environment Poppy(ocp3), PO with PO Lines(10)+Invoice with PO lines(10 from Order)

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
Requests	Total	Response Time (seconds)
IO_POST invoice/invoice_lines Create Invoice Line (POL)	1128	0.883	0.964	1.648	1.984	0.976
IO_POST invoice/invoices Create Invoice	113	0.103	0.121	0.162	0.179	0.1
POO_POST /orders/composite-orders Create Order	113	0.159	0.201	0.286	0.769	0.179
POO_POST orders/order-lines Create Order Line	1130	0.072	0.104	0.183	0.273	0.095
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice	111	2.477	2.733	2.89	3.162	2.375
AIE_PUT invoice/invoices/id Approve Invoice	111	1.311	1.473	2.064	2.846	1.391
POO_PUT orders/composite-orders/[order_id] Open Order	113	3.07	3.927	4.443	4.684	3.002
PUT orders/composite-orders/[order_id] Approve Order	113	0.178	0.258	0.86	1.236	0.254

Full result table

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
AIE_GET batch-groups/[batchGroupId]	222	0.017	0.019	0.055	0.096	0.023
AIE_GET batch-voucher/batch-voucher-exports	222	0.053	0.057	0.091	0.119	0.048
AIE_GET batch-voucher/export-configurations	222	0.018	0.023	0.058	0.149	0.03
AIE_GET configurations/entries	444	0.015	0.016	0.021	0.048	0.016
AIE_GET finance/fiscal-years/[fiscalYearId]	222	0.02	0.052	0.057	0.081	0.031
AIE_GET finance/funds	222	0.053	0.056	0.088	0.103	0.057
AIE_GET invoice/invoice-lines	222	0.053	0.056	0.089	0.112	0.057
AIE_GET invoice/invoices	222	0.059	0.089	0.132	0.614	0.079
AIE_GET invoice/invoices/[invoice_id]	222	0.028	0.034	0.071	0.158	0.037
AIE_GET invoice/invoices/[invoice_id]/documents	222	0.018	0.021	0.055	0.174	0.029
AIE_GET material-types	222	0.014	0.016	0.047	0.051	0.017
AIE_GET organizations-storage/categories	222	0.012	0.045	0.051	0.066	0.026
AIE_GET organizations/organizations	222	0.686	0.745	0.836	0.866	0.699
AIE_GET organizations/organizations/[invoice_organization_id]	444	0.018	0.02	0.045	0.098	0.021
AIE_GET users	222	0.011	0.013	0.053	0.058	0.015
AIE_GET voucher/voucher-lines	222	0.051	0.055	0.092	0.106	0.044
AIE_GET voucher/vouchers	222	0.051	0.059	0.096	0.566	0.056
AIE_GET batch-groups/{id}	111	0.018	0.051	0.084	0.099	0.032
AIE_GET batch-voucher/export-configurations	111	0.021	0.053	0.071	0.095	0.035
AIE_GET configurations/entries	222	0.015	0.016	0.02	0.048	0.016
AIE_GET finance/funds	111	0.055	0.058	0.077	0.114	0.058
AIE_GET invoice/invoice-lines	111	0.055	0.08	0.124	0.166	0.068
AIE_GET invoice/invoices	111	0.077	0.089	0.153	0.183	0.081
AIE_GET invoice/invoices-Choose	111	0.133	0.168	0.211	0.702	0.14
AIE_GET invoice/invoices-Choose by id	111	0.032	0.064	0.099	0.106	0.047
AIE_GET invoice/invoices/{id}/documents	111	0.02	0.053	0.086	0.103	0.036
AIE_GET material-types	111	0.014	0.017	0.05	0.052	0.02
AIE_GET organizations/organizations/{id}	222	0.018	0.02	0.056	0.084	0.022
AIE_GET users	111	0.012	0.013	0.054	0.061	0.016
AIE_PUT invoice/invoices/[invoice_id]	111	2.477	2.733	2.89	3.162	2.375
AIE_PUT invoice/invoices/id	111	1.311	1.473	2.064	2.846	1.391
AIE_TC: Invoices Approve fs09000000	111	1.938	2.109	2.841	3.55	2.002
Debug Sampler	1128	0	0	0.001	0.001	0
FOLIO: Login	1	0.317	0.317	0.317	0.317	0.317
GET bl-users/_self	1	1.412	1.412	1.412	1.412	1.412
IO_GET acquisitions-units/memberships	113	0.021	0.052	0.086	0.098	0.034
IO_GET acquisitions-units/units	337	0.02	0.024	0.088	0.107	0.031
IO_GET batch-groups	337	0.021	0.054	0.092	0.654	0.046
IO_GET batch-groups/{id}	111	0.052	0.059	0.093	0.098	0.049
IO_GET batch-voucher/export-configurations	111	0.052	0.061	0.095	0.167	0.053
IO_GET configurations/entries	785	0.015	0.018	0.034	0.051	0.018
IO_GET finance/expense-classes	224	0.022	0.025	0.059	0.089	0.032
IO_GET finance/funds	335	0.055	0.063	0.092	0.101	0.061
IO_GET invoice/invoice-lines	111	0.056	0.093	0.164	0.798	0.097
IO_GET invoice/invoices	113	0.05	0.078	0.098	0.122	0.06
IO_GET invoice/invoices/{id}	111	0.093	0.128	0.516	0.75	0.132
IO_GET invoice/invoices/{id}/documents	111	0.053	0.058	0.09	0.117	0.048
IO_GET material-types	111	0.015	0.048	0.053	0.076	0.028
IO_GET orders/order-lines	1128	0.13	0.139	0.172	0.23	0.135
IO_GET organizations/organizations	113	0.058	0.062	0.078	0.113	0.061
IO_GET organizations/organizations/{id}	335	0.019	0.023	0.091	0.115	0.029
IO_GET tags	337	0.015	0.017	0.047	0.053	0.017
IO_GET users	111	0.013	0.02	0.057	0.064	0.023
IO_POST invoice/invoice_lines	1128	0.883	0.964	1.648	1.984	0.976
IO_POST invoice/invoices	113	0.103	0.121	0.162	0.179	0.1
IO_TC: Create Invoice Lines fs09000000	1128	0.883	0.964	1.648	1.984	0.976
IO_TC: Create Invoices Workflow fs09000000	111	17.148	17.759	18.241	24.233	17.266
IOP_TC: Paying Invoices fs09000000	111	5.028	5.28	5.617	5.822	5.019
JSR223 Sampler 1	113	0	0	0.001	0.003	0
JSR223 Sampler 3	113	0	0.001	0.001	0.002	0.001
JSR223 Sampler 4	1129	0	0.001	0.001	0.001	0
POO-GET orders/configuration/prefixes	113	0.018	0.02	0.025	0.028	0.019
POO_GET /acquisitions-units/memberships	113	0.018	0.052	0.08	0.092	0.031
POO_GET /acquisitions-units/units	452	0.019	0.022	0.058	0.096	0.026
POO_GET /configurations/entries	1356	0.016	0.018	0.023	0.037	0.017
POO_GET /finance/expense-classes	113	0.022	0.028	0.059	0.096	0.031
POO_GET /finance/funds	226	0.054	0.058	0.086	0.116	0.058
POO_GET /material-types	113	0.014	0.015	0.023	0.055	0.016
POO_GET /orders/acquisition-methods	113	0.024	0.055	0.088	0.092	0.039
POO_GET /orders/composite-orders/[order_id]	113	0.032	0.09	0.11	0.131	0.053
POO_GET /orders/configuration/prefixes	452	0.021	0.05	0.099	0.11	0.035
POO_GET /orders/configuration/reasons-for-closure	339	0.02	0.052	0.089	0.099	0.034
POO_GET /orders/configuration/suffixes	452	0.018	0.049	0.091	0.112	0.032
POO_GET /orders/order-lines	226	0.172	0.202	0.258	0.301	0.14
POO_GET /orders/order-templates	113	0.021	0.053	0.086	0.1	0.035
POO_GET /orders/po-number	113	0.05	0.057	0.093	0.126	0.05
POO_GET /organizations(vendor)	113	0.676	0.715	0.795	0.895	0.69
POO_GET /organizations/organizations/[vendor_id]	113	0.018	0.02	0.029	0.092	0.021
POO_GET /tags	452	0.015	0.017	0.05	0.057	0.019
POO_GET /users	226	0.011	0.013	0.025	0.056	0.014
POO_GET _/proxy/tenants/[tenant]/modules	1130	0.051	0.054	0.085	0.092	0.055
POO_GET _/version	1130	0.005	0.005	0.04	0.049	0.008
POO_GET acquisitions-units/memberships	113	0.05	0.055	0.093	0.445	0.051
POO_GET acquisitions-units/units	4746	0.019	0.021	0.029	0.053	0.021
POO_GET configurations/entries	21809	0.015	0.017	0.024	0.043	0.016
POO_GET contributor-name-types	3390	0.011	0.012	0.021	0.047	0.013
POO_GET contributor-types	1130	0.018	0.021	0.053	0.066	0.023
POO_GET data-export-spring/configs	1130	0.027	0.03	0.067	0.103	0.036
POO_GET erm/entitlements	1130	0.016	0.019	0.053	0.065	0.021
POO_GET finance/expense-classes	1130	0.022	0.026	0.059	0.092	0.028
POO_GET finance/funds	5876	0.055	0.058	0.074	0.096	0.057
POO_GET holdings-storage/holdings	1130	0.011	0.013	0.046	0.051	0.017
POO_GET identifier-types	2260	0.012	0.013	0.026	0.049	0.014
POO_GET instance-formats	1130	0.012	0.014	0.047	0.053	0.017
POO_GET instance-relationship-types	2260	0.011	0.012	0.026	0.047	0.013
POO_GET instance-types	2260	0.011	0.013	0.026	0.05	0.014
POO_GET inventory/instances	2260	0.073	0.08	0.124	0.189	0.08
POO_GET inventory/instances/[instances_id]	1130	0.075	0.085	0.201	0.367	0.091
POO_GET invoice/invoice-lines	1130	0.053	0.06	0.104	0.154	0.063
POO_GET locations	4520	0.039	0.041	0.051	0.074	0.041
POO_GET material-types	4520	0.014	0.015	0.021	0.031	0.015
POO_GET modes-of-issuance	1130	0.011	0.013	0.046	0.052	0.015
POO_GET nature-of-content-terms	1130	0.011	0.013	0.046	0.054	0.016
POO_GET note-links/domain/orders/type/poLine/id/[poLine_id]	1130	0.014	0.017	0.049	0.062	0.019
POO_GET note-types	1130	0.013	0.016	0.048	0.06	0.019
POO_GET orders-storage/order-invoice-relns	1469	0.011	0.013	0.044	0.049	0.014
POO_GET orders/acquisition-methods	1130	0.018	0.021	0.054	0.079	0.024
POO_GET orders/acquisition-methods/[acquisition_methods_id]	1130	0.017	0.021	0.055	0.087	0.024
POO_GET orders/composite-orders	3955	0.776	1.009	1.162	1.38	0.615
POO_GET orders/composite-orders/[order_id]	5084	0.334	0.369	0.488	0.802	0.348
POO_GET orders/configuration/prefixes	2373	0.018	0.02	0.027	0.044	0.019
POO_GET orders/configuration/reasons-for-closure	3955	0.018	0.021	0.029	0.054	0.02
POO_GET orders/configuration/suffixes	2486	0.017	0.019	0.027	0.038	0.019
POO_GET orders/export-history	1356	0.018	0.022	0.056	0.089	0.025
POO_GET orders/order-lines	4857	0.126	0.139	0.195	0.261	0.135
POO_GET orders/order-templates	1243	0.02	0.023	0.056	0.071	0.027
POO_GET orders/po-number	113	0.025	0.058	0.491	0.649	0.075
POO_GET orders/titles	1130	0.155	0.193	0.255	0.32	0.172
POO_GET organizations/organizations	2373	0.054	0.06	0.088	0.121	0.059
POO_GET organizations/organizations/[vendor_id]	6102	0.018	0.02	0.027	0.052	0.02
POO_GET saml/check	1130	0.009	0.011	0.044	0.052	0.013
POO_GET search/instances	1130	0.063	0.067	0.101	0.129	0.069
POO_GET tags	4746	0.014	0.016	0.022	0.045	0.016
POO_GET users	4181	0.012	0.013	0.02	0.051	0.013
POO_POST /orders/composite-orders	113	0.159	0.201	0.286	0.769	0.179
POO_POST orders/order-lines	1130	0.072	0.104	0.183	0.273	0.095
POO_PUT orders/composite-orders/[order_id]	113	3.07	3.927	4.443	4.684	3.002
POO_TC Create Order fs09000000	113	2.24	2.488	2.744	3.204	2.319
POO_TC: Add Order Lines fs09000000	113	59.323	61.114	63.367	68.682	59.418
POO_TC: Approve Order fs09000000	113	3.004	3.211	3.963	4.132	3.104
POO_TC: Open Order fs09000000	113	5.188	5.904	6.522	7.205	5.03
PUT orders/composite-orders/[order_id]	113	0.178	0.258	0.86	1.236	0.254

Test №2

Test environment Poppy(ocp3), PO with PO Lines(500)+Invoice with PO lines(500 from Order)

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
Requests	Total	Response Time (seconds)
IO_POST invoice/invoice_lines Create Invoice Line (POL)	1000	4.71	5.51	7.233	8.782	4.988
IO_POST invoice/invoices Create Invoice	2	0.281	0.35	0.35	0.35	0.281
POO_POST /orders/composite-orders Create Order	2	0.371	0.422	0.422	0.422	0.371
POO_POST orders/order-lines Create Order Line	1000	0.169	0.309	0.813	1.65	0.27
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice	2	71.35	78.763	78.763	78.763	71.35
AIE_PUT invoice/invoices/id Approve Invoice	2	25.721	31.006	31.006	31.006	25.721
POO_PUT orders/composite-orders/[order_id] Open Order	2	108.005	111.748	111.748	111.748	108.005
PUT orders/composite-orders/[order_id] Approve Order	2	0.777	1.103	1.103	1.103	0.777

Full result table

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
AIE_GET batch-groups/[batchGroupId]	4	0.018	0.019	0.098	0.098	0.037
AIE_GET batch-voucher/batch-voucher-exports	4	0.076	0.088	0.091	0.091	0.076
AIE_GET batch-voucher/export-configurations	4	0.021	0.025	0.069	0.069	0.032
AIE_GET configurations/entries	8	0.021	0.048	0.483	0.483	0.087
AIE_GET finance/fiscal-years/[fiscalYearId]	4	0.053	0.054	0.067	0.067	0.05
AIE_GET finance/funds	4	0.082	0.089	0.089	0.089	0.077
AIE_GET invoice/invoice-lines	4	0.149	0.15	0.161	0.161	0.141
AIE_GET invoice/invoices	4	0.158	0.185	0.217	0.217	0.153
AIE_GET invoice/invoices/[invoice_id]	4	0.146	0.151	0.171	0.171	0.146
AIE_GET invoice/invoices/[invoice_id]/documents	4	0.022	0.023	0.052	0.052	0.029
AIE_GET material-types	4	0.051	0.053	0.058	0.058	0.043
AIE_GET organizations-storage/categories	4	0.051	0.056	0.072	0.072	0.048
AIE_GET organizations/organizations	4	0.808	0.82	0.948	0.948	0.799
AIE_GET organizations/organizations/[invoice_organization_id]	8	0.023	0.029	0.054	0.054	0.029
AIE_GET users	4	0.013	0.013	0.029	0.029	0.016
AIE_GET voucher/voucher-lines	4	0.091	0.118	0.165	0.165	0.095
AIE_GET voucher/vouchers	4	0.105	0.123	0.169	0.169	0.1
AIE_GET batch-groups/{id}	2	0.081	0.104	0.104	0.104	0.081
AIE_GET batch-voucher/export-configurations	2	0.087	0.088	0.088	0.088	0.087
AIE_GET configurations/entries	4	0.015	0.016	0.016	0.016	0.015
AIE_GET finance/funds	2	0.086	0.12	0.12	0.12	0.086
AIE_GET invoice/invoice-lines	2	0.211	0.245	0.245	0.245	0.211
AIE_GET invoice/invoices	2	0.183	0.217	0.217	0.217	0.183
AIE_GET invoice/invoices-Choose	2	0.288	0.301	0.301	0.301	0.288
AIE_GET invoice/invoices-Choose by id	2	0.148	0.162	0.162	0.162	0.148
AIE_GET invoice/invoices/{id}/documents	2	0.096	0.105	0.105	0.105	0.096
AIE_GET material-types	2	0.043	0.057	0.057	0.057	0.043
AIE_GET organizations/organizations/{id}	4	0.073	0.088	0.112	0.112	0.069
AIE_GET users	2	0.054	0.055	0.055	0.055	0.054
AIE_PUT invoice/invoices/[invoice_id]	2	71.35	78.763	78.763	78.763	71.35
AIE_PUT invoice/invoices/id	2	25.721	31.006	31.006	31.006	25.721
AIE_TC: Invoices Approve fs09000000	2	27.167	32.659	32.659	32.659	27.167
Debug Sampler	1000	0	0.001	0.001	0.001	0
FOLIO: Login	1	0.383	0.383	0.383	0.383	0.383
GET bl-users/_self	1	1.362	1.362	1.362	1.362	1.362
IO_GET acquisitions-units/memberships	2	0.065	0.066	0.066	0.066	0.065
IO_GET acquisitions-units/units	6	0.088	0.096	0.223	0.223	0.095
IO_GET batch-groups	6	0.086	0.095	0.148	0.148	0.082
IO_GET batch-groups/{id}	2	0.094	0.103	0.103	0.103	0.094
IO_GET batch-voucher/export-configurations	2	0.093	0.102	0.102	0.102	0.093
IO_GET configurations/entries	14	0.024	0.051	0.055	0.071	0.034
IO_GET finance/expense-classes	4	0.075	0.092	0.1	0.1	0.069
IO_GET finance/funds	6	0.103	0.122	0.149	0.149	0.103
IO_GET invoice/invoice-lines	2	0.266	0.294	0.294	0.294	0.266
IO_GET invoice/invoices	2	0.197	0.22	0.22	0.22	0.197
IO_GET invoice/invoices/{id}	2	0.166	0.191	0.191	0.191	0.166
IO_GET invoice/invoices/{id}/documents	2	0.089	0.094	0.094	0.094	0.089
IO_GET material-types	2	0.077	0.087	0.087	0.087	0.077
IO_GET orders/order-lines	1000	0.186	0.222	1.711	2.127	0.349
IO_GET organizations/organizations	2	0.074	0.083	0.083	0.083	0.074
IO_GET organizations/organizations/{id}	6	0.048	0.099	0.13	0.13	0.065
IO_GET tags	6	0.051	0.053	0.077	0.077	0.044
IO_GET users	2	0.077	0.086	0.086	0.086	0.077
IO_POST invoice/invoice_lines	1000	4.71	5.51	7.233	8.782	4.988
IO_POST invoice/invoices	2	0.281	0.35	0.35	0.35	0.281
IO_TC: Create Invoice Lines fs09000000	1000	4.71	5.51	7.233	8.782	4.988
IO_TC: Create Invoices Workflow fs09000000	2	4653.229	4678.266	4678.266	4678.266	4653.229
IOP_TC: Paying Invoices fs09000000	2	75.5	83.551	83.551	83.551	75.5
JSR223 Sampler 1	2	0.014	0.024	0.024	0.024	0.014
JSR223 Sampler 3	2	0.021	0.042	0.042	0.042	0.021
JSR223 Sampler 4	1000	0	0	0.001	0.001	0
POO-GET orders/configuration/prefixes	2	0.021	0.025	0.025	0.025	0.021
POO_GET /acquisitions-units/memberships	2	0.112	0.138	0.138	0.138	0.112
POO_GET /acquisitions-units/units	8	0.021	0.055	0.095	0.095	0.041
POO_GET /configurations/entries	24	0.017	0.018	0.055	0.062	0.022
POO_GET /finance/expense-classes	2	0.065	0.109	0.109	0.109	0.065
POO_GET /finance/funds	4	0.108	0.165	0.198	0.198	0.116
POO_GET /material-types	2	0.042	0.067	0.067	0.067	0.042
POO_GET /orders/acquisition-methods	2	0.054	0.093	0.093	0.093	0.054
POO_GET /orders/composite-orders/[order_id]	2	0.098	0.173	0.173	0.173	0.098
POO_GET /orders/configuration/prefixes	8	0.026	0.052	0.154	0.154	0.046
POO_GET /orders/configuration/reasons-for-closure	6	0.018	0.086	0.092	0.092	0.041
POO_GET /orders/configuration/suffixes	8	0.025	0.052	0.111	0.111	0.044
POO_GET /orders/order-lines	4	0.182	0.228	0.471	0.471	0.222
POO_GET /orders/order-templates	2	0.059	0.097	0.097	0.097	0.059
POO_GET /orders/po-number	2	0.119	0.184	0.184	0.184	0.119
POO_GET /organizations(vendor)	2	0.847	0.869	0.869	0.869	0.847
POO_GET /organizations/organizations/[vendor_id]	2	0.063	0.109	0.109	0.109	0.063
POO_GET /tags	8	0.016	0.017	0.056	0.056	0.021
POO_GET /users	4	0.012	0.014	0.053	0.053	0.021
POO_GET _/proxy/tenants/[tenant]/modules	1000	0.051	0.054	0.086	0.094	0.057
POO_GET _/version	1000	0.004	0.005	0.039	0.045	0.009
POO_GET acquisitions-units/memberships	2	0.071	0.094	0.094	0.094	0.071
POO_GET acquisitions-units/units	4004	0.019	0.025	0.092	1.108	0.055
POO_GET configurations/entries	18026	0.016	0.022	0.047	0.065	0.021
POO_GET contributor-name-types	3000	0.011	0.015	0.031	0.051	0.015
POO_GET contributor-types	1000	0.02	0.028	0.054	0.071	0.027
POO_GET data-export-spring/configs	1000	0.028	0.047	0.073	0.13	0.043
POO_GET erm/entitlements	1000	0.019	0.047	0.08	0.109	0.035
POO_GET finance/expense-classes	1000	0.024	0.034	0.065	0.102	0.035
POO_GET finance/funds	5004	0.058	0.077	0.116	0.157	0.069
POO_GET holdings-storage/holdings	1000	0.014	0.03	0.057	0.078	0.023
POO_GET identifier-types	2000	0.012	0.018	0.045	0.057	0.017
POO_GET instance-formats	1000	0.013	0.019	0.05	0.074	0.02
POO_GET instance-relationship-types	2000	0.011	0.016	0.044	0.054	0.016
POO_GET instance-types	2000	0.012	0.017	0.045	0.056	0.017
POO_GET inventory/instances	2000	0.089	0.123	0.21	0.356	0.111
POO_GET inventory/instances/[instances_id]	1000	0.105	0.151	0.234	0.346	0.125
POO_GET invoice/invoice-lines	1000	0.08	0.107	0.155	0.192	0.088
POO_GET locations	4000	0.041	0.049	0.072	0.092	0.046
POO_GET material-types	4000	0.014	0.019	0.032	0.052	0.018
POO_GET modes-of-issuance	1000	0.012	0.018	0.048	0.063	0.019
POO_GET nature-of-content-terms	1000	0.012	0.017	0.048	0.07	0.019
POO_GET note-links/domain/orders/type/poLine/id/[poLine_id]	1000	0.016	0.03	0.054	0.082	0.026
POO_GET note-types	1000	0.016	0.031	0.058	0.08	0.026
POO_GET orders-storage/order-invoice-relns	1006	0.013	0.019	0.047	0.066	0.02
POO_GET orders/acquisition-methods	1000	0.019	0.036	0.146	1.091	0.066
POO_GET orders/acquisition-methods/[acquisition_methods_id]	1000	0.018	0.048	0.883	1.469	0.111
POO_GET orders/composite-orders	3010	0.881	1.186	1.621	2.121	0.786
POO_GET orders/composite-orders/[order_id]	4010	2.216	3.361	4.259	5.104	2.339
POO_GET orders/configuration/prefixes	2002	0.018	0.028	0.621	1.302	0.089
POO_GET orders/configuration/reasons-for-closure	3010	0.018	0.024	0.057	0.903	0.042
POO_GET orders/configuration/suffixes	2004	0.018	0.025	0.098	1.173	0.059
POO_GET orders/export-history	1004	0.021	0.05	0.878	1.435	0.121
POO_GET orders/order-lines	4006	0.231	0.275	0.503	1.976	0.278
POO_GET orders/order-templates	1002	0.021	0.036	0.349	1.055	0.071
POO_GET orders/po-number	2	0.101	0.106	0.106	0.106	0.101
POO_GET orders/titles	1000	0.235	0.36	1.03	1.875	0.344
POO_GET organizations/organizations	2002	0.061	0.086	0.125	0.212	0.074
POO_GET organizations/organizations/[vendor_id]	5008	0.018	0.023	0.04	0.068	0.023
POO_GET saml/check	1000	0.009	0.011	0.044	0.052	0.015
POO_GET search/instances	1000	0.063	0.069	0.101	0.182	0.072
POO_GET tags	4004	0.015	0.021	0.045	0.058	0.02
POO_GET users	3014	0.012	0.021	0.052	0.078	0.019
POO_POST /orders/composite-orders	2	0.371	0.422	0.422	0.422	0.371
POO_POST orders/order-lines	1000	0.169	0.309	0.813	1.65	0.27
POO_PUT orders/composite-orders/[order_id]	2	108.005	111.748	111.748	111.748	108.005
POO_TC Create Order fs09000000	2	3.542	4.733	4.733	4.733	3.542
POO_TC: Add Order Lines fs09000000	2	6440.792	6507.086	6507.086	6507.086	6440.792
POO_TC: Approve Order fs09000000	2	14.075	15.68	15.68	15.68	14.075
POO_TC: Open Order fs09000000	2	117.6	122.882	122.882	122.882	117.6
PUT orders/composite-orders/[order_id]	2	0.777	1.103	1.103	1.103	0.777

Test №3

Test environment Poppy(ocp3), Invoice with blank invoice line(500)

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
Requests	Total	Response Time (seconds)
IO_POST invoice/invoice_lines Create Invoice Line (Blank Line)	25134	0.191	0.204	0.232	0.341	0.198
IO_POST invoice/invoices Create Invoice	51	0.116	0.134	0.18	0.189	0.117
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice	49	21.454	23.067	24.974	25.133	21.401
AIE_PUT invoice/invoices/id Approve Invoice	49	15.409	16.097	18.139	21.026	15.531

Full result table

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
AIE_GET batch-groups/[batchGroupId]	98	0.018	0.058	0.098	0.103	0.035
AIE_GET batch-voucher/batch-voucher-exports	98	0.058	0.065	0.105	0.106	0.053
AIE_GET batch-voucher/export-configurations	98	0.02	0.058	0.069	0.104	0.036
AIE_GET configurations/entries	196	0.014	0.016	0.056	0.061	0.019
AIE_GET finance/fiscal-years/[fiscalYearId]	98	0.018	0.057	0.061	0.062	0.034
AIE_GET finance/funds	98	0.051	0.058	0.094	0.104	0.065
AIE_GET invoice/invoice-lines	98	0.133	0.141	0.191	0.221	0.129
AIE_GET invoice/invoices	98	0.106	0.15	0.194	0.229	0.11
AIE_GET invoice/invoices/[invoice_id]	98	0.09	0.12	0.164	0.203	0.105
AIE_GET invoice/invoices/[invoice_id]/documents	98	0.019	0.058	0.098	0.108	0.037
AIE_GET material-types	98	0.016	0.027	0.059	0.071	0.024
AIE_GET organizations-storage/categories	98	0.012	0.051	0.057	0.059	0.026
AIE_GET organizations/organizations	98	0.702	0.75	0.814	0.86	0.709
AIE_GET organizations/organizations/[invoice_organization_id]	196	0.02	0.024	0.065	0.098	0.028
AIE_GET users	98	0.011	0.018	0.065	0.091	0.024
AIE_GET voucher/voucher-lines	98	0.066	0.075	0.112	0.116	0.06
AIE_GET voucher/vouchers	98	0.058	0.064	0.102	0.105	0.051
AIE_GET batch-groups/{id}	49	0.018	0.057	0.099	0.103	0.037
AIE_GET batch-voucher/export-configurations	49	0.02	0.06	0.069	0.106	0.038
AIE_GET configurations/entries	98	0.014	0.016	0.019	0.054	0.015
AIE_GET finance/funds	49	0.051	0.054	0.092	0.1	0.055
AIE_GET invoice/invoice-lines	49	0.138	0.169	0.185	0.219	0.136
AIE_GET invoice/invoices	49	0.068	0.094	0.134	0.137	0.078
AIE_GET invoice/invoices-Choose	49	0.164	0.197	0.271	0.291	0.172
AIE_GET invoice/invoices-Choose by id	49	0.081	0.115	0.126	0.156	0.095
AIE_GET invoice/invoices/{id}/documents	49	0.019	0.058	0.097	0.104	0.036
AIE_GET material-types	49	0.015	0.031	0.068	0.088	0.026
AIE_GET organizations/organizations/{id}	98	0.018	0.021	0.062	0.485	0.034
AIE_GET users	49	0.011	0.015	0.066	0.094	0.022
AIE_PUT invoice/invoices/[invoice_id]	49	21.454	23.067	24.974	25.133	21.401
AIE_PUT invoice/invoices/id	49	15.409	16.097	18.139	21.026	15.531
AIE_TC: Invoices Approve fs09000000	49	16.082	16.839	19.148	21.781	16.325
FOLIO: Login	1	0.244	0.244	0.244	0.244	0.244
GET bl-users/_self	1	1.464	1.464	1.464	1.464	1.464
IO_GET acquisitions-units/memberships	51	0.062	0.098	0.109	0.114	0.07
IO_GET acquisitions-units/units	151	0.056	0.072	0.5	0.979	0.098
IO_GET batch-groups	151	0.04	0.06	0.105	0.646	0.06
IO_GET batch-groups/{id}	49	0.024	0.058	0.103	0.106	0.041
IO_GET batch-voucher/export-configurations	49	0.056	0.062	0.098	0.107	0.044
IO_GET configurations/entries	351	0.015	0.017	0.057	0.064	0.021
IO_GET finance/expense-classes	100	0.061	0.065	0.452	0.712	0.089
IO_GET finance/funds	149	0.052	0.061	0.101	0.521	0.073
IO_GET invoice/invoice-lines	49	0.139	0.18	0.213	0.259	0.151
IO_GET invoice/invoices	51	0.086	0.099	0.138	0.152	0.085
IO_GET invoice/invoices/{id}	49	0.116	0.156	0.199	0.731	0.131
IO_GET invoice/invoices/{id}/documents	49	0.027	0.058	0.099	0.104	0.041
IO_GET material-types	49	0.029	0.058	0.077	0.077	0.037
IO_GET organizations/organizations	51	0.097	0.109	0.15	0.188	0.096
IO_GET organizations/organizations/{id}	149	0.021	0.06	0.069	0.107	0.036
IO_GET tags	151	0.019	0.058	0.457	0.73	0.07
IO_GET users	49	0.011	0.057	0.067	0.075	0.026
IO_POST invoice/invoice_lines	25134	0.191	0.204	0.232	0.341	0.198
IO_POST invoice/invoices	51	0.116	0.134	0.18	0.189	0.117
IO_TC: Create Invoice Lines fs09000000	25134	0.191	0.204	0.232	0.341	0.198
IO_TC: Create Invoices Blanck Line Workflow fs09000000	49	99.314	105.881	110.488	112.082	101.438
IOP_TC: Paying Invoices fs09000000	49	24.395	26.23	28.237	28.458	24.587

Test №4

Test environment Quesnelia(qcp1), PO with PO Lines(10)+Invoice with PO lines(10 from Order)

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
Requests	Total	Response Time (seconds)
IO_POST invoice/invoice_lines Create Invoice Line (POL)	1507	0.512	0.565	0.779	1.155	0.558
IO_POST invoice/invoices Create Invoice	152	0.066	0.09	0.123	0.134	0.069
POO_POST /orders/composite-orders Create Order	152	0.07	0.096	0.125	0.174	0.075
POO_POST orders/order-lines Create Order Line	1520	0.076	0.098	0.136	0.216	0.095
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice	150	0.808	1.081	1.403	2.341	0.933
AIE_PUT invoice/invoices/id Approve Invoice	150	1.202	1.318	1.467	1.505	1.171
POO_PUT orders/composite-orders/[order_id] Open Order	152	1.735	2.023	3.530	4.356	2.022
POO_PUT orders/composite-orders/[order_id] Approve Order	152	0.094	0.121	0.163	0.226	0.096

Full result table

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
POO_TC: Add Order Lines fs09000000	152	44.145	46.457	49.235	50.785	44.961
POO_GET search/instances	1520	0.158	0.271	0.566	1.147	0.231
AIE_GET batch-groups/[batchGroupId]	300	0.017	0.019	0.044	0.048	0.021
AIE_GET batch-voucher/batch-voucher-exports	300	0.021	0.046	0.071	0.077	0.032
AIE_GET batch-voucher/export-configurations	300	0.017	0.019	0.044	0.056	0.021
AIE_GET configurations/entries	600	0.014	0.016	0.024	0.038	0.016
AIE_GET finance/fiscal-years/[fiscalYearId]	300	0.017	0.04	0.046	0.049	0.023
AIE_GET finance/funds	300	0.038	0.041	0.056	0.067	0.041
AIE_GET invoice/invoice-lines	300	0.043	0.047	0.074	0.098	0.05
AIE_GET invoice/invoices	300	0.06	0.076	0.104	0.138	0.068
AIE_GET invoice/invoices/[invoice_id]	300	0.028	0.033	0.058	0.08	0.033
AIE_GET invoice/invoices/[invoice_id]/documents	300	0.018	0.019	0.045	0.048	0.02
AIE_GET material-types	300	0.014	0.015	0.021	0.037	0.015
AIE_GET organizations-storage/categories	300	0.011	0.023	0.04	0.049	0.018
AIE_GET organizations/organizations	300	0.328	0.351	0.423	0.479	0.321
AIE_GET organizations/organizations/[invoice_organization_id]	600	0.017	0.018	0.026	0.046	0.018
AIE_GET users	300	0.011	0.012	0.02	0.044	0.012
AIE_GET voucher/voucher-lines	300	0.02	0.045	0.072	0.081	0.031
AIE_GET voucher/vouchers	300	0.02	0.045	0.072	0.078	0.031
AIE_GET batch-groups/{id}	150	0.018	0.025	0.049	0.069	0.024
AIE_GET batch-voucher/export-configurations	150	0.018	0.042	0.054	0.075	0.026
AIE_GET configurations/entries	300	0.014	0.016	0.029	0.04	0.016
AIE_GET finance/funds	150	0.038	0.04	0.054	0.077	0.042
AIE_GET invoice/invoice-lines	150	0.044	0.052	0.078	0.127	0.052
AIE_GET invoice/invoices	150	0.044	0.053	0.075	0.106	0.05
AIE_GET invoice/invoices-Choose	150	0.063	0.084	0.129	0.144	0.075
AIE_GET invoice/invoices-Choose by id	150	0.03	0.053	0.069	0.087	0.039
AIE_GET invoice/invoices/{id}/documents	150	0.018	0.043	0.051	0.073	0.027
AIE_GET material-types	150	0.014	0.015	0.028	0.042	0.015
AIE_GET organizations/organizations/{id}	300	0.017	0.018	0.025	0.054	0.022
AIE_GET users	150	0.011	0.012	0.024	0.051	0.013
AIE_PUT invoice/invoices/[invoice_id]	150	0.808	1.081	1.403	2.341	0.933
AIE_PUT invoice/invoices/id	150	1.202	1.318	1.467	1.505	1.171
AIE_TC: Invoices Approve fs09000000	150	1.631	1.775	1.936	2.042	1.61
Debug Sampler	1507	0	0	0.001	0.001	0
FOLIO: Login	1	0.209	0.209	0.209	0.209	0.209
GET bl-users/_self	1	0.171	0.171	0.171	0.171	0.171
IO_GET acquisitions-units/memberships	152	0.017	0.024	0.046	0.053	0.024
IO_GET acquisitions-units/units	454	0.018	0.019	0.043	0.047	0.022
IO_GET batch-groups	454	0.019	0.043	0.052	0.073	0.027
IO_GET batch-groups/{id}	150	0.018	0.043	0.07	0.08	0.029
IO_GET batch-voucher/export-configurations	150	0.018	0.044	0.057	0.076	0.029
IO_GET configurations/entries	1058	0.015	0.017	0.025	0.041	0.016
IO_GET finance/expense-classes	302	0.024	0.025	0.052	0.056	0.027
IO_GET finance/funds	452	0.038	0.041	0.065	0.079	0.045
IO_GET invoice/invoice-lines	150	0.043	0.062	0.088	0.123	0.052
IO_GET invoice/invoices	152	0.07	0.08	0.109	0.117	0.069
IO_GET invoice/invoices/{id}	150	0.035	0.056	0.086	0.108	0.046
IO_GET invoice/invoices/{id}/documents	150	0.019	0.043	0.071	0.076	0.029
IO_GET material-types	150	0.014	0.015	0.04	0.047	0.017
IO_GET orders/order-lines	1508	0.046	0.048	0.065	0.082	0.052
IO_GET organizations/organizations	152	0.049	0.053	0.073	0.086	0.052
IO_GET organizations/organizations/{id}	452	0.017	0.019	0.032	0.054	0.019
IO_GET tags	454	0.011	0.012	0.031	0.04	0.013
IO_GET users	150	0.011	0.012	0.03	0.049	0.013
IO_POST invoice/invoice_lines	1507	0.512	0.565	0.779	1.155	0.558
IO_POST invoice/invoices	152	0.066	0.09	0.123	0.134	0.069
IO_TC: Create Invoice Lines fs09000000	1507	0.512	0.565	0.779	1.155	0.558
IO_TC: Create Invoices Workflow fs09000000	150	9.866	10.215	11.954	13.575	10.122
IOP_TC: Paying Invoices fs09000000	150	2.415	2.727	3.148	4.056	2.542
JSR223 Sampler 1	152	0	0	0.001	0.002	0
JSR223 Sampler 3	152	0	0	0.001	0.002	0.001
JSR223 Sampler 4	1508	0	0	0.001	0.001	0
POO-GET orders/configuration/prefixes	152	0.016	0.017	0.026	0.045	0.018
POO_GET /acquisitions-units/memberships	152	0.017	0.02	0.046	0.049	0.022
POO_GET /acquisitions-units/units	608	0.017	0.018	0.025	0.046	0.018
POO_GET /configurations/entries	1824	0.016	0.018	0.024	0.038	0.017
POO_GET /finance/expense-classes	152	0.024	0.025	0.048	0.053	0.026
POO_GET /finance/funds	304	0.039	0.041	0.064	0.082	0.043
POO_GET /material-types	152	0.013	0.014	0.022	0.04	0.015
POO_GET /orders/acquisition-methods	152	0.018	0.041	0.047	0.055	0.026
POO_GET /orders/composite-orders/[order_id]	152	0.025	0.029	0.053	0.055	0.037
POO_GET /orders/configuration/prefixes	608	0.017	0.022	0.047	0.058	0.021
POO_GET /orders/configuration/reasons-for-closure	456	0.017	0.018	0.044	0.047	0.02
POO_GET /orders/configuration/suffixes	608	0.016	0.018	0.043	0.049	0.021
POO_GET /orders/order-lines	304	0.074	0.11	0.131	0.168	0.076
POO_GET /orders/order-templates	152	0.018	0.02	0.046	0.068	0.023
POO_GET /orders/po-number	152	0.015	0.039	0.045	0.07	0.023
POO_GET /organizations(vendor)	152	0.203	0.223	0.268	0.292	0.212
POO_GET /organizations/organizations/[vendor_id]	152	0.017	0.018	0.024	0.044	0.018
POO_GET /tags	608	0.011	0.012	0.021	0.039	0.012
POO_GET /users	304	0.011	0.012	0.027	0.047	0.013
POO_GET _/proxy/tenants/[tenant]/modules	1520	0.054	0.058	0.08	0.09	0.057
POO_GET _/version	1520	0.004	0.005	0.03	0.036	0.006
POO_GET acquisitions-units/memberships	152	0.018	0.046	0.072	0.076	0.032
POO_GET acquisitions-units/units	6384	0.017	0.018	0.026	0.048	0.021
POO_GET configurations/entries	29336	0.014	0.017	0.023	0.039	0.016
POO_GET contributor-name-types	4560	0.01	0.011	0.019	0.038	0.012
POO_GET contributor-types	1520	0.021	0.022	0.046	0.053	0.023
POO_GET data-export-spring/configs	1520	0.03	0.032	0.058	0.078	0.033
POO_GET erm/entitlements	1520	0.017	0.02	0.044	0.06	0.021
POO_GET finance/expense-classes	1520	0.024	0.025	0.051	0.055	0.026
POO_GET finance/funds	7904	0.039	0.041	0.054	0.072	0.041
POO_GET holdings-storage/holdings	1520	0.011	0.012	0.037	0.046	0.014
POO_GET identifier-types	3040	0.012	0.013	0.023	0.04	0.013
POO_GET instance-formats	1520	0.013	0.014	0.038	0.044	0.015
POO_GET instance-relationship-types	3040	0.01	0.011	0.022	0.039	0.012
POO_GET instance-types	3040	0.012	0.013	0.023	0.04	0.013
POO_GET inventory/instances	3040	0.07	0.079	0.114	0.147	0.076
POO_GET inventory/instances/[instances_id]	1520	0.082	0.093	0.132	0.174	0.087
POO_GET invoice/invoice-lines	1520	0.032	0.037	0.061	0.088	0.037
POO_GET locations	6080	0.046	0.047	0.059	0.075	0.047
POO_GET material-types	6080	0.013	0.014	0.022	0.04	0.015
POO_GET modes-of-issuance	1520	0.011	0.012	0.036	0.042	0.013
POO_GET nature-of-content-terms	1520	0.011	0.012	0.037	0.043	0.013
POO_GET note-links/domain/orders/type/poLine/id/[poLine_id]	1520	0.012	0.014	0.038	0.044	0.015
POO_GET note-types	1520	0.012	0.013	0.038	0.044	0.015
POO_GET orders-storage/order-invoice-relns	1976	0.01	0.011	0.027	0.04	0.013
POO_GET orders/acquisition-methods	1520	0.017	0.018	0.044	0.053	0.021
POO_GET orders/acquisition-methods/[acquisition_methods_id]	1520	0.018	0.02	0.046	0.073	0.025
POO_GET orders/composite-orders	5320	0.04	0.043	0.067	0.094	0.045
POO_GET orders/composite-orders/[order_id]	6828	0.24	0.257	0.307	0.397	0.244
POO_GET orders/configuration/prefixes	3192	0.016	0.018	0.031	0.051	0.02
POO_GET orders/configuration/reasons-for-closure	5320	0.017	0.018	0.026	0.046	0.02
POO_GET orders/configuration/suffixes	3344	0.016	0.017	0.028	0.047	0.019
POO_GET orders/export-history	1824	1.151	1.194	3.364	3.585	1.357
POO_GET orders/order-lines	6524	0.047	0.049	0.071	0.092	0.051
POO_GET orders/order-templates	1672	0.018	0.019	0.046	0.053	0.022
POO_GET orders/po-number	152	0.039	0.043	0.068	0.079	0.04
POO_GET orders/titles	1520	0.038	0.043	0.072	0.108	0.046
POO_GET organizations/organizations	3192	0.038	0.041	0.067	0.097	0.043
POO_GET organizations/organizations/[vendor_id]	8208	0.017	0.018	0.025	0.046	0.018
POO_GET saml/check	1520	0.019	0.021	0.049	0.074	0.023
POO_GET tags	6384	0.011	0.012	0.021	0.038	0.012
POO_GET users	5624	0.011	0.012	0.023	0.046	0.012
POO_POST /orders/composite-orders	152	0.07	0.096	0.125	0.174	0.075
POO_POST orders/order-lines	1520	0.076	0.098	0.136	0.216	0.095
POO_PUT orders/composite-orders/[order_id]	304	0.732	1.751	3.187	3.617	1.081
POO_TC Create Order fs09000000	152	1.255	1.311	1.453	2	1.289
POO_TC: Approve Order fs09000000	152	2.674	2.744	2.906	3.38	2.704
POO_TC: Open Order fs09000000	152	6.268	7.026	8.02	8.848	6.59

Test №5

Test environment Quesnelia(qcp1), PO with PO Lines(500)+Invoice with PO lines(500 from Order)

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
Requests	Total	Response Time (seconds)
IO_POST invoice/invoice_lines Create Invoice Line (POL)	1000	1.011	1.158	1.373	1.665	1.11
IO_POST invoice/invoices Create Invoice	2	0.08	0.13	0.13	0.13	0.08
POO_POST /orders/composite-orders Create Order	2	0.163	0.221	0.221	0.221	0.163
POO_POST orders/order-lines Create Order Line	1000	0.067	0.09	0.145	0.31	0.089
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice	2	23.915	24.507	24.507	24.507	23.915
AIE_PUT invoice/invoices/id Approve Invoice	2	4.444	4.741	4.741	4.741	4.444
POO_PUT orders/composite-orders/[order_id] Open Order	2	56.41	54.49	54.49	54.49	56.41
POO_PUT orders/composite-orders/[order_id] Approve Order	2	$0.352$	0.3	0.3	0.3	0.326

Full result table

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
AIE_GET batch-groups/[batchGroupId]	4	0.032	0.046	0.046	0.046	0.031
AIE_GET batch-voucher/batch-voucher-exports	4	0.065	0.08	0.083	0.083	0.064
AIE_GET batch-voucher/export-configurations	4	0.029	0.041	0.073	0.073	0.037
AIE_GET configurations/entries	8	0.014	0.015	0.015	0.015	0.014
AIE_GET finance/fiscal-years/[fiscalYearId]	4	0.044	0.045	0.046	0.046	0.037
AIE_GET finance/funds	4	0.04	0.04	0.067	0.067	0.045
AIE_GET invoice/invoice-lines	4	0.116	0.117	0.126	0.126	0.113
AIE_GET invoice/invoices	4	0.131	0.148	0.204	0.204	0.129
AIE_GET invoice/invoices/[invoice_id]	4	0.099	0.106	0.237	0.237	0.129
AIE_GET invoice/invoices/[invoice_id]/documents	4	0.045	0.074	0.076	0.076	0.046
AIE_GET material-types	4	0.014	0.014	0.044	0.044	0.021
AIE_GET organizations-storage/categories	4	0.042	0.042	0.045	0.045	0.034
AIE_GET organizations/organizations	4	0.392	0.402	0.462	0.462	0.404
AIE_GET organizations/organizations/[invoice_organization_id]	8	0.016	0.017	0.043	0.043	0.019
AIE_GET users	4	0.011	0.011	0.052	0.052	0.021
AIE_GET voucher/voucher-lines	4	0.074	0.086	0.094	0.094	0.068
AIE_GET voucher/vouchers	4	0.059	0.073	0.074	0.074	0.052
AIE_GET batch-groups/{id}	2	0.031	0.045	0.045	0.045	0.031
AIE_GET batch-voucher/export-configurations	2	0.032	0.047	0.047	0.047	0.032
AIE_GET configurations/entries	4	0.014	0.015	0.042	0.042	0.021
AIE_GET finance/funds	2	0.051	0.066	0.066	0.066	0.051
AIE_GET invoice/invoice-lines	2	0.12	0.15	0.15	0.15	0.12
AIE_GET invoice/invoices	2	0.07	0.1	0.1	0.1	0.07
AIE_GET invoice/invoices-Choose	2	0.176	0.233	0.233	0.233	0.176
AIE_GET invoice/invoices-Choose by id	2	0.127	0.165	0.165	0.165	0.127
AIE_GET invoice/invoices/{id}/documents	2	0.018	0.019	0.019	0.019	0.018
AIE_GET material-types	2	0.031	0.047	0.047	0.047	0.031
AIE_GET organizations/organizations/{id}	4	0.037	0.045	0.046	0.046	0.036
AIE_GET users	2	0.029	0.05	0.05	0.05	0.029
AIE_PUT invoice/invoices/[invoice_id]	2	23.915	24.507	24.507	24.507	23.915
AIE_PUT invoice/invoices/id	2	4.444	4.741	4.741	4.741	4.444
AIE_TC: Invoices Approve fs09000000	2	5.242	5.778	5.778	5.778	5.242
Debug Sampler	1000	0	0.001	0.001	0.001	0
FOLIO: Login	1	0.319	0.319	0.319	0.319	0.319
GET bl-users/_self	1	0.645	0.645	0.645	0.645	0.645
IO_GET acquisitions-units/memberships	2	0.031	0.044	0.044	0.044	0.031
IO_GET acquisitions-units/units	6	0.049	0.078	0.179	0.179	0.065
IO_GET batch-groups	6	0.073	0.075	0.077	0.077	0.06
IO_GET batch-groups/{id}	2	0.057	0.069	0.069	0.069	0.057
IO_GET batch-voucher/export-configurations	2	0.06	0.072	0.072	0.072	0.06
IO_GET configurations/entries	14	0.015	0.019	0.04	0.045	0.019
IO_GET finance/expense-classes	4	0.038	0.054	0.084	0.084	0.046
IO_GET finance/funds	6	0.043	0.064	0.067	0.067	0.049
IO_GET invoice/invoice-lines	2	0.148	0.176	0.176	0.176	0.148
IO_GET invoice/invoices	2	0.134	0.134	0.134	0.134	0.134
IO_GET invoice/invoices/{id}	2	0.123	0.166	0.166	0.166	0.123
IO_GET invoice/invoices/{id}/documents	2	0.046	0.076	0.076	0.076	0.046
IO_GET material-types	2	0.04	0.058	0.058	0.058	0.04
IO_GET orders/order-lines	1000	0.046	0.048	0.111	0.322	0.059
IO_GET organizations/organizations	2	0.059	0.065	0.065	0.065	0.059
IO_GET organizations/organizations/{id}	6	0.045	0.076	0.088	0.088	0.048
IO_GET tags	6	0.011	0.039	0.04	0.04	0.02
IO_GET users	2	0.028	0.045	0.045	0.045	0.028
IO_POST invoice/invoice_lines	1000	1.011	1.158	1.373	1.665	1.11
IO_POST invoice/invoices	2	0.08	0.13	0.13	0.13	0.08
IO_TC: Create Invoice Lines fs09000000	1000	1.011	1.158	1.373	1.665	1.11
IO_TC: Create Invoices Workflow fs09000000	2	1027.835	1029.253	1029.253	1029.253	1027.835
IOP_TC: Paying Invoices fs09000000	2	26.513	27.55	27.55	27.55	26.513
JSR223 Sampler 1	2	0.013	0.026	0.026	0.026	0.013
JSR223 Sampler 3	2	0.009	0.019	0.019	0.019	0.009
JSR223 Sampler 4	1000	0	0	0.001	0.001	0
POO-GET orders/configuration/prefixes	2	0.016	0.017	0.017	0.017	0.016
POO_GET /acquisitions-units/memberships	2	0.06	0.078	0.078	0.078	0.06
POO_GET /acquisitions-units/units	8	0.032	0.045	0.082	0.082	0.039
POO_GET /configurations/entries	24	0.015	0.017	0.058	0.062	0.021
POO_GET /finance/expense-classes	2	0.07	0.118	0.118	0.118	0.07
POO_GET /finance/funds	4	0.083	0.129	0.157	0.157	0.089
POO_GET /material-types	2	0.029	0.045	0.045	0.045	0.029
POO_GET /orders/acquisition-methods	2	0.044	0.073	0.073	0.073	0.044
POO_GET /orders/composite-orders/[order_id]	2	0.068	0.11	0.11	0.11	0.068
POO_GET /orders/configuration/prefixes	8	0.034	0.046	0.175	0.175	0.051
POO_GET /orders/configuration/reasons-for-closure	6	0.033	0.049	0.079	0.079	0.037
POO_GET /orders/configuration/suffixes	8	0.019	0.045	0.09	0.09	0.034
POO_GET /orders/order-lines	4	0.125	0.129	0.248	0.248	0.133
POO_GET /orders/order-templates	2	0.047	0.078	0.078	0.078	0.047
POO_GET /orders/po-number	2	0.088	0.101	0.101	0.101	0.088
POO_GET /organizations(vendor)	2	0.267	0.334	0.334	0.334	0.267
POO_GET /organizations/organizations/[vendor_id]	2	0.045	0.076	0.076	0.076	0.045
POO_GET /tags	8	0.011	0.012	0.046	0.046	0.019
POO_GET /users	4	0.03	0.049	0.05	0.05	0.03
POO_GET _/proxy/tenants/[tenant]/modules	1000	0.053	0.056	0.066	0.087	0.055
POO_GET _/version	1000	0.004	0.005	0.01	0.034	0.006
POO_GET acquisitions-units/memberships	2	0.131	0.187	0.187	0.187	0.131
POO_GET acquisitions-units/units	4004	0.017	0.017	0.025	0.067	0.019
POO_GET configurations/entries	18026	0.013	0.015	0.019	0.043	0.014
POO_GET contributor-name-types	3000	0.01	0.011	0.013	0.038	0.011
POO_GET contributor-types	1000	0.02	0.021	0.04	0.051	0.022
POO_GET data-export-spring/configs	1000	0.028	0.03	0.057	0.086	0.032
POO_GET erm/entitlements	1000	0.016	0.017	0.042	0.065	0.018
POO_GET finance/expense-classes	1000	0.023	0.025	0.051	0.058	0.026
POO_GET finance/funds	5004	0.038	0.039	0.051	0.071	0.039
POO_GET holdings-storage/holdings	1000	0.011	0.012	0.036	0.047	0.013
POO_GET identifier-types	2000	0.011	0.012	0.017	0.041	0.012
POO_GET instance-formats	1000	0.012	0.013	0.036	0.043	0.014
POO_GET instance-relationship-types	2000	0.01	0.01	0.015	0.038	0.011
POO_GET instance-types	2000	0.011	0.012	0.016	0.04	0.012
POO_GET inventory/instances	2000	0.068	0.071	0.099	0.179	0.073
POO_GET inventory/instances/[instances_id]	1000	0.069	0.072	0.102	0.179	0.073
POO_GET invoice/invoice-lines	1000	0.03	0.032	0.062	0.093	0.036
POO_GET locations	4000	0.045	0.046	0.049	0.072	0.046
POO_GET material-types	4000	0.013	0.014	0.016	0.04	0.014
POO_GET modes-of-issuance	1000	0.01	0.011	0.033	0.041	0.012
POO_GET nature-of-content-terms	1000	0.011	0.011	0.031	0.044	0.012
POO_GET note-links/domain/orders/type/poLine/id/[poLine_id]	1000	0.011	0.012	0.035	0.044	0.013
POO_GET note-types	1000	0.011	0.012	0.037	0.044	0.013
POO_GET orders-storage/order-invoice-relns	1006	0.01	0.011	0.025	0.041	0.012
POO_GET orders/acquisition-methods	1000	0.017	0.018	0.046	0.121	0.022
POO_GET orders/acquisition-methods/[acquisition_methods_id]	1000	0.017	0.019	0.048	0.121	0.085
POO_GET orders/composite-orders	3010	0.038	0.04	0.069	0.116	0.044
POO_GET orders/composite-orders/[order_id]	4010	0.529	0.68	0.795	1.04	0.553
POO_GET orders/configuration/prefixes	2002	0.016	0.017	0.042	0.101	0.021
POO_GET orders/configuration/reasons-for-closure	3010	0.017	0.018	0.032	0.087	0.02
POO_GET orders/configuration/suffixes	2004	0.016	0.017	0.041	0.086	0.019
POO_GET orders/export-history	1004	1.082	1.088	1.122	1.9	1.105
POO_GET orders/order-lines	4006	0.084	0.117	0.138	0.378	0.091
POO_GET orders/order-templates	1002	0.018	0.019	0.047	0.091	0.022
POO_GET orders/po-number	2	0.075	0.076	0.076	0.076	0.075
POO_GET orders/titles	1000	0.036	0.039	0.077	0.158	0.044
POO_GET organizations/organizations	2002	0.036	0.038	0.066	0.092	0.04
POO_GET organizations/organizations/[vendor_id]	5008	0.016	0.017	0.021	0.046	0.017
POO_GET saml/check	1000	0.018	0.019	0.046	0.072	0.021
POO_GET search/instances	1000	0.132	0.219	0.474	0.898	0.189
POO_GET tags	4004	0.01	0.011	0.013	0.038	0.011
POO_GET users	3014	0.01	0.011	0.014	0.047	0.011
POO_POST /orders/composite-orders	2	0.163	0.221	0.221	0.221	0.163
POO_POST orders/order-lines	1000	0.067	0.09	0.145	0.31	0.089
POO_PUT orders/composite-orders/[order_id]	4	27.419	54.485	58.334	58.334	28.368
POO_TC Create Order fs09000000	2	2.32	3.379	3.379	3.379	2.32
POO_TC: Add Order Lines fs09000000	2	2573.821	2591.878	2591.878	2591.878	2573.821
POO_TC: Approve Order fs09000000	2	4.787	4.845	4.845	4.845	4.787
POO_TC: Open Order fs09000000	2	62.278	64.248	64.248	64.248	62.278

Test №6

Test environment Quesnelia(qcp1), Invoice with blank invoice line(500)

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
Requests	Total	Response Time (seconds)
IO_POST invoice/invoice_lines Create Invoice Line (Blank Line)	37714	0.167	0.184	0.204	0.232	0.169
IO_POST invoice/invoices Create Invoice	77	0.087	0.099	0.121	0.131	0.084
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice	75	2.241	2.468	3.046	3.237	2.335
AIE_PUT invoice/invoices/id Approve Invoice	75	2.674	2.827	3.534	3.62	2.74

Full result table

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average	Latency
AIE_GET batch-groups/[batchGroupId]	150	0.016	0.017	0.047	0.067	0.021	0.047
AIE_GET batch-voucher/batch-voucher-exports	150	0.042	0.05	0.082	0.448	0.046	0.082
AIE_GET batch-voucher/export-configurations	150	0.017	0.018	0.046	0.068	0.02	0.046
AIE_GET configurations/entries	300	0.014	0.014	0.017	0.037	0.014	0.016
AIE_GET finance/fiscal-years/[fiscalYearId]	150	0.016	0.042	0.046	0.07	0.026	0.046
AIE_GET finance/funds	150	0.037	0.039	0.064	0.087	0.04	0.063
AIE_GET invoice/invoice-lines	150	0.094	0.118	0.151	0.899	0.12	0.15
AIE_GET invoice/invoices	150	0.145	0.181	0.33	0.994	0.166	0.33
AIE_GET invoice/invoices/[invoice_id]	150	0.088	0.099	0.319	0.673	0.116	0.319
AIE_GET invoice/invoices/[invoice_id]/documents	150	0.017	0.018	0.046	0.081	0.022	0.046
AIE_GET material-types	150	0.013	0.014	0.042	0.045	0.015	0.042
AIE_GET organizations-storage/categories	150	0.011	0.036	0.039	0.042	0.019	0.039
AIE_GET organizations/organizations	150	0.348	0.394	0.492	0.532	0.352	0.485
AIE_GET organizations/organizations/[invoice_organization_id]	300	0.016	0.017	0.023	0.08	0.019	0.023
AIE_GET users	150	0.01	0.011	0.014	0.047	0.012	0.014
AIE_GET voucher/voucher-lines	150	0.052	0.058	0.083	0.092	0.048	0.082
AIE_GET voucher/vouchers	150	0.041	0.047	0.074	0.097	0.041	0.074
AIE_GET batch-groups/{id}	75	0.018	0.044	0.05	0.069	0.028	0.05
AIE_GET batch-voucher/export-configurations	75	0.018	0.043	0.051	0.068	0.029	0.051
AIE_GET configurations/entries	150	0.014	0.014	0.016	0.042	0.014	0.016
AIE_GET finance/funds	75	0.038	0.039	0.066	0.069	0.041	0.066
AIE_GET invoice/invoice-lines	75	0.118	0.123	0.151	0.181	0.113	0.15
AIE_GET invoice/invoices	75	0.068	0.073	0.121	0.131	0.066	0.121
AIE_GET invoice/invoices-Choose	75	0.173	0.183	0.228	0.233	0.17	0.228
AIE_GET invoice/invoices-Choose by id	75	0.089	0.115	0.168	0.185	0.106	0.168
AIE_GET invoice/invoices/{id}/documents	75	0.018	0.044	0.067	0.083	0.029	0.067
AIE_GET material-types	75	0.014	0.026	0.044	0.045	0.021	0.044
AIE_GET organizations/organizations/{id}	150	0.017	0.019	0.049	0.076	0.023	0.049
AIE_GET users	75	0.011	0.014	0.05	0.068	0.021	0.05
AIE_PUT invoice/invoices/[invoice_id]	75	2.241	2.468	3.046	3.237	2.335	0
AIE_PUT invoice/invoices/id	75	2.674	2.827	3.534	3.62	2.74	0
AIE_TC: Invoices Approve fs09000000	75	3.361	3.56	4.218	4.339	3.438	0.829
FOLIO: Login	1	0.309	0.309	0.309	0.309	0.309	0.308
GET bl-users/_self	1	0.233	0.233	0.233	0.233	0.233	0.232
IO_GET acquisitions-units/memberships	77	0.045	0.069	0.074	0.078	0.048	0.074
IO_GET acquisitions-units/units	229	0.024	0.05	0.087	0.124	0.037	0.087
IO_GET batch-groups	229	0.021	0.045	0.072	0.094	0.033	0.072
IO_GET batch-groups/{id}	75	0.045	0.047	0.078	0.086	0.042	0.078
IO_GET batch-voucher/export-configurations	75	0.046	0.057	0.083	0.097	0.047	0.083
IO_GET configurations/entries	533	0.014	0.018	0.055	0.065	0.02	0.055
IO_GET finance/expense-classes	152	0.05	0.054	0.085	0.096	0.044	0.085
IO_GET finance/funds	227	0.038	0.04	0.07	0.102	0.045	0.069
IO_GET invoice/invoice-lines	75	0.143	0.158	0.197	0.229	0.141	0.196
IO_GET invoice/invoices	77	0.041	0.043	0.067	0.129	0.046	0.067
IO_GET invoice/invoices/{id}	75	0.117	0.141	0.174	0.186	0.121	0.174
IO_GET invoice/invoices/{id}/documents	75	0.045	0.067	0.093	0.097	0.046	0.093
IO_GET material-types	75	0.029	0.047	0.057	0.059	0.034	0.057
IO_GET organizations/organizations	77	0.046	0.069	0.095	0.103	0.057	0.095
IO_GET organizations/organizations/{id}	227	0.021	0.047	0.088	0.093	0.033	0.088
IO_GET tags	229	0.011	0.014	0.043	0.062	0.018	0.043
IO_GET users	75	0.014	0.047	0.051	0.058	0.026	0.051
IO_POST invoice/invoice_lines	37714	0.167	0.184	0.204	0.232	0.169	0.204
IO_POST invoice/invoices	77	0.087	0.099	0.121	0.131	0.084	0.121
IO_TC: Create Invoice Lines fs09000000	37714	0.167	0.184	0.204	0.232	0.169	0.204
IO_TC: Create Invoices Blanck Line Workflow fs09000000	75	85.823	86.493	87.689	88.446	85.96	87.664
IOP_TC: Paying Invoices fs09000000	75	4.496	4.859	5.255	5.722	4.594	2.973

Comparison

Test №1 (Poppy) vs Test №4 (Quesnelia)

The following table compares the results between tests №1 (Poppy) and №4 (Quesnelia). We can observe that all requests showed an improvement in performance, with selected response times(highlighted in green) improving by more than half a second. Additionally, during the same test duration (1.5 hours), Test №4 (Quesnelia) processed 39 more orders with 390 order lines and 39 invoices with 379 invoice lines (POL) compared to Test №1 (Poppy).

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
Requests	Total	Response Time (seconds)
IO_POST invoice/invoice_lines Create Invoice Line (POL)	+379	-0.371	-0.399	-0.869	-0.829	-0.418
IO_POST invoice/invoices Create Invoice	+39	-0.037	-0.031	-0.039	-0.045	-0.031
POO_POST /orders/composite-orders Create Order	+39	-0.089	-0.105	-0.161	-0.595	-0.104
POO_POST orders/order-lines Create Order Line	+390	0.004	-0.006	-0.047	-0.057	0
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice	+39	-1.669	-1.652	-1.487	-0.821	-1.442
AIE_PUT invoice/invoices/id Approve Invoice	+39	-0.109	-0.155	-0.597	-1.341	-0.22
POO_PUT orders/composite-orders/[order_id] Open Order	+39	-1.335	-1.904	-0.913	-0.328	-0.98
PUT orders/composite-orders/[order_id] Approve Order	+39	-0.084	-0.137	-0.697	-1.01	-0.158

Test №2 (Poppy) vs Test №5 (Quesnelia)

The following table compares the results between tests №2 (Poppy) and №5 (Quesnelia). We can observe that all requests showed an improvement in performance, with selected response times (highlighted in green) improving by more than half a second. Additionally, we can see requests with improvements ranging from 20 to 57 seconds. Furthermore, during the same test scenario, test №2 (Poppy) lasted 3h 10m, while Test №5 (Quesnelia) lasted 1h 8m.

Requests	Response Time (seconds)
Requests	50th pct	75th pct	95th pct	99th pct	Average
IO_POST invoice/invoice_lines Create Invoice Line (POL)	-3.699	-4.352	-5.86	-7.117	-3.878
IO_POST invoice/invoices Create Invoice	-0.201	-0.22	-0.22	-0.22	-0.201
POO_POST /orders/composite-orders Create Order	-0.208	-0.201	-0.201	-0.201	-0.208
POO_POST orders/order-lines Create Order Line	-0.102	-0.219	-0.668	-1.34	-0.181
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice	-47.435	-54.256	-54.256	-54.256	-47.435
AIE_PUT invoice/invoices/id Approve Invoice	-21.277	-26.265	-26.265	-26.265	-21.277
POO_PUT orders/composite-orders/[order_id] Open Order	-51.595	-57.258	-57.258	-57.258	-51.595
PUT orders/composite-orders/[order_id] Approve Order	-0.425	-0.803	-0.803	-0.803	-0.451

Test №3 (Poppy) vs Test №6 (Quesnelia)

The following table compares the results between tests №3 (Poppy) and №6 (Quesnelia). We can observe that all requests showed an improvement in performance, with selected response times (highlighted in green) improving by more than 10 second. Additionally, during the same test duration (1 hours), Test №6 (Quesnelia) processed 26 more invoices and 12580 blank invoice lines compared to Test №3 (Poppy).

Requests	Total	50th pct	75th pct	95th pct	99th pct	Average
Requests	Total	Response Time (seconds)
IO_POST invoice/invoice_lines Create Invoice Line (Blank Line)	+12580	-0.024	-0.020	-0.028	-0.109	-0.029
IO_POST invoice/invoices Create Invoice	+26	-0.029	-0.035	-0.059	-0.058	-0.033
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice	+26	-19.213	-20.599	-21.928	-21.896	-19.066
AIE_PUT invoice/invoices/id Approve Invoice	+26	-12.735	-13.270	-14.605	-17.406	-12.791

Resource utilization for Test #1

Resource utilization table

CPU		RAM
mod-organizations-storage-b	11%	mod-inventory-b	75%
mod-inventory-b	11%	mod-orders-b	72%
mod-finance-b	9%	mod-invoice-b	58%
mod-orders-storage-b	6%	mod-orders-storage-b	44%
mod-organizations-b	4%	mod-organizations-storage-b	42%
mod-inventory-storage-b	1%	mod-organizations-b	40%
mod-finance-storage-b	1%	mod-finance-b	38%
mod-orders-b	1%	mod-finance-storage-b	33%
mod-invoice-b	1%	mod-invoice-storage-b	26%
mod-invoice-storage-b	1%	mod-inventory-storage-b	17%

Service CPU Utilization

Here we can see that mod-organizations-storage-b, mod-inventory-b and mod-finance-b modules used more 10% CPU

Service Memory Utilization

Here we can see that all modules show a stable trend.

DB CPU Utilization

DB CPU in the average was 50% and spikes up to 85%.

DB Connections

DB connections was 253.

DB load

Top SQL-queries

Resource utilization for Test #2

Resource utilization table

CPU		RAM
mod-orders-storage-b	34%	mod-orders-b	73%
mod-finance-b	33%	mod-inventory-b	72%
mod-inventory-b	17%	mod-invoice-b	54%
mod-inventory-storage-b	14%	mod-orders-storage-b	44%
mod-orders-b	10%	mod-finance-b	38%
mod-finance-storage-b	7%	mod-organizations-storage-b	36%
mod-organizations-storag	3%	mod-finance-storage-b	35%
mod-organizations-b	2%	mod-organizations-b	34%
mod-invoice-b	1%	mod-invoice-storage-b	25%
mod-invoice-storage-b	1%	mod-inventory-storage-b	16%

Service CPU Utilization

Here we can see that mod-orders-storage-b and mod-finance-b modules have spikes CPU up to 35%

Service Memory Utilization

Here we can see that all modules show a stable trend.

DB CPU Utilization

DB CPU was 85%.

DB Connections

DB connections was 244.

DB load

Top SQL-queries

Resource utilization for Test #3

Resource utilization table

CPU		RAM
mod-finance-b	40%	mod-inventory-b	76%
mod-invoice-b	16%	mod-invoice-b	56%
mod-inventory-b	11%	mod-orders-b	52%
mod-finance-storage-b	11%	mod-finance-storage-b	44%
mod-organizations-storag	6%	mod-orders-storage-b	41%
mod-invoice-storage-b	6%	mod-finance-b	41%
mod-orders-storage-b	5%	mod-organizations-storage-b	40%
mod-organizations-b	5%	mod-organizations-b	39%
mod-orders-b	1%	mod-invoice-storage-b	25%
mod-inventory-storage-b	1%	mod-inventory-storage-b	14%

Service CPU Utilization

Here we can see that mod-feesfines-b, okapi-b and mod-authtoken-b modules used 60% CPU

Service Memory Utilization

Here we can see that all modules show a stable trend.

DB CPU Utilization

DB CPU was 98% in spike.

DB Connections

DB connections was 245.

DB load

Top SQL-queries

Resource utilization for Test #4

Resource utilization table

CPU		RAM
mod-inventory-b	118%	mod-orders-storage-b	94%
mod-finance-b	26%	mod-orders-b	65%
mod-orders-storage-b	20%	mod-invoice-b	56%
mod-organizations-storage-b	15%	mod-inventory-b	42%
mod-inventory-storage-b	14%	mod-finance-b	37%
mod-organizations-b	12%	mod-organizations-b	37%
mod-orders-b	9%	mod-organizations-storage-b	36%
mod-finance-storage-b	5%	mod-finance-storage-b	34%
mod-invoice-b	2%	mod-invoice-storage-b	28%
mod-invoice-storage-b	1%	mod-inventory-storage-b	16%

Service CPU Utilization

Here we can see that mod-inventory-b had spike to 118% CPU on the start test and than we can see that all modules show a stable trend.

Service Memory Utilization

Here we can see that all modules show a stable trend.

DB CPU Utilization

DB CPU was 75% in average.

DB Connections

DB connections was 695.

DB load

Top SQL-queries


SELECT * FROM get_job_log_entries('ad16db9a-f14f-4d23-a74e-8229d9fb74a5', 'source_record_order', 'ASC', 100, 0, false, 'ALL')
EXPLAIN ANALYZE SELECT * FROM get_job_log_entries('ad16db9a-f14f-4d23-a74e-8229d9fb74a5', 'source_record_order', 'ASC', 100, 0, false, 'ALL')
SELECT jsonb,id FROM fs09000000_mod_orders_storage.export_history WHERE lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%')) ORDER BY left(lower(f_unaccent(export_history.jsonb->>'exportDate')),600) DESC, lower(f_unaccent(export_history.jsonb->>'exportDate')) DESC LIMIT 1000 OFFSET 0
SELECT fs09000000_mod_finance_storage.count_estimate('SELECT jsonb,id FROM fs09000000_mod_finance_storage.fund WHERE ((get_tsvector(f_unaccent(fund.jsonb->>''acqUnitIds'')) @@ tsquery_phrase(f_unaccent(''0ebb1f7d-983f-3026-8a4c-5318e0ebc041''))) OR ((true) AND ( (lower(f_unaccent(fund.jsonb->>''acqUnitIds'')) NOT LIKE lower(f_unaccent(''[]''))) IS NOT TRUE))) AND (true)')
SELECT * FROM fs09000000_mod_orders_storage.internal_lock WHERE lock_name = $1 FOR UPDATE
insert into "marc_records_lb" ("id", "content") values (cast($1 as uuid), cast($2 as jsonb)) on conflict ("id") do update set "content" = cast($3 as jsonb)

Resource utilization for Test #5

Resource utilization table

CPU		RAM
mod-orders-storage-b	74%	mod-orders-storage-b	94%
mod-orders-b	43%	mod-orders-b	59%
mod-finance-b	18%	mod-invoice-b	56%
mod-inventory-b	14%	mod-inventory-b	42%
mod-inventory-storage-b	5%	mod-finance-b	36%
mod-finance-storage-b	4%	mod-organizations-b	36%
mod-organizations-storage-b	3%	mod-organizations-storage-b	36%
mod-organizations-b	3%	mod-finance-storage-b	33%
mod-invoice-b	2%	mod-invoice-storage-b	27%
mod-invoice-storage-b	1%	mod-inventory-storage-b	17%

Service CPU Utilization

Here we can see that mod-feesfines-b, okapi-b module and mod-authtoken-b used 55-57% CPU.

Service Memory Utilization

Here we can see that all modules show a stable trend.

DB CPU Utilization

DB CPU was 25% in average and spike to 99%.

DB Connections

DB connections was 627.

DB load

Top SQL-queries

#	TOP 5 SQL statements
1	`SELECT * FROM fs09000000_mod_orders_storage.internal_lock WHERE lock_name = $1 FOR UPDATE`
2	SELECT fs09000000_mod_orders_storage.count_estimate('SELECT jsonb, id FROM fs09000000_mod_orders_storage.acquisitions_unit WHERE (CASE WHEN length(lower(f_unaccent(''false''))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>''isDeleted'')), 600) LIKE lower(f_unaccent(''false'')) ELSE left(lower(f_unaccent(acquisitions_unit.jsonb->>''isDeleted'')), 600) LIKE left(lower(f_unaccent(''false'')), 600) AND lower(f_unaccent(acquisitions_unit.jsonb->>''isDeleted'')) LIKE lower(f_unaccent(''false'')) END) AND (CASE WHEN length(lower(f_unaccent(''false''))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>''protectRead'')), 600) LIKE lower(f_unaccent(''false'')) ELSE left(lower(f_unaccent(acquisitions_unit.jsonb->>''protectRead'')), 600) LIKE left(lower(f_unaccent(''false'')), 600) AND lower(f_unaccent(acquisitions_unit.jsonb->>''protectRead'')) LIKE lower(f_unaccent(''false'')) END)');
3	SELECT jsonb,id FROM fs09000000_mod_orders_storage.export_history WHERE ((((((((((((((((((((((((lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"81911a48-41dc-446c-a136-c978ed340807"%'))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"18187128-a77f-41ce-ae6f-fd66820c17b3"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"3618e8d2-f0b1-4360-ad39-86fca482cc9b"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"47e54f0c-b57c-45f2-bbbc-5ca1e02c68ae"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"6c2c21e1-3a11-4688-af34-0a26830bd43f"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"3514f35e-0b92-4192-acb9-50f3f1b2e6dd"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"f229cf90-9bf4-44f5-b7a6-b80fff77256e"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"1c3d2b31-af3f-49c0-abc4-08403e353174"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"dc5e878c-e12a-4a3c-98e3-75032a45ea03"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"27c0d5d5-08a7-4938-b317-e0697da6e8e2"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"9b70a476-e5ab-4772-a30e-dac88dea237c"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"a03df40f-4606-4afa-afc2-4015024d5949"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"e2cd9a4f-8321-47fb-bebc-5694f439fb07"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"bee19ebc-441f-4ec5-8510-ada5afdf2461"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"f1b901d9-cd67-4e58-86f2-ccd1bfe60e90"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"f2726c53-8ebd-4a9c-a3f1-c25fdffe7c4e"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"75525937-9213-4e7a-b1db-9389f11a57a0"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"e82d9a29-3938-4863-8ddc-f48b88a2d210"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"53fc7739-c9cb-43cb-b1b1-46550d48003d"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"09217fae-869b-4dd0-b37a-c0eeb98d4b39"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"438f6a1e-8301-4d41-8003-069121c025bf"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"487e9daf-c33a-4ad6-91ef-18b5243443df"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"17fbed43-d644-42d1-a750-d565e906b582"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"e2241463-158b-4214-addc-4e5ab7542da0"%')))) OR (lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%"e14534a4-88ec-423d-8ad9-7142185524de"%'))) ORDER BY left(lower(f_unaccent(export_history.jsonb->>'exportDate')),600) DESC, lower(f_unaccent(export_history.jsonb->>'exportDate')) DESC LIMIT 1000 OFFSET 0
4	`SELECT fs09000000_mod_configuration.count_estimate('SELECT jsonb,id FROM fs09000000_mod_configuration.config_data WHERE (get_tsvector(f_unaccent(config_data.jsonb->>''module'')) @@ tsquery_phrase(f_unaccent(''TAGS''))) AND (get_tsvector(f_unaccent(config_data.jsonb->>''configName'')) @@ tsquery_phrase(f_unaccent(''tags_enabled'')))')`
5	`SELECT fs09000000_mod_finance_storage.count_estimate('SELECT jsonb,id FROM fs09000000_mod_finance_storage.fund WHERE ((get_tsvector(f_unaccent(fund.jsonb->>''acqUnitIds'')) @@ tsquery_phrase(f_unaccent(''0ebb1f7d-983f-3026-8a4c-5318e0ebc041''))) OR ((true) AND ( (lower(f_unaccent(fund.jsonb->>''acqUnitIds'')) NOT LIKE lower(f_unaccent(''[]''))) IS NOT TRUE))) AND (true)')`

Resource utilization for Test #6

Resource utilization table

CPU		RAM
mod-finance-b	40%	mod-orders-storage-b	94%
mod-invoice-b	20%	mod-orders-b	60%
mod-inventory-b	14%	mod-invoice-b	56%
mod-orders-storage-b	11%	mod-inventory-b	46%
mod-invoice-storage-b	10%	mod-finance-b	38%
mod-finance-storage-b	5%	mod-finance-storage-b	36%
mod-organizations-storage-b	3%	mod-organizations-b	36%
mod-organizations-b	2%	mod-organizations-storage-b	36%
mod-orders-b	1%	mod-invoice-storage-b	28%
mod-inventory-storage-b	1%	mod-inventory-storage-b	17%

Service CPU Utilization

Here we can see that mod-feesfines-b, okapi-b module and mod-authtoken-b used 55-57% CPU.

Service Memory Utilization

Here we can see that all modules show a stable trend.

DB CPU Utilization

DB CPU was 18% in average.

DB Connections

DB connections was 591.

DB load

Top SQL-queries


UPDATE fs09000000_mod_invoice_storage.invoice_lines SET jsonb = $1::jsonb WHERE id='66ecc39b-e442-4884-8bba-69e7defc8392'
SELECT jsonb,id FROM fs09000000_mod_orders_storage.acquisitions_unit_membership WHERE CASE WHEN length(lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684'))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')),600) LIKE lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684')) ELSE left(lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')),600) LIKE left(lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684')),600) AND lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')) LIKE lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684')) END LIMIT 2147483647 OFFSET 0
SELECT fs09000000_mod_orders_storage.count_estimate('SELECT jsonb,id FROM fs09000000_mod_orders_storage.acquisitions_unit WHERE (CASE WHEN length(lower(f_unaccent(''false''))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>''isDeleted'')),600) LIKE lower(f_unaccent(''false'')) ELSE left(lower(f_unaccent(acquisitions_unit.jsonb->>''isDeleted'')),600) LIKE left(lower(f_unaccent(''false'')),600) AND lower(f_unaccent(acquisitions_unit.jsonb->>''isDeleted'')) LIKE lower(f_unaccent(''false'')) END) AND (CASE WHEN length(lower(f_unaccent(''false''))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>''protectRead'')),600) LIKE lower(f_unaccent(''false'')) ELSE left(lower(f_unaccent(acquisitions_unit.jsonb->>''protectRead'')),600) LIKE left(lower(f_unaccent(''false'')),600) AND lower(f_unaccent(acquisitions_unit.jsonb->>''protectRead'')) LIKE lower(f_unaccent(''false'')) END)')
SELECT fs09000000_mod_finance_storage.count_estimate('SELECT jsonb,id FROM fs09000000_mod_finance_storage.ledger WHERE ((get_tsvector(f_unaccent(ledger.jsonb->>''acqUnitIds'')) @@ tsquery_phrase(f_unaccent(''0ebb1f7d-983f-3026-8a4c-5318e0ebc041''))) OR ((true) AND ( (lower(f_unaccent(ledger.jsonb->>''acqUnitIds'')) NOT LIKE lower(f_unaccent(''[]''))) IS NOT TRUE))) AND ((id=''52b500b3-4757-4d06-9fde-be125cc5e738'') AND (lower(f_unaccent(ledger.jsonb->>''restrictExpenditures'')) LIKE lower(f_unaccent(''true''))))')
INSERT INTO fs09000000_mod_invoice_storage.invoice_lines (id, jsonb) VALUES ($1, $2) RETURNING jsonb

Appendix

Infrastructure

PTF - environment Poppy (ocp3)

10 db.r6g.xlarge EC2 instances located in US East (N. Virginia)us-east-1
1 database instances, writer
Name Memory GIB vCPUs
db.r6g.xlarge
32 GiB 4 vCPUs
MSK ptf-mobius-testing2
- 2 m5.2xlarge brokers in 2 zones
- Apache Kafka version 2.8.0
- EBS storage volume per broker 300 GiB
- auto.create.topics.enable=true
- log.retention.minutes=480
- default.replication.factor=2

Poppy modules memory and CPU parameters

Moduleocp3-pvt Mon Apr 01 08:06:45 UTC 2024	Task Def. Revision	Module Version	Task Count	Mem Hard Limit	Mem Soft limit	CPU units	Xmx	MetaspaceSize	MaxMetaspaceSize	R/W split enabled


mod-remote-storage	15	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-remote-storage:3.0.1	2	4920	4472	1024	3960	512	512	FALSE
mod-ncip	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-ncip:1.14.4	2	1024	896	128	768	88	128	FALSE
mod-finance-storage	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-finance-storage:8.5.0	2	1024	896	1024	700	88	128	FALSE
mod-agreements	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-agreements:6.0.2	2	1592	1488	128	0	0	0	FALSE
mod-ebsconet	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-ebsconet:2.1.1	2	1248	1024	128	700	128	256	FALSE
edge-sip2	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-sip2:3.1.1	2	1024	896	128	768	88	128	FALSE
mod-organizations	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-organizations:1.8.0	2	1024	896	128	700	88	128	FALSE
mod-settings	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-settings:1.0.2	2	1024	896	200	768	88	128	FALSE
edge-dematic	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-dematic:2.1.1	1	1024	896	128	768	88	128	FALSE
mod-data-import	43	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-data-import:3.0.7	1	2048	1844	256	1292	384	512	FALSE
mod-search	36	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-search:3.0.5	2	2592	2480	2048	1440	512	1024	FALSE
mod-tags	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-tags:2.1.0	2	1024	896	128	768	88	128	FALSE
mod-authtoken	15	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-authtoken:2.14.1	2	1440	1152	512	922	88	128	FALSE
edge-courses	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-courses:1.3.0	2	1024	896	128	768	88	128	FALSE
mod-notify	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-notify:3.1.0	2	1024	896	128	768	88	128	FALSE
mod-inventory-update	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-inventory-update:3.2.1	2	1024	896	128	768	88	128	FALSE
mod-configuration	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-configuration:5.9.2	2	1024	896	128	768	88	128	FALSE
mod-orders-storage	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-orders-storage:13.6.0	2	1024	896	512	700	88	128	FALSE
edge-caiasoft	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-caiasoft:2.1.0	2	1024	896	128	768	88	128	FALSE
mod-login-saml	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-login-saml:2.7.2	2	1024	896	128	768	88	128	FALSE
mod-erm-usage-harvester	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-erm-usage-harvester:4.4.1	2	1024	896	128	768	88	128	FALSE
mod-licenses	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-licenses:5.0.2	2	2480	2312	128	1792	384	512	FALSE
mod-password-validator	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-password-validator:3.1.0	2	1440	1298	128	768	384	512	FALSE
mod-gobi	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-gobi:2.7.1	2	1024	896	128	700	88	128	FALSE
mod-bulk-operations	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-bulk-operations:1.1.9	2	3072	2600	1024	1536	384	512	FALSE
mod-fqm-manager	16	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-fqm-manager:2.1.0-SNAPSHOT.1098	2	1024	896	128	768	88	128	TRUE
mod-graphql	11	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-graphql:1.12.0	2	1024	896	128	768	88	128	FALSE
mod-finance	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-finance:4.8.0	2	1024	896	128	700	88	128	FALSE
mod-erm-usage	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-erm-usage:4.6.0	2	1024	896	128	768	88	128	FALSE
mod-lists	15	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-lists:1.1.0-SNAPSHOT.1263	2	1024	896	128	768	88	128	TRUE
mod-copycat	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-copycat:1.5.0	2	1024	896	128	768	88	128	FALSE
mod-entities-links	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-entities-links:2.0.4	2	2592	2480	400	1440	0	1024	FALSE
mod-permissions	25	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-permissions:6.5.0-SNAPSHOT.369	2	1684	1544	512	1024	384	512	FALSE
pub-edge	8	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/pub-edge:2023.06.14	2	1024	896	128	768	0	0	FALSE
mod-orders	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-orders:12.7.1	2	2048	1440	1024	1024	384	512	FALSE
edge-patron	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-patron:5.0.0	2	1024	896	256	768	88	128	FALSE
edge-ncip	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-ncip:1.9.2	2	1024	896	128	768	88	128	FALSE
mod-users-bl	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-users-bl:7.6.0	2	1440	1152	512	922	88	128	FALSE
mod-invoice	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-invoice:5.7.2	2	1440	1152	512	922	88	128	FALSE
mod-inventory-storage	14	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-inventory-storage:27.0.4	2	4096	3690	2048	3076	384	512	FALSE
mod-user-import	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-user-import:3.8.0	2	1024	896	128	768	88	128	FALSE
mod-sender	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-sender:1.11.0	2	1024	896	128	768	88	128	FALSE
edge-oai-pmh	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-oai-pmh:2.7.2	2	1512	1360	1024	1440	384	512	FALSE
mod-data-export-worker	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-data-export-worker:3.1.2	2	3072	2800	1024	2048	384	512	FALSE
mod-rtac	20	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-rtac:3.5.0	2	1024	896	128	768	88	128	FALSE
mod-circulation-storage	18	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-circulation-storage:17.1.7	2	2880	2592	1536	1814	384	512	FALSE
mod-source-record-storage	20	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-source-record-storage:5.8.0-SNAPSHOT.348	2	5600	5000	2048	3500	384	512	FALSE
mod-calendar	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-calendar:2.5.0	2	1024	896	128	768	88	128	FALSE
mod-event-config	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-event-config:2.6.0	2	1024	896	128	768	88	128	FALSE
mod-courses	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-courses:1.4.8	2	1024	896	128	768	88	128	FALSE
mod-inventory	18	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-inventory:20.1.7	2	2880	2592	1024	1814	384	512	FALSE
mod-email	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-email:1.16.0	2	1024	896	128	768	88	128	FALSE
mod-circulation	12	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-circulation:24.0.11	2	2880	2592	1536	1814	384	512	FALSE
mod-di-converter-storage	11	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-di-converter-storage:2.1.5	2	1024	896	128	768	88	128	FALSE
mod-pubsub	13	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-pubsub:2.11.3	2	1536	1440	1024	922	384	512	FALSE
edge-orders	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-orders:2.9.1	2	1024	896	128	768	88	128	FALSE
edge-rtac	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-rtac:2.6.2	2	1024	896	128	768	88	128	FALSE
mod-template-engine	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-template-engine:1.19.1	2	1024	896	128	768	88	128	FALSE
mod-users	15	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-users:19.3.0-SNAPSHOT.669	2	1024	896	128	768	88	128	FALSE
mod-patron-blocks	11	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-patron-blocks:1.9.0	2	1024	896	1024	768	88	128	FALSE
edge-fqm	12	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-fqm:1.0.1	2	1024	896	128	768	88	128	FALSE
mod-audit	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-audit:2.8.0	2	1024	896	128	768	88	128	FALSE
mod-source-record-manager	19	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-source-record-manager:3.7.8	2	5600	5000	2048	3500	384	512	FALSE
nginx-edge	8	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/nginx-edge:2023.06.14	2	1024	896	128	0	0	0	FALSE
mod-quick-marc	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-quick-marc:5.0.1	1	2288	2176	128	1664	384	512	FALSE
nginx-okapi	8	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/nginx-okapi:2023.06.14	2	1024	896	128	0	0	0	FALSE
okapi-b	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/okapi:5.1.1	3	1684	1440	1024	922	384	512	FALSE
mod-feesfines	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-feesfines:19.0.0	2	1024	896	128	768	88	128	FALSE
mod-invoice-storage	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-invoice-storage:5.7.0	2	1872	1536	1024	1024	384	512	FALSE
mod-service-interaction	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-service-interaction:3.0.2	2	2048	1844	256	1290	384	512	FALSE
mod-patron	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-patron:6.0.0	2	1024	896	128	768	88	128	FALSE
mod-data-export	11	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-data-export:4.8.7	1	1024	896	1024	768	88	128	FALSE
mod-oai-pmh	11	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-oai-pmh:3.12.8	2	4096	3690	2048	3076	384	512	FALSE
edge-connexion	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-connexion:1.1.1	2	1024	896	128	768	88	128	FALSE
mod-notes	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-notes:5.1.0	2	1024	896	128	952	384	512	FALSE
mod-kb-ebsco-java	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-kb-ebsco-java:4.0.0	2	1024	896	128	768	88	128	FALSE
mod-data-export-spring	14	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-data-export-spring:3.0.2	1	2048	1844	256	1536	384	512	FALSE
mod-login	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-login:7.10.1	2	1440	1298	1024	768	384	512	FALSE
mod-organizations-storage	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-organizations-storage:4.6.0	2	1024	896	128	700	88	128	FALSE
pub-okapi	8	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/pub-okapi:2023.06.14	2	1024	896	128	768	0	0	FALSE
mod-eusage-reports	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-eusage-reports:2.0.0	2	1024	896	128	768	88	128	FALSE

PTF - environment Quesnelia (qcp1)

10 m6g.2xlarge EC2 instances located in US East (N. Virginia)us-east-1
1 database instances, writer
Name Memory GIB vCPUs
db.r6g.xlarge
32 GiB 4 vCPUs
MSK ptf-mobius-testing2
- 2 m5.2xlarge brokers in 2 zones
- Apache Kafka version 2.8.0
- EBS storage volume per broker 300 GiB
- auto.create.topics.enable=true
- log.retention.minutes=480
- default.replication.factor=2

Quesnelia modules memory and CPU parameters

Module	Task Def. Revision	Module Version	Task Count	Mem Hard Limit	Mem Soft limit	CPU units	Xmx	MetaspaceSize	MaxMetaspaceSize	R/W split enabled
qcp1-pvt
Thu Apr 04 10:28:25 UTC 2024
mod-remote-storage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-remote-storage:3.2.0-SNAPSHOT.162	2	4920	4472	1024	3960	512	512	FALSE
mod-ncip	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-ncip:1.14.5-SNAPSHOT.224	2	1024	896	128	768	88	128	FALSE
mod-finance-storage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-finance-storage:8.6.0-SNAPSHOT.159	2	1024	896	1024	700	88	128	FALSE
mod-agreements	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-agreements:6.1.0-SNAPSHOT.195	2	1592	1488	128	0	0	0	FALSE
mod-ebsconet	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-ebsconet:2.2.0-SNAPSHOT.74	2	1248	1024	128	700	128	256	FALSE
mod-organizations	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-organizations:1.9.0-SNAPSHOT.84	2	1024	896	128	768	88	128	FALSE
edge-sip2	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-sip2:3.2.0-SNAPSHOT.209	2	1024	896	128	768	88	128	FALSE
mod-serials-management	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-serials-management:1.0.0-SNAPSHOT.25	2	2480	2312	128	1792	384	512	FALSE
mod-settings	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-settings:1.0.3-SNAPSHOT.63	2	1024	896	200	768	88	128	FALSE
mod-data-import	5	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-data-import:3.1.0-SNAPSHOT.174	1	2048	1844	256	1292	384	512	FALSE
edge-dematic	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-dematic:2.1.2-SNAPSHOT.130	1	1024	896	128	768	88	128	FALSE
mod-search	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-search:3.2.0-SNAPSHOT.199	2	2592	2480	2048	1440	512	1024	FALSE
mod-inn-reach	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-inn-reach:3.2.0-SNAPSHOT.86	2	3600	3240	1024	2880	512	1024	FALSE
mod-tags	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-tags:2.1.1-SNAPSHOT.132	2	1024	896	128	768	88	128	FALSE
edge-courses	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-courses:1.3.2-SNAPSHOT.1138	2	1024	896	128	768	88	128	FALSE
mod-authtoken	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-authtoken:2.15.0-SNAPSHOT.290	2	1440	1152	512	922	88	128	FALSE
mod-inventory-update	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-inventory-update:3.2.2-SNAPSHOT.82	2	1024	896	128	768	88	128	FALSE
mod-notify	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-notify:3.1.1-SNAPSHOT.262	2	1024	896	128	768	88	128	FALSE
mod-configuration	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-configuration:5.11.0-SNAPSHOT.348	2	1024	896	128	768	88	128	FALSE
mod-orders-storage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-orders-storage:13.7.0-SNAPSHOT.215	2	1024	896	512	700	88	128	FALSE
edge-caiasoft	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-caiasoft:2.1.1-SNAPSHOT.82	2	1024	896	128	768	88	128	FALSE
mod-login-saml	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-login-saml:2.8.0-SNAPSHOT.280	2	1024	896	128	768	88	128	FALSE
mod-erm-usage-harvester	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-erm-usage-harvester:4.5.0-SNAPSHOT.123	2	1024	896	128	768	88	128	FALSE
mod-licenses	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-licenses:5.1.0-SNAPSHOT.147	2	2480	2312	128	1792	384	512	FALSE
mod-gobi	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-gobi:2.8.0-SNAPSHOT.244	2	1024	896	128	768	88	128	FALSE
mod-password-validator	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-password-validator:3.1.1-SNAPSHOT.137	2	1440	1298	128	768	384	512	FALSE
mod-bulk-operations	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-bulk-operations:2.0.0-SNAPSHOT.81	2	3072	2600	1024	1536	384	512	FALSE
mod-fqm-manager	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-fqm-manager:1.1.0-SNAPSHOT.1083	2	1024	896	128	768	88	128	FALSE
edge-dcb	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-dcb:1.1.0-SNAPSHOT.16	2	1024	896	128	768	88	128	FALSE
mod-graphql	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-graphql:1.12.1.401	2	1024	896	128	768	88	128	FALSE
mod-finance	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-finance:4.9.0-SNAPSHOT.160	2	1024	896	128	768	88	128	FALSE
mod-erm-usage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-erm-usage:4.7.0-SNAPSHOT.99	2	1024	896	128	768	88	128	FALSE
mod-batch-print	3	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-batch-print:1.2.0-SNAPSHOT.10	2	1024	896	128	768	88	128	FALSE
mod-copycat	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-copycat:1.6.0-SNAPSHOT.197	2	1024	896	128	768	88	128	FALSE
mod-lists	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-lists:1.1.0-SNAPSHOT.1266	2	1024	896	128	768	88	128	FALSE
mod-entities-links	3	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-entities-links:3.0.0-SNAPSHOT.78	2	2592	2480	2096	1440	0	1024	FALSE
mod-permissions	4	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-permissions:6.5.0-SNAPSHOT.374	2	1684	1544	512	1024	384	512	FALSE
pub-edge	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/pub-edge:2023.06.14	2	1024	896	128	768	0	0	FALSE
mod-orders	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-orders:12.8.0-SNAPSHOT.332	2	2048	1440	1024	1024	384	512	FALSE
edge-patron	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-patron:5.1.0-SNAPSHOT.153	2	1024	896	256	768	88	128	FALSE
edge-ncip	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-ncip:1.9.3-SNAPSHOT.103	2	1024	896	128	768	88	128	FALSE
edge-inn-reach	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-inn-reach:3.1.1-SNAPSHOT.45	2	1024	896	128	768	88	128	FALSE
mod-users-bl	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-users-bl:7.6.1-SNAPSHOT.282	2	1440	1152	512	922	88	128	FALSE
mod-oa	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-oa:2.1.0-SNAPSHOT.62	2	1024	896	128	768	88	128	FALSE
mod-inventory-storage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-inventory-storage:27.1.0-SNAPSHOT.719	2	4096	3690	2048	3076	384	512	FALSE
mod-invoice	3	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-invoice:5.8.0-SNAPSHOT.187	2	1440	1152	512	922	88	128	FALSE
mod-user-import	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-user-import:3.9.0-SNAPSHOT.192	2	1024	896	128	768	88	128	FALSE
mod-sender	3	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-sender:1.11.1-SNAPSHOT.94	2	1024	896	128	768	88	128	FALSE
edge-oai-pmh	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-oai-pmh:2.8.0-SNAPSHOT.155	2	1512	1360	1024	1440	384	512	FALSE
mod-data-export-worker	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-data-export-worker:3.2.0-SNAPSHOT.195	2	3072	2800	1024	2048	384	512	FALSE
mod-rtac	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-rtac:3.6.0-SNAPSHOT.166	2	1024	896	128	768	88	128	FALSE
mod-circulation-storage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-circulation-storage:17.2.0-SNAPSHOT.384	2	2880	2592	1536	1814	384	512	FALSE
mod-calendar	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-calendar:2.6.0-SNAPSHOT.218	2	1024	896	128	768	88	128	FALSE
mod-source-record-storage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-source-record-storage:5.8.0-SNAPSHOT.353	2	5600	5000	2048	3500	384	512	FALSE
mod-event-config	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-event-config:2.6.1-SNAPSHOT.100	2	1024	896	128	768	88	128	FALSE
mod-courses	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-courses:1.4.9-SNAPSHOT.143	2	1024	896	128	768	88	128	FALSE
mod-circulation-item	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-circulation-item:1.0.0-SNAPSHOT.16	2	1024	896	128	768	88	128	FALSE
mod-inventory	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-inventory:20.2.0-SNAPSHOT.501	2	2880	2592	1024	1814	384	512	FALSE
mod-email	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-email:1.16.1-SNAPSHOT.122	2	1024	896	128	768	88	128	FALSE
mod-pubsub	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-pubsub:2.13.0-SNAPSHOT.196	2	1536	1440	1024	922	384	512	FALSE
mod-circulation	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-circulation:24.2.0-SNAPSHOT.649	2	2880	2592	1536	1814	384	512	FALSE
mod-di-converter-storage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-di-converter-storage:2.2.0-SNAPSHOT.108	2	1024	896	128	768	88	128	FALSE
edge-rtac	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-rtac:2.7.0-SNAPSHOT.212	2	1024	896	128	768	88	128	FALSE
edge-orders	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-orders:2.10.0-SNAPSHOT.123	2	1024	896	128	768	88	128	FALSE
mod-users	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-users:19.3.0-SNAPSHOT.679	2	1024	896	128	768	88	128	FALSE
mod-template-engine	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-template-engine:1.19.2-SNAPSHOT.111	2	1024	896	128	768	88	128	FALSE
mod-patron-blocks	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-patron-blocks:1.10.0-SNAPSHOT.152	2	1024	896	1024	768	88	128	FALSE
mod-audit	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-audit:2.9.0-SNAPSHOT.207	2	1024	896	128	768	88	128	FALSE
edge-fqm	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-fqm:1.1.0-SNAPSHOT.84	2	1024	896	128	768	88	128	FALSE
mod-source-record-manager	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-source-record-manager:3.8.0-SNAPSHOT.306	2	5600	5000	2048	3500	384	512	FALSE
nginx-edge	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/nginx-edge:2023.06.14	2	1024	896	128	0	0	0	FALSE
mod-quick-marc	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-quick-marc:5.1.0-SNAPSHOT.134	1	2288	2176	128	1664	384	512	FALSE
nginx-okapi	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/nginx-okapi:2023.06.14	2	1024	896	1024	0	0	0	FALSE
okapi-b	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/okapi:5.1.2	3	1684	1440	1024	922	384	512	FALSE
mod-feesfines	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-feesfines:19.1.0-SNAPSHOT.189	2	1024	896	128	768	88	128	FALSE
mod-invoice-storage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-invoice-storage:5.8.0-SNAPSHOT.123	2	1872	1536	1024	1024	384	512	FALSE
mod-dcb	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-dcb:1.1.0-SNAPSHOT.18	2	1024	896	128	768	88	128	FALSE
mod-service-interaction	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-service-interaction:3.1.0-SNAPSHOT.117	2	2048	1844	256	1290	384	512	FALSE
mod-data-export	6	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-data-export:4.8.7	1	2048	1524	1024	0	0	0	FALSE
mod-patron	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-patron:6.1.0-SNAPSHOT.147	2	1024	896	128	768	88	128	FALSE
mod-oai-pmh	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-oai-pmh:3.13.0-SNAPSHOT.393	2	4096	3690	2048	3076	384	512	FALSE
edge-connexion	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/edge-connexion:1.2.0-SNAPSHOT.72	2	1024	896	128	768	88	128	FALSE
mod-kb-ebsco-java	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-kb-ebsco-java:4.1.0-SNAPSHOT.162	2	1024	896	128	768	88	128	FALSE
mod-notes	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-notes:5.2.0-SNAPSHOT.306	2	1024	896	128	952	384	512	FALSE
mod-data-export-spring	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-data-export-spring:3.2.0-SNAPSHOT.149	1	2048	1844	256	1536	384	512	FALSE
mod-organizations-storage	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-organizations-storage:4.7.0-SNAPSHOT.125	2	1024	896	128	768	88	128	FALSE
mod-login	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-login:7.11.0-SNAPSHOT.314	2	1440	1298	1024	768	384	512	FALSE
pub-okapi	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/pub-okapi:2023.06.14	2	1024	896	128	768	0	0	FALSE
mod-eusage-reports	2	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-eusage-reports:2.1.0-SNAPSHOT.65	2	1024	896	128	768	88	128	FALSE

Methodology/Approach

All tests were started by Jenkins.

Create artefacts and upload to carrier-io: ocp3_order_invoice, ocp3_invoice, qcp1_invoice and qcp1_invoice
Compare configuration module parameters between Poppy env(ocp3) and Quesnelia env(qcp1). File with result is attached.
Use Jenkins to change parameters and run test
Run test on both Poppy and Quesnelia environment

Test parameters for Test №1

Number of users: 2
Test duration: 1.5h
No pause between user action

Test scenario

Create order
Create 10 po lines
Open order
Create invoice
Add 10 po lines from Order (with connection to POL)
Approve invoice
Pay invoice

Test parameters for Test №2

Number of users: 2
Test duration: test without repetitions
No pause between user action

Test scenario

Create order
Create 500 po lines
Open order
Create invoice
Add 500 po lines from Order (with connection to POL)
Approve invoice
Pay invoice

Test parameters for Test №3

Number of users: 2
Test duration: 1h
No pause between user action

Test scenario

Create invoice
Create 500 blank invoice lines (without connection to POL)
Approve invoice
Pay invoice

Attached files

Compared configuration module parameters between Poppy env(ocp3) and Quesnelia env(qcp1):

#	TOP 6 SQL statements
1	`SELECT * FROM get_job_log_entries('ad16db9a-f14f-4d23-a74e-8229d9fb74a5', 'source_record_order', 'ASC', 100, 0, false, 'ALL')`
2	`EXPLAIN ANALYZE SELECT * FROM get_job_log_entries('ad16db9a-f14f-4d23-a74e-8229d9fb74a5', 'source_record_order', 'ASC', 100, 0, false, 'ALL')`
3	`SELECT jsonb,id FROM fs09000000_mod_orders_storage.export_history WHERE lower(f_unaccent(export_history.jsonb->>'exportedPoLineIds')) LIKE lower(f_unaccent('%')) ORDER BY left(lower(f_unaccent(export_history.jsonb->>'exportDate')),600) DESC, lower(f_unaccent(export_history.jsonb->>'exportDate')) DESC LIMIT 1000 OFFSET 0`
4	`SELECT fs09000000_mod_finance_storage.count_estimate('SELECT jsonb,id FROM fs09000000_mod_finance_storage.fund WHERE ((get_tsvector(f_unaccent(fund.jsonb->>''acqUnitIds'')) @@ tsquery_phrase(f_unaccent(''0ebb1f7d-983f-3026-8a4c-5318e0ebc041''))) OR ((true) AND ( (lower(f_unaccent(fund.jsonb->>''acqUnitIds'')) NOT LIKE lower(f_unaccent(''[]''))) IS NOT TRUE))) AND (true)')`
5	`SELECT * FROM fs09000000_mod_orders_storage.internal_lock WHERE lock_name = $1 FOR UPDATE`
6	`insert into "marc_records_lb" ("id", "content") values (cast($1 as uuid), cast($2 as jsonb)) on conflict ("id") do update set "content" = cast($3 as jsonb)`

#	TOP 5 SQL statements
1	`UPDATE fs09000000_mod_invoice_storage.invoice_lines SET jsonb = $1::jsonb WHERE id='66ecc39b-e442-4884-8bba-69e7defc8392'`
2	SELECT jsonb,id FROM fs09000000_mod_orders_storage.acquisitions_unit_membership WHERE CASE WHEN length(lower (f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684'))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')),600) LIKE lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684')) ELSE left(lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')),600) LIKE left(lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684')),600) AND lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')) LIKE lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684')) END LIMIT 2147483647 OFFSET 0
3	SELECT fs09000000_mod_orders_storage.count_estimate('SELECT jsonb,id FROM fs09000000_mod_orders_storage.acquisitions_unit WHERE (CASE WHEN length(lower (f_unaccent(''false''))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>''isDeleted'')),600) LIKE lower(f_unaccent(''false'')) ELSE left(lower (f_unaccent(acquisitions_unit.jsonb->>''isDeleted'')),600) LIKE left(lower(f_unaccent(''false'')),600) AND lower(f_unaccent(acquisitions_unit.jsonb->>''isDeleted'')) LIKE lower(f_unaccent(''false'')) END) AND (CASE WHEN length(lower(f_unaccent(''false''))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>''protectRead'')),600) LIKE lower(f_unaccent(''false'')) ELSE left(lower(f_unaccent(acquisitions_unit.jsonb->>''protectRead'')),600) LIKE left(lower(f_unaccent(''false'')),600) AND lower(f_unaccent(acquisitions_unit.jsonb->>''protectRead'')) LIKE lower(f_unaccent(''false'')) END)')
4	SELECT fs09000000_mod_finance_storage.count_estimate('SELECT jsonb,id FROM fs09000000_mod_finance_storage.ledger WHERE ((get_tsvector(f_unaccent(ledger.jsonb->>''acqUnitIds'')) @@ tsquery_phrase(f_unaccent(''0ebb1f7d-983f-3026-8a4c-5318e0ebc041''))) OR ((true) AND ( (lower(f_unaccent(ledger.jsonb->>''acqUnitIds'')) NOT LIKE lower(f_unaccent(''[]''))) IS NOT TRUE))) AND ((id=''52b500b3-4757-4d06-9fde-be125cc5e738'') AND (lower(f_unaccent(ledger.jsonb->>''restrictExpenditures'')) LIKE lower(f_unaccent(''true''))))')
5	`INSERT INTO fs09000000_mod_invoice_storage.invoice_lines (id, jsonb) VALUES ($1, $2) RETURNING jsonb`

Name	Memory GIB	vCPUs
db.r6g.xlarge	32 GiB	4 vCPUs

Name	Memory GIB	vCPUs
db.r6g.xlarge	32 GiB	4 vCPUs