1CREATE TABLE test_hash (a int, b text); 2INSERT INTO test_hash VALUES (1, 'one'); 3CREATE INDEX test_hash_a_idx ON test_hash USING hash (a); 4 5\x 6 7SELECT hash_page_type(get_raw_page('test_hash_a_idx', 0)); 8SELECT hash_page_type(get_raw_page('test_hash_a_idx', 1)); 9SELECT hash_page_type(get_raw_page('test_hash_a_idx', 2)); 10SELECT hash_page_type(get_raw_page('test_hash_a_idx', 3)); 11SELECT hash_page_type(get_raw_page('test_hash_a_idx', 4)); 12SELECT hash_page_type(get_raw_page('test_hash_a_idx', 5)); 13SELECT hash_page_type(get_raw_page('test_hash_a_idx', 6)); 14 15 16SELECT * FROM hash_bitmap_info('test_hash_a_idx', 0); 17SELECT * FROM hash_bitmap_info('test_hash_a_idx', 1); 18SELECT * FROM hash_bitmap_info('test_hash_a_idx', 2); 19SELECT * FROM hash_bitmap_info('test_hash_a_idx', 3); 20SELECT * FROM hash_bitmap_info('test_hash_a_idx', 4); 21SELECT * FROM hash_bitmap_info('test_hash_a_idx', 5); 22 23 24SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, 25lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM 26hash_metapage_info(get_raw_page('test_hash_a_idx', 0)); 27 28SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, 29lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM 30hash_metapage_info(get_raw_page('test_hash_a_idx', 1)); 31 32SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, 33lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM 34hash_metapage_info(get_raw_page('test_hash_a_idx', 2)); 35 36SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, 37lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM 38hash_metapage_info(get_raw_page('test_hash_a_idx', 3)); 39 40SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, 41lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM 42hash_metapage_info(get_raw_page('test_hash_a_idx', 4)); 43 44SELECT magic, version, ntuples, bsize, bmsize, bmshift, maxbucket, highmask, 45lowmask, ovflpoint, firstfree, nmaps, procid, spares, mapp FROM 46hash_metapage_info(get_raw_page('test_hash_a_idx', 5)); 47 48SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, 49hasho_bucket, hasho_flag, hasho_page_id FROM 50hash_page_stats(get_raw_page('test_hash_a_idx', 0)); 51 52SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, 53hasho_bucket, hasho_flag, hasho_page_id FROM 54hash_page_stats(get_raw_page('test_hash_a_idx', 1)); 55 56SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, 57hasho_bucket, hasho_flag, hasho_page_id FROM 58hash_page_stats(get_raw_page('test_hash_a_idx', 2)); 59 60SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, 61hasho_bucket, hasho_flag, hasho_page_id FROM 62hash_page_stats(get_raw_page('test_hash_a_idx', 3)); 63 64SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, 65hasho_bucket, hasho_flag, hasho_page_id FROM 66hash_page_stats(get_raw_page('test_hash_a_idx', 4)); 67 68SELECT live_items, dead_items, page_size, hasho_prevblkno, hasho_nextblkno, 69hasho_bucket, hasho_flag, hasho_page_id FROM 70hash_page_stats(get_raw_page('test_hash_a_idx', 5)); 71 72SELECT * FROM hash_page_items(get_raw_page('test_hash_a_idx', 0)); 73SELECT * FROM hash_page_items(get_raw_page('test_hash_a_idx', 1)); 74SELECT * FROM hash_page_items(get_raw_page('test_hash_a_idx', 2)); 75SELECT * FROM hash_page_items(get_raw_page('test_hash_a_idx', 3)); 76SELECT * FROM hash_page_items(get_raw_page('test_hash_a_idx', 4)); 77SELECT * FROM hash_page_items(get_raw_page('test_hash_a_idx', 5)); 78 79 80DROP TABLE test_hash; 81