Thread: No indication of activity during count

I verified the following is still happening in 1.8.  If I right click a 
large table (7 million rows) and then select "Count", pgAdmin gives no 
indication that it is busy.  In my case, this count takes about 45 
seconds to complete.  I use a trick I learned with Toad years ago: if 
you move the window, the menu bar does not refresh and hence turns a 
solid white.  When the query completes, the menu reappears.

But I'm not asking for the menu bar to be addressed.  Rather, I'd like 
some indicator that shows pgAdmin is busy.  The obvious choice would be 
to update the elapsed time counter in the bottom right corner.

Thanks for a great admin tool.

-- 
Guy Rouillier

Guy Rouillier wrote:
> I verified the following is still happening in 1.8.  If I right click a
> large table (7 million rows) and then select "Count", pgAdmin gives no
> indication that it is busy.  In my case, this count takes about 45
> seconds to complete.  I use a trick I learned with Toad years ago: if
> you move the window, the menu bar does not refresh and hence turns a
> solid white.  When the query completes, the menu reappears.
> 
> But I'm not asking for the menu bar to be addressed.  Rather, I'd like
> some indicator that shows pgAdmin is busy.  The obvious choice would be
> to update the elapsed time counter in the bottom right corner.
> 
> Thanks for a great admin tool.
> 

Thanks - I've added a status bar message and busy cursor whilst counting
is happening.

Regards, Dave.