Re: reading pg_stat_activity view - Mailing list pgsql-admin

From Usama Dar
Subject Re: reading pg_stat_activity view
Date
Msg-id ff0e67090712161137iacf9abfv41d13b2fe131c6e1@mail.gmail.com
Whole thread Raw
In response to Re: reading pg_stat_activity view  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
Responses Re: reading pg_stat_activity view  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: reading pg_stat_activity view  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin

 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 ;)



--
Usama Munir Dar http://linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar

pgsql-admin by date:

Previous
From: "Usama Dar"
Date:
Subject: Re: pg_hba.conf is driving me nuts
Next
From: olivier boissard
Date:
Subject: Re: pg_hba.conf is driving me nuts