High Memory and CPU Usage in pgAdmin 8.12 Web Interface Causes Browser Freezing

[MostafaHassanzadeh]

n version 8.12 of pgAdmin, there is a bug that causes excessive memory and CPU usage on the client side when using the web interface. This issue leads to frequent browser freezing, significantly impacting usability. It appears that the web interface consumes resources continuously, even during idle periods.

Steps to reproduce:

Open the pgAdmin 8.12 web interface in any modern browser (tested on Chrome, Firefox).
Perform any basic operations, such as viewing tables or running queries, or leave the interface idle.
Monitor memory and CPU usage, which will spike and remain high over time.
The browser becomes unresponsive or crashes after prolonged use.
Expected behavior: The web interface should maintain stable memory and CPU usage without causing the browser to freeze.

Please address this issue in future updates, as it limits the usability of pgAdmin for regular database management tasks.

[masoudChd]

This is a critical problem that leads to major errors and forces an exit from the web version.

In many scenarios, I encountered this issue even in the very initial steps, not only in more complex ones. For example, it occurred when simply selecting a database or checking statistics from the dashboard.

[yogeshmahajan-1903]

@masoudChd
Can you please get us profile data from chrome? Open developer tools > Performance tool > Start recording.

[MostafaHassanzadeh]

@akshay-joshi
Due to security concerns, I cannot publish the profile file itself, so I'll just upload a photo of it.

[yogeshmahajan-1903]

@MostafaHassanzadeh
Unfortunately, I am not able to reproduce the issue. Are there some specific activities that a causing this issue? Can you please try closing the dashboard and check if there is any difference in CPU usage?
Also, can you please provide more information about platform?
Does downgrading pgadmin version eliminates this issue?

[yogeshmahajan-1903]

No response from author, hence closing the issue.