I have a AWS RDS m5.large Postgres 10 database that performs a lot of the following queries
SELECT "bundles".* FROM "bundles" WHERE "bundles"."version_id" = $1 AND (tree_path ~ ?) LIMIT $2
the problem is the poor performance of the overall system. Via advanced monitoring we see a very high value for current activity:
and it seems that the forementioned query have some sort of impact on the load by waits
What do you suggest to check? I’m not a DBA so I can’t judge if those queries are efficent.