The query text for all sessions on my Redshift cluster show <command string not enable>. Is this something I can configure or is it just not supported in Redshift? If it is configurable, how?
Are you looking at the pg_stats_activity table? If so, I think you need to enable stats_command_string and restart the cluster. I think on Redshift there is a table called stv_inflight which might give you similiar information.
Hope that helps,