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/>
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 ? |