25.6. Retrieving Information About Cached Parquet Files #
You can retrieve information about Parquet files from the pgpro_axe cache.
Required privileges: Postgres Pro AXE administrator only. For more information about stored procedures and privileges, refer to Section 18.1.
Execute the following command on the Postgres Pro AXE server:
SELECT * FROM duckdb.query('SELECT * FROM duckdb_external_file_cache(); ') ;
Postgres Pro AXE outputs a table with the following columns:
path: The path to the Parquet file.nr_bytes: The size of the cached data, in bytes.location: The starting byte position of the cached data in the Parquet file.loaded: Specifies whether the cached data is currently loaded in RAM.