List all SQL statements run over a certain period of time

Post date: Aug 09, 2013 12:54:3 PM

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';