37.2. Viewing Databases #
In the navigation panel, go to Databases.
(Optional) To display system databases, turn on Show system databases.
The table of databases includes the following columns:
DB name.
Total size.
The horizontal indicator displays the size of tables, bloat, and indexes.
Wraparound: The percentage of released transaction IDs in the database.
Instance: The instance where the database is created.
Data collecting: The amount of the instance service information collected by agents.
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 the corresponding instructions.
The database size is calculated as the total sum of all its relational objects. This allows avoiding redundant calls of the pg_database_size function that uses the recursive traversal of directories and files and can negatively impact the performance of the main instance workload.
Important
If a database 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.