Unix Technical Forum

see all queries incoming

This is a discussion on see all queries incoming within the pgsql Admins forums, part of the PostgreSQL category; --> How can I see, such as MSSQL screen, all queries that are processing in real time? I want to ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Admins

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 06:11 AM
=?ISO-8859-1?Q?Fl=E1vio?= Brito
 
Posts: n/a
Default see all queries incoming

How can I see, such as MSSQL screen, all queries that are processing in
real time?

I want to monitor all the queries that are being processed by a user in
real time.

Thanks

Flavio



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 06:11 AM
Michael Fuhr
 
Posts: n/a
Default Re: see all queries incoming

On Sun, Aug 28, 2005 at 08:49:13AM -0300, Flávio Brito wrote:
> How can I see, such as MSSQL screen, all queries that are processing in
> real time?


You can configure the backend to log the queries it receives; for
more information see "Error Reporting and Logging" in the "Server
Run-time Environment" chapter of the documentation. Here's a link
to the documentation for the latest version of PostgreSQL:

http://www.postgresql.org/docs/8.0/s...CONFIG-LOGGING

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:57 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com