Обсуждение: SET STATISTICS value recorded where?

Поиск
Список
Период
Сортировка

SET STATISTICS value recorded where?

От
Jeff Boes
Дата:
When you do this to a table:

 ALTER TABLE foobar ALTER COLUMN blah SET STATISTICS 10000;

Where would you find the resulting value in a pg_* table? I'm sure it
gets recorded somewhere.

In other words, how can I pull out the SET STATISTICS settings from an
existing schema?

--
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise

Re: SET STATISTICS value recorded where?

От
Tom Lane
Дата:
Jeff Boes <jboes@nexcerpt.com> writes:
> When you do this to a table:
>  ALTER TABLE foobar ALTER COLUMN blah SET STATISTICS 10000;
> Where would you find the resulting value in a pg_* table? I'm sure it
> gets recorded somewhere.

pg_attribute.attstattarget

            regards, tom lane