search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.57k stars 661 forks source link

Dashboard breaking when database is super busy #7809

Open MacaulaySouza opened 3 months ago

MacaulaySouza commented 3 months ago

Describe the bug

We have a super busy database that triggers multiples parallel process causing multiple objects locked.

image

Since the latest update, we are not able to use PGADMIN to monitor active sessions because it tried to load all locked objects, that includes all sorts of locks and crashes.

To Reproduce

Steps to reproduce the behavior:

  1. Go to dashboard -> State
  2. See the error image app crash image

Expected behavior

Allow some option to disable lock monitoring or limit the number of objects in the UI

Error message

There is no error message, when it happens, the screen get white and I have to reload the program

Screenshots

If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

Additional context

Add any other context about the problem here.

khushboovashi commented 4 days ago

Hi @MacaulaySouza,

Just to be sure, the issue is only on the UI side. That said, the data is loaded successfully in the client's memory; the only issue while displaying those records?