Postgres Pro
Downloads
Home   >   mailing lists

Re: Sort by DB size takes a very long time - Mailing list pgadmin-support

From Akshay Joshi
Subject Re: Sort by DB size takes a very long time
Date
Msg-id CANxoLDf3cO51GJR+fYNhcc6xYg99-gyUkWxjBz36QHSzBzTJnQ@mail.gmail.com
Whole thread Raw
In response to Sort by DB size takes a very long time  (Cherio <cherio@gmail.com>)
List pgadmin-support
Tree view

On Sat, Feb 13, 2021 at 1:35 AM Cherio <cherio@gmail.com> wrote:
There seems to be a "suboptimal" implementation of the "Statistics" page when it comes to sorting. I experienced it when sorting by DB "Size" field but it looks like the problem to a lesser extent exists when sorting by other fields as well.

Steps to reproduce:
1. Click on the "Databases" node; it should have multiple databases to work
2. Select "statistics" tab
3. Click to sort on the "Size" column

In my case it took about 40 seconds to sort 13 databases, including "postgres" DB
image.png


--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246

Attachment

pgadmin-support by date:

Previous
From: Akshay Joshi
Date:
Subject: Re: pgAdmin 4 v4.30 released
Next
From: Jo Drop
Date:
Subject: Re: pgadmin setup without /usr/pgadmin4/bin/setup-web.sh