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.