Explain plan query size limit?

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...

dbadmin=> \x
Expanded display is on.
dbadmin=> select parameter_name, current_value, description, change_under_support_guidance from configuration_parameters where parameter_name = 'MaxParsedQuerySizeMB';
-[ RECORD 1 ]-----------------+--------------------------------------------------------------------------------------------------------------------------------------
parameter_name                | MaxParsedQuerySizeMB
current_value                 | 512
description                   | Maximum amount of memory allowed for parsing a single request; Increasing this value may help with 'Request size too big' errors (MB)
change_under_support_guidance | t

Thanks, Jim!