Profile parameters and their set limit - how to check?

Sankarmn

I have created the profiles.
How do I check by vsql to see what limits has been set for the created profile?

Jim_Knicely

Check the V_CATALOG.PROFILES and V_CATALOG.PROFILE_PARAMETERS system tables.

Doc references:
https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/PROFILES.htm
https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/PROFILE_PARAMETERS.htm