lauraxt/socorro — comment on commit 41c719d6d811bba273283fbce05a52f7c0e9ca2e
File:  line 0
By jberkus:

Just to make sure the correct index is used, please modify the above per:

tstz_between( reports.date_processed, ( date ? - 1 ), ( date ? + 1 ) " ), $uuid, $report_date_sql, $report_date_sql)->current();

the tstz_between(timestamptz,date,date) function is a custom function which always hits the partition index for searches on date_processed.