- 综合排序
- 最热优先
- 最新优先
- 来自专栏Greenplum
Greenplum 列存表(AO表)的膨胀和垃圾检查与空间收缩
关系名 2.1 执行查看命令 以下命令是开启执行的时间，并查看表的类型 stagging=# \timing on Timing is on. stagging=# select distinct relstorage from pg_class ; relstorage ------------ h a x v c (5 rows) Time: 6.132 ms 2.2 名词解释 timing 打开 =# select t2.nspname, t1.relname from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage =# select t2.nspname, t1.relname from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage gp_aovisimap_compaction_info(t1.oid)).* from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage
3.1K20发布于 2020-10-26 - 来自专栏Greenplum
Greenplum释放表的空间
2.1 执行查看命令 stagging=# \timing Timing is on. stagging=# select distinct relstorage from pg_class ; relstorage =# select t2.nspname, t1.relname from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage gp_aovisimap_compaction_info(t1.oid)).* from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage gp_aovisimap_compaction_info(t1.oid)).* from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage gp_aovisimap_compaction_info(t1.oid)).* from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage
1.5K20发布于 2019-08-05 - 来自专栏Greenplum
Greenplum 列存表(AO表)的膨胀和垃圾检查与空间收缩
2 查看表的储存类型 2.1 执行查看命令 stagging=# \timing Timing is on. stagging=# select distinct relstorage from pg_class ; relstorage ------------ h a x v c (5 rows) Time: 6.132 ms 2.2 名词解释 timing 打开SQL的执行时间 h = 堆表 =# select t2.nspname, t1.relname from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage gp_aovisimap_compaction_info(t1.oid)).* from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage gp_aovisimap_compaction_info(t1.oid)).* from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage
4.7K21发布于 2018-10-12 - 来自专栏Greenplum
Greenplum 元数据信息
pg_catalog.pg_class c, pg_catalog.pg_namespace nwheren.oid = c.relnamespaceand n.nspname='schemaname 'and pc.relstorage AO 表 select t2.nspname, t1.relname from pg_class t1, pg_namespace t2where t1.relnamespace=t2.oid and relstorage 查看数据库中的堆表 select t2.nspname, t1.relname from pg_class t1, pg_namespace t2where t1.relnamespace=t2.oid and relstorage 外部表信息 select t2.nspname, t1.relname from pg_class t1, pg_namespace t2where t1.relnamespace=t2.oid and relstorage
1.6K70发布于 2020-07-02 - 来自专栏Greenplum
Greenplum高级使用
pg_catalog.pg_namespace n where n.oid = c.relnamespace and n.nspname='main' and c.relkind='r' and relstorage ='x' main: 代表当前的schema的信息 9.1.5.5 查询schema下的普通表的列表 9.1.5.5.3 获取类型的表 chinadaas=# select distinct relstorage from pg_class ; relstorage ------------ h a x v c (5 rows) Time: 30.556 ms 参数说明: a -- 行存储AO pg_catalog.pg_namespace n where n.oid = c.relnamespace and n.nspname='main' and c.relkind='r' and relstorage
1.7K10发布于 2019-01-28 - 来自专栏网站知识
Greenplum查看psql操作执行的具体语句
relhasrules, reltriggers <> 0, relhasoids, pg_catalog.array_to_string(reloptions, E', '), reltablespace, relstorage
98960发布于 2021-03-19 - 来自专栏Greenplum
Greenplum数据库巡检报告
表 select t2.nspname, t1.relname from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage 4.7.4.2 查看堆表的数量 select count(*) from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage 4.7.5.2 查看外部表的数量 select count(*) from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage 查看制定schema下视图的数量 select count(*) from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage 表 SELECT ns.nspname,pc.relname FROM pg_class pc,pg_namespace ns WHERE pc.relnamespace = ns.oid AND relstorage
3K102发布于 2020-04-20 - 来自专栏Greenplum
Greenplum数据库使用总结(干货满满)--高级使用
pg_catalog.pg_namespace n where n.oid = c.relnamespace and n.nspname='main' and c.relkind='r' and relstorage pg_catalog.pg_namespace n where n.oid = c.relnamespace and n.nspname='main' and c.relkind='r' and relstorage in ('h', 'a'); main: 代表当前的schema的信息 9.1.5.6 获取参数说明 注意，relstorage字段取值'x'表示外部表,'h'表示heap表,'a'表示append-only
4.2K20发布于 2019-08-05 - 来自专栏Greenplum
Greenplum 元数据常用查询语句
pg_catalog.pg_class c, pg_catalog.pg_namespace n where n.oid = c.relnamespace and n.nspname='schemaname ' and pc.relstorage
3.3K60发布于 2020-01-14 - 来自专栏Greenplum
Greenplum集群扩容总结
的名字 查询schema下外表的数量 select count(*) from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage gp_aovisimap_compaction_info(t1.oid)).* from pg_class t1, pg_namespace t2 where t1.relnamespace=t2.oid and relstorage
2.9K42编辑于 2022-03-04 - 来自专栏大数据生态
Greenplum 操作锦囊
查看表的存储格式select relstorage from pg_class where relname = '{table_name}'; a -- 行存储AO表 h -- heap堆表
1.9K133编辑于 2023-11-08
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号