pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Showing Column Statistics Number
2+ messages / 2 participants
[nested] [flat]

* Showing Column Statistics Number
@ 2006-01-11 22:05 Dave Dutcher <dave@tridecap.com>
  2006-01-11 22:21 ` Re: Showing Column Statistics Number Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Dave Dutcher @ 2006-01-11 22:05 UTC (permalink / raw)
  To: pgsql-performance

Hi,
 
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.
 
Thanks,
 
Dave

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Showing Column Statistics Number
  2006-01-11 22:05 Showing Column Statistics Number Dave Dutcher <dave@tridecap.com>
@ 2006-01-11 22:21 ` Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Fuhr @ 2006-01-11 22:21 UTC (permalink / raw)
  To: Dave Dutcher <dave@tridecap.com>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2006-01-11 22:21 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-11 22:05 Showing Column Statistics Number Dave Dutcher <dave@tridecap.com>
2006-01-11 22:21 ` Michael Fuhr <mike@fuhr.org>

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