From: | Evan Martin <postgresql(at)realityexists(dot)net> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: See full query text in Server Status window |
Date: | 2012-12-05 08:28:43 |
Message-ID: | 50BF05BB.8060809@realityexists.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
You're right, the third button does exactly what I want, I just didn't
know about it - thanks.
I was looking in the main menu or context menu for this. I think it's
unusual for an application to offer some command /only/ from a toolbar.
Cancel Query and Terminate Backend also seem to be in this category. Are
there shortcut keys for them? If not, that would be very useful.
Regards,
Evan
On 4/12/2012 11:25 PM, Guillaume Lelarge wrote:
> On Mon, 2012-12-03 at 21:53 +1100, Evan Martin wrote:
>> 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).
>>
> 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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-12-05 09:01:53 | Re: See full query text in Server Status window |
Previous Message | Guillaume Lelarge | 2012-12-05 08:13:15 | Re: Retina display support |