Server Status window issue

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Server Status window issue
Date: 2013-01-03 16:11:31
Message-ID: B75CD08C73BD3543B97E4EF3964B7D701F1031F0@CITESMBX1.ad.uillinois.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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]<http://illinois.edu/>

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Robert Klaus 2013-01-03 19:43:41 Large number of rows in pg_type and slow gui (pgadmin) refresh
Previous Message Thomas Joseph 2013-01-03 05:25:22 pgAdmin3 NO INHERIT syntax error ?