Avoid type cast that prevents index usage Casting to timestamp instead of timestamptz prevented usage of an index on measure_date. To be sure, also pass the location code as isrs instead of type record.