David Gardner <David(dot)Gardner(at)yucaipaco(dot)com> writes:
> I have a timestamp without timezone field in one of my tables that is used =
> in the where clause of one of my queries:
> WHERE date_trunc('day',"backupReports"."start") = current_date
If you can change the query, it'd be better/more efficient to spell this
as
WHERE "backupReports"."start"::date = current_date
Either way, you need to build an index on the expression, not just the
raw column, to make this search fast.
regards, tom lane