Search Postgresql Archives

Tracking IO Queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Tracking IO Queries
From: Patrick B <patrickbakerbr@xxxxxxxxx>
Date: Thu, 14 Jul 2016 10:31:56 +1200

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Tracking IO Queries
  - From: Jeff Janes

Prev by Date: FTS with more than one language in body and with unknown query language?
Next by Date: Re: pg_restore out of memory
Previous by thread: FTS with more than one language in body and with unknown query language?
Next by thread: Re: Tracking IO Queries
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux