pgstat documentation tables - Mailing list pgsql-hackers

From Magnus Hagander
Subject pgstat documentation tables
Date
Msg-id CABUevEzME09womLKmFGfXW=oxbqXH1EVW=4K16wj6w7M=8g0Mg@mail.gmail.com
Whole thread Raw
Responses Re: pgstat documentation tables  (Greg Smith <greg@2ndQuadrant.com>)
Re: pgstat documentation tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Right now we have a single table on
http://www.postgresql.org/docs/devel/static/monitoring-stats.html#MONITORING-STATS-VIEWS
that lists all our statistics views. It makes for difficult to parse
descriptions like "One row only, showing cluster-wide statistics from
the background writer: number of scheduled checkpoints, requested
checkpoints, buffers written by checkpoints and cleaning scans, and
the number of times the background writer stopped a cleaning scan
because it had written too many buffers. Also includes statistics
about the shared buffer pool, including buffers written by backends
(that is, not by the background writer), how many times those backends
had to execute their own fsync calls (normally the background writer
handles those even when the backend does its own write), total buffers
allocated, and time of last statistics reset."

I'd like to turn that into one table for each view, with two columns,
one being the name the other one being the description. That'll also
make it possible to expand on the descriptions without making it
completley unreadable, should we want to.

Comments?Objections?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: automating CF submissions (was xlog location arithmetic)
Next
From: Greg Smith
Date:
Subject: Re: IDLE in transaction introspection