Re: [PERFORM] investigating slow queries through pg_stat_activity

2005-07-03 Thread Enrico Weigelt
* Dan Harris <[EMAIL PROTECTED]> wrote: Hi, > I've got some queries generated by my application that will, for some > reason, run forever until I kill the pid. Yet, when I run the > queries manually to check them out, they usually work fine. If you can change your application, you could t

Re: [PERFORM] investigating slow queries through pg_stat_activity

2005-06-20 Thread George Essig
On 6/20/05, Dan Harris <[EMAIL PROTECTED]> wrote: > Also, I'm sure some people will respond with "turn on query > logging".. I've explored that option and the formatting of the log > file and the fact that EVERY query is logged is not what I'm after > for this project. You don't have to log ever

Re: [PERFORM] investigating slow queries through pg_stat_activity

2005-06-20 Thread Tom Lane
Dan Harris <[EMAIL PROTECTED]> writes: > However, the problem I have is that pg_stat_activity only returns the > first n (255?) characters of the SQL as "current_query", so it gets > chopped off at the end. I would very much like to find out how I can > get the *entire* query that is active.