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