Re: Consult is very slow

V
>
> My query is
>
> select EXTRACT(MONTH FROM M.fecha) as ho,count(*) as tot from correo M
> where EXTRACT(YEAR FROM M.fecha)='2004' group by EXTRACT(MONTH FROM
> M.fecha);
>
> When I executed a EXPLAIN ANALIZE, I hace the following Answer
>
> Aggregate  (cost=122439.31..122558.36 rows=2381 width=4) (actual
> time=64626.46..76021.93 rows=11 loops=1)
>   ->  Group  (cost=122439.31..122498.84 rows=23809 width=4) (actual
> time=63951.10..73332.27 rows=4177209 loops=1)
>         ->  Sort  (cost=122439.31..122439.31 rows=23809 width=4) (actual
> time=63951.09..67240.94 rows=4177209 loops=1)
>               ->  Seq Scan on web_sms m  (cost=0.00..120708.48 rows=23809
> width=4) (actual time=0.30..55077.31 rows=4177209 loops=1)
> Total runtime: 76069.22 msec
>
> How can I do to acceletate the answer?

You could use date_part and create a funtional index.

Sincerely,

Joshua D. Drake


>
> Thanks.
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL