Re: Logging query plan for queries

Поиск
Список
Период
Сортировка
От Himanshu Baweja
Тема Re: Logging query plan for queries
Дата
Msg-id 20050607084412.86104.qmail@web51002.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Logging query plan for queries  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Logging query plan for queries  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
--- Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> > 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)....
>
> Sure, see log_min_duration_statement.

i think bruce u got my question wrong...
log_min_duration_statement will log only the queries
which are longer than a particular value... and if i
turn debug_print_plan.... it will log plans for all
the queries irrespective of the value of
log_min_duration_statement...
that is wht my testing says....

plz point out if i am wrong...
and also... is there any way of logging plans for only
a part of queries which satisfy a particular duration
criteria...

thx
Himanshu

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

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

Предыдущее
От: "Ilja Golshtein"
Дата:
Сообщение: CHAR LIKE VARCHAR
Следующее
От: Jochem van Dieten
Дата:
Сообщение: Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2