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

Slow query > 1000 ms: get_record_by_external_id

    XMLWordPrintable

Details

    • Folijet

    Description

      During testing loading items on instance record (in holdings accordion) the next slow query has been captured:

      EXPLAIN ANALYZE select get_record_by_external_id('89a7ec1c-608f-4d24-90b6-57da21557874', 'instanceId');
      

      Steps to Reproduce:

      1. Log into performance environment as folio user
      2. Get formatted records using curl for example
        curl -i --verbose --request GET 'https://okapi-fcp1.int.aws.folio.org:443/source-storage/formattedRecords/89a7ec1c-608f-4d24-90b6-57da21557874?identifier=INSTANCE' \
        > --header 'x-okapi-tenant: fs09000000' \
        > --header 'x-okapi-token: ${xokapi-token}' \
        > --header 'Content-Type: application/json' 
        

      Expected Results: query should return records < 20 ms
      Actual Results: 2650.877 ms

      Additional Information:
      URL: https://wiki.folio.org/display/FOLIJET/Loading+items+on+instance+record+%28in+holdings+accordion%29+Test+Report

      Interested parties:
      Everyone

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                OleksiiKuzminov Oleksii Kuzminov
                Zmiivska Svitlana Zmiivska
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases