PGAA functions reference
========================

Synopsis
^^^^^^^^

Lists all PGAA tables on the instance, their storage location, and path.

Parameters
^^^^^^^^^^

None.

Returns
^^^^^^^

.. csv-table::
  :header: Column,Type,Description
  :widths: 12,15,25
  :align: left
  :class: longtable

  `schema_name`,`text`,The schema of the table
  `table_name`,`text`,The name of the table
  `storage_location_name`,`text`,The name of the storage location for the table
  `path`,`text`,The path to the table in the storage location
  `managed_by`,`text`,The name of the user who created the table
  `format`,`text`,The format of the table (currently `delta` or `iceberg`)

pgaa.lakehouse_table_stats()
----------------------------

.. _synopsis-1:

Synopsis
^^^^^^^^

Returns the size in bytes of the latest version of a Lakehouse table and
the total size of all versions.

.. _parameters-1:

Parameters
^^^^^^^^^^

.. csv-table::
  :header: Parameter,Type,Description
  :widths: 12,15,25
  :align: left
  :class: longtable

  `relation`,`regclass`,The name of the table to get the size of

.. _returns-1:

Returns
^^^^^^^

.. csv-table::
  :header: Column,Type,Description
  :widths: 12,15,25
  :align: left
  :class: longtable

  `latest_snapshot_size`,`bigint`,The size in bytes of the latest snapshot of the table
  `total_size`,`bigint`,The total size in bytes of all versions of the table