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

Add indexes for tables

    XMLWordPrintable

Details

    • Story
    • Status: Closed (View Workflow)
    • P3
    • Resolution: Done
    • None
    • 5.0.0
    • None
    • ACQ Sprint 89
    • 1
    • 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
            19 kB
            Andrei Makaranka
          2. Ledger_index.png
            23 kB
            Andrei Makaranka
          3. screenshot-1.png
            46 kB
            Siarhei Hrabko
          4. screenshot-2.png
            42 kB
            Siarhei Hrabko

          Issue Links

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases