Subject: reading pg_stat_activity view
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 12/16/2007 6:57:07 PM
"Usama Dar" <munir.usama@gmail.com> writes:
> 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 ;)
See log_min_duration_statement
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|