| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Joey Quinn <bjquinniii(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: tracking scripts... |
| Date: | 2013-11-26 16:20:11 |
| Message-ID: | CALd+dcc7-UM3dkWAJzvL84mTD-DGS_65L4SK-RbBOqyNSJ7gtg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Connect to the DB and run "select * from pg_stat_activity" to see what
specific query your other connection is running. Then find that in your
file to see how far it has progressed.
I hope you profiled your queries to make sure they run fast before you
started. :)
On Tue, Nov 26, 2013 at 10:28 AM, Joey Quinn <bjquinniii(at)gmail(dot)com> wrote:
> I have a fairly large table (4.3 billion rows) that I am running an update
> script on (a bit over 127 thousand individual update queries). I am using
> the gui. It has been running for about 24 hours now. Is there any good way
> to gauge progress (as in, how many of the individual update queries have
> finished)?
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joey Quinn | 2013-11-26 17:11:22 | Re: tracking scripts... |
| Previous Message | Rémi Cura | 2013-11-26 16:16:08 | Re: tracking scripts... |