SQLize Online / PHPize Online  /  SQLtest Online

create extension pageinspect; CREATE TABLE test (id VARCHAR(255)); create index on test using hash(id); INSERT INTO test SELECT generate_series FROM generate_series(1,100); select ntuples, maxbucket from hash_metapage_info(get_raw_page('test_id_idx',0)); INSERT INTO test SELECT generate_series FROM generate_series(101,500); select ntuples, maxbucket from hash_metapage_info(get_raw_page('test_id_idx',0)); INSERT INTO test SELECT generate_series FROM generate_series(501,1000); select ntuples, maxbucket from hash_metapage_info(get_raw_page('test_id_idx',0)); INSERT INTO test SELECT generate_series FROM generate_series(1001,2000); select ntuples, maxbucket from hash_metapage_info(get_raw_page('test_id_idx',0)); INSERT INTO test SELECT generate_series FROM generate_series(2001,3000); select ntuples, maxbucket from hash_metapage_info(get_raw_page('test_id_idx',0)); INSERT INTO test SELECT generate_series FROM generate_series(3001,4000); select ntuples, maxbucket from hash_metapage_info(get_raw_page('test_id_idx',0)); INSERT INTO test SELECT generate_series FROM generate_series(4001,5000); select ntuples, maxbucket from hash_metapage_info(get_raw_page('test_id_idx',0)); INSERT INTO test SELECT generate_series FROM generate_series(5001,6000); select ntuples, maxbucket from hash_metapage_info(get_raw_page('test_id_idx',0));