Re: stored procedure stats in collector - Mailing list pgsql-patches

From Tom Lane
Subject Re: stored procedure stats in collector
Date
Msg-id 10046.1210730577@sss.pgh.pa.us
Whole thread Raw
In response to Re: stored procedure stats in collector  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: stored procedure stats in collector
Re: stored procedure stats in collector
List pgsql-patches
I wrote:
> I'm starting to look through this now,

I found another fairly big problem, which is that this stuff isn't even
going to begin to compile on Windows.

What I think we should do about that is forget tracking getrusage()'s
user/system/real time and just track elapsed time.  We have the
technology to get that in a portable fashion (cf the well-proven
instrument.c code).  Such a decision would also alleviate two of the
biggest negatives of this patch, which are the runtime overhead and
the extent to which it's going to bloat the pgstats file.

Thoughts?

            regards, tom lane

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [GENERAL] Making sure \timing is on
Next
From: Greg Smith
Date:
Subject: Re: posix advises ...