Re: Progress bar updates

Csaba Nagy <nagy@ecircle-ag.com>

From: Csaba Nagy <nagy@ecircle-ag.com>
To: Andrew Hammond <andrew.george.hammond@gmail.com>
Cc: postgres hackers <pgsql-hackers@postgresql.org>
Date: 2006-07-20T08:51:33Z
Lists: pgsql-hackers
> We already have EXPLAIN ANALYZE. Perhaps the right way to do this is
> something that provides similar output. I could see something that
> looks like EXPLAIN for the parts that have not yet executed, something
> reasonable to show progress of the currently active part of the plan
> (current time, rows, loops), and EXPLAIN ANALYZE output for the parts
> which have been completed.

Now this is something that would really help testing a system, by
dynamically seeing the plans of queries which run too long. That
combined with the ability to see the values of bind parameters would be
a useful debug aid.

Cheers,
Csaba.