All,
Actually, an indicator of even just what step of the query was being
executed would be very useful for checking on stuck queries. If a DBA
checks once that the query is on "bitmapscan on table_x(index_y)", and
it's still on that 15 minutes later, he/she can guess that the query is
thrashing due to HW or bad plan issues and kill it.
If the query is on "sort rowset by col1" then the DBA knows not to kill
it because it's almost done.
So, while an actual % completed indicator would be perfect, a "query
steps completed, current step =" would still be very useful and a large
improvement over what we have now.
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com