1 of 12 – Greenplum – Instance Manager – Summary
2 of 12 – Greenplum – Instance Manager – Segment
3 of 12 – Greenplum – Security Manager – Tree
4 of 12 – Greenplum – Security Manager – Users
5 of 12 – Greenplum – Security Manager – Groups
6 of 12 – Greenplum – Session Manager – Sessions
7 of 12 – Greenplum – Session Manager – Sessions Stats
8 of 12 – Greenplum – Session Manager – Locks
9 of 12 – Greenplum – Storage Manager – Tree
10 of 12 – Greenplum – Storage Manager – Tablespaces
11 of 12 – Greenplum – Storage Manager – Databases
12 of 12 – Greenplum – Storage Manager – Objects
Greenplum DBA Tools
Aqua Data Studio offers a suite of Greenplum DBA Tools for the monitoring, maintaining and tuning of the Greenplum server. It includes an Instance Manager, Storage Manager, Security Manager, and Session Manager. These managers allow the monitoring and maintenance of Tablespaces, Database Objects, Sessions, Users and Permissions via GUI.
Aqua Data Studio Greenplum Administration Tools Include:
Greenplum1 Instance Manager
Provides GUI view and search access for:
- Instance Summary (Server Component, Value, Group, Description, Extra Info, Context, Type, Source)
- Segments Summary
Greenplum Session Manager
Provides GUI view and search access for:
- Session Details with current statement, Kill Session
- Session Statistics
- Session Locks
- Session Grouping (By Process ID, Auth ID, and more)
Greenplum Storage Manager
Provides GUI view and search access for:
- Tree View for Tablespaces, Databases, Device Usage, Location
- Tablespace Properties and Details
- Properties of Databases, Device Usage, Default Tablespace
- Table, Index Storage View
Greenplum Security Manager
Provides GUI view and search access for:
- Tree View for Users, Groups
- Users View, Create, Alter, Drop
- Groups View, Create, Alter, Drop
References
- ^ Pivotal Greenplum Database Wikipedia article. Greenplum is built on PostgreSQL and operates as a data warehouse and uses a shared-nothing, massively parallel processing (MPP) architecture, available under the terms of the GNU General Public License, owned by Pivotal.
- ^ Greenplum Wikipedia article.