The tables accessed through the DBA tab display a read-only view of the database tables. A DBA can use the information to diagnose some user issues without accessing the console database directly or issuing SQL commands. The tables provide helpful information that a cloud administrator can use when troubleshooting.
For security reasons, the DBA tab does not display the table in which the server stores personal information about registered users, and columns containing sensitive information are obfuscated.
The activation table stores the user activation codes that are generated during registration or password recovery. The table contains one entry for each activation code generated.
The attachedvolume table provides information about volumes attached to cluster instances. The table contains one entry for each attached volume.
The backups table provides information about the current backups stored by the server. A backup consists of multiple snapshots (one for each EBS volume in a cluster).
The dbengine table provides information about the currently defined database engines. The table contains one entry for each engine.
The instances table provides information about the currently active EDB Ark nodes for the EDB Ark service account. The table contains one entry for each instance (master or replica node).
The nodestatistics table displays information gathered by the cluster manager about the activity for each node. The table contains one record for each time that the cluster manager collected information.
The pcshistory table provides a sortable list of the transactions that have been displayed on the Events tabs of the registered users of the EDB Ark service account.
The pgpoolprop table displays the current values assigned to each parameter within each pgpool.conf parameter group. Click the PARAMGROUP column header to sort the table contents by parameter group.
The postgresconfparameters table provides information about parameter values for the postgresql.conf file.
The postgresprops table displays the current values assigned to each parameter within each parameter group. Click the PARAMGROUP column header to sort the table contents by parameter group.
The property table displays persistent properties used in the console, such as the console name used during backups and wall messages.
The snapshots table provides information about cluster backups that reside in the cloud.