On Sun, May 8, 2016 at 7:07 PM, drum.lucas@xxxxxxxxx <drum.lucas@xxxxxxxxx> 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 causing that 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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
