diff options
Diffstat (limited to 'contrib/pageinspect/sql/hash.sql')
| -rw-r--r-- | contrib/pageinspect/sql/hash.sql | 55 |
1 files changed, 43 insertions, 12 deletions
diff --git a/contrib/pageinspect/sql/hash.sql b/contrib/pageinspect/sql/hash.sql index 9e7635e36d7..87ee549a7b4 100644 --- a/contrib/pageinspect/sql/hash.sql +++ b/contrib/pageinspect/sql/hash.sql @@ -21,22 +21,53 @@ SELECT * FROM hash_bitmap_info('test_hash_a_idx', 4); SELECT * FROM hash_bitmap_info('test_hash_a_idx', 5); +SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, +lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM +hash_metapage_info(get_raw_page('test_hash_a_idx', 0)); -SELECT * FROM hash_metapage_info(get_raw_page('test_hash_a_idx', 0)); -SELECT * FROM hash_metapage_info(get_raw_page('test_hash_a_idx', 1)); -SELECT * FROM hash_metapage_info(get_raw_page('test_hash_a_idx', 2)); -SELECT * FROM hash_metapage_info(get_raw_page('test_hash_a_idx', 3)); -SELECT * FROM hash_metapage_info(get_raw_page('test_hash_a_idx', 4)); -SELECT * FROM hash_metapage_info(get_raw_page('test_hash_a_idx', 5)); +SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, +lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM +hash_metapage_info(get_raw_page('test_hash_a_idx', 1)); +SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, +lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM +hash_metapage_info(get_raw_page('test_hash_a_idx', 2)); -SELECT * FROM hash_page_stats(get_raw_page('test_hash_a_idx', 0)); -SELECT * FROM hash_page_stats(get_raw_page('test_hash_a_idx', 1)); -SELECT * FROM hash_page_stats(get_raw_page('test_hash_a_idx', 2)); -SELECT * FROM hash_page_stats(get_raw_page('test_hash_a_idx', 3)); -SELECT * FROM hash_page_stats(get_raw_page('test_hash_a_idx', 4)); -SELECT * FROM hash_page_stats(get_raw_page('test_hash_a_idx', 5)); +SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, +lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM +hash_metapage_info(get_raw_page('test_hash_a_idx', 3)); +SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, +lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM +hash_metapage_info(get_raw_page('test_hash_a_idx', 4)); + +SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, +lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM +hash_metapage_info(get_raw_page('test_hash_a_idx', 5)); + +SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, +hasho_bucket, hasho_flag, hasho_page_id FROM +hash_page_stats(get_raw_page('test_hash_a_idx', 0)); + +SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, +hasho_bucket, hasho_flag, hasho_page_id FROM +hash_page_stats(get_raw_page('test_hash_a_idx', 1)); + +SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, +hasho_bucket, hasho_flag, hasho_page_id FROM +hash_page_stats(get_raw_page('test_hash_a_idx', 2)); + +SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, +hasho_bucket, hasho_flag, hasho_page_id FROM +hash_page_stats(get_raw_page('test_hash_a_idx', 3)); + +SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, +hasho_bucket, hasho_flag, hasho_page_id FROM +hash_page_stats(get_raw_page('test_hash_a_idx', 4)); + +SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, +hasho_bucket, hasho_flag, hasho_page_id FROM +hash_page_stats(get_raw_page('test_hash_a_idx', 5)); SELECT * FROM hash_page_items(get_raw_page('test_hash_a_idx', 0)); SELECT * FROM hash_page_items(get_raw_page('test_hash_a_idx', 1)); |