You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/06/27 02:42:53 UTC
[shardingsphere] branch master updated: Add opengauss pg_catalog tables (#26572)
This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new f256619ebf7 Add opengauss pg_catalog tables (#26572)
f256619ebf7 is described below
commit f256619ebf7991f5c8a26b4e7a7d7af7ec800fe9
Author: ZhangCheng <ch...@apache.org>
AuthorDate: Tue Jun 27 10:42:47 2023 +0800
Add opengauss pg_catalog tables (#26572)
* Add opengauss pg_catalog tables
* Add opengauss pg_catalog tables
* Add opengauss pg_catalog tables
* Add opengauss pg_catalog tables
* fix
* ci
---
.../schema/builder/SystemSchemaBuilderRule.java | 40 +-
.../pg_catalog/get_global_prepared_xacts.yaml | 67 ++
.../pg_catalog/gs_all_control_group_info.yaml | 99 +++
.../schema/opengauss/pg_catalog/gs_asp.yaml | 238 +++++
.../schema/opengauss/pg_catalog/gs_auditing.yaml | 75 ++
.../opengauss/pg_catalog/gs_auditing_access.yaml | 75 ++
.../opengauss/pg_catalog/gs_auditing_policy.yaml | 56 ++
.../pg_catalog/gs_auditing_policy_access.yaml | 56 ++
.../pg_catalog/gs_auditing_policy_filters.yaml | 64 ++
.../pg_catalog/gs_auditing_policy_privileges.yaml | 56 ++
.../pg_catalog/gs_auditing_privilege.yaml | 75 ++
.../pg_catalog/gs_client_global_keys.yaml | 64 ++
.../pg_catalog/gs_client_global_keys_args.yaml | 54 ++
.../pg_catalog/gs_cluster_resource_info.yaml | 75 ++
.../opengauss/pg_catalog/gs_column_keys.yaml | 82 ++
.../opengauss/pg_catalog/gs_column_keys_args.yaml | 54 ++
.../pg_catalog/gs_comm_proxy_thread_status.yaml | 75 ++
.../opengauss/pg_catalog/gs_db_privilege.yaml | 50 ++
.../opengauss/pg_catalog/gs_db_privileges.yaml | 43 +
.../opengauss/pg_catalog/gs_encrypted_columns.yaml | 80 ++
.../opengauss/pg_catalog/gs_encrypted_proc.yaml | 64 ++
.../schema/opengauss/pg_catalog/gs_file_stat.yaml | 123 +++
.../pg_catalog/gs_get_control_group_info.yaml | 115 +++
.../opengauss/pg_catalog/gs_global_chain.yaml | 102 +++
.../opengauss/pg_catalog/gs_global_config.yaml | 35 +
.../opengauss/pg_catalog/gs_gsc_memory_detail.yaml | 51 ++
.../opengauss/pg_catalog/gs_instance_time.yaml | 43 +
.../opengauss/pg_catalog/gs_job_argument.yaml | 74 ++
.../opengauss/pg_catalog/gs_job_attribute.yaml | 48 ++
.../schema/opengauss/pg_catalog/gs_labels.yaml | 67 ++
.../opengauss/pg_catalog/gs_lsc_memory_detail.yaml | 91 ++
.../schema/opengauss/pg_catalog/gs_masking.yaml | 67 ++
.../opengauss/pg_catalog/gs_masking_policy.yaml | 56 ++
.../pg_catalog/gs_masking_policy_actions.yaml | 66 ++
.../pg_catalog/gs_masking_policy_filters.yaml | 64 ++
.../schema/opengauss/pg_catalog/gs_matview.yaml | 62 ++
.../pg_catalog/gs_matview_dependency.yaml | 54 ++
.../schema/opengauss/pg_catalog/gs_matviews.yaml | 67 ++
.../opengauss/pg_catalog/gs_model_warehouse.yaml | 200 +++++
.../opengauss/pg_catalog/gs_obsscaninfo.yaml | 91 ++
.../schema/opengauss/pg_catalog/gs_opt_model.yaml | 158 ++++
.../opengauss/pg_catalog/gs_os_run_info.yaml | 59 ++
.../schema/opengauss/pg_catalog/gs_package.yaml | 88 ++
.../opengauss/pg_catalog/gs_policy_label.yaml | 72 ++
.../schema/opengauss/pg_catalog/gs_recyclebin.yaml | 184 ++++
.../schema/opengauss/pg_catalog/gs_redo_stat.yaml | 75 ++
.../pg_catalog/gs_session_cpu_statistics.yaml | 99 +++
.../opengauss/pg_catalog/gs_session_memory.yaml | 51 ++
.../pg_catalog/gs_session_memory_context.yaml | 83 ++
.../pg_catalog/gs_session_memory_detail.yaml | 83 ++
.../pg_catalog/gs_session_memory_statistics.yaml | 99 +++
.../opengauss/pg_catalog/gs_session_stat.yaml | 59 ++
.../opengauss/pg_catalog/gs_session_time.yaml | 51 ++
.../pg_catalog/gs_shared_memory_detail.yaml | 67 ++
.../schema/opengauss/pg_catalog/gs_sql_count.yaml | 227 +++++
.../opengauss/pg_catalog/gs_stat_session_cu.yaml | 43 +
.../pg_catalog/gs_thread_memory_context.yaml | 91 ++
.../pg_catalog/gs_total_memory_detail.yaml | 43 +
.../gs_total_nodegroup_memory_detail.yaml | 43 +
.../opengauss/pg_catalog/gs_txn_snapshot.yaml | 58 ++
.../schema/opengauss/pg_catalog/gs_uid.yaml | 38 +
.../opengauss/pg_catalog/gs_wlm_cgroup_info.yaml | 91 ++
.../pg_catalog/gs_wlm_ec_operator_history.yaml | 131 +++
.../pg_catalog/gs_wlm_ec_operator_info.yaml | 131 +++
.../pg_catalog/gs_wlm_ec_operator_statistics.yaml | 99 +++
.../pg_catalog/gs_wlm_instance_history.yaml | 139 +++
.../pg_catalog/gs_wlm_operator_history.yaml | 195 +++++
.../opengauss/pg_catalog/gs_wlm_operator_info.yaml | 195 +++++
.../pg_catalog/gs_wlm_operator_statistics.yaml | 203 +++++
.../pg_catalog/gs_wlm_plan_encoding_table.yaml | 83 ++
.../pg_catalog/gs_wlm_plan_operator_history.yaml | 155 ++++
.../pg_catalog/gs_wlm_plan_operator_info.yaml | 155 ++++
.../gs_wlm_rebuild_user_resource_pool.yaml | 27 +
.../opengauss/pg_catalog/gs_wlm_resource_pool.yaml | 99 +++
.../pg_catalog/gs_wlm_session_history.yaml | 563 ++++++++++++
.../opengauss/pg_catalog/gs_wlm_session_info.yaml | 563 ++++++++++++
.../pg_catalog/gs_wlm_session_info_all.yaml | 715 +++++++++++++++
.../pg_catalog/gs_wlm_session_query_info_all.yaml | 715 +++++++++++++++
.../pg_catalog/gs_wlm_session_statistics.yaml | 411 +++++++++
.../opengauss/pg_catalog/gs_wlm_user_info.yaml | 99 +++
.../pg_catalog/gs_wlm_user_resource_history.yaml | 163 ++++
.../pg_catalog/gs_wlm_workload_records.yaml | 139 +++
.../schema/opengauss/pg_catalog/mpp_tables.yaml | 67 ++
.../schema/opengauss/pg_catalog/pg_aggregate.yaml | 104 +++
.../schema/opengauss/pg_catalog/pg_am.yaml | 272 ++++++
.../schema/opengauss/pg_catalog/pg_amop.yaml | 90 ++
.../schema/opengauss/pg_catalog/pg_amproc.yaml | 64 ++
.../pg_catalog/pg_app_workloadgroup_mapping.yaml | 40 +
.../schema/opengauss/pg_catalog/pg_attrdef.yaml | 64 ++
.../schema/opengauss/pg_catalog/pg_attribute.yaml | 216 +++++
.../opengauss/pg_catalog/pg_auth_history.yaml | 48 ++
.../opengauss/pg_catalog/pg_auth_members.yaml | 56 ++
.../schema/opengauss/pg_catalog/pg_authid.yaml | 232 +++++
.../pg_available_extension_versions.yaml | 83 ++
.../pg_catalog/pg_available_extensions.yaml | 51 ++
.../schema/opengauss/pg_catalog/pg_cast.yaml | 72 ++
.../schema/opengauss/pg_catalog/pg_collation.yaml | 72 ++
.../schema/opengauss/pg_catalog/pg_comm_delay.yaml | 75 ++
.../opengauss/pg_catalog/pg_comm_recv_stream.yaml | 155 ++++
.../opengauss/pg_catalog/pg_comm_send_stream.yaml | 155 ++++
.../opengauss/pg_catalog/pg_comm_status.yaml | 123 +++
.../schema/opengauss/pg_catalog/pg_constraint.yaml | 244 ++++++
.../pg_catalog/pg_control_group_config.yaml | 27 +
.../schema/opengauss/pg_catalog/pg_conversion.yaml | 82 ++
.../schema/opengauss/pg_catalog/pg_cursors.yaml | 67 ++
.../schema/opengauss/pg_catalog/pg_database.yaml | 144 ++++
.../opengauss/pg_catalog/pg_db_role_setting.yaml | 46 +
.../opengauss/pg_catalog/pg_default_acl.yaml | 56 ++
.../schema/opengauss/pg_catalog/pg_depend.yaml | 80 ++
.../opengauss/pg_catalog/pg_description.yaml | 54 ++
.../schema/opengauss/pg_catalog/pg_directory.yaml | 56 ++
.../schema/opengauss/pg_catalog/pg_enum.yaml | 50 ++
.../schema/opengauss/pg_catalog/pg_ext_stats.yaml | 123 +++
.../schema/opengauss/pg_catalog/pg_extension.yaml | 80 ++
.../pg_catalog/pg_extension_data_source.yaml | 72 ++
.../pg_catalog/pg_foreign_data_wrapper.yaml | 72 ++
.../opengauss/pg_catalog/pg_foreign_server.yaml | 80 ++
.../opengauss/pg_catalog/pg_foreign_table.yaml | 54 ++
.../pg_catalog/pg_get_invalid_backends.yaml | 59 ++
.../pg_catalog/pg_get_senders_catchup_time.yaml | 83 ++
.../schema/opengauss/pg_catalog/pg_group.yaml | 43 +
.../opengauss/pg_catalog/pg_gtt_attached_pids.yaml | 51 ++
.../opengauss/pg_catalog/pg_gtt_relstats.yaml | 83 ++
.../schema/opengauss/pg_catalog/pg_gtt_stats.yaml | 131 +++
.../schema/opengauss/pg_catalog/pg_hashbucket.yaml | 64 ++
.../schema/opengauss/pg_catalog/pg_index.yaml | 184 ++++
.../schema/opengauss/pg_catalog/pg_indexes.yaml | 59 ++
.../schema/opengauss/pg_catalog/pg_inherits.yaml | 48 ++
.../schema/opengauss/pg_catalog/pg_job.yaml | 184 ++++
.../schema/opengauss/pg_catalog/pg_job_proc.yaml | 48 ++
.../schema/opengauss/pg_catalog/pg_language.yaml | 88 ++
.../opengauss/pg_catalog/pg_largeobject.yaml | 46 +
.../pg_catalog/pg_largeobject_metadata.yaml | 38 +
.../schema/opengauss/pg_catalog/pg_locks.yaml | 171 ++++
.../schema/opengauss/pg_catalog/pg_node_env.yaml | 75 ++
.../schema/opengauss/pg_catalog/pg_object.yaml | 78 ++
.../opengauss/pg_catalog/pg_obsscaninfo.yaml | 91 ++
.../schema/opengauss/pg_catalog/pg_opclass.yaml | 88 ++
.../schema/opengauss/pg_catalog/pg_operator.yaml | 136 +++
.../schema/opengauss/pg_catalog/pg_opfamily.yaml | 56 ++
.../schema/opengauss/pg_catalog/pg_os_threads.yaml | 59 ++
.../schema/opengauss/pg_catalog/pg_partition.yaml | 262 ++++++
.../schema/opengauss/pg_catalog/pg_pltemplate.yaml | 86 ++
.../pg_catalog/pg_prepared_statements.yaml | 59 ++
.../opengauss/pg_catalog/pg_prepared_xacts.yaml | 59 ++
.../schema/opengauss/pg_catalog/pg_proc.yaml | 340 ++++++++
.../opengauss/pg_catalog/pg_publication.yaml | 72 ++
.../opengauss/pg_catalog/pg_publication_rel.yaml | 40 +
.../pg_catalog/pg_publication_tables.yaml | 43 +
.../schema/opengauss/pg_catalog/pg_range.yaml | 70 ++
.../pg_catalog/pg_replication_origin.yaml | 40 +
.../pg_catalog/pg_replication_origin_status.yaml | 51 ++
.../opengauss/pg_catalog/pg_replication_slots.yaml | 99 +++
.../opengauss/pg_catalog/pg_resource_pool.yaml | 128 +++
.../schema/opengauss/pg_catalog/pg_rewrite.yaml | 88 ++
.../opengauss/pg_catalog/pg_rlspolicies.yaml | 75 ++
.../schema/opengauss/pg_catalog/pg_rlspolicy.yaml | 72 ++
.../schema/opengauss/pg_catalog/pg_roles.yaml | 235 +++++
.../schema/opengauss/pg_catalog/pg_rules.yaml | 51 ++
.../opengauss/pg_catalog/pg_running_xacts.yaml | 99 +++
.../schema/opengauss/pg_catalog/pg_seclabel.yaml | 62 ++
.../schema/opengauss/pg_catalog/pg_seclabels.yaml | 83 ++
.../opengauss/pg_catalog/pg_session_iostat.yaml | 99 +++
.../opengauss/pg_catalog/pg_session_wlmstat.yaml | 211 +++++
.../schema/opengauss/pg_catalog/pg_settings.yaml | 147 ++++
.../schema/opengauss/pg_catalog/pg_shadow.yaml | 163 ++++
.../schema/opengauss/pg_catalog/pg_shdepend.yaml | 88 ++
.../opengauss/pg_catalog/pg_shdescription.yaml | 46 +
.../schema/opengauss/pg_catalog/pg_shseclabel.yaml | 54 ++
.../opengauss/pg_catalog/pg_stat_activity.yaml | 203 +++++
.../opengauss/pg_catalog/pg_stat_activity_ng.yaml | 187 ++++
.../opengauss/pg_catalog/pg_stat_all_indexes.yaml | 83 ++
.../opengauss/pg_catalog/pg_stat_all_tables.yaml | 195 +++++
.../opengauss/pg_catalog/pg_stat_bad_block.yaml | 91 ++
.../opengauss/pg_catalog/pg_stat_bgwriter.yaml | 107 +++
.../opengauss/pg_catalog/pg_stat_database.yaml | 171 ++++
.../pg_catalog/pg_stat_database_conflicts.yaml | 75 ++
.../opengauss/pg_catalog/pg_stat_replication.yaml | 139 +++
.../opengauss/pg_catalog/pg_stat_subscription.yaml | 83 ++
.../opengauss/pg_catalog/pg_stat_sys_indexes.yaml | 83 ++
.../opengauss/pg_catalog/pg_stat_sys_tables.yaml | 195 +++++
.../pg_catalog/pg_stat_user_functions.yaml | 67 ++
.../opengauss/pg_catalog/pg_stat_user_indexes.yaml | 83 ++
.../opengauss/pg_catalog/pg_stat_user_tables.yaml | 195 +++++
.../pg_catalog/pg_stat_xact_all_tables.yaml | 107 +++
.../pg_catalog/pg_stat_xact_sys_tables.yaml | 107 +++
.../pg_catalog/pg_stat_xact_user_functions.yaml | 67 ++
.../pg_catalog/pg_stat_xact_user_tables.yaml | 107 +++
.../pg_catalog/pg_statio_all_indexes.yaml | 75 ++
.../pg_catalog/pg_statio_all_sequences.yaml | 59 ++
.../opengauss/pg_catalog/pg_statio_all_tables.yaml | 107 +++
.../pg_catalog/pg_statio_sys_indexes.yaml | 75 ++
.../pg_catalog/pg_statio_sys_sequences.yaml | 59 ++
.../opengauss/pg_catalog/pg_statio_sys_tables.yaml | 107 +++
.../pg_catalog/pg_statio_user_indexes.yaml | 75 ++
.../pg_catalog/pg_statio_user_sequences.yaml | 59 ++
.../pg_catalog/pg_statio_user_tables.yaml | 107 +++
.../schema/opengauss/pg_catalog/pg_statistic.yaml | 254 ++++++
.../opengauss/pg_catalog/pg_statistic_ext.yaml | 254 ++++++
.../schema/opengauss/pg_catalog/pg_stats.yaml | 139 +++
.../opengauss/pg_catalog/pg_subscription.yaml | 88 ++
.../schema/opengauss/pg_catalog/pg_synonym.yaml | 64 ++
.../schema/opengauss/pg_catalog/pg_tables.yaml | 99 +++
.../schema/opengauss/pg_catalog/pg_tablespace.yaml | 72 ++
.../schema/opengauss/pg_catalog/pg_tde_info.yaml | 43 +
.../pg_catalog/pg_thread_wait_status.yaml | 147 ++++
.../opengauss/pg_catalog/pg_timezone_abbrevs.yaml | 43 +
.../opengauss/pg_catalog/pg_timezone_names.yaml | 51 ++
.../pg_catalog/pg_total_memory_detail.yaml | 43 +
.../pg_catalog/pg_total_user_resource_info.yaml | 155 ++++
.../pg_total_user_resource_info_oid.yaml | 155 ++++
.../schema/opengauss/pg_catalog/pg_trigger.yaml | 154 ++++
.../schema/opengauss/pg_catalog/pg_ts_config.yaml | 64 ++
.../opengauss/pg_catalog/pg_ts_config_map.yaml | 54 ++
.../schema/opengauss/pg_catalog/pg_ts_dict.yaml | 64 ++
.../schema/opengauss/pg_catalog/pg_ts_parser.yaml | 80 ++
.../opengauss/pg_catalog/pg_ts_template.yaml | 56 ++
.../schema/opengauss/pg_catalog/pg_type.yaml | 264 ++++++
.../schema/opengauss/pg_catalog/pg_user.yaml | 171 ++++
.../opengauss/pg_catalog/pg_user_mapping.yaml | 48 ++
.../opengauss/pg_catalog/pg_user_mappings.yaml | 67 ++
.../opengauss/pg_catalog/pg_user_status.yaml | 80 ++
.../opengauss/pg_catalog/pg_variable_info.yaml | 107 +++
.../schema/opengauss/pg_catalog/pg_views.yaml | 51 ++
.../opengauss/pg_catalog/pg_wlm_statistics.yaml | 91 ++
.../opengauss/pg_catalog/pg_workload_group.yaml | 48 ++
.../schema/opengauss/pg_catalog/pgxc_class.yaml | 102 +++
.../schema/opengauss/pg_catalog/pgxc_group.yaml | 88 ++
.../schema/opengauss/pg_catalog/pgxc_node.yaml | 154 ++++
.../opengauss/pg_catalog/pgxc_prepared_xacts.yaml | 27 +
.../schema/opengauss/pg_catalog/pgxc_slice.yaml | 128 +++
.../pg_catalog/pgxc_thread_wait_status.yaml | 147 ++++
.../schema/opengauss/pg_catalog/plan_table.yaml | 107 +++
.../opengauss/pg_catalog/plan_table_data.yaml | 123 +++
.../opengauss/pg_catalog/statement_history.yaml | 438 ++++++++++
.../opengauss/pg_catalog/streaming_cont_query.yaml | 146 ++++
.../pg_catalog/streaming_reaper_status.yaml | 56 ++
.../opengauss/pg_catalog/streaming_stream.yaml | 40 +
.../schema/opengauss/pg_catalog/sys_dummy.yaml | 27 +
.../builder/SystemSchemaBuilderRuleTest.java | 3 +
.../schema/builder/SystemSchemaBuilderTest.java | 2 +-
...ngauss_pg_catalog_get_global_prepared_xacts.xml | 27 +
...ngauss_pg_catalog_gs_all_control_group_info.xml | 31 +
.../db/select_opengauss_pg_catalog_gs_asp.xml | 48 ++
.../db/select_opengauss_pg_catalog_gs_auditing.xml | 28 +
...ect_opengauss_pg_catalog_gs_auditing_access.xml | 28 +
...ect_opengauss_pg_catalog_gs_auditing_policy.xml | 25 +
...ngauss_pg_catalog_gs_auditing_policy_access.xml | 25 +
...gauss_pg_catalog_gs_auditing_policy_filters.xml | 26 +
...ss_pg_catalog_gs_auditing_policy_privileges.xml | 25 +
..._opengauss_pg_catalog_gs_auditing_privilege.xml | 28 +
..._opengauss_pg_catalog_gs_client_global_keys.xml | 26 +
...gauss_pg_catalog_gs_client_global_keys_args.xml | 25 +
...engauss_pg_catalog_gs_cluster_resource_info.xml | 28 +
.../select_opengauss_pg_catalog_gs_column_keys.xml | 28 +
...ct_opengauss_pg_catalog_gs_column_keys_args.xml | 25 +
...auss_pg_catalog_gs_comm_proxy_thread_status.xml | 28 +
...select_opengauss_pg_catalog_gs_db_privilege.xml | 24 +
...elect_opengauss_pg_catalog_gs_db_privileges.xml | 24 +
...t_opengauss_pg_catalog_gs_encrypted_columns.xml | 28 +
...lect_opengauss_pg_catalog_gs_encrypted_proc.xml | 26 +
.../select_opengauss_pg_catalog_gs_file_stat.xml | 34 +
...ngauss_pg_catalog_gs_get_control_group_info.xml | 33 +
...select_opengauss_pg_catalog_gs_global_chain.xml | 31 +
...elect_opengauss_pg_catalog_gs_global_config.xml | 23 +
...t_opengauss_pg_catalog_gs_gsc_memory_detail.xml | 25 +
...elect_opengauss_pg_catalog_gs_instance_time.xml | 24 +
...select_opengauss_pg_catalog_gs_job_argument.xml | 27 +
...elect_opengauss_pg_catalog_gs_job_attribute.xml | 24 +
.../db/select_opengauss_pg_catalog_gs_labels.xml | 27 +
...t_opengauss_pg_catalog_gs_lsc_memory_detail.xml | 30 +
.../db/select_opengauss_pg_catalog_gs_masking.xml | 27 +
...lect_opengauss_pg_catalog_gs_masking_policy.xml | 25 +
...ngauss_pg_catalog_gs_masking_policy_actions.xml | 26 +
...ngauss_pg_catalog_gs_masking_policy_filters.xml | 26 +
.../db/select_opengauss_pg_catalog_gs_matview.xml | 26 +
..._opengauss_pg_catalog_gs_matview_dependency.xml | 25 +
.../db/select_opengauss_pg_catalog_gs_matviews.xml | 27 +
...ect_opengauss_pg_catalog_gs_model_warehouse.xml | 43 +
.../select_opengauss_pg_catalog_gs_obsscaninfo.xml | 30 +
.../select_opengauss_pg_catalog_gs_opt_model.xml | 38 +
.../select_opengauss_pg_catalog_gs_os_run_info.xml | 26 +
.../db/select_opengauss_pg_catalog_gs_package.xml | 29 +
...select_opengauss_pg_catalog_gs_policy_label.xml | 27 +
.../select_opengauss_pg_catalog_gs_recyclebin.xml | 40 +
.../select_opengauss_pg_catalog_gs_redo_stat.xml | 28 +
...ngauss_pg_catalog_gs_session_cpu_statistics.xml | 31 +
...lect_opengauss_pg_catalog_gs_session_memory.xml | 25 +
...ngauss_pg_catalog_gs_session_memory_context.xml | 29 +
...engauss_pg_catalog_gs_session_memory_detail.xml | 29 +
...uss_pg_catalog_gs_session_memory_statistics.xml | 31 +
...select_opengauss_pg_catalog_gs_session_stat.xml | 26 +
...select_opengauss_pg_catalog_gs_session_time.xml | 25 +
...pengauss_pg_catalog_gs_shared_memory_detail.xml | 27 +
.../select_opengauss_pg_catalog_gs_sql_count.xml | 47 +
...ect_opengauss_pg_catalog_gs_stat_session_cu.xml | 24 +
...engauss_pg_catalog_gs_thread_memory_context.xml | 30 +
...opengauss_pg_catalog_gs_total_memory_detail.xml | 24 +
...pg_catalog_gs_total_nodegroup_memory_detail.xml | 24 +
...select_opengauss_pg_catalog_gs_txn_snapshot.xml | 25 +
.../db/select_opengauss_pg_catalog_gs_uid.xml | 23 +
...ect_opengauss_pg_catalog_gs_wlm_cgroup_info.xml | 30 +
...gauss_pg_catalog_gs_wlm_ec_operator_history.xml | 35 +
...pengauss_pg_catalog_gs_wlm_ec_operator_info.xml | 35 +
...ss_pg_catalog_gs_wlm_ec_operator_statistics.xml | 31 +
...pengauss_pg_catalog_gs_wlm_instance_history.xml | 36 +
...pengauss_pg_catalog_gs_wlm_operator_history.xml | 43 +
...t_opengauss_pg_catalog_gs_wlm_operator_info.xml | 43 +
...gauss_pg_catalog_gs_wlm_operator_statistics.xml | 44 +
...gauss_pg_catalog_gs_wlm_plan_encoding_table.xml | 29 +
...uss_pg_catalog_gs_wlm_plan_operator_history.xml | 38 +
...ngauss_pg_catalog_gs_wlm_plan_operator_info.xml | 38 +
...g_catalog_gs_wlm_rebuild_user_resource_pool.xml | 22 +
...t_opengauss_pg_catalog_gs_wlm_resource_pool.xml | 31 +
...opengauss_pg_catalog_gs_wlm_session_history.xml | 89 ++
...ct_opengauss_pg_catalog_gs_wlm_session_info.xml | 89 ++
...pengauss_pg_catalog_gs_wlm_session_info_all.xml | 108 +++
...ss_pg_catalog_gs_wlm_session_query_info_all.xml | 108 +++
...ngauss_pg_catalog_gs_wlm_session_statistics.xml | 70 ++
...elect_opengauss_pg_catalog_gs_wlm_user_info.xml | 31 +
...uss_pg_catalog_gs_wlm_user_resource_history.xml | 39 +
...pengauss_pg_catalog_gs_wlm_workload_records.xml | 36 +
.../db/select_opengauss_pg_catalog_mpp_tables.xml | 27 +
.../select_opengauss_pg_catalog_pg_aggregate.xml | 31 +
.../db/select_opengauss_pg_catalog_pg_am.xml | 52 ++
.../db/select_opengauss_pg_catalog_pg_amop.xml | 29 +
.../db/select_opengauss_pg_catalog_pg_amproc.xml | 26 +
...uss_pg_catalog_pg_app_workloadgroup_mapping.xml | 23 +
.../db/select_opengauss_pg_catalog_pg_attrdef.xml | 26 +
.../select_opengauss_pg_catalog_pg_attribute.xml | 45 +
...select_opengauss_pg_catalog_pg_auth_history.xml | 24 +
...select_opengauss_pg_catalog_pg_auth_members.xml | 25 +
.../db/select_opengauss_pg_catalog_pg_authid.xml | 47 +
..._pg_catalog_pg_available_extension_versions.xml | 29 +
...pengauss_pg_catalog_pg_available_extensions.xml | 25 +
.../db/select_opengauss_pg_catalog_pg_cast.xml | 27 +
.../db/select_opengauss_pg_catalog_pg_class.xml | 61 ++
.../select_opengauss_pg_catalog_pg_collation.xml | 27 +
.../select_opengauss_pg_catalog_pg_comm_delay.xml | 28 +
...ct_opengauss_pg_catalog_pg_comm_recv_stream.xml | 38 +
...ct_opengauss_pg_catalog_pg_comm_send_stream.xml | 38 +
.../select_opengauss_pg_catalog_pg_comm_status.xml | 34 +
.../select_opengauss_pg_catalog_pg_constraint.xml | 48 ++
...pengauss_pg_catalog_pg_control_group_config.xml | 22 +
.../select_opengauss_pg_catalog_pg_conversion.xml | 28 +
.../db/select_opengauss_pg_catalog_pg_cursors.xml | 27 +
.../db/select_opengauss_pg_catalog_pg_database.xml | 36 +
...ect_opengauss_pg_catalog_pg_db_role_setting.xml | 24 +
.../select_opengauss_pg_catalog_pg_default_acl.xml | 25 +
.../db/select_opengauss_pg_catalog_pg_depend.xml | 28 +
.../select_opengauss_pg_catalog_pg_description.xml | 25 +
.../select_opengauss_pg_catalog_pg_directory.xml | 25 +
.../db/select_opengauss_pg_catalog_pg_enum.xml | 24 +
.../select_opengauss_pg_catalog_pg_ext_stats.xml | 34 +
.../select_opengauss_pg_catalog_pg_extension.xml | 28 +
...engauss_pg_catalog_pg_extension_data_source.xml | 27 +
...pengauss_pg_catalog_pg_foreign_data_wrapper.xml | 27 +
...lect_opengauss_pg_catalog_pg_foreign_server.xml | 28 +
...elect_opengauss_pg_catalog_pg_foreign_table.xml | 25 +
...pengauss_pg_catalog_pg_get_invalid_backends.xml | 26 +
...auss_pg_catalog_pg_get_senders_catchup_time.xml | 29 +
.../db/select_opengauss_pg_catalog_pg_group.xml | 24 +
...t_opengauss_pg_catalog_pg_gtt_attached_pids.xml | 25 +
...select_opengauss_pg_catalog_pg_gtt_relstats.xml | 29 +
.../select_opengauss_pg_catalog_pg_gtt_stats.xml | 35 +
.../select_opengauss_pg_catalog_pg_hashbucket.xml | 26 +
.../db/select_opengauss_pg_catalog_pg_index.xml | 41 +
.../db/select_opengauss_pg_catalog_pg_indexes.xml | 26 +
.../db/select_opengauss_pg_catalog_pg_inherits.xml | 24 +
.../db/select_opengauss_pg_catalog_pg_job.xml | 41 +
.../db/select_opengauss_pg_catalog_pg_job_proc.xml | 24 +
.../db/select_opengauss_pg_catalog_pg_language.xml | 29 +
.../select_opengauss_pg_catalog_pg_largeobject.xml | 24 +
...pengauss_pg_catalog_pg_largeobject_metadata.xml | 23 +
.../db/select_opengauss_pg_catalog_pg_locks.xml | 40 +
.../select_opengauss_pg_catalog_pg_namespace.xml | 27 +
.../db/select_opengauss_pg_catalog_pg_node_env.xml | 28 +
.../db/select_opengauss_pg_catalog_pg_object.xml | 28 +
.../select_opengauss_pg_catalog_pg_obsscaninfo.xml | 30 +
.../db/select_opengauss_pg_catalog_pg_opclass.xml | 29 +
.../db/select_opengauss_pg_catalog_pg_operator.xml | 35 +
.../db/select_opengauss_pg_catalog_pg_opfamily.xml | 25 +
.../select_opengauss_pg_catalog_pg_os_threads.xml | 26 +
.../select_opengauss_pg_catalog_pg_partition.xml | 50 ++
.../select_opengauss_pg_catalog_pg_pltemplate.xml | 29 +
...opengauss_pg_catalog_pg_prepared_statements.xml | 26 +
...lect_opengauss_pg_catalog_pg_prepared_xacts.xml | 26 +
.../db/select_opengauss_pg_catalog_pg_proc.xml | 60 ++
.../select_opengauss_pg_catalog_pg_publication.xml | 27 +
...ect_opengauss_pg_catalog_pg_publication_rel.xml | 23 +
..._opengauss_pg_catalog_pg_publication_tables.xml | 24 +
.../db/select_opengauss_pg_catalog_pg_range.xml | 27 +
..._opengauss_pg_catalog_pg_replication_origin.xml | 23 +
...uss_pg_catalog_pg_replication_origin_status.xml | 25 +
...t_opengauss_pg_catalog_pg_replication_slots.xml | 31 +
...elect_opengauss_pg_catalog_pg_resource_pool.xml | 34 +
.../db/select_opengauss_pg_catalog_pg_rewrite.xml | 29 +
.../select_opengauss_pg_catalog_pg_rlspolicies.xml | 28 +
.../select_opengauss_pg_catalog_pg_rlspolicy.xml | 27 +
.../db/select_opengauss_pg_catalog_pg_roles.xml | 48 ++
.../db/select_opengauss_pg_catalog_pg_rules.xml | 25 +
...elect_opengauss_pg_catalog_pg_running_xacts.xml | 31 +
.../db/select_opengauss_pg_catalog_pg_seclabel.xml | 26 +
.../select_opengauss_pg_catalog_pg_seclabels.xml | 29 +
...lect_opengauss_pg_catalog_pg_session_iostat.xml | 31 +
...ect_opengauss_pg_catalog_pg_session_wlmstat.xml | 45 +
.../db/select_opengauss_pg_catalog_pg_settings.xml | 37 +
.../db/select_opengauss_pg_catalog_pg_shadow.xml | 39 +
.../db/select_opengauss_pg_catalog_pg_shdepend.xml | 29 +
...elect_opengauss_pg_catalog_pg_shdescription.xml | 24 +
.../select_opengauss_pg_catalog_pg_shseclabel.xml | 25 +
...elect_opengauss_pg_catalog_pg_stat_activity.xml | 44 +
...ct_opengauss_pg_catalog_pg_stat_activity_ng.xml | 42 +
...ct_opengauss_pg_catalog_pg_stat_all_indexes.xml | 29 +
...ect_opengauss_pg_catalog_pg_stat_all_tables.xml | 43 +
...lect_opengauss_pg_catalog_pg_stat_bad_block.xml | 30 +
...elect_opengauss_pg_catalog_pg_stat_bgwriter.xml | 32 +
...elect_opengauss_pg_catalog_pg_stat_database.xml | 40 +
...gauss_pg_catalog_pg_stat_database_conflicts.xml | 28 +
...ct_opengauss_pg_catalog_pg_stat_replication.xml | 36 +
...t_opengauss_pg_catalog_pg_stat_subscription.xml | 29 +
...ct_opengauss_pg_catalog_pg_stat_sys_indexes.xml | 29 +
...ect_opengauss_pg_catalog_pg_stat_sys_tables.xml | 43 +
...opengauss_pg_catalog_pg_stat_user_functions.xml | 27 +
...t_opengauss_pg_catalog_pg_stat_user_indexes.xml | 29 +
...ct_opengauss_pg_catalog_pg_stat_user_tables.xml | 43 +
...pengauss_pg_catalog_pg_stat_xact_all_tables.xml | 32 +
...pengauss_pg_catalog_pg_stat_xact_sys_tables.xml | 32 +
...auss_pg_catalog_pg_stat_xact_user_functions.xml | 27 +
...engauss_pg_catalog_pg_stat_xact_user_tables.xml | 32 +
..._opengauss_pg_catalog_pg_statio_all_indexes.xml | 28 +
...pengauss_pg_catalog_pg_statio_all_sequences.xml | 26 +
...t_opengauss_pg_catalog_pg_statio_all_tables.xml | 32 +
..._opengauss_pg_catalog_pg_statio_sys_indexes.xml | 28 +
...pengauss_pg_catalog_pg_statio_sys_sequences.xml | 26 +
...t_opengauss_pg_catalog_pg_statio_sys_tables.xml | 32 +
...opengauss_pg_catalog_pg_statio_user_indexes.xml | 28 +
...engauss_pg_catalog_pg_statio_user_sequences.xml | 26 +
..._opengauss_pg_catalog_pg_statio_user_tables.xml | 32 +
.../select_opengauss_pg_catalog_pg_statistic.xml | 50 ++
...elect_opengauss_pg_catalog_pg_statistic_ext.xml | 50 ++
.../db/select_opengauss_pg_catalog_pg_stats.xml | 36 +
...select_opengauss_pg_catalog_pg_subscription.xml | 29 +
.../db/select_opengauss_pg_catalog_pg_synonym.xml | 26 +
.../db/select_opengauss_pg_catalog_pg_tables.xml | 31 +
.../select_opengauss_pg_catalog_pg_tablespace.xml | 27 +
.../db/select_opengauss_pg_catalog_pg_tde_info.xml | 24 +
..._opengauss_pg_catalog_pg_thread_wait_status.xml | 37 +
...ct_opengauss_pg_catalog_pg_timezone_abbrevs.xml | 24 +
...lect_opengauss_pg_catalog_pg_timezone_names.xml | 25 +
...opengauss_pg_catalog_pg_total_memory_detail.xml | 24 +
...auss_pg_catalog_pg_total_user_resource_info.xml | 38 +
..._pg_catalog_pg_total_user_resource_info_oid.xml | 38 +
.../db/select_opengauss_pg_catalog_pg_trigger.xml | 37 +
.../select_opengauss_pg_catalog_pg_ts_config.xml | 26 +
...elect_opengauss_pg_catalog_pg_ts_config_map.xml | 25 +
.../db/select_opengauss_pg_catalog_pg_ts_dict.xml | 26 +
.../select_opengauss_pg_catalog_pg_ts_parser.xml | 28 +
.../select_opengauss_pg_catalog_pg_ts_template.xml | 25 +
.../db/select_opengauss_pg_catalog_pg_type.xml | 51 ++
.../db/select_opengauss_pg_catalog_pg_user.xml | 40 +
...select_opengauss_pg_catalog_pg_user_mapping.xml | 24 +
...elect_opengauss_pg_catalog_pg_user_mappings.xml | 27 +
.../select_opengauss_pg_catalog_pg_user_status.xml | 28 +
...elect_opengauss_pg_catalog_pg_variable_info.xml | 32 +
.../db/select_opengauss_pg_catalog_pg_views.xml | 25 +
...lect_opengauss_pg_catalog_pg_wlm_statistics.xml | 30 +
...lect_opengauss_pg_catalog_pg_workload_group.xml | 24 +
.../db/select_opengauss_pg_catalog_pgxc_class.xml | 31 +
.../db/select_opengauss_pg_catalog_pgxc_group.xml | 29 +
.../db/select_opengauss_pg_catalog_pgxc_node.xml | 37 +
...ct_opengauss_pg_catalog_pgxc_prepared_xacts.xml | 22 +
.../db/select_opengauss_pg_catalog_pgxc_slice.xml | 34 +
...pengauss_pg_catalog_pgxc_thread_wait_status.xml | 37 +
.../db/select_opengauss_pg_catalog_plan_table.xml | 32 +
...select_opengauss_pg_catalog_plan_table_data.xml | 34 +
...lect_opengauss_pg_catalog_statement_history.xml | 73 ++
...t_opengauss_pg_catalog_streaming_cont_query.xml | 35 +
...pengauss_pg_catalog_streaming_reaper_status.xml | 25 +
...elect_opengauss_pg_catalog_streaming_stream.xml | 23 +
.../db/select_opengauss_pg_catalog_sys_dummy.xml | 22 +
.../dql/dql-integration-select-system-schema.xml | 959 +++++++++++++++++++++
482 files changed, 34470 insertions(+), 2 deletions(-)
diff --git a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
index e61844cefaa..67a9d03f96e 100644
--- a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
+++ b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
@@ -138,7 +138,45 @@ public enum SystemSchemaBuilderRule {
"tables", "triggered_update_columns", "triggers", "udt_privileges", "usage_privileges", "user_defined_types", "user_mapping_options", "user_mappings", "view_column_usage",
"view_routine_usage", "view_table_usage", "views"))),
- OPEN_GAUSS_PG_CATALOG("openGauss", "pg_catalog", new HashSet<>(Arrays.asList("pg_class", "pg_namespace"))),
+ OPEN_GAUSS_PG_CATALOG("openGauss", "pg_catalog", new HashSet<>(Arrays.asList("get_global_prepared_xacts", "gs_all_control_group_info", "gs_asp", "gs_auditing", "gs_auditing_access",
+ "gs_auditing_policy", "gs_auditing_policy_access", "gs_auditing_policy_filters", "gs_auditing_policy_privileges",
+ "gs_auditing_privilege", "gs_client_global_keys", "gs_client_global_keys_args", "gs_cluster_resource_info", "gs_column_keys", "gs_column_keys_args", "gs_comm_proxy_thread_status",
+ "gs_db_privilege", "gs_db_privileges",
+ "gs_encrypted_columns", "gs_encrypted_proc", "gs_file_stat", "gs_get_control_group_info", "gs_global_chain", "gs_global_config", "gs_gsc_memory_detail", "gs_instance_time",
+ "gs_job_argument",
+ "gs_job_attribute", "gs_labels", "gs_lsc_memory_detail", "gs_masking", "gs_masking_policy", "gs_masking_policy_actions", "gs_masking_policy_filters", "gs_matview", "gs_matview_dependency",
+ "gs_matviews", "gs_model_warehouse", "gs_obsscaninfo", "gs_opt_model", "gs_os_run_info", "gs_package", "gs_policy_label", "gs_recyclebin", "gs_redo_stat",
+ "gs_session_cpu_statistics", "gs_session_memory", "gs_session_memory_context", "gs_session_memory_detail", "gs_session_memory_statistics", "gs_session_stat", "gs_session_time",
+ "gs_shared_memory_detail", "gs_sql_count",
+ "gs_stat_session_cu", "gs_thread_memory_context", "gs_total_memory_detail", "gs_total_nodegroup_memory_detail", "gs_txn_snapshot", "gs_uid", "gs_wlm_cgroup_info",
+ "gs_wlm_ec_operator_history", "gs_wlm_ec_operator_info",
+ "gs_wlm_ec_operator_statistics", "gs_wlm_instance_history", "gs_wlm_operator_history", "gs_wlm_operator_info", "gs_wlm_operator_statistics", "gs_wlm_plan_encoding_table",
+ "gs_wlm_plan_operator_history", "gs_wlm_plan_operator_info", "gs_wlm_rebuild_user_resource_pool",
+ "gs_wlm_resource_pool", "gs_wlm_session_history", "gs_wlm_session_info", "gs_wlm_session_info_all", "gs_wlm_session_query_info_all", "gs_wlm_session_statistics", "gs_wlm_user_info",
+ "gs_wlm_user_resource_history", "gs_wlm_workload_records",
+ "mpp_tables", "pg_aggregate", "pg_am", "pg_amop", "pg_amproc", "pg_app_workloadgroup_mapping", "pg_attrdef", "pg_attribute", "pg_auth_history",
+ "pg_auth_members", "pg_authid", "pg_available_extension_versions", "pg_available_extensions", "pg_cast", "pg_class", "pg_collation", "pg_comm_delay", "pg_comm_recv_stream",
+ "pg_comm_send_stream", "pg_comm_status", "pg_constraint", "pg_control_group_config", "pg_conversion", "pg_cursors", "pg_database", "pg_db_role_setting", "pg_default_acl",
+ "pg_depend", "pg_description", "pg_directory", "pg_enum", "pg_ext_stats", "pg_extension", "pg_extension_data_source", "pg_foreign_data_wrapper", "pg_foreign_server",
+ "pg_foreign_table", "pg_get_invalid_backends", "pg_get_senders_catchup_time", "pg_group", "pg_gtt_attached_pids", "pg_gtt_relstats", "pg_gtt_stats", "pg_hashbucket", "pg_index",
+ "pg_indexes", "pg_inherits", "pg_job", "pg_job_proc", "pg_language", "pg_largeobject", "pg_largeobject_metadata", "pg_locks", "pg_namespace",
+ "pg_node_env", "pg_object", "pg_obsscaninfo", "pg_opclass", "pg_operator", "pg_opfamily", "pg_os_threads", "pg_partition", "pg_pltemplate",
+ "pg_prepared_statements", "pg_prepared_xacts", "pg_proc", "pg_publication", "pg_publication_rel", "pg_publication_tables", "pg_range", "pg_replication_origin",
+ "pg_replication_origin_status",
+ "pg_replication_slots", "pg_resource_pool", "pg_rewrite", "pg_rlspolicies", "pg_rlspolicy", "pg_roles", "pg_rules", "pg_running_xacts", "pg_seclabel",
+ "pg_seclabels", "pg_session_iostat", "pg_session_wlmstat", "pg_settings", "pg_shadow", "pg_shdepend", "pg_shdescription", "pg_shseclabel", "pg_stat_activity",
+ "pg_stat_activity_ng", "pg_stat_all_indexes", "pg_stat_all_tables", "pg_stat_bad_block", "pg_stat_bgwriter", "pg_stat_database", "pg_stat_database_conflicts", "pg_stat_replication",
+ "pg_stat_subscription",
+ "pg_stat_sys_indexes", "pg_stat_sys_tables", "pg_stat_user_functions", "pg_stat_user_indexes", "pg_stat_user_tables", "pg_stat_xact_all_tables", "pg_stat_xact_sys_tables",
+ "pg_stat_xact_user_functions", "pg_stat_xact_user_tables",
+ "pg_statio_all_indexes", "pg_statio_all_sequences", "pg_statio_all_tables", "pg_statio_sys_indexes", "pg_statio_sys_sequences", "pg_statio_sys_tables", "pg_statio_user_indexes",
+ "pg_statio_user_sequences", "pg_statio_user_tables",
+ "pg_statistic", "pg_statistic_ext", "pg_stats", "pg_subscription", "pg_synonym", "pg_tables", "pg_tablespace", "pg_tde_info", "pg_thread_wait_status",
+ "pg_timezone_abbrevs", "pg_timezone_names", "pg_total_memory_detail", "pg_total_user_resource_info", "pg_total_user_resource_info_oid", "pg_trigger", "pg_ts_config", "pg_ts_config_map",
+ "pg_ts_dict",
+ "pg_ts_parser", "pg_ts_template", "pg_type", "pg_user", "pg_user_mapping", "pg_user_mappings", "pg_user_status", "pg_variable_info", "pg_views",
+ "pg_wlm_statistics", "pg_workload_group", "pgxc_class", "pgxc_group", "pgxc_node", "pgxc_prepared_xacts", "pgxc_slice", "pgxc_thread_wait_status", "plan_table",
+ "plan_table_data", "statement_history", "streaming_cont_query", "streaming_stream", "streaming_reaper_status", "sys_dummy"))),
OPEN_GAUSS_BLOCKCHAIN("openGauss", "blockchain", Collections.emptySet()),
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/get_global_prepared_xacts.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/get_global_prepared_xacts.yaml
new file mode 100644
index 00000000000..d0e2e0c8d4b
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/get_global_prepared_xacts.yaml
@@ -0,0 +1,67 @@
+#
+# 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.
+#
+
+name: get_global_prepared_xacts
+columns:
+ transaction:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: transaction
+ primaryKey: false
+ unsigned: false
+ visible: true
+ gid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: gid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ prepared:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: prepared
+ primaryKey: false
+ unsigned: false
+ visible: true
+ owner:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: owner
+ primaryKey: false
+ unsigned: false
+ visible: true
+ database:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: database
+ primaryKey: false
+ unsigned: false
+ visible: true
+ node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_all_control_group_info.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_all_control_group_info.yaml
new file mode 100644
index 00000000000..87b550bd701
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_all_control_group_info.yaml
@@ -0,0 +1,99 @@
+#
+# 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.
+#
+
+name: gs_all_control_group_info
+columns:
+ name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ gid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: gid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ classgid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: classgid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ class:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: class
+ primaryKey: false
+ unsigned: false
+ visible: true
+ workload:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: workload
+ primaryKey: false
+ unsigned: false
+ visible: true
+ shares:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: shares
+ primaryKey: false
+ unsigned: false
+ visible: true
+ limits:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: limits
+ primaryKey: false
+ unsigned: false
+ visible: true
+ wdlevel:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: wdlevel
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpucores:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpucores
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_asp.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_asp.yaml
new file mode 100644
index 00000000000..70864d00f75
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_asp.yaml
@@ -0,0 +1,238 @@
+#
+# 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.
+#
+
+name: gs_asp
+columns:
+ sampleid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: sampleid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sample_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: sample_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ need_flush_sample:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: need_flush_sample
+ primaryKey: false
+ unsigned: false
+ visible: true
+ databaseid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: databaseid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ thread_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: thread_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sessionid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: sessionid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: event
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lwtid:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: lwtid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ psessionid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: psessionid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tlevel:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: tlevel
+ primaryKey: false
+ unsigned: false
+ visible: true
+ smpid:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: smpid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ userid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: userid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ application_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: application_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_addr:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: client_addr
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_hostname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: client_hostname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_port:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: client_port
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: query_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ unique_query_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: unique_query_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ user_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: user_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cn_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: cn_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ unique_query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: unique_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ locktag:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: locktag
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lockmode:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: lockmode
+ primaryKey: false
+ unsigned: false
+ visible: true
+ block_sessionid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: block_sessionid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ wait_status:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: wait_status
+ primaryKey: false
+ unsigned: false
+ visible: true
+ global_sessionid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: global_sessionid
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_asp_sampletime_index:
+ name: gs_asp_sampletime_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing.yaml
new file mode 100644
index 00000000000..467ee81f71a
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing.yaml
@@ -0,0 +1,75 @@
+#
+# 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.
+#
+
+name: gs_auditing
+columns:
+ polname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: polname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pol_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pol_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ polenabled:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: polenabled
+ primaryKey: false
+ unsigned: false
+ visible: true
+ access_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: access_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ label_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: label_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ priv_object:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: priv_object
+ primaryKey: false
+ unsigned: false
+ visible: true
+ filter_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: filter_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_access.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_access.yaml
new file mode 100644
index 00000000000..6c60abac1a9
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_access.yaml
@@ -0,0 +1,75 @@
+#
+# 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.
+#
+
+name: gs_auditing_access
+columns:
+ polname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: polname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pol_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pol_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ polenabled:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: polenabled
+ primaryKey: false
+ unsigned: false
+ visible: true
+ access_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: access_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ label_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: label_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ access_object:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: access_object
+ primaryKey: false
+ unsigned: false
+ visible: true
+ filter_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: filter_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy.yaml
new file mode 100644
index 00000000000..5d4150b63b9
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy.yaml
@@ -0,0 +1,56 @@
+#
+# 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.
+#
+
+name: gs_auditing_policy
+columns:
+ polname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: polname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ polcomments:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: polcomments
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modifydate:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: modifydate
+ primaryKey: false
+ unsigned: false
+ visible: true
+ polenabled:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: polenabled
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_auditing_policy_oid_index:
+ name: gs_auditing_policy_oid_index
+ gs_auditing_policy_name_index:
+ name: gs_auditing_policy_name_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy_access.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy_access.yaml
new file mode 100644
index 00000000000..c18828f4722
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy_access.yaml
@@ -0,0 +1,56 @@
+#
+# 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.
+#
+
+name: gs_auditing_policy_access
+columns:
+ accesstype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: accesstype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ labelname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: labelname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ policyoid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: policyoid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modifydate:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: modifydate
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_auditing_policy_access_oid_index:
+ name: gs_auditing_policy_access_oid_index
+ gs_auditing_policy_access_row_index:
+ name: gs_auditing_policy_access_row_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy_filters.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy_filters.yaml
new file mode 100644
index 00000000000..c41e690109b
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy_filters.yaml
@@ -0,0 +1,64 @@
+#
+# 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.
+#
+
+name: gs_auditing_policy_filters
+columns:
+ filtertype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: filtertype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ labelname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: labelname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ policyoid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: policyoid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modifydate:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: modifydate
+ primaryKey: false
+ unsigned: false
+ visible: true
+ logicaloperator:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: logicaloperator
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_auditing_policy_filters_oid_index:
+ name: gs_auditing_policy_filters_oid_index
+ gs_auditing_policy_filters_row_index:
+ name: gs_auditing_policy_filters_row_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy_privileges.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy_privileges.yaml
new file mode 100644
index 00000000000..968cd095991
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_policy_privileges.yaml
@@ -0,0 +1,56 @@
+#
+# 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.
+#
+
+name: gs_auditing_policy_privileges
+columns:
+ privilegetype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilegetype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ labelname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: labelname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ policyoid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: policyoid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modifydate:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: modifydate
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_auditing_policy_privileges_oid_index:
+ name: gs_auditing_policy_privileges_oid_index
+ gs_auditing_policy_privileges_row_index:
+ name: gs_auditing_policy_privileges_row_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_privilege.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_privilege.yaml
new file mode 100644
index 00000000000..963f4e0e5fa
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_auditing_privilege.yaml
@@ -0,0 +1,75 @@
+#
+# 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.
+#
+
+name: gs_auditing_privilege
+columns:
+ polname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: polname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pol_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pol_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ polenabled:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: polenabled
+ primaryKey: false
+ unsigned: false
+ visible: true
+ access_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: access_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ label_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: label_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ priv_object:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: priv_object
+ primaryKey: false
+ unsigned: false
+ visible: true
+ filter_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: filter_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_client_global_keys.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_client_global_keys.yaml
new file mode 100644
index 00000000000..5fa4521e0e2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_client_global_keys.yaml
@@ -0,0 +1,64 @@
+#
+# 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.
+#
+
+name: gs_client_global_keys
+columns:
+ global_key_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: global_key_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ key_namespace:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: key_namespace
+ primaryKey: false
+ unsigned: false
+ visible: true
+ key_owner:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: key_owner
+ primaryKey: false
+ unsigned: false
+ visible: true
+ key_acl:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: key_acl
+ primaryKey: false
+ unsigned: false
+ visible: true
+ create_date:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: create_date
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_client_global_keys_oid_index:
+ name: gs_client_global_keys_oid_index
+ gs_client_global_keys_name_index:
+ name: gs_client_global_keys_name_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_client_global_keys_args.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_client_global_keys_args.yaml
new file mode 100644
index 00000000000..a4ccb467a71
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_client_global_keys_args.yaml
@@ -0,0 +1,54 @@
+#
+# 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.
+#
+
+name: gs_client_global_keys_args
+columns:
+ global_key_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: global_key_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ function_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: function_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ key:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: key
+ primaryKey: false
+ unsigned: false
+ visible: true
+ value:
+ caseSensitive: true
+ dataType: -2
+ generated: false
+ name: value
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_client_global_keys_args_oid_index:
+ name: gs_client_global_keys_args_oid_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_cluster_resource_info.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_cluster_resource_info.yaml
new file mode 100644
index 00000000000..47ef85c437e
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_cluster_resource_info.yaml
@@ -0,0 +1,75 @@
+#
+# 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.
+#
+
+name: gs_cluster_resource_info
+columns:
+ min_mem_util:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_mem_util
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_mem_util:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_mem_util
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_cpu_util:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_cpu_util
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_cpu_util:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_cpu_util
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_io_util:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_io_util
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_io_util:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_io_util
+ primaryKey: false
+ unsigned: false
+ visible: true
+ used_mem_rate:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: used_mem_rate
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_column_keys.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_column_keys.yaml
new file mode 100644
index 00000000000..5471db57b7a
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_column_keys.yaml
@@ -0,0 +1,82 @@
+#
+# 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.
+#
+
+name: gs_column_keys
+columns:
+ column_key_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_key_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_key_distributed_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: column_key_distributed_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ global_key_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: global_key_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ key_namespace:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: key_namespace
+ primaryKey: false
+ unsigned: false
+ visible: true
+ key_owner:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: key_owner
+ primaryKey: false
+ unsigned: false
+ visible: true
+ create_date:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: create_date
+ primaryKey: false
+ unsigned: false
+ visible: true
+ key_acl:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: key_acl
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_column_keys_oid_index:
+ name: gs_column_keys_oid_index
+ gs_column_keys_name_index:
+ name: gs_column_keys_name_index
+ gs_column_keys_distributed_id_index:
+ name: gs_column_keys_distributed_id_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_column_keys_args.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_column_keys_args.yaml
new file mode 100644
index 00000000000..8bdf1d48958
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_column_keys_args.yaml
@@ -0,0 +1,54 @@
+#
+# 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.
+#
+
+name: gs_column_keys_args
+columns:
+ column_key_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: column_key_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ function_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: function_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ key:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: key
+ primaryKey: false
+ unsigned: false
+ visible: true
+ value:
+ caseSensitive: true
+ dataType: -2
+ generated: false
+ name: value
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_column_keys_args_oid_index:
+ name: gs_column_keys_args_oid_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_comm_proxy_thread_status.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_comm_proxy_thread_status.yaml
new file mode 100644
index 00000000000..e771861a971
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_comm_proxy_thread_status.yaml
@@ -0,0 +1,75 @@
+#
+# 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.
+#
+
+name: gs_comm_proxy_thread_status
+columns:
+ proxythreadid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: ProxyThreadId
+ primaryKey: false
+ unsigned: false
+ visible: true
+ proxycpuaffinity:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ProxyCpuAffinity
+ primaryKey: false
+ unsigned: false
+ visible: true
+ threadstarttime:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ThreadStartTime
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rxpcknums:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: RxPckNums
+ primaryKey: false
+ unsigned: false
+ visible: true
+ txpcknums:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: TxPckNums
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rxpcks:
+ caseSensitive: true
+ dataType: 8
+ generated: false
+ name: RxPcks
+ primaryKey: false
+ unsigned: false
+ visible: true
+ txpcks:
+ caseSensitive: true
+ dataType: 8
+ generated: false
+ name: TxPcks
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_db_privilege.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_db_privilege.yaml
new file mode 100644
index 00000000000..08cbddb3e26
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_db_privilege.yaml
@@ -0,0 +1,50 @@
+#
+# 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.
+#
+
+name: gs_db_privilege
+columns:
+ roleid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: roleid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ admin_option:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: admin_option
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_db_privilege_oid_index:
+ name: gs_db_privilege_oid_index
+ gs_db_privilege_roleid_index:
+ name: gs_db_privilege_roleid_index
+ gs_db_privilege_roleid_privilege_type_index:
+ name: gs_db_privilege_roleid_privilege_type_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_db_privileges.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_db_privileges.yaml
new file mode 100644
index 00000000000..12baac63e70
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_db_privileges.yaml
@@ -0,0 +1,43 @@
+#
+# 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.
+#
+
+name: gs_db_privileges
+columns:
+ rolename:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: rolename
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ admin_option:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: admin_option
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_encrypted_columns.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_encrypted_columns.yaml
new file mode 100644
index 00000000000..4b11f55ad36
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_encrypted_columns.yaml
@@ -0,0 +1,80 @@
+#
+# 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.
+#
+
+name: gs_encrypted_columns
+columns:
+ rel_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rel_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_key_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: column_key_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ encryption_type:
+ caseSensitive: true
+ dataType: -6
+ generated: false
+ name: encryption_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type_original_oid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: data_type_original_oid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type_original_mod:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: data_type_original_mod
+ primaryKey: false
+ unsigned: false
+ visible: true
+ create_date:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: create_date
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_encrypted_columns_oid_index:
+ name: gs_encrypted_columns_oid_index
+ gs_encrypted_columns_rel_id_column_name_index:
+ name: gs_encrypted_columns_rel_id_column_name_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_encrypted_proc.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_encrypted_proc.yaml
new file mode 100644
index 00000000000..de40324380d
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_encrypted_proc.yaml
@@ -0,0 +1,64 @@
+#
+# 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.
+#
+
+name: gs_encrypted_proc
+columns:
+ func_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: func_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ prorettype_orig:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: prorettype_orig
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_change:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: last_change
+ primaryKey: false
+ unsigned: false
+ visible: true
+ proargcachedcol:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: proargcachedcol
+ primaryKey: false
+ unsigned: false
+ visible: true
+ proallargtypes_orig:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: proallargtypes_orig
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_encrypted_proc_oid:
+ name: gs_encrypted_proc_oid
+ gs_encrypted_proc_func_id_index:
+ name: gs_encrypted_proc_func_id_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_file_stat.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_file_stat.yaml
new file mode 100644
index 00000000000..9c81d2e1aff
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_file_stat.yaml
@@ -0,0 +1,123 @@
+#
+# 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.
+#
+
+name: gs_file_stat
+columns:
+ filenum:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: filenum
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dbid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: dbid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spcid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: spcid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ phyrds:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: phyrds
+ primaryKey: false
+ unsigned: false
+ visible: true
+ phywrts:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: phywrts
+ primaryKey: false
+ unsigned: false
+ visible: true
+ phyblkrd:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: phyblkrd
+ primaryKey: false
+ unsigned: false
+ visible: true
+ phyblkwrt:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: phyblkwrt
+ primaryKey: false
+ unsigned: false
+ visible: true
+ readtim:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: readtim
+ primaryKey: false
+ unsigned: false
+ visible: true
+ writetim:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: writetim
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avgiotim:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: avgiotim
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lstiotim:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: lstiotim
+ primaryKey: false
+ unsigned: false
+ visible: true
+ miniotim:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: miniotim
+ primaryKey: false
+ unsigned: false
+ visible: true
+ maxiowtm:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: maxiowtm
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_get_control_group_info.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_get_control_group_info.yaml
new file mode 100644
index 00000000000..c4cebeb6cc7
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_get_control_group_info.yaml
@@ -0,0 +1,115 @@
+#
+# 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.
+#
+
+name: gs_get_control_group_info
+columns:
+ name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ gid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: gid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ classgid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: classgid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ class:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: class
+ primaryKey: false
+ unsigned: false
+ visible: true
+ workload:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: workload
+ primaryKey: false
+ unsigned: false
+ visible: true
+ shares:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: shares
+ primaryKey: false
+ unsigned: false
+ visible: true
+ limits:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: limits
+ primaryKey: false
+ unsigned: false
+ visible: true
+ wdlevel:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: wdlevel
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpucores:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpucores
+ primaryKey: false
+ unsigned: false
+ visible: true
+ nodegroup:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: nodegroup
+ primaryKey: false
+ unsigned: false
+ visible: true
+ group_kind:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: group_kind
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_global_chain.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_global_chain.yaml
new file mode 100644
index 00000000000..5fc144f9c0e
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_global_chain.yaml
@@ -0,0 +1,102 @@
+#
+# 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.
+#
+
+name: gs_global_chain
+columns:
+ blocknum:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: blocknum
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dbname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dbname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ username:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: username
+ primaryKey: false
+ unsigned: false
+ visible: true
+ starttime:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: starttime
+ primaryKey: false
+ unsigned: false
+ visible: true
+ relid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: relid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ relnsp:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: relnsp
+ primaryKey: false
+ unsigned: false
+ visible: true
+ relname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: relname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ relhash:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: relhash
+ primaryKey: false
+ unsigned: false
+ visible: true
+ globalhash:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: globalhash
+ primaryKey: false
+ unsigned: false
+ visible: true
+ txcommand:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: txcommand
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_global_chain_relid_index:
+ name: gs_global_chain_relid_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_global_config.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_global_config.yaml
new file mode 100644
index 00000000000..2b555273e83
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_global_config.yaml
@@ -0,0 +1,35 @@
+#
+# 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.
+#
+
+name: gs_global_config
+columns:
+ name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_gsc_memory_detail.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_gsc_memory_detail.yaml
new file mode 100644
index 00000000000..c0688e95348
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_gsc_memory_detail.yaml
@@ -0,0 +1,51 @@
+#
+# 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.
+#
+
+name: gs_gsc_memory_detail
+columns:
+ db_id:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: db_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ totalsize:
+ caseSensitive: true
+ dataType: 2
+ generated: false
+ name: totalsize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ freesize:
+ caseSensitive: true
+ dataType: 2
+ generated: false
+ name: freesize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ usedsize:
+ caseSensitive: true
+ dataType: 2
+ generated: false
+ name: usedsize
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_instance_time.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_instance_time.yaml
new file mode 100644
index 00000000000..26b4a50cf12
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_instance_time.yaml
@@ -0,0 +1,43 @@
+#
+# 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.
+#
+
+name: gs_instance_time
+columns:
+ stat_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: stat_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ stat_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: stat_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_job_argument.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_job_argument.yaml
new file mode 100644
index 00000000000..9b5514470a8
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_job_argument.yaml
@@ -0,0 +1,74 @@
+#
+# 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.
+#
+
+name: gs_job_argument
+columns:
+ argument_position:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: argument_position
+ primaryKey: false
+ unsigned: false
+ visible: true
+ argument_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: argument_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ job_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: job_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ argument_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: argument_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ argument_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: argument_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ default_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: default_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_job_argument_oid_index:
+ name: gs_job_argument_oid_index
+ gs_job_argument_name_index:
+ name: gs_job_argument_name_index
+ gs_job_argument_position_index:
+ name: gs_job_argument_position_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_job_attribute.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_job_attribute.yaml
new file mode 100644
index 00000000000..9409b451b7c
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_job_attribute.yaml
@@ -0,0 +1,48 @@
+#
+# 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.
+#
+
+name: gs_job_attribute
+columns:
+ job_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: job_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attribute_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: attribute_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attribute_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: attribute_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_job_attribute_oid_index:
+ name: gs_job_attribute_oid_index
+ gs_job_attribute_name_index:
+ name: gs_job_attribute_name_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_labels.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_labels.yaml
new file mode 100644
index 00000000000..c74d0fe85a4
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_labels.yaml
@@ -0,0 +1,67 @@
+#
+# 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.
+#
+
+name: gs_labels
+columns:
+ labelname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: labelname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ labeltype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: labeltype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ fqdntype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: fqdntype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ schemaname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: schemaname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ fqdnname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: fqdnname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ columnname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: columnname
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_lsc_memory_detail.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_lsc_memory_detail.yaml
new file mode 100644
index 00000000000..7c5f441fc28
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_lsc_memory_detail.yaml
@@ -0,0 +1,91 @@
+#
+# 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.
+#
+
+name: gs_lsc_memory_detail
+columns:
+ threadid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: threadid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: tid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ thrdtype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: thrdtype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ contextname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: contextname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ level:
+ caseSensitive: true
+ dataType: 5
+ generated: false
+ name: level
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parent:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: parent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ totalsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: totalsize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ freesize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: freesize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ usedsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: usedsize
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking.yaml
new file mode 100644
index 00000000000..bd51e685978
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking.yaml
@@ -0,0 +1,67 @@
+#
+# 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.
+#
+
+name: gs_masking
+columns:
+ polname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: polname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ polenabled:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: polenabled
+ primaryKey: false
+ unsigned: false
+ visible: true
+ maskaction:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: maskaction
+ primaryKey: false
+ unsigned: false
+ visible: true
+ labelname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: labelname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ masking_object:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: masking_object
+ primaryKey: false
+ unsigned: false
+ visible: true
+ filter_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: filter_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking_policy.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking_policy.yaml
new file mode 100644
index 00000000000..a8f5212b2c6
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking_policy.yaml
@@ -0,0 +1,56 @@
+#
+# 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.
+#
+
+name: gs_masking_policy
+columns:
+ polname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: polname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ polcomments:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: polcomments
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modifydate:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: modifydate
+ primaryKey: false
+ unsigned: false
+ visible: true
+ polenabled:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: polenabled
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_masking_policy_oid_index:
+ name: gs_masking_policy_oid_index
+ gs_masking_policy_name_index:
+ name: gs_masking_policy_name_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking_policy_actions.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking_policy_actions.yaml
new file mode 100644
index 00000000000..374b5959ff2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking_policy_actions.yaml
@@ -0,0 +1,66 @@
+#
+# 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.
+#
+
+name: gs_masking_policy_actions
+columns:
+ actiontype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: actiontype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ actparams:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: actparams
+ primaryKey: false
+ unsigned: false
+ visible: true
+ actlabelname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: actlabelname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ policyoid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: policyoid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ actmodifydate:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: actmodifydate
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_masking_policy_actions_oid_index:
+ name: gs_masking_policy_actions_oid_index
+ gs_masking_policy_actions_row_index:
+ name: gs_masking_policy_actions_row_index
+ gs_masking_policy_actions_policy_oid_index:
+ name: gs_masking_policy_actions_policy_oid_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking_policy_filters.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking_policy_filters.yaml
new file mode 100644
index 00000000000..04ca0fb5471
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_masking_policy_filters.yaml
@@ -0,0 +1,64 @@
+#
+# 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.
+#
+
+name: gs_masking_policy_filters
+columns:
+ filtertype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: filtertype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ filterlabelname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: filterlabelname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ policyoid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: policyoid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modifydate:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: modifydate
+ primaryKey: false
+ unsigned: false
+ visible: true
+ logicaloperator:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: logicaloperator
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_masking_policy_filters_oid_index:
+ name: gs_masking_policy_filters_oid_index
+ gs_masking_policy_filters_row_index:
+ name: gs_masking_policy_filters_row_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_matview.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_matview.yaml
new file mode 100644
index 00000000000..681206cd8d6
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_matview.yaml
@@ -0,0 +1,62 @@
+#
+# 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.
+#
+
+name: gs_matview
+columns:
+ matviewid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: matviewid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mapid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mapid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ivm:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: ivm
+ primaryKey: false
+ unsigned: false
+ visible: true
+ needrefresh:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: needrefresh
+ primaryKey: false
+ unsigned: false
+ visible: true
+ refreshtime:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: refreshtime
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_matview_oid_index:
+ name: gs_matview_oid_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_matview_dependency.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_matview_dependency.yaml
new file mode 100644
index 00000000000..8b4f9ae644d
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_matview_dependency.yaml
@@ -0,0 +1,54 @@
+#
+# 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.
+#
+
+name: gs_matview_dependency
+columns:
+ matviewid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: matviewid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ relid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: relid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mlogid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mlogid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mxmin:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: mxmin
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_matviewdep_oid_index:
+ name: gs_matviewdep_oid_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_matviews.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_matviews.yaml
new file mode 100644
index 00000000000..16d7a5460d0
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_matviews.yaml
@@ -0,0 +1,67 @@
+#
+# 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.
+#
+
+name: gs_matviews
+columns:
+ schemaname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: schemaname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ matviewname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: matviewname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ matviewowner:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: matviewowner
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tablespace:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: tablespace
+ primaryKey: false
+ unsigned: false
+ visible: true
+ hasindexes:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: hasindexes
+ primaryKey: false
+ unsigned: false
+ visible: true
+ definition:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: definition
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_model_warehouse.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_model_warehouse.yaml
new file mode 100644
index 00000000000..3963c1192d7
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_model_warehouse.yaml
@@ -0,0 +1,200 @@
+#
+# 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.
+#
+
+name: gs_model_warehouse
+columns:
+ modelname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: modelname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modelowner:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: modelowner
+ primaryKey: false
+ unsigned: false
+ visible: true
+ createtime:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: createtime
+ primaryKey: false
+ unsigned: false
+ visible: true
+ processedtuples:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: processedtuples
+ primaryKey: false
+ unsigned: false
+ visible: true
+ discardedtuples:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: discardedtuples
+ primaryKey: false
+ unsigned: false
+ visible: true
+ preprocesstime:
+ caseSensitive: true
+ dataType: 7
+ generated: false
+ name: preprocesstime
+ primaryKey: false
+ unsigned: false
+ visible: true
+ exectime:
+ caseSensitive: true
+ dataType: 7
+ generated: false
+ name: exectime
+ primaryKey: false
+ unsigned: false
+ visible: true
+ iterations:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: iterations
+ primaryKey: false
+ unsigned: false
+ visible: true
+ outputtype:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: outputtype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modeltype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: modeltype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modeldata:
+ caseSensitive: true
+ dataType: -2
+ generated: false
+ name: modeldata
+ primaryKey: false
+ unsigned: false
+ visible: true
+ weight:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: weight
+ primaryKey: false
+ unsigned: false
+ visible: true
+ hyperparametersnames:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: hyperparametersnames
+ primaryKey: false
+ unsigned: false
+ visible: true
+ hyperparametersvalues:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: hyperparametersvalues
+ primaryKey: false
+ unsigned: false
+ visible: true
+ hyperparametersoids:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: hyperparametersoids
+ primaryKey: false
+ unsigned: false
+ visible: true
+ coefnames:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: coefnames
+ primaryKey: false
+ unsigned: false
+ visible: true
+ coefvalues:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: coefvalues
+ primaryKey: false
+ unsigned: false
+ visible: true
+ coefoids:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: coefoids
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trainingscoresname:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: trainingscoresname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trainingscoresvalue:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: trainingscoresvalue
+ primaryKey: false
+ unsigned: false
+ visible: true
+ modeldescribe:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: modeldescribe
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_model_oid_index:
+ name: gs_model_oid_index
+ gs_model_name_index:
+ name: gs_model_name_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_obsscaninfo.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_obsscaninfo.yaml
new file mode 100644
index 00000000000..0411d9b2050
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_obsscaninfo.yaml
@@ -0,0 +1,91 @@
+#
+# 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.
+#
+
+name: gs_obsscaninfo
+columns:
+ query_id:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: query_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ user_id:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: file_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ time_stamp:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: time_stamp
+ primaryKey: false
+ unsigned: false
+ visible: true
+ actual_time:
+ caseSensitive: true
+ dataType: 8
+ generated: false
+ name: actual_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file_scanned:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: file_scanned
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_size:
+ caseSensitive: true
+ dataType: 8
+ generated: false
+ name: data_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ billing_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: billing_info
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_opt_model.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_opt_model.yaml
new file mode 100644
index 00000000000..e6b7a9c7031
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_opt_model.yaml
@@ -0,0 +1,158 @@
+#
+# 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.
+#
+
+name: gs_opt_model
+columns:
+ template_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: template_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ model_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: model_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ datname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: datname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ip:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ip
+ primaryKey: false
+ unsigned: false
+ visible: true
+ port:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: port
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_epoch:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_epoch
+ primaryKey: false
+ unsigned: false
+ visible: true
+ learning_rate:
+ caseSensitive: true
+ dataType: 7
+ generated: false
+ name: learning_rate
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dim_red:
+ caseSensitive: true
+ dataType: 7
+ generated: false
+ name: dim_red
+ primaryKey: false
+ unsigned: false
+ visible: true
+ hidden_units:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: hidden_units
+ primaryKey: false
+ unsigned: false
+ visible: true
+ batch_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: batch_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ feature_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: feature_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ available:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: available
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_training:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: is_training
+ primaryKey: false
+ unsigned: false
+ visible: true
+ label:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: label
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: max
+ primaryKey: false
+ unsigned: false
+ visible: true
+ acc:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: acc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ description:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: description
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_opt_model_name_index:
+ name: gs_opt_model_name_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_os_run_info.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_os_run_info.yaml
new file mode 100644
index 00000000000..66e04e1d3bb
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_os_run_info.yaml
@@ -0,0 +1,59 @@
+#
+# 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.
+#
+
+name: gs_os_run_info
+columns:
+ id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ value:
+ caseSensitive: true
+ dataType: 2
+ generated: false
+ name: value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ comments:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: comments
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cumulative:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: cumulative
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_package.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_package.yaml
new file mode 100644
index 00000000000..2f9737bcdf4
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_package.yaml
@@ -0,0 +1,88 @@
+#
+# 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.
+#
+
+name: gs_package
+columns:
+ pkgnamespace:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pkgnamespace
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pkgowner:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pkgowner
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pkgname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pkgname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pkgspecsrc:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pkgspecsrc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pkgbodydeclsrc:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pkgbodydeclsrc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pkgbodyinitsrc:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pkgbodyinitsrc
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pkgacl:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: pkgacl
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pkgsecdef:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: pkgsecdef
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_package_oid_index:
+ name: gs_package_oid_index
+ gs_package_name_index:
+ name: gs_package_name_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_policy_label.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_policy_label.yaml
new file mode 100644
index 00000000000..70dc37afcca
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_policy_label.yaml
@@ -0,0 +1,72 @@
+#
+# 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.
+#
+
+name: gs_policy_label
+columns:
+ labelname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: labelname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ labeltype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: labeltype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ fqdnnamespace:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: fqdnnamespace
+ primaryKey: false
+ unsigned: false
+ visible: true
+ fqdnid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: fqdnid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ relcolumn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: relcolumn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ fqdntype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: fqdntype
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_policy_label_oid_index:
+ name: gs_policy_label_oid_index
+ gs_policy_label_name_index:
+ name: gs_policy_label_name_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_recyclebin.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_recyclebin.yaml
new file mode 100644
index 00000000000..b389ecd4d1b
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_recyclebin.yaml
@@ -0,0 +1,184 @@
+#
+# 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.
+#
+
+name: gs_recyclebin
+columns:
+ rcybaseid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcybaseid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcydbid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcydbid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyrelid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcyrelid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: rcyname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyoriginname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: rcyoriginname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyoperation:
+ caseSensitive: true
+ dataType: 1
+ generated: false
+ name: rcyoperation
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcytype:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: rcytype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyrecyclecsn:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcyrecyclecsn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyrecycletime:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: rcyrecycletime
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcycreatecsn:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcycreatecsn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcychangecsn:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcychangecsn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcynamespace:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcynamespace
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyowner:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcyowner
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcytablespace:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcytablespace
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyrelfilenode:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rcyrelfilenode
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcycanrestore:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: rcycanrestore
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcycanpurge:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: rcycanpurge
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyfrozenxid:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: rcyfrozenxid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rcyfrozenxid64:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: rcyfrozenxid64
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_recyclebin_id_index:
+ name: gs_recyclebin_id_index
+ gs_recyclebin_baseid_index:
+ name: gs_recyclebin_baseid_index
+ gs_recyclebin_name_index:
+ name: gs_recyclebin_name_index
+ gs_recyclebin_dbid_nsp_oriname_index:
+ name: gs_recyclebin_dbid_nsp_oriname_index
+ gs_recyclebin_dbid_spcid_rcycsn_index:
+ name: gs_recyclebin_dbid_spcid_rcycsn_index
+ gs_recyclebin_dbid_relid_index:
+ name: gs_recyclebin_dbid_relid_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_redo_stat.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_redo_stat.yaml
new file mode 100644
index 00000000000..176450a937f
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_redo_stat.yaml
@@ -0,0 +1,75 @@
+#
+# 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.
+#
+
+name: gs_redo_stat
+columns:
+ phywrts:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: phywrts
+ primaryKey: false
+ unsigned: false
+ visible: true
+ phyblkwrt:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: phyblkwrt
+ primaryKey: false
+ unsigned: false
+ visible: true
+ writetim:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: writetim
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avgiotim:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: avgiotim
+ primaryKey: false
+ unsigned: false
+ visible: true
+ lstiotim:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: lstiotim
+ primaryKey: false
+ unsigned: false
+ visible: true
+ miniotim:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: miniotim
+ primaryKey: false
+ unsigned: false
+ visible: true
+ maxiowtm:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: maxiowtm
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_cpu_statistics.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_cpu_statistics.yaml
new file mode 100644
index 00000000000..9377a361a5d
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_cpu_statistics.yaml
@@ -0,0 +1,99 @@
+#
+# 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.
+#
+
+name: gs_session_cpu_statistics
+columns:
+ datid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: datid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ usename:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: usename
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ node_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: node_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_cpu_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_cpu_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory.yaml
new file mode 100644
index 00000000000..49dcab9d553
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory.yaml
@@ -0,0 +1,51 @@
+#
+# 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.
+#
+
+name: gs_session_memory
+columns:
+ sessid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sessid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ init_mem:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: init_mem
+ primaryKey: false
+ unsigned: false
+ visible: true
+ used_mem:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: used_mem
+ primaryKey: false
+ unsigned: false
+ visible: true
+ peak_mem:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: peak_mem
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory_context.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory_context.yaml
new file mode 100644
index 00000000000..f3dc2e7ba55
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory_context.yaml
@@ -0,0 +1,83 @@
+#
+# 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.
+#
+
+name: gs_session_memory_context
+columns:
+ sessid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sessid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ threadid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: threadid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ contextname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: contextname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ level:
+ caseSensitive: true
+ dataType: 5
+ generated: false
+ name: level
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parent:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: parent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ totalsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: totalsize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ freesize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: freesize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ usedsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: usedsize
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory_detail.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory_detail.yaml
new file mode 100644
index 00000000000..2459adc79d6
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory_detail.yaml
@@ -0,0 +1,83 @@
+#
+# 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.
+#
+
+name: gs_session_memory_detail
+columns:
+ sessid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sessid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sesstype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sesstype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ contextname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: contextname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ level:
+ caseSensitive: true
+ dataType: 5
+ generated: false
+ name: level
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parent:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: parent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ totalsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: totalsize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ freesize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: freesize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ usedsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: usedsize
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory_statistics.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory_statistics.yaml
new file mode 100644
index 00000000000..45649aef66c
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_memory_statistics.yaml
@@ -0,0 +1,99 @@
+#
+# 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.
+#
+
+name: gs_session_memory_statistics
+columns:
+ datid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: datid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ usename:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: usename
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: spill_info
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ node_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: node_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_mem_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_mem_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_stat.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_stat.yaml
new file mode 100644
index 00000000000..862b7025678
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_stat.yaml
@@ -0,0 +1,59 @@
+#
+# 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.
+#
+
+name: gs_session_stat
+columns:
+ sessid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sessid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statid:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: statid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: statname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ statunit:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: statunit
+ primaryKey: false
+ unsigned: false
+ visible: true
+ value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_time.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_time.yaml
new file mode 100644
index 00000000000..1f7129cfaa6
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_session_time.yaml
@@ -0,0 +1,51 @@
+#
+# 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.
+#
+
+name: gs_session_time
+columns:
+ sessid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sessid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ stat_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: stat_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ stat_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: stat_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_shared_memory_detail.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_shared_memory_detail.yaml
new file mode 100644
index 00000000000..b2682891074
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_shared_memory_detail.yaml
@@ -0,0 +1,67 @@
+#
+# 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.
+#
+
+name: gs_shared_memory_detail
+columns:
+ contextname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: contextname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ level:
+ caseSensitive: true
+ dataType: 5
+ generated: false
+ name: level
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parent:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: parent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ totalsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: totalsize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ freesize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: freesize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ usedsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: usedsize
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_sql_count.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_sql_count.yaml
new file mode 100644
index 00000000000..3ee91af4050
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_sql_count.yaml
@@ -0,0 +1,227 @@
+#
+# 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.
+#
+
+name: gs_sql_count
+columns:
+ node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ user_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ select_count:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: select_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ update_count:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: update_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ insert_count:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: insert_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ delete_count:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: delete_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mergeinto_count:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mergeinto_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ddl_count:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: ddl_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dml_count:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: dml_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dcl_count:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: dcl_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_select_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_select_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_select_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: avg_select_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_select_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_select_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_select_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_select_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_update_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_update_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_update_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: avg_update_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_update_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_update_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_update_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_update_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_insert_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_insert_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_insert_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: avg_insert_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_insert_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_insert_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_insert_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_insert_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_delete_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_delete_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ avg_delete_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: avg_delete_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_delete_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_delete_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_delete_elapse:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_delete_elapse
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_stat_session_cu.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_stat_session_cu.yaml
new file mode 100644
index 00000000000..50c8c5ce9e7
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_stat_session_cu.yaml
@@ -0,0 +1,43 @@
+#
+# 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.
+#
+
+name: gs_stat_session_cu
+columns:
+ mem_hit:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: mem_hit
+ primaryKey: false
+ unsigned: false
+ visible: true
+ hdd_sync_read:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: hdd_sync_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ hdd_asyn_read:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: hdd_asyn_read
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_thread_memory_context.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_thread_memory_context.yaml
new file mode 100644
index 00000000000..b1bb9479dc5
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_thread_memory_context.yaml
@@ -0,0 +1,91 @@
+#
+# 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.
+#
+
+name: gs_thread_memory_context
+columns:
+ threadid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: threadid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: tid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ thrdtype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: thrdtype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ contextname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: contextname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ level:
+ caseSensitive: true
+ dataType: 5
+ generated: false
+ name: level
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parent:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: parent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ totalsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: totalsize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ freesize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: freesize
+ primaryKey: false
+ unsigned: false
+ visible: true
+ usedsize:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: usedsize
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_total_memory_detail.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_total_memory_detail.yaml
new file mode 100644
index 00000000000..405aaeb42e9
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_total_memory_detail.yaml
@@ -0,0 +1,43 @@
+#
+# 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.
+#
+
+name: gs_total_memory_detail
+columns:
+ nodename:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: nodename
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memorytype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: memorytype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memorymbytes:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: memorymbytes
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_total_nodegroup_memory_detail.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_total_nodegroup_memory_detail.yaml
new file mode 100644
index 00000000000..80690085224
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_total_nodegroup_memory_detail.yaml
@@ -0,0 +1,43 @@
+#
+# 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.
+#
+
+name: gs_total_nodegroup_memory_detail
+columns:
+ ngname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ngname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memorytype:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: memorytype
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memorymbytes:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: memorymbytes
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_txn_snapshot.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_txn_snapshot.yaml
new file mode 100644
index 00000000000..cb00d28e5e6
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_txn_snapshot.yaml
@@ -0,0 +1,58 @@
+#
+# 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.
+#
+
+name: gs_txn_snapshot
+columns:
+ snptime:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: snptime
+ primaryKey: false
+ unsigned: false
+ visible: true
+ snpxmin:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: snpxmin
+ primaryKey: false
+ unsigned: false
+ visible: true
+ snpcsn:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: snpcsn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ snpsnapshot:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: snpsnapshot
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_txn_snapshot_time_csn_index:
+ name: gs_txn_snapshot_time_csn_index
+ gs_txn_snapshot_csn_xmin_index:
+ name: gs_txn_snapshot_csn_xmin_index
+ gs_txn_snapshot_xmin_index:
+ name: gs_txn_snapshot_xmin_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_uid.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_uid.yaml
new file mode 100644
index 00000000000..a9a9cb706f6
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_uid.yaml
@@ -0,0 +1,38 @@
+#
+# 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.
+#
+
+name: gs_uid
+columns:
+ relid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: relid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ uid_backup:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: uid_backup
+ primaryKey: false
+ unsigned: false
+ visible: true
+indexes:
+ gs_uid_relid_index:
+ name: gs_uid_relid_index
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_cgroup_info.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_cgroup_info.yaml
new file mode 100644
index 00000000000..a15e40e4129
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_cgroup_info.yaml
@@ -0,0 +1,91 @@
+#
+# 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.
+#
+
+name: gs_wlm_cgroup_info
+columns:
+ cgroup_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cgroup_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ priority:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: priority
+ primaryKey: false
+ unsigned: false
+ visible: true
+ usage_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: usage_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ shares:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: shares
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpuacct:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpuacct
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpuset:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpuset
+ primaryKey: false
+ unsigned: false
+ visible: true
+ relpath:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: relpath
+ primaryKey: false
+ unsigned: false
+ visible: true
+ valid:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: valid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ node_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: node_group
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_ec_operator_history.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_ec_operator_history.yaml
new file mode 100644
index 00000000000..f4764de9d96
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_ec_operator_history.yaml
@@ -0,0 +1,131 @@
+#
+# 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.
+#
+
+name: gs_wlm_ec_operator_history
+columns:
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: plan_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ duration:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tuple_processed:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: tuple_processed
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_status:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_status
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_execute_datanode:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_execute_datanode
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_dsn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_dsn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_username:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_username
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_libodbc_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_libodbc_type
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_ec_operator_info.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_ec_operator_info.yaml
new file mode 100644
index 00000000000..221847c261e
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_ec_operator_info.yaml
@@ -0,0 +1,131 @@
+#
+# 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.
+#
+
+name: gs_wlm_ec_operator_info
+columns:
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: plan_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ duration:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tuple_processed:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: tuple_processed
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_status:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_status
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_execute_datanode:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_execute_datanode
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_dsn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_dsn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_username:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_username
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_libodbc_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_libodbc_type
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_ec_operator_statistics.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_ec_operator_statistics.yaml
new file mode 100644
index 00000000000..cc382d91117
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_ec_operator_statistics.yaml
@@ -0,0 +1,99 @@
+#
+# 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.
+#
+
+name: gs_wlm_ec_operator_statistics
+columns:
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: plan_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_status:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_status
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_execute_datanode:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_execute_datanode
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_dsn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_dsn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_username:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_username
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_libodbc_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ec_libodbc_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ec_fetch_count:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: ec_fetch_count
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_instance_history.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_instance_history.yaml
new file mode 100644
index 00000000000..c7b8e9afeca
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_instance_history.yaml
@@ -0,0 +1,139 @@
+#
+# 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.
+#
+
+name: gs_wlm_instance_history
+columns:
+ instancename:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: instancename
+ primaryKey: false
+ unsigned: false
+ visible: true
+ timestamp:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: timestamp
+ primaryKey: false
+ unsigned: false
+ visible: true
+ used_cpu:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: used_cpu
+ primaryKey: false
+ unsigned: false
+ visible: true
+ free_mem:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: free_mem
+ primaryKey: false
+ unsigned: false
+ visible: true
+ used_mem:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: used_mem
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_await:
+ caseSensitive: true
+ dataType: 7
+ generated: false
+ name: io_await
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_util:
+ caseSensitive: true
+ dataType: 7
+ generated: false
+ name: io_util
+ primaryKey: false
+ unsigned: false
+ visible: true
+ disk_read:
+ caseSensitive: true
+ dataType: 7
+ generated: false
+ name: disk_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ disk_write:
+ caseSensitive: true
+ dataType: 7
+ generated: false
+ name: disk_write
+ primaryKey: false
+ unsigned: false
+ visible: true
+ process_read:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: process_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ process_write:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: process_write
+ primaryKey: false
+ unsigned: false
+ visible: true
+ logical_read:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: logical_read
+ primaryKey: false
+ unsigned: false
+ visible: true
+ logical_write:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: logical_write
+ primaryKey: false
+ unsigned: false
+ visible: true
+ read_counts:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: read_counts
+ primaryKey: false
+ unsigned: false
+ visible: true
+ write_counts:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: write_counts
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_operator_history.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_operator_history.yaml
new file mode 100644
index 00000000000..bb63beb654b
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_operator_history.yaml
@@ -0,0 +1,195 @@
+#
+# 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.
+#
+
+name: gs_wlm_operator_history
+columns:
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: plan_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: plan_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ duration:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_dop:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: query_dop
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimated_rows:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: estimated_rows
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tuple_processed:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: tuple_processed
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memory_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: memory_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: spill_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: cpu_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ warning:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: warning
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_operator_info.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_operator_info.yaml
new file mode 100644
index 00000000000..aefc58cd925
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_operator_info.yaml
@@ -0,0 +1,195 @@
+#
+# 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.
+#
+
+name: gs_wlm_operator_info
+columns:
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: plan_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: plan_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ duration:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_dop:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: query_dop
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimated_rows:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: estimated_rows
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tuple_processed:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: tuple_processed
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memory_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: memory_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: spill_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: cpu_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ warning:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: warning
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_operator_statistics.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_operator_statistics.yaml
new file mode 100644
index 00000000000..d9555340891
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_operator_statistics.yaml
@@ -0,0 +1,203 @@
+#
+# 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.
+#
+
+name: gs_wlm_operator_statistics
+columns:
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: plan_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: plan_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ duration:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ status:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: status
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_dop:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: query_dop
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimated_rows:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: estimated_rows
+ primaryKey: false
+ unsigned: false
+ visible: true
+ tuple_processed:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: tuple_processed
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memory_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: memory_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: spill_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: cpu_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ warning:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: warning
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_plan_encoding_table.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_plan_encoding_table.yaml
new file mode 100644
index 00000000000..8c9953fdcf2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_plan_encoding_table.yaml
@@ -0,0 +1,83 @@
+#
+# 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.
+#
+
+name: gs_wlm_plan_encoding_table
+columns:
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: plan_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parent_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: parent_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ startup_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: startup_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rows:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rows
+ primaryKey: false
+ unsigned: false
+ visible: true
+ peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ encode:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: encode
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_plan_operator_history.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_plan_operator_history.yaml
new file mode 100644
index 00000000000..7e588c853f9
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_plan_operator_history.yaml
@@ -0,0 +1,155 @@
+#
+# 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.
+#
+
+name: gs_wlm_plan_operator_history
+columns:
+ datname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: datname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: plan_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ startup_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: startup_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ actual_rows:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: actual_rows
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_dop:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: query_dop
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parent_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: parent_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ left_child_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: left_child_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ right_child_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: right_child_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ operation:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: operation
+ primaryKey: false
+ unsigned: false
+ visible: true
+ orientation:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: orientation
+ primaryKey: false
+ unsigned: false
+ visible: true
+ strategy:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: strategy
+ primaryKey: false
+ unsigned: false
+ visible: true
+ options:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: options
+ primaryKey: false
+ unsigned: false
+ visible: true
+ condition:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: condition
+ primaryKey: false
+ unsigned: false
+ visible: true
+ projection:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: projection
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_plan_operator_info.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_plan_operator_info.yaml
new file mode 100644
index 00000000000..07e9b5022d9
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_plan_operator_info.yaml
@@ -0,0 +1,155 @@
+#
+# 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.
+#
+
+name: gs_wlm_plan_operator_info
+columns:
+ datname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: datname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: plan_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ startup_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: startup_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ actual_rows:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: actual_rows
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_dop:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: query_dop
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parent_node_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: parent_node_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ left_child_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: left_child_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ right_child_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: right_child_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ operation:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: operation
+ primaryKey: false
+ unsigned: false
+ visible: true
+ orientation:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: orientation
+ primaryKey: false
+ unsigned: false
+ visible: true
+ strategy:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: strategy
+ primaryKey: false
+ unsigned: false
+ visible: true
+ options:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: options
+ primaryKey: false
+ unsigned: false
+ visible: true
+ condition:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: condition
+ primaryKey: false
+ unsigned: false
+ visible: true
+ projection:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: projection
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_rebuild_user_resource_pool.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_rebuild_user_resource_pool.yaml
new file mode 100644
index 00000000000..c2c725e89c3
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_rebuild_user_resource_pool.yaml
@@ -0,0 +1,27 @@
+#
+# 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.
+#
+
+name: gs_wlm_rebuild_user_resource_pool
+columns:
+ gs_wlm_rebuild_user_resource_pool:
+ caseSensitive: true
+ dataType: -7
+ generated: false
+ name: gs_wlm_rebuild_user_resource_pool
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_resource_pool.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_resource_pool.yaml
new file mode 100644
index 00000000000..b26bf6c522c
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_resource_pool.yaml
@@ -0,0 +1,99 @@
+#
+# 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.
+#
+
+name: gs_wlm_resource_pool
+columns:
+ rpoid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rpoid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ respool:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: respool
+ primaryKey: false
+ unsigned: false
+ visible: true
+ control_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: control_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parentid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: parentid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ref_count:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: ref_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ active_points:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: active_points
+ primaryKey: false
+ unsigned: false
+ visible: true
+ running_count:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: running_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ waiting_count:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: waiting_count
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_limits:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: io_limits
+ primaryKey: false
+ unsigned: false
+ visible: true
+ io_priority:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: io_priority
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_history.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_history.yaml
new file mode 100644
index 00000000000..3dd351db905
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_history.yaml
@@ -0,0 +1,563 @@
+#
+# 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.
+#
+
+name: gs_wlm_session_history
+columns:
+ datid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: datid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dbname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dbname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ schemaname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: schemaname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ nodename:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: nodename
+ primaryKey: false
+ unsigned: false
+ visible: true
+ username:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: username
+ primaryKey: false
+ unsigned: false
+ visible: true
+ application_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: application_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_addr:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: client_addr
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_hostname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: client_hostname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_port:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: client_port
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_band:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query_band
+ primaryKey: false
+ unsigned: false
+ visible: true
+ block_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: block_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ finish_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: finish_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ duration:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimate_total_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: estimate_total_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ status:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: status
+ primaryKey: false
+ unsigned: false
+ visible: true
+ abort_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: abort_info
+ primaryKey: false
+ unsigned: false
+ visible: true
+ resource_pool:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: resource_pool
+ primaryKey: false
+ unsigned: false
+ visible: true
+ control_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: control_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimate_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: estimate_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memory_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: memory_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: spill_info
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: spill_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: average_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dntime_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: dntime_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: cpu_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ iops_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: iops_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ warning:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: warning
+ primaryKey: false
+ unsigned: false
+ visible: true
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_plan:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query_plan
+ primaryKey: false
+ unsigned: false
+ visible: true
+ node_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: node_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top1_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top1_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top2_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top2_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top3_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top3_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top4_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top4_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top5_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top5_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top1_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top1_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top2_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top2_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top3_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top3_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top4_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top4_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top5_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top5_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top1_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top1_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top2_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top2_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top3_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top3_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top4_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top4_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top5_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top5_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top1_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top1_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top2_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top2_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top3_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top3_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top4_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top4_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top5_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top5_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_mem_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_mem_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_cpu_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_cpu_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_info.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_info.yaml
new file mode 100644
index 00000000000..9c3fa202176
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_info.yaml
@@ -0,0 +1,563 @@
+#
+# 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.
+#
+
+name: gs_wlm_session_info
+columns:
+ datid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: datid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dbname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dbname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ schemaname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: schemaname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ nodename:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: nodename
+ primaryKey: false
+ unsigned: false
+ visible: true
+ username:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: username
+ primaryKey: false
+ unsigned: false
+ visible: true
+ application_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: application_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_addr:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: client_addr
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_hostname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: client_hostname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_port:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: client_port
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_band:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query_band
+ primaryKey: false
+ unsigned: false
+ visible: true
+ block_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: block_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ finish_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: finish_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ duration:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimate_total_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: estimate_total_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ status:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: status
+ primaryKey: false
+ unsigned: false
+ visible: true
+ abort_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: abort_info
+ primaryKey: false
+ unsigned: false
+ visible: true
+ resource_pool:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: resource_pool
+ primaryKey: false
+ unsigned: false
+ visible: true
+ control_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: control_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimate_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: estimate_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memory_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: memory_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: spill_info
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: spill_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: average_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dntime_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: dntime_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: cpu_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ iops_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: iops_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ warning:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: warning
+ primaryKey: false
+ unsigned: false
+ visible: true
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_plan:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query_plan
+ primaryKey: false
+ unsigned: false
+ visible: true
+ node_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: node_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top1_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top1_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top2_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top2_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top3_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top3_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top4_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top4_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top5_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top5_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top1_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top1_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top2_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top2_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top3_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top3_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top4_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top4_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top5_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top5_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top1_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top1_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top2_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top2_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top3_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top3_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top4_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top4_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top5_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top5_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top1_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top1_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top2_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top2_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top3_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top3_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top4_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top4_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top5_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top5_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_mem_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_mem_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_cpu_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_cpu_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_info_all.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_info_all.yaml
new file mode 100644
index 00000000000..cfffe9cd3f4
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_info_all.yaml
@@ -0,0 +1,715 @@
+#
+# 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.
+#
+
+name: gs_wlm_session_info_all
+columns:
+ datid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: datid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dbname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dbname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ schemaname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: schemaname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ nodename:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: nodename
+ primaryKey: false
+ unsigned: false
+ visible: true
+ username:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: username
+ primaryKey: false
+ unsigned: false
+ visible: true
+ application_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: application_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_addr:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: client_addr
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_hostname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: client_hostname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_port:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: client_port
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_band:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query_band
+ primaryKey: false
+ unsigned: false
+ visible: true
+ block_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: block_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ finish_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: finish_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ duration:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimate_total_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: estimate_total_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ status:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: status
+ primaryKey: false
+ unsigned: false
+ visible: true
+ abort_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: abort_info
+ primaryKey: false
+ unsigned: false
+ visible: true
+ resource_pool:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: resource_pool
+ primaryKey: false
+ unsigned: false
+ visible: true
+ control_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: control_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimate_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: estimate_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memory_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: memory_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: spill_info
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: spill_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: average_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dntime_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: dntime_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: cpu_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ iops_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: iops_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ warning:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: warning
+ primaryKey: false
+ unsigned: false
+ visible: true
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_plan:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query_plan
+ primaryKey: false
+ unsigned: false
+ visible: true
+ node_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: node_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top1_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top1_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top2_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top2_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top3_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top3_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top4_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top4_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top5_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top5_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top1_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top1_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top2_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top2_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top3_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top3_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top4_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top4_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top5_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top5_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top1_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top1_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top2_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top2_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top3_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top3_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top4_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top4_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top5_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top5_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top1_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top1_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top2_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top2_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top3_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top3_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top4_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top4_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top5_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top5_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_mem_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_mem_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_cpu_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_cpu_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_returned_rows:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_returned_rows
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_fetched:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_fetched
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_returned:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_returned
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_inserted:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_inserted
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_updated:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_updated
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_deleted:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_deleted
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_blocks_fetched:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_blocks_fetched
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_blocks_hit:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_blocks_hit
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: db_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ execution_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: execution_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parse_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: parse_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: plan_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rewrite_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rewrite_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pl_execution_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pl_execution_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pl_compilation_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pl_compilation_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ net_send_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: net_send_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_io_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: data_io_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_slow_query:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: is_slow_query
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_query_info_all.yaml b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_query_info_all.yaml
new file mode 100644
index 00000000000..d8be6f011f2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/opengauss/pg_catalog/gs_wlm_session_query_info_all.yaml
@@ -0,0 +1,715 @@
+#
+# 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.
+#
+
+name: gs_wlm_session_query_info_all
+columns:
+ datid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: datid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dbname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dbname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ schemaname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: schemaname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ nodename:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: nodename
+ primaryKey: false
+ unsigned: false
+ visible: true
+ username:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: username
+ primaryKey: false
+ unsigned: false
+ visible: true
+ application_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: application_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_addr:
+ caseSensitive: true
+ dataType: 1111
+ generated: false
+ name: client_addr
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_hostname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: client_hostname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ client_port:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: client_port
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_band:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query_band
+ primaryKey: false
+ unsigned: false
+ visible: true
+ block_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: block_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: start_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ finish_time:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: finish_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ duration:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: duration
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimate_total_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: estimate_total_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ status:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: status
+ primaryKey: false
+ unsigned: false
+ visible: true
+ abort_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: abort_info
+ primaryKey: false
+ unsigned: false
+ visible: true
+ resource_pool:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: resource_pool
+ primaryKey: false
+ unsigned: false
+ visible: true
+ control_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: control_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ estimate_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: estimate_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_memory:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_memory
+ primaryKey: false
+ unsigned: false
+ visible: true
+ memory_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: memory_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_info:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: spill_info
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_spill_size:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_spill_size
+ primaryKey: false
+ unsigned: false
+ visible: true
+ spill_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: spill_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_dn_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: average_dn_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dntime_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: dntime_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: min_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: max_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ total_cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: total_cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: cpu_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ min_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: min_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ average_peak_iops:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: average_peak_iops
+ primaryKey: false
+ unsigned: false
+ visible: true
+ iops_skew_percent:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: iops_skew_percent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ warning:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: warning
+ primaryKey: false
+ unsigned: false
+ visible: true
+ queryid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: queryid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ query_plan:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: query_plan
+ primaryKey: false
+ unsigned: false
+ visible: true
+ node_group:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: node_group
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top1_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top1_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top2_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top2_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top3_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top3_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top4_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top4_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top5_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cpu_top5_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top1_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top1_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top2_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top2_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top3_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top3_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top4_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top4_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top5_node_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: mem_top5_node_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top1_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top1_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top2_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top2_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top3_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top3_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top4_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top4_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_top5_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_top5_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top1_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top1_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top2_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top2_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top3_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top3_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top4_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top4_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ mem_top5_value:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: mem_top5_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_mem_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_mem_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ top_cpu_dn:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: top_cpu_dn
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_returned_rows:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_returned_rows
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_fetched:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_fetched
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_returned:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_returned
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_inserted:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_inserted
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_updated:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_updated
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_tuples_deleted:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_tuples_deleted
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_blocks_fetched:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_blocks_fetched
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_blocks_hit:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: n_blocks_hit
+ primaryKey: false
+ unsigned: false
+ visible: true
+ db_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: db_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cpu_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: cpu_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ execution_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: execution_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parse_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: parse_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ plan_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: plan_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ rewrite_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: rewrite_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pl_execution_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pl_execution_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pl_compilation_time:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: pl_compilation_time
... 27888 lines suppressed ...