Aqua Data Studio offers a suite of Amazon Redshift DBA Tools for the monitoring, maintaining and tuning of the Amazon Redshift server. It includes an Instance Manager, Storage Manager, Security Manager, and Session Manager. These managers allow the monitoring and maintenance of Database Objects, Sessions, Users and Permissions via GUI. A Query History view is also provided.
Aqua Data Studio Amazon Redshift Administration Tools
Amazon Redshift Instance Manager
Provides GUI view and search access for:
- Instance Summary (Server Component, Value, Group, Description, Extra Info, Context, Type, Source)
- Query History with filtering on query type and date range. Execution Plan tab in the bottom pane displays query execution plan for the selected query.
Amazon Redshift Session Manager
Provides GUI view and search access for:
- Session Details, Kill Session
- Session Statistics
- Session Locks
- Session Grouping (By Auth ID, Process ID, and more)
Amazon Redshift Storage Manager
Provides GUI view and search access for:
- Database View, Create, Drop
- Table, Storage View
Amazon Redshift Security Manager
Provides GUI view and search access for:
- Tree View for Users, Groups
- Users View, Create, Alter, Drop
- Groups View, Create, Alter, Drop