Increased I/O / Writes

Поиск
Список
Период
Сортировка
От drum.lucas@gmail.com
Тема Increased I/O / Writes
Дата
Msg-id CAE_gQfUZSg-c_vw0gwuUvK2MpH_jRBAzyed9GWwSVUZr0vhSBQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Increased I/O / Writes  (Igor Neyman <ineyman@perceptron.com>)
Re: Increased I/O / Writes  (Edson Richter <edsonrichter@hotmail.com>)
Re: Increased I/O / Writes  (Sergey Konoplev <gray.ru@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi all,

I've recently an increase IO for writes on my DB. I'm currently using PostgreSQL 9.2.
Inline images 1

I know that much improvements can be done (as I'm using SATA disks), but my question is:

Is there a way to detect the queries that are causing that?

I can use pg_stat_statements to get the most usage queries, but I was wondering how can I find the queries that are causing that much IO?

Please, if anyone can share anything.. Thanks a lot!
Lucas
Вложения

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

Предыдущее
От: Jasim Mohd
Дата:
Сообщение: Postgres RFC3339 datetime formatting
Следующее
От: Roman Khalupa
Дата:
Сообщение: Build postgresql