Обсуждение: Server Status window issue
<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>
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