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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| ||||
| 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 |