Is there any online url for VSQL tutorial ?

UJJWAL_RANA

Hi,

I am looking for the detail information related to VSQL. I wonder if there is any specific url for VSQL tutorial

SruthiA

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

UJJWAL_RANA

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

 

 

 

 

SruthiA

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