On Mon, Jun 11, 2007 at 07:22:24PM +0530, Nimesh Satam wrote:
> INFO: analyzing "public.cam_attr"
> INFO: "cam_attr": scanned 103 of 103 pages, containing 11829 live rows and
> 0 dead rows; 6000 rows in sample, 11829 estimated total rows
> Also how do we check if the statistics are set to Zero for the table?
SELECT attname, attstattarget
WHERE attrelid = 'public.cam_attr'::regclass
AND attnum > 0
AND NOT attisdropped;
If nobody has changed the statistics targets then they're all
probably -1. Negative attstattarget values mean to use the system
default, which you can see with:
How exactly are you determining that no statistics are showing up
for this table? Are you running a query like the following?
WHERE schemaname = 'public' AND tablename = 'cam_attr';
In response to
pgsql-performance by date
|Next:||From: Dave Cramer||Date: 2007-06-11 15:09:42|
|Subject: Re: How much ram is too much|
|Previous:||From: Nimesh Satam||Date: 2007-06-11 13:52:24|
|Subject: Re: pg_statistic doesnt contain details for specific table|