Tracking IO Queries

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Tracking IO Queries
Date: 2016-07-13 22:31:56
Message-ID: CAJNY3iuHtMG1kQX8C2KpdTOodgQiY95goqt9nxnPu4HYEHbNjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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'm using Postgres 9.2.

Thanks
Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-07-13 22:42:51 Re: pg_restore out of memory
Previous Message Stefan Keller 2016-07-13 22:16:21 FTS with more than one language in body and with unknown query language?