From: Michael Fuhr <mike@fuhr.org>
To: Dave Dutcher <dave@tridecap.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Showing Column Statistics Number
Date: Wed, 11 Jan 2006 15:21:38 -0700
Message-ID: <20060111222138.GA88301@winnie.fuhr.org> (raw)
In-Reply-To: <020101c616fb$1c4f9de0$8300a8c0@tridecap.com>
References: <020101c616fb$1c4f9de0$8300a8c0@tridecap.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mike@fuhr.org, dave@tridecap.com
Subject: Re: Showing Column Statistics Number
In-Reply-To: <20060111222138.GA88301@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox