Client: Tryton Client, GNU Health client
Server: GNU health 3.8
OS: Debian 11
Database: Postgresql 13

Hello guys, I hope everything is all right with you.

I'm having a really strange problem which happens when I click on the Created Invoices menu inside Health Services menu.

It takes more than a minute to get the data from the database, and while it waits for the data the client program hangs unresponsive unlike any other menu.

When I tried to click on other menus in which returns more data than the Created Invoices menu, for example the client invoices inside the Financial Menu from the account module, the client program behaves as it should, returning the data normally even though it has more invoices than the Created Invoices menu have. I've also tried to click on other menu like the prescriptions menu and it returns more data than the Created Invoices and it behaves normally.

Another thing that happens is that, when I click on the Created Invoices menu and run htop program to check the resources consumed, the CPU usage goes up to 100% for the duration of all query.

Even though I tried to decrease the Search limit to 50, it still take much time to get the data from the database.

It's also important to note that, it's only this menu that has this problem.

I attached a photo with the htop running so you can see the query running on the database and its consumption.

I hope you guys can help me with this.

Thank you so much for all your work.

Happy new year for all.

Cheers