38.2. Viewing Schemas #

  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.

The table of schemas with the following columns will be displayed:

  • Schemas: The unique name of the schema.

  • Total size.

    The horizontal indicator displays the size of tables, bloat, and indexes.

  • Owner.

  • Tables:

    • the number of tables

    • the size of tables

    • the table bloat percentage

  • Indexes:

    • the number of indexes

    • the size of indexes

    • the index bloat percentage

  • Actions.

    For more information about available actions, refer to other instructions in this section.

The size of the schema objects is calculated as the total sum of all its relational objects.

Important

If a schema is created outside PPEM, the information about it can be displayed in the web application with a delay. The delay duration depends on the agent configuration. By default, it is one minute.