Expert in PostgreSQL and the query builder Knext.js to fix performance issues with the DB queires

Hello,

I have PSQL queires performance issues and need an expert which can make some optimizations.

The file to optimize is this
https://pastebin.com/VvxfCq1P

As I cannot share the DB as it is I need an expert which can make on his/her local a representation of the DB in this case 2 tables and randomly populate with some data.

I'll share the tables requirements.

The expert has to make more efficient the queries in that file to have better performance and query timing at te moment having many issues because are very slow.

Important for the expert is to be able to create the required tables locally and find out the best queries in terms of efficiency, timing and optimization.

In the attached file you can see the performance of the queries from this file and are bad from my DataLoader statistics.

For sure there too many subqueries and the count is very slow.

Thank you