Re: [GENERAL] Tracking IO Queries

2016-07-14 Thread Jeff Janes
On Wed, Jul 13, 2016 at 3:31 PM, Patrick B wrote: > Hi all, > > I got some IO spikes on my master server. How is that diagnosed? Is it read or write or can't you tell? > But the point is that I was unable > to find the query that caused that, because the query didn't take more than > 300ms to r

[GENERAL] Tracking IO Queries

2016-07-13 Thread Patrick B
Hi all, I got some IO spikes on my master server. But the point is that I was unable to find the query that caused that, because the query didn't take more than 300ms to run (300ms is the time that my alerts are settled)... Is there any way to track those queries? Maybe with pg_stat_statement? I