> > > On Oct 7, 2013, at 11:34, Toni Helenius
> > >
> > > wrote:
> > >
> > > > Hi,
> > > >
> > > > yes, I'm cheating by using GUI :) (PgAdmin)
> > >
> > > Please do not top-post.
> > >
> >
> > On Oct 7, 2013, at 11:34, Toni Helenius
> >
> > wrote:
> >
> > > Hi,
> > >
> > > yes, I'm cheating by using GUI :) (PgAdmin)
> >
> > Please do not top-post.
> >
> > Analyze is an entirely different command tha
> On Oct 7, 2013, at 11:34, Toni Helenius
> wrote:
>
> > Hi,
> >
> > yes, I'm cheating by using GUI :) (PgAdmin)
>
> Please do not top-post.
>
> Analyze is an entirely different command than Explain analyze. Analyze
> updates the statistics o
oops=1)"
"Total runtime: 2912.211 ms"
-Original Message-
From: Alban Hertroys [mailto:haram...@gmail.com]
Sent: 7. lokakuuta 2013 12:31
To: Toni Helenius
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Index only select count(*)
On Oct 7, 2013, at 11:23, Toni Hel
nd all. No help. The output of analyze:
"Aggregate (cost=18240.50..18240.51 rows=1 width=0)"
" -> Seq Scan on min1_009 (cost=0.00..18108.60 rows=52760 width=0)"
--
Toni Helenius
