Hello everyone, I have an OJS instance for which we have upgraded from 3.3.0.13 to 3.3.0.19.
The upgrade went well, but afterwards we noticed a query that requires many resources and is heavily impacting the database, where does it come from, how do I mitigate its effects?
the query is this:
select "s".* from "submissions" as "s" where "s"."context_id" = $1 and "s"."status" in ($2) and (exists (select * from "submission_search_objects" as "sso" inner join
"submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($3) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join
"submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($4) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join "submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($5) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join
"submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($6) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join
"submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($7) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join
"submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($8) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join
"submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($9) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join "submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($10) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join "submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($11) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join
"submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($12) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join "submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_id" inner join "submission_search_keyword_list" as "sskl" on "sskl"."keyword_id" = "ssok"."keyword_id" where "sskl"."keyword_text" = LOWER($13) and "s"."submission_id" = "sso"."submission_id") or exists (select * from "submission_search_objects" as "sso" inner join
"submission_search_object_keywords" as "ssok" on "sso"."object_id" = "ssok"."object_i.....