From: "Mendola Gaetano" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend