关系名 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
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
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
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
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
relhasrules, reltriggers 0, relhasoids, pg_catalog.array_to_string(reloptions, E', '), reltablespace, relstorage
表 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
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
pg_catalog.pg_class c, pg_catalog.pg_namespace n where n.oid = c.relnamespace and n.nspname='schemaname ' and pc.relstorage
的名字 查询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
查看表的存储格式select relstorage from pg_class where relname = '{table_name}'; a -- 行存储AO表 h -- heap堆表
领取专属 10元无门槛券
手把手带您无忧上云