Postgres Pro
Downloads
Home   >   mailing lists

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

From Cherio
Subject Sort by DB size takes a very long time
Date
Msg-id CAKHqFkKE12S9CdWXV5MjiB4vDZ7JsQ2ddSK1PvuTLZem+RMh6A@mail.gmail.com
Whole thread Raw
In response to Re: query tool csv/txt output file extension choice and encoding  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
Responses Re: Sort by DB size takes a very long time  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
List pgadmin-support
Tree view
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
Attachment

pgadmin-support by date:

Previous
From: bw
Date:
Subject: Re: i need help
Next
From: Jo Drop
Date:
Subject: pgadmin setup without /usr/pgadmin4/bin/setup-web.sh