test2.sql

application/octet-stream

Download

CREATE EXTENSION pageinspect;
create extension btree_gist;
create table t(f text) with (autovacuum_enabled=false);
create index on t using gist(f);
insert into t select 1::text;
select * from gist_page_items_bytea(get_raw_page('t_f_idx', 0));
select * from gist_page_opaque_info(get_raw_page('t_f_idx', 0));
delete from t;
set enable_seqscan = off; set enable_bitmapscan = off;
explain (analyze, costs off, timing off) select f from t;
select * from gist_page_opaque_info(get_raw_page('t_f_idx', 0));