Group: pgsql.admin


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