Re: Help writing a query to predict auto analyze - Mailing list pgsql-general

From Gordon Shannon
Subject Re: Help writing a query to predict auto analyze
Date
Msg-id 28616817.post@talk.nabble.com
Whole thread Raw
In response to Re: Help writing a query to predict auto analyze  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Help writing a query to predict auto analyze  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general


alvherre wrote:
>
> n_live_tup and n_dead_tup corresponds to the current numbers,
> whereas "last analysis tuples" are the values from back when the
> previous analyze ran.  These counters keep moving per updates, deletes,
> inserts, they are not static.
>
>

OK.  Do you know how can I get the values from back when the previous
analyze ran?
--
View this message in context:
http://old.nabble.com/Help-writing-a-query-to-predict-auto-analyze-tp28610247p28616817.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Connection lost
Next
From: Alvaro Herrera
Date:
Subject: Re: Help writing a query to predict auto analyze