Re: Help writing a query to predict auto analyze

From: Gordon Shannon <gordo169(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help writing a query to predict auto analyze
Date: 2010-05-20 03:32:07
Message-ID: 28616817.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-05-20 03:45:32 Re: Help writing a query to predict auto analyze
Previous Message Scott Marlowe 2010-05-20 03:15:28 Re: Connection lost