Hi all,
I've recently an increase IO for writes on my DB. I'm currently using PostgreSQL 9.2.
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
