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.  Is this possible?

I think the limit is ~1000 characters in 8.0 and later.  However, you
can't realistically have "unlimited" because of constraints of the stats
messaging mechanism.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to