Re: How to identify which query is running - reg. - Mailing list pgsql-general

From Richard Huxton
Subject Re: How to identify which query is running - reg.
Date
Msg-id 411B283A.3050100@archonet.com
Whole thread Raw
In response to Re: How to identify which query is running - reg.  (Shanmugasundaram Doraisamy <shan@ceedees.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: [pgsql-hackers-win32] error moving table to tablespace
Next
From: Richard Huxton
Date:
Subject: Re: Clustering, mirroriing, or replication?