> database=> explain select date_trunc('hour', time),count(*) as total from
> test where p1=53 and time > now() - interval '24 hours' group by
> date_trunc order by date_trunc ;
time > '2005-06-28 15:34:00'
ie. put in the time 24 hours ago as a literal constant.
In response to
pgsql-performance by date
|Next:||From: Praveen Raja||Date: 2005-06-28 09:50:08|
|Subject: Re: Insert performance vs Table size|
|Previous:||From: Klint Gore||Date: 2005-06-28 08:36:35|
|Subject: Re: How can I speed up this function?|