RootCauseunvalidated
unnest(actionServiceIds) expands each row into many rows, and PostgreSQL cannot efficiently index or optimize DISTINCT/count over array contents when stored as non-atomic values. This forces large intermediate result sets and expensive group-by/distinct operations.
73caa53a-93ac-4184-991d-063311dd1519
unnest(actionServiceIds) expands each row into many rows, and PostgreSQL cannot efficiently index or optimize DISTINCT/count over array contents when stored as non-atomic values. This forces large intermediate result sets and expensive group-by/distinct operations.