Is there any online url for VSQL tutorial ?

Hi,

 Please find the URL below. http://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/ProgrammersGuide/vsql/UsingVsql.htm%3FTocPath%3DProgrammer's%20Guide%7CUsing%20vsql%7C_____0

It explains all the options regarding vsql and its usage

-Regards,

 Sruthi

Hello Shruti,

Thanks for the response. I am looking some more vsql statements further more which i did not find in the documents. For example like I want to check the following information from VSQL

CPU/Memory/Disk I/O(Last Hour)
'General Pool' Activity
Database Nodes Health
Query Processing Activity
Database Nodes Health
I/O Wait Notices
Workload Analyzer
Projections

Hi,

   The following links provide you with the required information.

1. V_CATALOG schema contains system tables provide information (metadata) about  tables, constraints, users, projections, and so on.

http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/CATALOG/V_CATALOGSchema.htm%3FTocPath%3DSQL%2520Reference%2520Manual%7CHP%2520Vertica%2520System%2520Tables%7CV_CATALOG%2520Schema%7C_____0

2. V_MONITOR schema contains system tables that provide information about the health of the HP Vertica database.

http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/V_MONITORSchema.htm%3FTocPath%3DSQL%2520Reference%2520Manual%7CHP%2520Vertica%2520System%2520Tables%7CV_MONITOR%2520Schema%7C_____0

-Regards,

 Sruthi