Re: Showing Column Statistics Number

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Dave Dutcher <dave(at)tridecap(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Showing Column Statistics Number
Date: 2006-01-11 22:21:38
Message-ID: 20060111222138.GA88301@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jean-Philippe Côté 2006-01-11 22:37:24 Extremely irregular query performance
Previous Message Dave Dutcher 2006-01-11 22:05:18 Showing Column Statistics Number