User guide

SELECT ut.userid,
trim(u.usename),
COUNT(text) as count
FROM stl_utilitytext ut
JOIN pg_user u ON ut.userid = u.usesysid
WHERE ut.text LIKE 'SAVEPOINT%'
GROUP BY ut.userid, u.usename
ORDER BY count DESC;
When you know which users have SQL client tools that create savepoints, work with these users to
configure their client tools:
• In SQL Workbench/J and some other tools, users can prevent attempts to roll back to a savepoint by
making sure that transactions are automatically committed. To configure this functionality in SQL
Workbench/J, enable the Autocommit option in the connection profile. For more information about
configuring this option, see Connect to Your Cluster by Using SQL Workbench/J (p. 162).
• For client tools other than SQL Workbench/J, refer to the tool's documentation to either enable automatic
commit functionality or to disable savepoints. Either solution prevents rolling back to savepoints.
For a similar issue with a different solution, see Queries Appear to Hang in the Client and Do Not Reach
the Cluster (p. 176).
API Version 2012-12-01
178
Amazon Redshift Management Guide
Troubleshooting Connection Issues in Amazon Redshift