* 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
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
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.
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. To get
more information about these queries, I'm writing a utility to take
snapshots of pg_stat_a