Re: See full query text in Server Status window

<div class="moz-cite-prefix">You're right, the third button does exactly what I want, I just didn't know about it -
thanks.<br/><br /> I was looking in the main menu or context menu for this. I think it's unusual for an application to
offersome command <i>only</i> from a toolbar. Cancel Query and Terminate Backend also seem to be in this category. Are
thereshortcut keys for them? If not, that would be very useful.<br /><br /> Regards,<br /><br /> Evan<br /><br /> On
4/12/201211:25 PM, Guillaume Lelarge wrote:<br /></div><blockquote
cite="mid:1354623941.2079.24.camel@localhost.localdomain"type="cite"><pre wrap="">On Mon, 2012-12-03 at 21:53 +1100,
EvanMartin wrote:
 
</pre><blockquote type="cite"><pre wrap="">Is there any way to get the full query text for a given process in the 
Server Status window? The Query column shows the start of it, so I 
presume pgAdmin has the whole thing, but is not showing it. If it's not 
currently possible please add it! Something like a "copy query to 
clipboard" context menu option or, even better, "open query in new query 
window" (which would automatically connect to the same database as well).

</pre></blockquote><pre wrap="">
The latter already exists: third button in the toolbar (starting from
the left). But remember that pgAdmin only gets what PostgreSQL gives it.
What I mean is that PostgreSQL truncates the query to the 1024 first
characters in old releases. In more recent releases (8.4 I think, but I
may be wrong), you have the track_activity_query_size GUC to change the
maximum size of a query.


</pre></blockquote><br />