> > the explain plan shows most any query scans/hits all partitions even if > > we specify the partition key: > > > > explain select * from pwreport.url_hits where "time" > > > date_part('epoch'::text, '2009-08-12'::timestamp without time
> > zone)::integer; QUERY PLAN
Does the plan change if you use a hard-coded timestamp in your query?