Details
-
Story
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
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
Issue Links
- blocks
-
MODFISTO-108 MODFISTO (mod-finance-storage) release
-
- Closed
-
- defines
-
UXPROD-2295 Value management through transactions Part 3 - Fixes and committing/encumbering money for approved invoices
-
- Closed
-