PGAA functions reference v1.3.1

The November 2025 Innovation Release of EDB Postgres AI is available. For more information, see the release notes.

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

None.

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()`

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

Parameter	Type	Description
`relation`	`regclass`	The name of the table to get the size of

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