Re: How to identify which query is running - reg.

Shanmugasundaram Doraisamy wrote:
> 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