Pivotal Knowledge Base


How to change the current_query display content length in pg_stat_activity view


Product Version
Pivotal Greenplum (GPDB) 4.3.x, 4.2.6.x and later


Since GPDB v4261, Pivotal introduced a new parameter to control the length of current_query column in pg_stat_activity view. This is very useful when the customer try to look at the complete content of their big queries. Please see below description of this new parameter:

Additional Information
For further information, refer to the Pivotal Greenplum Database Administration Guide.  


Powered by Zendesk