From: | Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Logging query plan for queries |
Date: | 2005-06-07 08:44:12 |
Message-ID: | 20050607084412.86104.qmail@web51002.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--- Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jochem van Dieten | 2005-06-07 08:56:51 | Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2 |
Previous Message | Ilja Golshtein | 2005-06-07 08:24:25 | CHAR LIKE VARCHAR |