> 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 ;
Try going:
time > '2005-06-28 15:34:00'
ie. put in the time 24 hours ago as a literal constant.
Chris