Re: Performance : Optimize query

From: Björn Metzdorf <bm(at)turtle-entertainment(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance : Optimize query
Date: 2002-11-13 11:25:47
Message-ID: 011001c28b07$69cba1a0$81c206d4@office.turtleentertainment.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> EXPLAIN ANALYZE select count(*) from "Data" where "IDOrigin"='29';
> NOTICE: QUERY PLAN:
>
> Aggregate (cost=108945.77..108945.77 rows=1 width=0) (actual
> time=108845.29..108845.30 rows=1 loops=1)
> -> Seq Scan on Data (cost=0.00..107152.11 rows=717462 width=0) (actual
> time=18233.46..106927.60 rows=1457826 loops=1)
> Total runtime: 108845.50 msec.

Well, do you have an index on Data.IDOrigin ?

Regards,
Bjoern

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message アムス 2002-11-13 11:37:45 Can not connect to the database
Previous Message Areski 2002-11-13 11:22:49 Performance : Optimize query