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

Em 08/05/2016 23:07, drum(dot)lucas(at)gmail(dot)com escreveu:
> 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