| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Usama Dar" <munir(dot)usama(at)gmail(dot)com> |
| Cc: | "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: reading pg_stat_activity view |
| Date: | 2007-12-16 23:37:48 |
| Message-ID: | dcc563d10712161537m55cd0f9bt57e0e9b3fef3b428@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Dec 16, 2007 1:37 PM, Usama Dar <munir(dot)usama(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2007-12-16 23:42:55 | Re: sequence owned by backwards compatability |
| Previous Message | Aldor | 2007-12-16 20:07:40 | Re: autovacuum running even when not set in config? |