39.2. Viewing Tables #

  1. In the navigation panel, go to Databases.

  2. (Optional) To display system databases, turn on Show system databases.

  3. Click the name of the database.

  4. Click the name of the schema.

The schema page with the selected Tables tab will be displayed. This tab includes the following columns:

  • Tables: The unique name of the table within the schema.

  • Total size: The size of the table in bytes.

    The horizontal indicator displays the following:

    • the size of the table user data and bloating

    • the total size of all table indexes, including the index bloat

    • the size of the service TOAST storage without bloating

  • CFS: Specifies whether the CFS compression is used for the table. Applicable only for the Postgres Pro Enterprise edition.

  • Data: The size of data in bytes, with the bloat percentage indicated separately.

  • Indexes: The total number of indexes, size of indexes in bytes, and bloating percentage.

  • TOAST: The size of the service TOAST storage without bloating.

  • Actions.

    For more information about available actions, refer to the corresponding instructions.