On 11/14/05, Mikael Carneholm <Mikael.Carneholm@xxxxxxxxxxxxxxx> 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 ;) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
