Pivotal Knowledge Base

Follow

How to Change the current_query Display Content Length in pg_stat_activity View

Environment

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

Purpose

This article describes how to change the current_query display content-length in pg_stat_activity view.

Procedure 

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.

Comments

Powered by Zendesk