Re: Logging SQL queries?
От | Phil Geer |
---|---|
Тема | Re: Logging SQL queries? |
Дата | |
Msg-id | 001c01c22d4b$56e8a700$4ac16dd8@offback2000 обсуждение исходный текст |
Ответ на | Logging SQL queries? (Steve Lane <slane@fmpro.com>) |
Ответы |
Re: Logging SQL queries?
|
Список | pgsql-general |
SET DEBUG_PRINT_QUERY TO 1 it might be SET DEBUG_PRINT_QUERY TO ON Had to do this a couple weeks back to debug something. That should work it'll print your queries to the standard log file but the experts may have a way to get it into another file for you. Good Luck Phil ----- Original Message ----- From: "Steve Lane" <slane@fmpro.com> To: "PostgreSQL General Mailing List" <pgsql-general@postgresql.org> Sent: Tuesday, July 16, 2002 11:40 PM Subject: [GENERAL] Logging SQL queries? > Hello all: > > I want to do some profiling of a large application I run under postgres. > Ideally I'd like to capture just the queries that are submitted to the > database. It would be rather annoying to have to log them from the > application layer, so I'm hoping there's some suitable log-level setting on > the back end that can do this. Something that could log only the queries to > a different specific file would be excellent, but any flavor of this would > be good. > > Thanks, > > steve > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > >
В списке pgsql-general по дате отправления: