Pivotal Knowledge Base


How to Change the current_query Display Content Length in pg_stat_activity View


Pivotal Greenplum Database (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 tries 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