Re: Help writing a query to predict auto analyze

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Gordon Shannon <gordo169(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help writing a query to predict auto analyze
Date: 2010-05-19 16:26:11
Message-ID: 1274286200-sup-5365@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Excerpts from Gordon Shannon's message of mié may 19 11:49:45 -0400 2010:

> at: last analysis tuples = pg_class.reltuples ????
>
> I'm the least confident about the last one -- tuples as of last analyze.
> Can anyone confirm or correct these?

In 8.4 it's number of dead + lives tuples that there were in the previous
analyze. See pgstat_recv_analyze in src/backend/postmaster/pgstat.c.
(In 9.0 it's been reworked a bit.)
--

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scot Kreienkamp 2010-05-19 17:32:27 CIDR data type query help
Previous Message Gordon Shannon 2010-05-19 15:49:45 Help writing a query to predict auto analyze