Why pgAdmin 4 is too slow?

user_13465074 0
Viewed 9782

pgAdmin 4 GUI for postgreSQL is very slow. It takes too much time to even expand a server tree or a database tree. They each took almost 30 seconds to expand. It also hangs while creating a new database or table. Even after loading it took more than a minute just to create and save a new database. It happens almost every time I load the pgAdmin. Is this problem faced just by me or there's something wrong?

My system specifications: PostgreSQL 12.3, Firefox 77.0, Windows 10 64-bit, 8th Gen Quad Core i5 8250u processor, 8GB RAM and 2GB dedicated graphics memory.

In the picture you can see:

  • The database tree is still loading.
  • The right click menu and create database window got hanged up.

enter image description here

Hanged on clicking save. It took more than a minute to save a new database enter image description here

pgadmin-4 performance
7 Answers

I had the very same issue, Seems it's related to Windows 10 preferring ipv6 over ipv4.

the following fix worked for me: https://dba.stackexchange.com/questions/201646/

Modify the listen_addresses setting in

the postgresql.conf file usually located under : (unless another data folder specified)

{installation folder}/data/postgresql.conf

to be -> listen_addresses = '127.0.0.1,::1'

The Default value for the listen_addresses is localhost

user_80300480

Click the title bar of pgadmin and drag it around(slowly, otherwise other windows will minimize). I don't know how but it works for me, everything will load faster.

user_84805380

I also had the same issue when I installed pgAdmin 4. Server tree loading and query execution took long time than the older versions took.

I tried to change many things but the thing that worked was changing the binary path. Actually I had added the binary path of postgresql bin folder i.e. C:\Program Files\PostgreSQL\14\bin to PostgreSQL 14. I changed the that and added the path to PostgreSQL 13.

Open the preferences dialog box from 'File' in the menu bar. Then go to binary paths tab and it should look similar to this image. enter image description here

Actually PostgresSQL 14 is the latest one and it should work but I also don't know why it is not working. Maybe in the future developers will solve this issue, but for now I hope that this solution helps you.

user_134103300

I had the same problem. It turns out that the PostgreSQL binary path was pointing to $DIR/../runtime:

Screenshot

So I had to manually set the binary path, restart PgAdmin and that's it; everything works as expected.

Screenshot

user_195453050

pgAdmin 4 is just a frontend for PostgreSQL, there are around 25 front end like this that you can use for Postgre, i personally use DBeaver for PostgreSQL, i also had so many issues with pgAdmin 4, its super slow and will give you issues if you working with nodejs.

Install DBeaver and go to "NEw Database Connection> and connect with PostgreSQL

Thank you

user_188652920
user_189985100

FILE >> PREFERENCES >> BINARY PATHS :

I moved the '$DIR/runtime' path from Pg14 to Pg13.

GUI is much faster now.

user_73852280
Related