Re: Increased I/O / Writes

On 05/10/2016 09:50 AM, Igor Neyman wrote:

> 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.
>

You could use iotop to determine which postgres pid is eating the IO,
then use statement logging with PID (or pg_stat_activity/statement) to
see what the system is actually doing.

JD


> Regards,
>
> Igor Neyman
>


--
Command Prompt, Inc.                  http://the.postgres.company/
                         +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.