Re: How reliable are the stats collector stats?

From: Eric B(dot)Ridge <ebr(at)tcdi(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How reliable are the stats collector stats?
Date: 2004-03-14 23:06:38
Message-ID: 3FB2183C-760C-11D8-8DB5-000A95D98B3E@tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mar 13, 2004, at 1:27 AM, Eric B.Ridge wrote:

> This is good to know. I don't have specifics handy, but I've seen a
> few columns from the pg_statio_user_tables view come back w/ null
> values. Oh yeah, this is against v7.3.4.

It's the various toast_ and idx_ columns that sometimes appear null.
And they're null only for those tables that haven't toasted anything
and/or don't have indexes. This looks like normal behavior.

eric

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2004-03-14 23:09:06 Re: Sorting by numerical order
Previous Message Mike Nolan 2004-03-14 22:59:45 Re: Sorting by numerical order