PGAA functions reference#
Synopsis#
Lists all PGAA tables on the instance, their storage location, and path.
Parameters#
None.
Returns#
Column |
Type |
Description |
|---|---|---|
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#
Returns the size in bytes of the latest version of a Lakehouse table and the total size of all versions.
Parameters#
Parameter |
Type |
Description |
|---|---|---|
relation |
regclass |
The name of the table to get the size of |
Returns#
Column |
Type |
Description |
|---|---|---|
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 |