Re: Long running query: How to monitor the progress

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Long running query: How to monitor the progress
Дата
Msg-id 19480.1440510642@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Long running query: How to monitor the progress  (Johann Spies <johann.spies@gmail.com>)
Список pgsql-performance
Johann Spies <johann.spies@gmail.com> writes:
> Some of hour queries to extract the data and insert it in other tables runs
> for days and in one case we have created a table with 758million unique
> records.

> Now my question. Is there a way to monitor the progress of a long running
> query like this?

You could watch how fast the target table is physically growing, perhaps.
Or I think contrib/pgstattuple could be used to count uncommitted tuples
in it.

            regards, tom lane


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

Предыдущее
От: Henrik Thostrup Jensen
Дата:
Сообщение: Gist indexing performance with cidr types
Следующее
От: Emre Hasegeli
Дата:
Сообщение: Re: Gist indexing performance with cidr types