Database Inspector (DB Inspector)

../_images/image136.png

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

../_images/image61.png

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:

../_images/image135.png
  1. You can navigate between multiple issues related to the same object.

  2. If it is possible to solve the problem with the platform tools, then it can be done directly from the description section.

../_images/image72.png

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.

../_images/image85.png