How do I enable command string text for sessions in Redshift?

by Mar 28, 2019

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