How often is Postgres parsing a foreign table based on file_fdw?
The file is read whenever the foreign table is scanned, which can happen several times during processing of a query.

There is no caching except the file system cache of the operating system.