Postgres Pro
Downloads
Home   >   mailing lists

Tracking IO Queries - Mailing list pgsql-general

From Patrick B
Subject Tracking IO Queries
Date
Msg-id CAJNY3iuHtMG1kQX8C2KpdTOodgQiY95goqt9nxnPu4HYEHbNjQ@mail.gmail.com
Whole thread Raw
Responses Re: Tracking IO Queries
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Stefan Keller
Date:
Subject: FTS with more than one language in body and with unknown query language?
Next
From: Tom Lane
Date:
Subject: Re: pg_restore out of memory