Postgres Pro
Downloads
Home   >   mailing lists

Queries causing highest I/O load since pg_stat_reset? - Mailing list pgsql-general

From Mikael Carneholm
Subject Queries causing highest I/O load since pg_stat_reset?
Date
Msg-id 7F10D26ECFA1FB458B89C5B4B0D72C2B08820F@sesrv12.wirelesscar.com
Whole thread Raw
Responses Re: Queries causing highest I/O load since pg_stat_reset?  (Jaime Casanova <systemguards@gmail.com>)
Re: Queries causing highest I/O load since pg_stat_reset?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-general
Tree view 
Hi,

is it possible to retrieve a list of queries that has caused the highest i/o load? Something like

(1) select pg_stat_reset();
(2) run some queries for a while
(3) list the queries that caused the highest i/o since step (1)

?

/Mikael

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug with index-usage?
Next
From: Jaime Casanova
Date:
Subject: Re: Queries causing highest I/O load since pg_stat_reset?