Re: Showing Column Statistics Number - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: Showing Column Statistics Number
Date
Msg-id 20060111222138.GA88301@winnie.fuhr.org
Whole thread Raw
In response to Showing Column Statistics Number  ("Dave Dutcher" <dave@tridecap.com>)
List pgsql-performance
On Wed, Jan 11, 2006 at 04:05:18PM -0600, Dave Dutcher wrote:
> I've looked around through the docs, but can't seem to find an answer to
> this.  If I change a column's statistics with "Alter table alter column
> set statistics n", is there a way I can later go back and see what the
> number is for that column?  I want to be able to tell which columns I've
> changed the statistics on, and which ones I haven't.

pg_attribute.attstattarget

http://www.postgresql.org/docs/8.1/interactive/catalog-pg-attribute.html

--
Michael Fuhr

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Showing Column Statistics Number
Next
From: Jean-Philippe Côté
Date:
Subject: Extremely irregular query performance