Logging query plan for queries

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Logging query plan for queries

Himanshu Baweja
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 

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
Reply | Threaded
Open this post in threaded view
|

Re: Logging query plan for queries

Bruce Momjian-2
Himanshu Baweja wrote:
> 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)....

Sure, see log_min_duration_statement.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org
Reply | Threaded
Open this post in threaded view
|

Re: Logging query plan for queries

Himanshu Baweja

--- Bruce Momjian <[hidden email]> 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 

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
Reply | Threaded
Open this post in threaded view
|

Re: Logging query plan for queries

Bruce Momjian-2
Himanshu Baweja wrote:

>
> --- Bruce Momjian <[hidden email]> 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...

Oh, log _plans_ for queries over a certain duration --- we don't have
any way to support that, sorry.  In fact, at plan time we don't even
know how long it will take for the query to run.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend