Skip site navigation (1) Skip section navigation (2)

Re: Query progress indication - an implementation

From: Scara Maccai <m_lists(at)yahoo(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Query progress indication - an implementation
Date: 2009-06-30 06:31:23
Message-ID: 197024.3126.qm@web24613.mail.ird.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> +1.  Especially if I run it a few times and I can see
> which counters
> are still moving.

Per-node percentage is easy to do (given the perfect estimates, of course).
The problem comes when you want to give an "overall" percentage.

I wouldn't know where to put that "explain-like" output though: in a column in pg_stat_get_activity??? (and it would be available only if the proper variable was "on" before sending the query)

> -1.    A counter that slowly goes from 99% to
> 99.5% done is
> much worse than a counter that takes the same much time
> going from "1000% of estimated rows done" to "2000% of
> estimated rows done".

It's not just about estimates.
Even with 100% correct estimates, IMHO there's no way to get the perfect amount of work done so far.
And this is even without considering multiple queries running at the same time...

If someone has some time to read those papers let me know what he thinks about them... because I think their methods couldn't give them those results...




      

pgsql-hackers by date

Next:From: Jeremy KerrDate: 2009-06-30 06:48:43
Subject: [PATCH 2/2 v3] [libpq] Try to avoid manually masking SIGPIPEs onevery send()
Previous:From: Peter EisentrautDate: 2009-06-30 05:33:06
Subject: 8.5 development schedule

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group