Katello 4.9 is very slow

Support
,
9

Hello

I have the same Problem.
RedHat 8
Foreman 3.7 / Katello 4.9
and what is see is that following select in the postgresql takes several hours:

SELECT “katello_rpms”.* FROM “katello_rpms” WHERE “katello_rpms”.“id” NOT IN (SELECT “katello_repository_rpms”.“rpm_id” FROM “katello_repository_rpms” WHERE “katello_repository_rpms”.“repository_id” IN (SELECT “katello_repositories”.“id” FROM “katello_repositories”));

all 3 of them seperate are working.
also this 2: SELECT “katello_repository_rpms”.“rpm_id” FROM “katello_repository_rpms” WHERE “katello_repository_rpms”.“repository_id” IN (SELECT “katello_repositories”.“id” FROM “katello_repositories”)

is there a index missing or wrong?
is this select statement new?

1 Like