Auditiing in greenplum

List all SQL statements run over a certain period of time

posted Aug 9, 2013, 5:54 AM by Sachchida Ojha

SELECT loguser, logdatabase, logmessage
FROM gp_toolkit.__gp_log_master_ext
WHERE logseverity='LOG' and logmessage ~ '^statement:'
AND logtime between '2013-01-01' and '2013-01-31';

1-1 of 1