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.