From: | Kenji Sugita <sugita(at)srapc1327(dot)sra(dot)co(dot)jp> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Index counters of statistics collector does not work |
Date: | 2003-07-20 14:38:46 |
Message-ID: | 20030720.233846.74735149.sugita@srapc1327.sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
From: "Mendola Gaetano" <mendola(at)bigfoot(dot)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(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.
I forgot to include a select without explain. I found it July 15. Anyway it
works for today's version.
Kenji Sugita
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-07-20 17:42:14 | Re: compile failure |
Previous Message | Mendola Gaetano | 2003-07-20 13:42:29 | Re: Index counters of statistics collector does not work on 7.4devel |