There is a slow query issue in completion/classes/api.php.
It's the query in the mark_course_completions_activity_criteria function.
This query takes approximately one hour and thirty to complete.

I have attached a report that shows you for each course:

• how many activities are presents
• how many users are enrolled (please note that some users are enrolled multiple times in the same course via different enrollment methods)

In the following table, you can see how many records each table has.

I have also attached the EXPLAIN query report.

I'm using postgreSQL 16

Can you help me to find a solution?