Sort by DB size takes a very long time

From: Cherio <cherio(at)gmail(dot)com>
To: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Sort by DB size takes a very long time
Date: 2021-02-12 20:05:07
Message-ID: CAKHqFkKE12S9CdWXV5MjiB4vDZ7JsQ2ddSK1PvuTLZem+RMh6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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: image.png]

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Jo Drop 2021-02-13 12:10:51 pgadmin setup without /usr/pgadmin4/bin/setup-web.sh
Previous Message bw 2021-02-12 12:41:57 Re: i need help