Re: Monitor SQL Commands

Поиск
Список
Период
Сортировка
От A.Bhuvaneswaran
Тема Re: Monitor SQL Commands
Дата
Msg-id Pine.LNX.4.44.0304011500580.3691-100000@Bhuvan.bksys.co.in
обсуждение исходный текст
Ответ на Monitor SQL Commands  ("NOFINWAY" <mail@nofinway.com>)
Список pgsql-novice
> How would one go about retrieving sql commands that are being sent to the
> database.
>
> What I'm trying to do is take a look at the queries and possibly time them
> to see what is taking so long and where is it getting hung up.

If pre-7.3, below entry must be there in postgresql.conf:
debug_print_query = true

If 7.3 or above, below entries must be there in postgresql.conf:
log_statement = true
log_duration = true

regards,
bhuvaneswaran


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Crombleholme, Roy"
Дата:
Сообщение: Re: Export content of a DB
Следующее
От: "Jennifer Lee"
Дата:
Сообщение: Re: installation issues with postgresql 7.3.2