vertica 常用语句

1. 查看所有的表

 select * from tables;

2.

select * from schemata;

3.查看所有的请求队列

 select * from resource_queues limit 10;

4.查看资源池

SELECT name, memorysize, maxmemorysize, priority, runtimepriority,QUEUETIMEOUT,runtimeprioritythreshold, runtimecap, maxconcurrency  FROM V_CATALOG.RESOURCE_POOLS;

部分借鉴自: http://blog.sina.com.cn/s/blog_64995b990102wb4c.html

Leave a comment

Your email address will not be published.

*