Postgres Pro
Downloads
Home   >   mailing lists

Thread: Server Status window issue

Server Status window issue

From
"Campbell, Lance"
Date:
<div class="WordSection1"><p class="MsoNormal">PostgreSQL 9.2.2<p class="MsoNormal">pgAdmin 1.16.1<p
class="MsoNormal">pgAdmin> Tools > Server Status<p class="MsoNormal"> <p class="MsoNormal">When viewing the
ServerStatus window I notice that my queries look like this:<p class="MsoNormal"> <p class="MsoNormal">SELECT * FROM
tablexWHERE id=$1<p class="MsoNormal"> <p class="MsoNormal">How can I display the full query without the $1?  <p
class="MsoNormal"> <pclass="MsoNormal">Example of what I would like to see:<p class="MsoNormal"> <p
class="MsoNormal">SELECT* FROM tablex where id=75<p class="MsoNormal"> <p class="MsoNormal">I would assume this is some
kindof setting within the PostgreSQL database log configuration.  But I am at a loss on what I need to set in order to
havethe parameters populated.<p class="MsoNormal"> <p class="MsoNormal">Thanks for your help.  This is an amazing
tool. I used it just today to identify an issue.  Because I could not see the $1 value I was only able to solve part of
theissue.  If I could see the full query that would allow me to zero in directly to the issue.<p class="MsoNormal"> <p
class="MsoNormal">Thanksagain for the great tool,<p class="MsoNormal"> <p class="MsoNormal">Lance Campbell<p
class="MsoNormal">SoftwareArchitect<p class="MsoNormal">Web Services at Public Affairs<p
class="MsoNormal">217-333-0382<pclass="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a
href="http://illinois.edu/"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue;text-decoration:none"><imgalt="University of
Illinoisat Urbana-Champaign logo" border="0" height="33" id="Picture_x0020_1" src="cid:image003.png@01CDE99A.B35EEAF0"
width="195"/></span></a><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue"></span><p
class="MsoNormal"> <pclass="MsoNormal"> </div>

Re: Server Status window issue

From
Guillaume Lelarge
Date:
On Thu, 2013-01-03 at 16:11 +0000, Campbell, Lance wrote:
> PostgreSQL 9.2.2
> pgAdmin 1.16.1
> pgAdmin > Tools > Server Status
> 
> When viewing the Server Status window I notice that my queries look like this:
> 
> SELECT * FROM tablex WHERE id=$1
> 
> How can I display the full query without the $1?
> 

Is it in the activity pane? I don't think so. I would bet it is in the
log pane, right?

> Example of what I would like to see:
> 
> SELECT * FROM tablex where id=75
> 
> I would assume this is some kind of setting within the PostgreSQL database log configuration.  But I am at a loss on
whatI need to set in order to have the parameters populated.
 
> 

If it is in the log pane (which means it is in you log files), there's
no setting that will replace $1 with the runtime value. IIRC, you have
the actual value below in recent releases.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com