Vertica Database Common Management Command summary

1. Query the database for waiting

SELECT * from Resource_queues where node_name= (select Node_name from Nodes order by Node_name limit 1) Order by queue_entr Y_timestamp desc;

2. Check the current database execution SQL (included in the queue waiting)

3. Resource Pools

3.1 Querying the settings of the current resource pool

SELECT name, memorysize, Maxmemorysize, priority, Runtimepriority,queuetimeout,runtimeprioritythreshold, Runtimecap, MaxConcurrency from V_catalog. Resource_pools;

3.2 Querying the current resource pool usage status

Select Node_name,pool_name,running_query_count as Running,memory_size_kb,memory_inuse_kb,general_memory_borrowed_ kb,query_budget_kb from Resource_pool_status where Running_query_count > 0 order by Pool_name,node_name;

4. Is data persisted to disk, diff=0

Select Latestepoch-earliestepoch as Diff,epochmap,earliestepoch,latestepoch,ahmepoch from Vs_epoch_map;

5. Querying the tuple mover status (dbadmin execution)

Select Node_name,service_name,service_interval_sec as Period,is_enabled,last_run_start,last_run_end from System_ Services where service_name like ' tm% ' ORDER by last_run_end Desc,last_run_start Desc,service_name;

6. Manually persist data (moveout)

Select Do_tm_task (' Moveout ', ');

7. Export the Build Table statement

Select Export_objects ('/tmp/all.sql ', ');

8. View license Information

SELECT Display_license ();