|
With the new RMB 26 release, a warning will be logged if the query does not have the expected index in database. Please try to resolve those warnings originated from platform-perf test run.
Missing index messages in the log
See attached files for the details including corresponding CQL and SQL queries
mod-inventory-storage:
WARNING: Doing LIKE search without GIN index for instance_holding_item_view.it_jsonb->>'barcode'
WARNING: Doing LIKE search without GIN index for instance_holding_view.ho_jsonb->>'permanentLocationId'
WARNING: Doing LIKE search without GIN index for service_point_user.jsonb->>'userId'
mod-users
WARNING: Doing FT search without FT index proxyfor.jsonb->>'proxyUserId'
WARNING: Doing FT search without FT index users_groups_view.jsonb->>'barcode'
WARNING: Doing FT search without FT index users_groups_view.jsonb->>'externalSystemId'
WARNING: Doing FT search without FT index users_groups_view.jsonb->'personal'->>'email'
WARNING: Doing FT search without FT index users_groups_view.jsonb->'personal'->>'firstName'
WARNING: Doing FT search without FT index users_groups_view.jsonb->'personal'->>'lastName'
WARNING: Doing FT search without FT index users_groups_view.jsonb->>'username'
WARNING: Doing FT search without FT index users.jsonb->>'active'
WARNING: Doing FT search without FT index users.jsonb->>'barcode'
WARNING: Doing FT search without FT index users.jsonb->>'externalSystemId'
WARNING: Doing FT search without FT index users.jsonb->'personal'->>'email'
WARNING: Doing FT search without FT index users.jsonb->'personal'->>'firstName'
WARNING: Doing FT search without FT index users.jsonb->'personal'->>'lastName'
WARNING: Doing FT search without FT index users.jsonb->>'username'
WARNING: Doing LIKE search without GIN index for proxyfor.jsonb->>'userId'
WARNING: Doing LIKE search without GIN index for users.jsonb->>'active'
mod-circulation-storage
WARNING: Doing FT search without FT index loan.jsonb->>'userId'
WARNING: Doing LIKE search without GIN index for loan.jsonb->'status'->>'name'
WARNING: Doing LIKE search without GIN index for request.jsonb->>'itemId'
WARNING: Doing LIKE search without GIN index for request.jsonb->>'requestType'
WARNING: Doing LIKE search without GIN index for request.jsonb->>'status'
|