Re: Ingres statdump equivalent for postgresql - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Ingres statdump equivalent for postgresql
Date
Msg-id 4C936E190200002500035962@gw.wicourts.gov
Whole thread Raw
In response to Ingres statdump equivalent for postgresql  (badair@epc-instore.com)
Responses Re: Ingres statdump equivalent for postgresql
List pgsql-admin
<badair@epc-instore.com> wrote:

> I'm looking for a tool that will enable me to dump the data
> frequency histograms for a postgresql table. This assumes of
> course that postgresql supports compilation and use of these sort
> of statistics. I've had a look through the manuals but nothing
> springs to the eye.

Did you look at the system catalogs in the documentation?  It sounds
like you want some of the information from pg_statistic in pretty
form?

http://www.postgresql.org/docs/current/interactive/catalog-pg-statistic.html

You might also want to read about the ANALYZE command.

-Kevin

pgsql-admin by date:

Previous
From: badair@epc-instore.com
Date:
Subject: Ingres statdump equivalent for postgresql
Next
From: Tom Lane
Date:
Subject: Re: Ingres statdump equivalent for postgresql