On Sun, May 8, 2016 at 7:07 PM, [email protected] <[email protected]> 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 [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
