Re: Progress bar updates

This is how netezza and teradata do it and it works very well.

In each of their cases you can see a graphical representation of the plan with progress for each stage.

For the command line it would be great to just dump the current status, which would provide a snapshot of the explain analyze.

- Luke

Sent from my GoodLink synchronized handheld (www.good.com)

-----Original Message-----
From: Csaba Nagy [mailto:nagy(at)ecircle-ag(dot)com]
Sent: Thursday, July 20, 2006 04:52 AM Eastern Standard Time
To: Andrew Hammond
Cc: postgres hackers
Subject: Re: [HACKERS] Progress bar updates

> 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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org