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]