Pivotal Greenplum Database (GPDB) 4.3.x, 4.2.6.x, and later
This article describes how to change the current_query display content-length in pg_stat_activity view.
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:
For further information, refer to the Pivotal Greenplum Database Administration Guide.