Re: Index counters of statistics collector does not work on 7.4devel

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>, "Kenji Sugita" <sugita(at)srapc1327(dot)sra(dot)co(dot)jp>
Subject: Re: Index counters of statistics collector does not work on 7.4devel
Date: 2003-07-20 13:42:29
Message-ID: 0c8101c34ec4$c3f53750$10d4a8c0@mm.eutelsat.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Kenji Sugita" <sugita(at)srapc1327(dot)sra(dot)co(dot)jp> wrote:
> =# explain select * from class1 where id = 1234;
> QUERY PLAN
> ----------------------------------------------------------------------
--------
> Index Scan using class1_id_index on class1 (cost=0.00..3.01 rows=2
width=4)
> Index Cond: (id = 1234)
> (2 rows)

I don't think that the select is really performed, try the same experiment
but doing
explain analyze instead.

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kenji Sugita 2003-07-20 14:38:46 Re: Index counters of statistics collector does not work
Previous Message Kenji Sugita 2003-07-20 13:12:39 Index counters of statistics collector does not work on 7.4devel