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?

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 what I need to set in order to have the 
parameters populated.

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 the issue.  If I could see the full query that would allow me to 
zero in directly to the issue.

Thanks again for the great tool,

Lance Campbell
Software Architect
Web Services at Public Affairs
217-333-0382
[University of Illinois at Urbana-Champaign logo]<http://illinois.edu/>


<<inline: image003.png>>

Reply via email to