Re: Increased I/O / Writes

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of drum(dot)lucas(at)gmail(dot)com
Sent: Sunday, May 08, 2016 10:07 PM
To: Postgres General <pgsql-general(at)postgresql(dot)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