Queries causing highest I/O load since pg_stat_reset?

From: "Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com>
To: "'Pgsql-General \(E-mail\)" <pgsql-general(at)postgresql(dot)org>
Subject: Queries causing highest I/O load since pg_stat_reset?
Date: 2005-11-14 19:59:19
Message-ID: 7F10D26ECFA1FB458B89C5B4B0D72C2B08820F@sesrv12.wirelesscar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2005-11-14 20:07:30 Re: Queries causing highest I/O load since pg_stat_reset?
Previous Message Michelle Konzack 2005-11-14 18:36:44 3 x PostgreSQL in cluster/redunant