From: | "Areski" <areski5(at)hotmail(dot)com> |
---|---|
To: | Björn Metzdorf <bm(at)turtle-entertainment(dot)de>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Performance : Optimize query |
Date: | 2002-11-13 14:42:13 |
Message-ID: | OE74qFXfyY0QUUBPcZi00001f19@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes of course...
I have more less 2 millions of records on this table...
----- Original Message -----
From: "Björn Metzdorf" <bm(at)turtle-entertainment(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, November 13, 2002 12:25 PM
Subject: Re: [GENERAL] Performance : Optimize query
> > 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-13 14:58:22 | Re: Comparing strings with non-ASCII characters |
Previous Message | Tom Lane | 2002-11-13 14:34:14 | Re: SELECT INTO |