Overview

The purpose of this test is to establish baseline for item-search filter test, to be able compare this test with analogical test in future. Find possible issues, and/or bottlenecks.

Test result summary

System shows stable work without unexpected errors and spikes, however there is slowness on DB side. According to PG Hero there is 8 slow queries (See "Slow queries" selection) that causing high CPU usage and slowness.

Version

okapi:4.2.2

mod-inventory-storage:19.4.3"

mod-inventory:16.1.2

Test

Test #	Virtual Users	Duration

Test #	Virtual Users	Duration
1	5	1800

Results

Requests	Total	Min	50th pct	75th pct	95th pct	99th pct	Max

Requests	Total	Min	50th pct	75th pct	95th pct	99th pct	Max
authn/login HTTP Request	1	0.288	0.288	0.288	0.288	0.288	0.288
GET_/alternative-title-types	219	0.013	0.019	0.022	0.033	0.063	0.316
GET_/call-number-types	219	0.012	0.020	0.023	0.040	0.074	0.170
GET_/classification-types	219	0.013	0.019	0.022	0.042	0.086	0.147
GET_/contributor-name-types	219	0.012	0.019	0.023	0.040	0.137	0.287
GET_/contributor-types	219	0.024	0.036	0.043	0.098	0.314	0.410
GET_/electronic-access-relationships	219	0.012	0.018	0.022	0.034	0.048	0.052
GET_/holdings-note-types	219	0.012	0.019	0.022	0.037	0.078	0.503
GET_/holdings-types	219	0.012	0.019	0.022	0.041	0.068	0.166
GET_/identifier-types	219	0.022	0.034	0.046	0.109	0.219	0.390
GET_/ill-policies	219	0.012	0.019	0.025	0.040	0.064	0.481
GET_/instance-formats	219	0.015	0.023	0.026	0.048	0.213	0.387
GET_/instance-note-types	219	0.015	0.022	0.025	0.038	0.054	0.213
GET_/instance-relationship-types	219	0.012	0.020	0.024	0.036	0.125	0.218
GET_/instance-statuses	219	0.013	0.021	0.024	0.053	0.241	0.266
GET_/instance-storage/instances filter by location	215	8.055	8.996	9.757	11.449	191.360	191.561
GET_/instance-types	219	0.014	0.021	0.025	0.043	0.199	0.380
GET_/inventory/instances	219	0.262	0.435	0.498	0.641	2.078	2.129
GET_/inventory/instances item.discoverySuppress=="true" limit 100	219	0.024	0.033	0.042	0.084	0.182	0.336
GET_/inventory/instances languages==spa and staffSuppress==true limit 100	219	0.020	0.027	0.033	0.073	0.157	600.030
GET_/inventory/instances languages=spa and natureOfContentTermIds=ebbbdef1-00e1-428b-bc11-314dc0705074 limit 100	219	14.983	23.280	23.910	24.719	27.917	28.190
GET_/inventory/instances limit 100	657	0.299	0.492	0.645	0.890	2.046	9.822
GET_/inventory/instances limit 100 offset 100	219	0.298	0.457	0.524	0.762	1.384	1.504
GET_/item-damaged-statuses	219	0.011	0.018	0.021	0.037	0.099	0.117
GET_/item-note-types	219	0.012	0.019	0.021	0.038	0.055	0.435
GET_/loan-types	219	0.015	0.023	0.026	0.043	0.067	0.116
GET_/locations	219	0.050	0.075	0.085	0.203	0.284	0.369
GET_/material-types	219	0.014	0.023	0.025	0.039	0.092	0.097
GET_/modes-of-issuance	219	0.013	0.019	0.023	0.038	0.072	0.100
GET_/nature-of-content-terms	219	0.013	0.019	0.023	0.036	0.084	0.113
GET_/statistical-code-types	219	0.012	0.020	0.023	0.040	0.200	0.460
GET_/statistical-codes	219	0.014	0.021	0.024	0.042	0.116	0.174
Inventory Item Search Transaction	215	28.178	36.028	36.938	38.505	236.099	640.697

Service CPU usage:

CPU usage on relevant modules:

OKAPI - 66%-68%;
Mod inventory storage - 29%-39%;
Mod Inventory - 7%-10%.

Service Memory usage:

RDS CPU usage:

DB load by waits:

DB load by SQL

RDS memory usage:

item-search-filter test report

Overview

Test result summary

Version

Test

Results

Slow queries: