Home > mailing lists

Vacuum analyze verbose output - Mailing list pgsql-general

From	Anjali Arora
Subject	Vacuum analyze verbose output
Date	December 19, 2012 12:14:36
Msg-id	1355908467.26009.YahooMailClassic@web192204.mail.sg3.yahoo.com Whole thread Raw
Responses	Re: Vacuum analyze verbose output (Albe Laurenz <laurenz.albe@wien.gv.at>) Re: Vacuum analyze verbose output (Glyn Astill <glynastill@yahoo.co.uk>)
List	pgsql-general

Hi all,

I ran following command on 8.2.2 postgresql:

psql -p port dbname -c "vacuum analyze verbose"

last few lines from "vacuum analyze verbose" output:

DETAIL: A total of 2336 page slots are in use (including overhead).

2336 page slots are required to track all free space.

Current limits are: 153600 page slots, 1000 relations, using 965 kB.

After upgrade to postgresql 9.0.4 I am not getting this output as the part of "vacuum analyze verbose" output.

Can anybody please let me know where can I find this information in postgresql 9.0.4.

Thanks,

Anjali

From: Albe Laurenz
Date: 19 December 2012, 12:00:04
Subject: Re: evaluating expressions stored in table

From: Albe Laurenz
Date: 19 December 2012, 12:49:47
Subject: Re: Vacuum analyze verbose output