src/backend/catalog/gp_toolkit_test.sql.in

-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements.  See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership.  The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- "License"); you may not use this file except in compliance
-- with the License.  You may obtain a copy of the License at
--
--   http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an
-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-- KIND, either express or implied.  See the License for the
-- specific language governing permissions and limitations
-- under the License.
--


drop table if exists fooaot;
create table fooaot(a int, b int) with (appendonly=true);

drop table if exists fooheap;
create table fooheap(a int, b int);

--

select * from %%JETPACK_PREFIX_AUX%%is_append_only
where iaooid = 'fooaot'::regclass;

select * from %%JETPACK_PREFIX_AUX%%is_append_only
where iaooid = 'fooheap'::regclass;

select * from %%JETPACK_PREFIX_AUX%%fullname
where fnoid = 'fooaot'::regclass;

select * from %%JETPACK_PREFIX_AUX%%user_namespaces;

select count(*) from %%JETPACK_PREFIX_AUX%%user_tables;
select count(*) from %%JETPACK_PREFIX_AUX%%user_data_tables;

select count(distinct localid) as distlocid FROM %%JETPACK_PREFIX_AUX%%localid;
select * FROM %%JETPACK_PREFIX_AUX%%masterid;


select * from %%JETPACK_PREFIX_AUX%%number_of_segments;

select count(*) from %%JETPACK_PREFIX_AUX%%log_segment_ext;
select count(*) from %%JETPACK_PREFIX_AUX%%log_master_ext;
select count(*) from %%JETPACK_PREFIX%%log_system;
select count(*) from %%JETPACK_PREFIX%%log_database;
select count(*) from %%JETPACK_PREFIX%%log_master_concise;
select count(*) from %%JETPACK_PREFIX%%log_command_timings;

select * FROM %%JETPACK_PREFIX_AUX%%param_local_setting('max_connections');
select * FROM %%JETPACK_PREFIX%%param_setting('max_connections');
select * from %%JETPACK_PREFIX%%param_settings() limit 10;
select * from %%JETPACK_PREFIX%%param_settings_seg_value_diffs;

select * FROM %%JETPACK_PREFIX%%skew_details('fooaot'::regclass);
select * FROM %%JETPACK_PREFIX%%skew_details('fooheap'::regclass);

select * from %%JETPACK_PREFIX%%skew_coefficient('fooheap'::regclass);
select * from %%JETPACK_PREFIX%%skew_coefficient('fooaot'::regclass);

select * from %%JETPACK_PREFIX_AUX%%skew_coefficients() order by 1 limit 10 ;
select * from %%JETPACK_PREFIX%%skew_coefficients order by 1 limit 10 ;

select * from %%JETPACK_PREFIX%%skew_idle_fraction('fooaot'::regclass);
select * from %%JETPACK_PREFIX%%skew_idle_fraction('fooheap'::regclass);

select * from %%JETPACK_PREFIX_AUX%%skew_idle_fractions() order by 1 limit 10 ;
select * from %%JETPACK_PREFIX%%skew_idle_fractions order by 1 limit 10 ;

--create skew
insert into fooaot select 1, generate_series(1,1000000);
select * from %%JETPACK_PREFIX%%skew_idle_fraction('fooaot'::regclass);
select * from %%JETPACK_PREFIX%%skew_coefficient('fooaot'::regclass);


select * from %%JETPACK_PREFIX%%stats_missing order by 1 limit 10;

select * from %%JETPACK_PREFIX%%disk_free;

insert into fooheap select 1, generate_series(1,1000000);
delete from fooheap;
analyze fooheap;

select * from %%JETPACK_PREFIX%%bloat_diag;


select * from %%JETPACK_PREFIX%%resq_activity_by_queue;
select * from %%JETPACK_PREFIX%%resq_priority_statement;
select * from %%JETPACK_PREFIX%%resq_priority_backend;


select * from %%JETPACK_PREFIX%%pgdatabase_invalid;

select * from %%JETPACK_PREFIX%%resq_role;

select * from %%JETPACK_PREFIX%%locks_on_resqueue;
select * from %%JETPACK_PREFIX%%locks_on_relation;

select * from %%JETPACK_PREFIX%%roles_assigned;

select * from %%JETPACK_PREFIX%%size_of_index;
select * from %%JETPACK_PREFIX%%size_of_table_disk;
select * from %%JETPACK_PREFIX%%size_of_table_uncompressed;
select * from %%JETPACK_PREFIX%%table_indexes limit 10;
select * from %%JETPACK_PREFIX%%size_of_all_table_indexes;
select * from %%JETPACK_PREFIX%%size_of_table_and_indexes_disk;
select * from %%JETPACK_PREFIX%%size_of_partition_and_indexes_disk;
select * from %%JETPACK_PREFIX%%size_of_schema_disk;
select * from %%JETPACK_PREFIX%%size_of_database;