Re: tracking scripts...

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: tracking scripts...
Дата
Msg-id CALd+dcc7-UM3dkWAJzvL84mTD-DGS_65L4SK-RbBOqyNSJ7gtg@mail.gmail.com
обсуждение исходный текст
Ответ на tracking scripts...  (Joey Quinn <bjquinniii@gmail.com>)
Ответы Re: tracking scripts...
Список 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@gmail.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)?



В списке pgsql-general по дате отправления:

Предыдущее
От: Rémi Cura
Дата:
Сообщение: Re: tracking scripts...
Следующее
От: Joey Quinn
Дата:
Сообщение: Re: tracking scripts...