Logging query plan for queries

Поиск
Список
Период
Сортировка
От Himanshu Baweja
Тема Logging query plan for queries
Дата
Msg-id 20050606162944.6686.qmail@web51006.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Logging query plan for queries  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
when i enable debug_print_plan and
debug_pretty_print...
query plans are written to log file for all
queries....(3 gb of logs in 3 mins) which is of course
diffcult to analyze and consume too much resources....

is it possible to log plans for only the queries whose
duration was more than a particular value or something
like that... (e.g. log_min_duration_statement)....

thx
Himanshu

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: postgresql books
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Logging query plan for queries