Slow concepts/mappings select

[rkorytkowski]

DB reports the following query as slow:
2021-10-12 09:59:10 UTC:10.1.11.167(56360):postgres@postgres:[20237]:LOG: duration: 51915.650 ms statement: SELECT "concepts"."id", "concepts"."public_access", "concepts"."created_at", "concepts"."updated_at", "concepts"."created_by_id", "concepts"."updated_by_id", "concepts"."is_active", "concepts"."extras", "concepts"."uri", "concepts"."version", "concepts"."released", "concepts"."retired", "concepts"."is_latest_version", "concepts"."name", "concepts"."full_name", "concepts"."default_locale", "concepts"."supported_locales", "concepts"."website", "concepts"."description", "concepts"."external_id", "concepts"."concept_class", "concepts"."datatype", "concepts"."comment", "concepts"."parent_id", "concepts"."versioned_object_id", "concepts"."mnemonic" FROM "concepts" WHERE ("concepts"."is_active" AND NOT "concepts"."retired" AND "concepts"."is_latest_version" AND NOT ("concepts"."public_access" = 'None')) ORDER BY "concepts"."updated_at" DESC LIMIT 25

We need to include "updated_at" in the multi-field index.

[rkorytkowski]

Same applies to mappings...