From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Evan Martin <postgresql(at)realityexists(dot)net> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: See full query text in Server Status window |
Date: | 2012-12-04 12:25:41 |
Message-ID: | 1354623941.2079.24.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Taylor | 2012-12-04 16:56:13 | Re: Password entry in pgadmin3; pg_hba.conf vs .pgpass. Permissioning issue? |
Previous Message | Guillaume Lelarge | 2012-12-04 12:18:50 | Re: pgAdmin crashes when checking "Security of definer" |