Re: "Statistics" tab is very slow

Hi,

On Tue, Jan 8, 2019 at 3:59 PM Petr Fedorov <petr(dot)fedorov(at)phystech(dot)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.
>
>
>
>
>