| From: | mlw <markw(at)mohawksoft(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Yet more logging questions |
| Date: | 2001-12-02 15:45:13 |
| Message-ID: | 3C0A4C89.E2B97ADE@mohawksoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
>
> mlw <markw(at)mohawksoft(dot)com> writes:
> > I was wondering if there was a way to log the "explain" of a query.
>
> Being a NOTICE, it *is* logged.
Sorry, I didn't make my intentions clear. I mean as a function of normal query
operation.
The debug_print_plan is VERY verbose. Is there an option which does the
equivilent of an EXPLAIN on a submitted query?
For instance, I would like to be able to do something like this:
debug_print_query = true
debug_print_explain = true #my own fictional directive
show_query_stats = true
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mlw | 2001-12-02 16:04:36 | configuration files and PGDATA variable |
| Previous Message | matthew green | 2001-12-02 15:32:15 | Re: Second call for platform testing |