1 – hash_insertions_field
This field gives the number of hash key insertions in the database's hashed indexes. It includes unique key insertions as well as duplicate key insertions.
2 – _____duplicates_field_
This field gives the number of duplicate key updates in the database's hashed indexes.
3 – hash_deletions_field
This field gives the number of hash key deletions from the database's hashed indexes. It includes unique key deletions as well as duplicate key deletions.
4 – ____duplicates_field_
This field gives the number of duplicate key deletions in the database's hashed indexes.
5 – hash_scans_field
This field gives the number of hashed index scans, including both retrieval and update scans, that were opened on the database's hashed indexes. A scan is defined as the sequential processing of the records that meet the search criteria of a query. Hashed scans then refer to the case where duplicate records are returned that meet the search criteria of a query from a scan of the hashed index.
6 – hash_index_fetches_field
This field gives the number of hashed index nodes that were fetched on a successful search of the database's hashed indexes. This includes fetches of duplicate nodes as well as bucket fragment nodes.
7 – __bucket_fragments_field
This field gives the number of bucket fragments that were fetched on a successful search of the database's hashed indexes.
8 – ___duplicate_nodes_field
This field gives the number of duplicate nodes that were fetched on a successful search of the database's hashed indexes.
9 – hash_bucket_stores_field
This field gives teh number of hash index buckets stored in the index. A hash index bucket contains one or more hash keys.