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