Re: Increased I/O / Writes

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема Re: Increased I/O / Writes
Дата
Msg-id DM2PR07MB5576EE4A736CD2F0E6692A2DA710@DM2PR07MB557.namprd07.prod.outlook.com
обсуждение исходный текст
Ответ на Increased I/O / Writes  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Ответы Re: Increased I/O / Writes  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Дерево обсуждения

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of drum.lucas@gmail.com
Sent: Sunday, May 08, 2016 10:07 PM
To: Postgres General <pgsql-general@postgresql.org>
Subject: [GENERAL] Increased I/O / Writes

 

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

 

 

So, what’s wrong with using pg_stat_statements?

It has a set of columns pertaining to IO.

 

Regards,

Igor Neyman

 

Вложения

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

Предыдущее
От: John McKown
Дата:
Сообщение: Re: Postgres RFC3339 datetime formatting
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Increased I/O / Writes