Re: Index counters of statistics collector does not work

From: "Mendola Gaetano" <mendola@bigfoot.com>
Subject: Re: [HACKERS] Index counters of statistics collector does not work on 7.4devel
Date: Sun, 20 Jul 2003 15:42:29 +0200

;;; "Kenji Sugita" <sugita@srapc1327.sra.co.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.

I forgot to include a select without explain.  I found it July 15. Anyway it
works for today's version.


Kenji Sugita