| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Barry Lind <barry(at)xythos(dot)com>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, Ashley Cambrell <ash(at)freaky-namuh(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: 7.3 schedule |
| Date: | 2002-04-12 09:49:38 |
| Message-ID: | 1018604983.5365.12.camel@taru.tm.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 2002-04-11 at 22:48, Tom Lane wrote:
> Barry Lind <barry(at)xythos(dot)com> writes:
> > ...
> > Since we
> > don't currently provide any information to the user on the relative cost
> > of the parse, plan and execute phases, the end user is going to be
> > guessing IMHO.
>
> You can in fact get that information fairly easily; set
> show_parser_stats, show_planner_stats, and show_executor_stats to 1
> and then look in the postmaster log for the results.
One thing that seems to be missing is backend ids for query stats - if I
set
log_timestamp = true
log_pid = true
then I get pid for query but _not_ for stats
If I have many long-running queries then it is impossible to know which
stats are for which query ;(
----------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2002-04-12 13:20:36 | Re: numeric/decimal docs bug? |
| Previous Message | Jean-Michel POURE | 2002-04-12 09:12:28 | Disregard my last message |