Re: reading pg_stat_activity view - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: reading pg_stat_activity view
Date
Msg-id dcc563d10712161537m55cd0f9bt57e0e9b3fef3b428@mail.gmail.com
Whole thread Raw
In response to Re: reading pg_stat_activity view  ("Usama Dar" <munir.usama@gmail.com>)
List pgsql-admin
On Dec 16, 2007 1:37 PM, Usama Dar <munir.usama@gmail.com> wrote:
>
> >
> >
> >
> >  There wouldn't
> > be any way to just log it and still keep the query alive,
> > would there?
> >
> I think it will be a useful feature to add to postgres, for the benefit of
> DBAs, the ability to log slow queries, the queries which take more than x
> amount of time, maybe in a separate slow query log. i am sure it sounds
> familiar to a lot of people ;)

You can already log slow queries, they just go into the pgsql logs.

pgsql-admin by date:

Previous
From: "Usama Dar"
Date:
Subject: Re: pg_restore error
Next
From: "Scott Marlowe"
Date:
Subject: Re: sequence owned by backwards compatability