Hi Jim, On 10/18/06, Jim C. Nasby [EMAIL PROTECTED] wrote:
Also how many times a relation has been vacuumed (which puts all theother numbers in more perspective... good catch Simon). And I thinknumber of pages that could not be added to the FSM would also beextremely valuable.
By the above, do
On Thu, Oct 19, 2006 at 04:10:46PM +0530, NikhilS wrote:
Hi Jim,
On 10/18/06, Jim C. Nasby [EMAIL PROTECTED] wrote:
Also how many times a relation has been vacuumed (which puts all the
other numbers in more perspective... good catch Simon). And I think
number of pages that could not be
Jim C. Nasby [EMAIL PROTECTED] writes:
BTW, if we add these counters we'll be up to 7 stats dealing with vacuum
and analyze, and NikhilS has a patch we're finalizing that would add 3
more. Right now there's 4 slated to go into pg_stat_* in 8.2, but maybe
we should have a separate view for
On Thu, Oct 19, 2006 at 11:47:53AM -0400, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
BTW, if we add these counters we'll be up to 7 stats dealing with vacuum
and analyze, and NikhilS has a patch we're finalizing that would add 3
more. Right now there's 4 slated to go into
Also how many times a relation has been vacuumed (which puts all the
other numbers in more perspective... good catch Simon). And I think
number of pages that could not be added to the FSM would also be
extremely valuable.
On Wed, Oct 18, 2006 at 11:27:39AM +0530, NikhilS wrote:
Hi,
So:
On Sat, 2006-10-14 at 11:32 +0530, NikhilS wrote:
On 10/13/06, Jim C. Nasby [EMAIL PROTECTED] wrote:
I'm also not sure if this metric is what you actually want,
since a
single page can be returned many times from the FSM even
between
vacuums.
Hi,
So:
heap_blks_reused (with Jim's semantics), heap_blks_extend,
heap_blks_truncate are the interesting stats? Will try to work up a
patch for this.
Regards,
Nikhils
EnterpriseDB http://www.enterprisedb.com
On 10/15/06, Simon Riggs [EMAIL PROTECTED] wrote:
On Sat, 2006-10-14 at 11:32 +0530,
Hi Jim,
On 10/13/06, Jim C. Nasby [EMAIL PROTECTED] wrote:
On Fri, Oct 13, 2006 at 06:17:47PM +0530, NikhilS wrote: Currently a select * from pg_statio_user_tables; displays only
heap_blks_read, heap_blks_hit stats amongst others for the main relation. It would be good to have the following stats
On Fri, Oct 13, 2006 at 06:17:47PM +0530, NikhilS wrote:
Currently a select * from pg_statio_user_tables; displays only
heap_blks_read, heap_blks_hit stats amongst others for the main relation. It
would be good to have the following stats collected too. I think these stats
can be used to