The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Explain plan query size limit?

As part of a predictive model we have a query that is 4,344 lines long. When we try to run an explain plan we get the message: “ALERT! SQL/Command truncated due to size”.
I couldn't find any documentation as to the size limit for an explain plan - does anyone know? Clearly the query needs to be rewritten but it would be nice to know the size limit.
thanks
0
Comments
Hi,
You can increase the size of the MaxParsedQuerySizeMB config param. The default is 512 MB. Although, note that this param should be changed under support guidance...
Thanks, Jim!