Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

monitoring postgresql query

Status
Not open for further replies.

sbraaa

Programmer
Oct 7, 2002
3
IT
I'm using postgresql 6.5.3 and i need to monitoring querys executed by user but i don't know who.
I try to enable log files at postmaster startup but the information write to log file aren't that useful... (i could get this infos just using 'top' or 'ps -ef | grep postmaster').
So i had installed pg_monitor but the infos are the same... All i want to know is the statement of the query launched by a specific user (something like user -> "select * from mytable..." ).
Exists any tool that could solve this problem? I think about upgrading postgresql to a recent release but i can't do it because i need to test our application before do this.. anyways i look the postgresql manual of 7.3 and i don't see any new feature relate to my problem... (but this could not be true... :) )
So anyone knows ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top