Re: Increased I/O / Writes

I had a similar problem few days ago.

Point is, I've (by mistaken), deleted a index, and this increased the table scan, increasing overall I/O.

Atenciosamente,

Edson Carlos Ericksson Richter

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