Server Status window issue - Mailing list pgadmin-support

From Campbell, Lance
Subject Server Status window issue
Date
Msg-id B75CD08C73BD3543B97E4EF3964B7D701F1031F0@CITESMBX1.ad.uillinois.edu
Whole thread Raw
Responses Re: Server Status window issue
List pgadmin-support

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

 

 

pgadmin-support by date:

Previous
From: Thomas Joseph
Date:
Subject: pgAdmin3 NO INHERIT syntax error ?
Next
From: "Robert Klaus"
Date:
Subject: Large number of rows in pg_type and slow gui (pgadmin) refresh