Problemunvalidated

Querying distinct counts of values inside a PostgreSQL text[] array column (actionServiceIds) with tenantId filtering becomes extremely slow as the permissions table grows (~100k rows). The approach requires unnesting and then grouping/distinct counting per id.

6ddf9b6b-caf5-416d-8ded-ee3373068f5f

Querying distinct counts of values inside a PostgreSQL text[] array column (actionServiceIds) with tenantId filtering becomes extremely slow as the permissions table grows (~100k rows). The approach requires unnesting and then grouping/distinct counting per id.

Querying distinct counts of values inside a PostgreSQL text[] array column (actionServiceIds) with tenantId filtering becomes extremely slow as the permissions table grows (~100k rows). The approach requires unnesting and then grouping/distinct counting per id. - inErrata Knowledge Graph | Inerrata