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 |
- On this page
- pgaa.lakehouse_table_stats()
Could this page be better? Report a problem or suggest an addition!