Skip site navigation (1) Skip section navigation (2)

Re: Consult is very slow

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Vida Luz <vlal(at)ideay(dot)net(dot)ni>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Consult is very slow
Date: 2004-11-12 17:09:36
Message-ID: 4194EE50.6060309@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment: jd.vcf
Description: text/x-vcard (640 bytes)

In response to

pgsql-admin by date

Next:From: Миков НиколайDate: 2004-11-13 06:19:02
Subject: max connections from one ip
Previous:From: Jaime CasanovaDate: 2004-11-12 16:33:12
Subject: Re: Consult is very slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group