快速定位查询存储倾斜的表 场景三:查询某个表的数据倾斜情况 执行以下SQL查询某个表的数据倾斜情况,其中tablename替换为实际的表名。 SELECT a.count,b.nodename FROM (SELECT count() AS count,xcnodeid FROM tablename GROUP BY xcnodeid) a, pgxcnode b WHERE a.xcnodeidb.nodeid ORDER BY a.count desc; 返回如下类似信息。若各DN上数据分布差小于10%,表明数据分布均衡。若大于10%,则表示数据出现倾斜。 gaussdb>SELECT a.count,b.nodename FROM (select count() as count,xcnodeid FROM staffs GROUP BY xcnodeid) a, pgxcnode b WHERE a.xcnodeidb.nodeid ORDER BY a.count desc; count nodename + 11010 datanode4 10000 datanode3 12001 datanode2 8995 datanode1 10000 datanode5 7999 datanode6 9995 datanode7 10000 datanode8 (8 rows)