App Indexes view PostgreSQL

App Indexes view - PostgreSQL

Administration DBA App Indexes App Indexes view

The App Indexes view provides an audit of your database indexes.

This option is not available if your N4 TOS is hosted by Kaleris.

The values in the Diff column indicate the status of the index:

OK: The database has the required index.
DUPLICATED: The index has double declaration. This does not impact functionality or performance. Send a low priority request to Navis to remove the duplication in a future N4 release.
EXTRA: The database has it, but N4 does not require it. You can drop these, but consult your database administrator and Navis first.
MISSED: N4 requires the index, but the database does not have it. You need to add a MISSED or MISSED FK index as soon as possible as it could play a role in performance.
MISSED FK (foreign key): N4 requires the index, but there are not any on this column.

To add an index:

Adding an index can take several minutes. It is best to do this during off peak hours.

To drop an index:

The Database Performance Management privilege (on page 1) controls access to this view.

App Indexes Columns - PostgreSQL

Short Label	Long Label	Description
Diff	Difference	Status of the index: OK: The database has the required index. Duplicated: The index has double declaration. Extra: The database has it, but N4 does not require it. Missed: N4 requires the index, but the database does not have it. Missed FK (foreign key): N4 requires the index, but there are not any in this column
Usage	Usage Count	Number of times that the index is used. Useful in gathering information about unused indexes.
Table name	Table Name	The table for which the index was created.
Index Name	Index Name	Name of the index.
Column Name	Column Name	Name of the table column.
Multicolumn	Multicolumn	Indicates True if the index covers more than one column.
Position	Position	Indicates the indexed column position in a multicolumn index, or 1 for non-multicolumn index.
Tablespace name	Tablespace Name	Indicates how the database objects are distributed on the file system.
Index Type	Index Type	The index type: NORMAL BITMAP FUNCTION-BASED NORMAL FUNCTION-BASED BITMAP DOMAIN
Number of Rows	Number of Rows	Approximate number of rows in the index as indicated by the statistics table.
Uniqueness	Uniqueness	Indicates if the index is unique, where each value in the key column is unique. UNIQUE NONUNIQUE
Last Analyzed	Last Analyzed	Indicates how the database objects are distributed on the file system.
Database Specific	Database Specific	Indicates True if this index is specific to the database type.