Search Postgresql Archives

Re: Index only select count(*)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Oct 7, 2013, at 11:23, Toni Helenius <Toni.Helenius@xxxxxxxxxxxxxxx> wrote:

> 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)"

That's the output of Explain, not of Explain Analyze. The latter has actual measurements to go with the estimated costs, which gives a lot more insight.

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux