Hi!
I feel something wrong when i query partitioned table when i filter it by timerange to get benefit of partitioning, it looks like it's still quering "whole table"
I see tha is something which is already fixed years ago:
but when i check my filter date from question on sql i see something like that:
WHERE
(
"schema"."table"."event_date" >= DATE_TRUNC('week', (NOW() + INTERVAL '-1 week'))
)
AND (
"schema"."table"."event_date" < DATE_TRUNC('week', NOW())
)
which is wrong, so it looks like that's not working as intended