On 11/14/05, Mikael Carneholm <Mikael(dot)Carneholm(at)wirelesscar(dot)com> wrote:
> 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
>
select * from pg_stat_activity;
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)