Re: Increased I/O / Writes - Mailing list pgsql-general

On Sun, May 8, 2016 at 7:07 PM, drum.lucas@gmail.com
<drum.lucas@gmail.com> wrote:
> 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
causingthat much IO? 

Take a look at this tool:

https://github.com/grayhemp/pgcookbook/blob/master/statement_statistics_collecting_and_reporting.md

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
https://github.com/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray.ru@gmail.com