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?
Thanks,
Darwin
Response
Thomas Conrad over 4 years ago
Hello,
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,
Tom