On 27 Jul 2010, at 21:48, Jamie Kahgee wrote:
> EXPLAIN ANALYZE SELECT page, count(page) as impressions FROM
> campaign_impressions WHERE campaign = 42 and "timestamp" BETWEEN '2010-05-21
> 00:00:00' AND '2010-07-27 00:00:00' group by page order by impressions;
>
EXPLAIN ANALYZE SELECT page, count(page) as impressions FROM
campaign_impressions WHERE campaign = 42 and "timestamp" BETWEEN '2010-05-21
00:00:00' AND '2010-07-27 00:00:00' group by page order by impressions;
QUERY PLAN
--
show us explain analyze on this
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm trying to increase my query speed for this table, it currently takes 2-3
seconds and would like to make if faster if possible.
my table reads as
Table "public.campaign_impressions"
Column |Type | Modifiers
---+-+
