Investigate search without indexes for mod-circulation-storage

Performing tests for Check-In/ Check-Out with DB read-write split disabled and enabled warnings about search without indexes were observed.

• 14:40:58 [893005/circulation;312636/request-storage] [fs09000000] [9eb67301-6f6e-468f-9b1a-6134dc39a684] [mod_circulation_storage] WARN  CQL2PgJSON           Doing FT search without index for request.jsonb->>'pickupServicePointId', CQL >>> SQL: pickupServicePointId = 7068e104-aa14-4f30-a8bf-71f71cc15e07 >>> get_tsvector(f_unaccent(request.jsonb->>'pickupServicePointId')) @@ tsquery_phrase(f_unaccent('7068e104-aa14-4f30-a8bf-71f71cc15e07'))
• 14:40:58 [863718/circulation;693082/request-storage] [fs09000000] [9eb67301-6f6e-468f-9b1a-6134dc39a684] [mod_circulation_storage] WARN  CQL2PgJSON           Doing LIKE search without index for request.jsonb->>'instanceId', CQL >>> SQL: instanceId == c34b9e0d-4f6b-4e15-aafa-4f314a241dc9 >>> lower(f_unaccent(request.jsonb->>'instanceId')) LIKE lower(f_unaccent('c34b9e0d-4f6b-4e15-aafa-4f314a241dc9'))
• 14:40:58 [487959/circulation;934846/actual-cost-record-storage] [fs07000001] [] [mod_circulation_storage] WARN  CQL2PgJSON           Doing SQL query without index for actual_cost_record.jsonb->>'expirationDate', CQL >>> SQL: expirationDate < "2022-12-05T14:40:58.310708Z[Etc/UTC]" >>> actual_cost_record.jsonb->>'expirationDate' <'2022-12-05T14:40:58.310708Z[Etc/UTC]'

Environment:

https://ptf-nolana-2.int.aws.folio.org/

ncp3