Dear Richard,
Thankyou for you immediate reply, I did set the stats_command_string=true and tried select * from pg_stat_activity;
It gave me the desired result. In the mean while you had mentioned about reading the monitoring activity chapter. Please tell me where I could find it ( the website address). Thanking you,
All the manuals are online at http://www.postgresql.org/docs/
If you're running version 7.4 you'll want "Chapter 23. Monitoring Database Activity"
You probably have a copy on your server too. Where depends on how you installed, but the RedHat RPMs put documents in /usr/share/doc/...
Also, you'll want: http://techdocs.postgresql.org/ Various user-submitted notes and guides. http://www.postgresql.org/lists.html Mailing list archives (especially check the announcements list) http://www.varlena.com/GeneralBits/ Elein's journal, with contributions from other community members.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
