Re: Configurable Additional Stats

Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> One way to accomplish the original goal by using the stats
> aggregation/reporting infrastructure directly would be to add a stats_domain
> guc which stats messages get tagged with. So you could have each application
> domain set the guc to a different value and have the stats collector keep
> table stats separately for each stats_domain/table pair.

> That could be interesting for other purposes such as marking a single
> transaction with a new stats_domain so you can look at the stats for
> just that transaction.

Hmm. That has some possibilities. You'd want a way to get the stats
collector to discard a domain when you didn't want those numbers
anymore, but that seems doable enough. Also, most likely you'd want
the collector to keep both "global" and per-domain counters, else
resetting a domain loses state --- which'd be bad from autovac's
point of view, if nothing else.

regards, tom lane