Database Inspector (DB Inspector)

The «DB Inspector» page displays a list with information about the databases present in the PostgreSQL instance, as well as their total number and their total size. If you need more detailed information about a particular database, you need to click on the “Inspect” button (number 1 above).
Database

The database page displays detailed information about the database present in PostgreSQL. In order to collect information on HEALTHCHECKS, you must press the «COLLECT» / «REFRESH» button (see number 1). The information is cached within the user session, indicating the time of data collection. The following list of checks (HEALTHCHECKS) is currently supported:
Tables with candidate to partial indexes
Tables indexes with NULL values > 50%
Top size tables
Tables with top size indexes
Top writable tables
Top readable tables
Tables with the top bloat
Top seqscans tables
Tables with invalid indexes
Tables with not used indexes
Tables with redundant indexes
Tables with FKs without index
Tables with FKs with different data type then the original column
Tables with the low HOT updates ratio
Tables with possible autoanalyze issue
Tables with possible autovacuum issue
Tables without unique indexes
For each check, the number of tables is limited to 20. If the database has problems with the data schema or configuration settings, then you will see a table in the corresponding HEALTHCHECK. Then you can select the problem of interest in the HEALTHCHECKS section (see number 2). There is a filter to filter HEALTHCHECKS by importance level (see number 3).
Table Overview
In addition to detailed information about the problem, a description and recommendations. The page has useful functionality:

You can navigate between multiple issues related to the same object.
If it is possible to solve the problem with the platform tools, then it can be done directly from the description section.

You only need to click “Done”. For a more detailed explanation of the maintenance action flags, see the Run Maintenance subclause.
Table Statistics
The page provides detailed statistics on work with the table, maintenance, as well as the distribution of values since the last analysis.
