Thanks for help.
I’ve performed some more tests and it seems expressions with “extract” function are not pushed down at all -
the WHERE criteria from the following query are not pushed down as well and filter is performed locally:
SELECT
*
FROM
t1
WHERE extract(YEAR FROM date_column) = 2023
I was under impression that “extract” meets all criteria for pushable expressions - looks like I am wrong?
What would be the _expression_ to achieve the same but such that postgres_fdw would push it down?
What Postgres versions on both ends?
16.1 on both sides
What does
select proname, prosrc, provolatile from pg_proc where proname = 'extract';
return?
extract | extract_date | i
(and bunch of similar records for other types - for timestampz provolatile is “s”)
