Uploaded image for project: 'mod-finance-storage'
  1. mod-finance-storage
  2. MODFISTO-78

Add indexes for tables

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P3
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 5.0.0
    • Labels:
      None
    • Template:
    • Sprint:
      ACQ Sprint 89
    • Story Points:
      1
    • Development Team:
      Thunderjet

      Description

      Overview
      Found the below logs in bugfest:

      WARNING: Doing FT search without index for ledger.jsonb->>'ledgerStatus', CQL >>> SQL: ledgerStatus = Active >>> to_tsvector('simple', f_unaccent(ledger.jsonb->>'ledgerStatus')) @@ replace((to_tsquery('simple', f_unaccent('''Active''')))::text, '&', '<->')::tsquery
      
      WARNING: Doing LIKE search without index for fiscal_year.jsonb->>'series', CQL >>> SQL: series == DB >>> lower(f_unaccent(fiscal_year.jsonb->>'series')) LIKE lower(f_unaccent('DB'))
      
      

      NOTE: We need to determine the exact list of fields which are missing indexes. That is part of this story and baked into the estimation.

      Acceptance Criteria

      • Necessary indexes are added

        TestRail: Results

          Attachments

          1. fiscal_year_index.png
            fiscal_year_index.png
            19 kB
          2. Ledger_index.png
            Ledger_index.png
            23 kB
          3. screenshot-1.png
            screenshot-1.png
            46 kB
          4. screenshot-2.png
            screenshot-2.png
            42 kB

            Issue Links

              Activity

                People

                Assignee:
                Andrei_Makaranka Andrei Makaranka
                Reporter:
                KVupp Kruthi Vuppala
                Tester Assignee:
                Andrei Makaranka Andrei Makaranka
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases