log_statement

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

log_statement

Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type.

Value Range Default Set Classifications
NONE

DDL

MOD

ALL

ALL master

session

reload

superuser