PostgreSQL Indexes Test
An index is a data structure that a database uses to reduce the amount of time it takes to perform certain operations. An index can also be used to ensure that duplicate values don’t appear where they are not needed.
This test monitors the indexes on the PostgreSQL server and helps administrators quickly and accurately assess the effectiveness of these indexes.
Target of the test : PostgreSQL server
Agent deploying the test: An internal/remote agent
Outputs of the test : One set of results for every index for every table in each database that is configured for monitoring on the target PostgreSQL server
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Index scans: |
Indicates the rate at which the index scans are initiated on this index in this database . |
Scans/Sec |
|
Rows read: |
Indicates the rate at which the index entries (rows) are read during the index scans on this index. |
Reads/Sec |
|
Rows fetched: |
Indicates the rate at which the rows are fetched from this index upon execution of a query. |
Fetches/Sec |
If the value of this measure is greater than the value of the Rows read measure, it indicates a possibility of index fragmentation or that the executed query is inefficient. |