39.6. Retrieving Analytical Table Statistics #
Analytical table statistics are contained in the pga_table_stats metadata table.
On the server with the metadata catalog, execute the following command:
SELECT s1.record_count, s1.file_size_bytes FROM axe_catalog.pga_table_stats s1, axe_catalog.pga_table t1 WHERE s1.table_id = t1.table_id
and t1.table_name='table_name';
Where table_name is the name of the analytical table from the pga_table metadata table.
Postgres Pro AXE outputs the number of analytical table rows and the total size of all its Parquet files.