Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-131

Create indexes on fields used in search queries

    XMLWordPrintable

Details

    • Folijet Sprint 91, Folijet Sprint 92
    • 2
    • Folijet
    • Q2 2020

    Description

      Overview
      The below logs were observed in the fameflower deploy in one of our clusters. 

      WARNING: Doing LIKE search without index for records.jsonb->'externalIdsHolder'->>'instanceId', CQL >>> SQL: externalIdsHolder.instanceId == 8802fdee-7e05-4f62-b92a-6bb1660bf169 >>> lower(f_unaccent(records.jsonb->'externalIdsHolder'->>'instanceId')) LIKE lower(f_unaccent('8802fdee-7e05-4f62-b92a-6bb1660bf169'))
May 06, 2020 4:59:45 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for records.jsonb->'externalIdsHolder'->>'instanceId', CQL >>> SQL: externalIdsHolder.instanceId == ffc0eea0-4125-457f-9f89-0b301c3e3b41 >>> lower(f_unaccent(records.jsonb->'externalIdsHolder'->>'instanceId')) LIKE lower(f_unaccent('ffc0eea0-4125-457f-9f89-0b301c3e3b41'))
May 06, 2020 4:59:45 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for records.jsonb->'externalIdsHolder'->>'instanceId', CQL >>> SQL: externalIdsHolder.instanceId == 4c0de67c-f2db-4ab5-a863-d5676c99c553 >>> lower(f_unaccent(records.jsonb->'externalIdsHolder'->>'instanceId')) LIKE lower(f_unaccent('4c0de67c-f2db-4ab5-a863-d5676c99c553'))
May 06, 2020 4:59:45 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for records.jsonb->'externalIdsHolder'->>'instanceId', CQL >>> SQL: externalIdsHolder.instanceId == e2a35068-f7a8-4026-91ae-278f5b828c20 >>> lower(f_unaccent(records.jsonb->'externalIdsHolder'->>'instanceId')) LIKE lower(f_unaccent('e2a35068-f7a8-4026-91ae-278f5b828c20'))

      Acceptance Criteria

      • Indexes are added on these fields
        externalIdsHolder.instanceId
        matchId
        state
        dates

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Task - A task that needs to be done. MODSOURCE-151 Release v4.0.0

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            defines

            Umbrella - MODSOURCE-121 Improve performance for receiving records from SRS

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            New Feature - New feature requests UXPROD-2220 NFR: Data Import (Batch Importer for Bib Acq) & PubSub Q2 2020 Technical, NFR, & Misc bug work

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                wwelling William Welling
                KVupp Kruthi Vuppala
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases