Tracking IO Queries

Поиск
Список
Период
Сортировка
От Patrick B
Тема Tracking IO Queries
Дата
Msg-id CAJNY3iuHtMG1kQX8C2KpdTOodgQiY95goqt9nxnPu4HYEHbNjQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Tracking IO Queries  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Hi all,

I got some IO spikes on my master server. But the point is that I was unable to find the query that caused that, because the query didn't take more than 300ms to run (300ms is the time that my alerts are settled)...

Is there any way to track those queries? Maybe with pg_stat_statement?

I'm using Postgres 9.2.

Thanks
Patrick

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

Предыдущее
От: Stefan Keller
Дата:
Сообщение: FTS with more than one language in body and with unknown query language?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore out of memory