On Wed, Feb 02, 2005 at 06:51:13AM -0800, TJ O'Donnell wrote: > I had thought that the Creation of the Index would do something > equivalent to Analyze. I tried Analyze Verbose and it improved > the scanner's ability to predict when an index would be useful. Create index creates an index, analyze collects statistics. Neither happens without being asked for... > Last week, I asked about visualizing B-tree "coverage". I think > I meant "Can I see the histograms that Analyze creates?" > Are they available anywhere? The docs mention them (bins) and I > was hoping Analyze Verbose would show them to me. Maybe pg_statistic? You may need the oid of the column definition to work out what goes where... Hope this helps, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment:
pgp14fcFvQh76.pgp
Description: PGP signature
