Re: reading pg_stat_activity view

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Dec 16, 2007 1:37 PM, Usama Dar <munir.usama@xxxxxxxxx> 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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux