Re: Access statistics - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Access statistics
Date
Msg-id 686.991404521@sss.pgh.pa.us
Whole thread Raw
In response to Re: Access statistics  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Access statistics  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
Jan Wieck <JanWieck@Yahoo.com> writes:
>     So outing myself not beeing a *real programmer*, this is what
>     I have so far:

Hmm ... what is the performance of all this like?  Seems like a lot
of overhead.  Can it be turned off?

>     * Backends call some collector functions  at  various  places
>       now  (these  will  finally  be macros), that count up table
>       scans, tuples returned by scans,  buffer  fetches/hits  and
>       the like.

Have you removed the existing stats-gathering support
(backend/access/heap/stats.c and so on)?   That would buy back
at least a few of the cycles involved ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: cache lookup for proc 43030134 failed
Next
From: Jan Wieck
Date:
Subject: Re: Access statistics