Thread: "Statistics" tab is very slow
Hello, I'm using pgAdmin 4 version 3.6 on Centos 7, Postgresql 10.6 runs on the same machine. I use local connections. Almost everything works fine except for 'Statistics' tab when viewing pgAgent job log. It takes 60-90 seconds to load, the whole pgAdmin4 is frozen during the load, Firefox shows yellow bar suggesting to stop slowly running tab. Deleting job log entries (leaving few dozens) has little impact. Can it be fixed somehow? P.S. Sometimes opening Query Tool is also slow (15-20 seconds to connect) or is not able to connect at all. But closing it and opening again always works fine.
Hi,
On Tue, Jan 8, 2019 at 3:59 PM Petr Fedorov <petr.fedorov@phystech.edu> wrote:
Hello,
I'm using pgAdmin 4 version 3.6 on Centos 7, Postgresql 10.6 runs on the
same machine. I use local connections.
Almost everything works fine except for 'Statistics' tab when viewing
pgAgent job log. It takes 60-90 seconds to load, the whole pgAdmin4 is
frozen during the load, Firefox shows yellow bar suggesting to stop
slowly running tab. Deleting job log entries (leaving few dozens) has
little impact.
This has already been reported. Please check the RM #3664 https://redmine.postgresql.org/issues/3664
Can it be fixed somehow?
P.S. Sometimes opening Query Tool is also slow (15-20 seconds to
connect) or is not able to connect at all. But closing it and opening
again always works fine.
This has already been fixed. https://redmine.postgresql.org/issues/3679
You will get this fix in the next release which is very soon.
Hi,
On Tue, Jan 8, 2019 at 3:59 PM Petr Fedorov <petr.fedorov@phystech.edu> wrote:
Hello,
I'm using pgAdmin 4 version 3.6 on Centos 7, Postgresql 10.6 runs on the
same machine. I use local connections.
Almost everything works fine except for 'Statistics' tab when viewing
pgAgent job log. It takes 60-90 seconds to load, the whole pgAdmin4 is
frozen during the load, Firefox shows yellow bar suggesting to stop
slowly running tab. Deleting job log entries (leaving few dozens) has
little impact.
Can it be fixed somehow?
For now as a work around you can also limit the numder of rows using preference dialog.
File -> Preference -> Browser -> Properties -> 'Maximum job history rows' to some small number.
--
Murtuza
P.S. Sometimes opening Query Tool is also slow (15-20 seconds to
connect) or is not able to connect at all. But closing it and opening
again always works fine.
On Wed, 9 Jan 2019, 19:00 Petr Fedorov <petr.fedorov@phystech.edu wrote:
Thanks - it helped!
Please keep the support mail group in the loop.
Thanks,
Murtuza
09.01.2019 15:42, Murtuza Zabuawala пишет:Hi,On Tue, Jan 8, 2019 at 3:59 PM Petr Fedorov <petr.fedorov@phystech.edu> wrote:Hello,
I'm using pgAdmin 4 version 3.6 on Centos 7, Postgresql 10.6 runs on the
same machine. I use local connections.
Almost everything works fine except for 'Statistics' tab when viewing
pgAgent job log. It takes 60-90 seconds to load, the whole pgAdmin4 is
frozen during the load, Firefox shows yellow bar suggesting to stop
slowly running tab. Deleting job log entries (leaving few dozens) has
little impact.
Can it be fixed somehow?For now as a work around you can also limit the numder of rows using preference dialog.File -> Preference -> Browser -> Properties -> 'Maximum job history rows' to some small number.--Murtuza
P.S. Sometimes opening Query Tool is also slow (15-20 seconds to
connect) or is not able to connect at all. But closing it and opening
again always works fine.