Part V. Using PPEM

Table of Contents

30. Logging in to the Web Application
31. Web Application Interface
32. System Configuration
32.1. Viewing PPEM Summary Information
32.2. Agents
32.3. Tags
33. User Management
33.1. Users
33.2. User Groups
33.3. User Roles and Privileges
34. Instances
34.1. Creating an Instance
34.2. Viewing Instances
34.3. Restarting an Instance
34.4. Checking the Consistency of an Instance Data Directory
34.5. Stopping and Starting an Instance
34.6. Creating a Backup
34.7. Applying and Removing a Configuration Preset From an Instance
34.8. Editing an Instance
34.9. Selecting a Repository Instance
34.10. Deleting an Instance
35. Clusters
35.1. Creating a Cluster
35.2. Viewing Clusters
35.3. Editing a Cluster
35.4. Deleting a Cluster
35.5. Managing Nodes of BiHA Clusters
35.6. Migration of BiHA Clusters
36. Configuration Presets
36.1. Creating a Configuration Preset
36.2. Viewing Configuration Presets
36.3. Applying a Configuration Preset
36.4. Editing a Configuration Preset
36.5. Deleting a Configuration Preset
37. Tablespaces
37.1. Creating a Tablespace
37.2. Viewing Tablespaces
37.3. Renaming a Tablespace
37.4. Deleting a Tablespace
38. Databases
38.1. Creating a Database
38.2. Viewing Databases
38.3. Running the psql Terminal
38.4. Collecting the Planner Statistics for a Database
38.5. Editing a Statistics Collecting Schedule for a Database
38.6. Reindexing a Database
38.7. Editing a Database Reindexing Schedule
38.8. Vacuuming a Database
38.9. Editing a Database Vacuuming Schedule
38.10. Renaming a Database
38.11. Deleting a Database
39. Schemas
39.1. Creating a Schema
39.2. Viewing Schemas
39.3. Editing a Schema
39.4. Deleting a Schema
40. Tables
40.1. Creating a Table
40.2. Viewing Tables
40.3. Collecting the Planner Statistics for a Table
40.4. Editing a Statistics Collecting Schedule for a Table
40.5. Reindexing a Table
40.6. Editing a Table Reindexing Schedule
40.7. Vacuuming a Table
40.8. Editing a Table Vacuuming Schedule
40.9. Viewing Table Constraints
40.10. Viewing Table Storage Layers
40.11. Editing a Table
40.12. Viewing Table Columns
40.13. Editing a Table Column
40.14. Deleting a Table Column
40.15. Deleting a Table
40.16. Table Storage Parameters
41. Indexes
41.1. Creating an Index
41.2. Viewing Indexes
41.3. Reindexing an Index
41.4. Editing an Index
41.5. Deleting an Index
42. Functions
42.1. Creating a Function
42.2. Viewing Functions
42.3. Editing a Function
42.4. Deleting a Function
43. Sequences
43.1. Creating a Sequence
43.2. Viewing Sequences
43.3. Editing a Sequence
43.4. Deleting a Sequence
44. Control Center
45. Metrics
45.1. Viewing Main Metrics
45.2. Creating an SQL Metric
45.3. Viewing SQL Metrics
45.4. Editing an SQL Metric
45.5. Deleting an SQL Metric
46. Alerts
46.1. Pre-Configuring Alerts
46.2. Creating an Alert
46.3. Viewing Alerts
46.4. Viewing Detailed Alert Information
46.5. Disabling and Enabling Alerts
46.6. Editing an Alert
46.7. Editing Alert Recipients
46.8. Clearing Alert History
46.9. Deleting an Alert
47. Activity
47.1. User Sessions
47.2. Wait Event Statistics
47.3. Vacuum Processes
47.4. Statistics Collection Processes
47.5. Clustering Processes
47.6. Reindexing or Index Creation Processes
47.7. Base Backup Processes
47.8. Copying Processes
48. Backend Diagnostics
48.1. Configuring Backend Diagnostics
48.2. Downloading a Diagnostic File
48.3. Deleting a Diagnostic File
49. CPU Usage Reports
49.1. Viewing a CPU Usage Report
49.2. Configuring the Retention Period for CPU Usage Reports
49.3. Downloading a CPU Usage Report
50. SQL Statistics
51. Repository Maintenance
51.1. Creating a Housekeeping Rule
51.2. Viewing the Repository Summary
51.3. Viewing Housekeeping Rules
51.4. Viewing Detailed Housekeeping Rule Information
51.5. Running a Housekeeping Rule
51.6. Editing a Housekeeping Rule
51.7. Deleting a Housekeeping Rule
52. Instance Parameters
52.1. Viewing Instance Parameters
52.2. Editing Instance Parameters
53. Extensions
53.1. Installing Extensions
53.2. Viewing Extensions
53.3. Editing an Extension
53.4. Deleting an Extension
54. Profiler
54.1. Profiler Servers
54.2. Samples
54.3. Viewing Profiler Graphs
54.4. Sampling Schedules
54.5. Reports
55. Authentication
55.1. Viewing Authentication Rules
55.2. Editing Authentication Rules
56. Instance Roles
56.1. Creating an Instance Role
56.2. Viewing Instance Roles
56.3. Editing an Instance Role
56.4. Deleting an Instance Role
57. Message Log
58. Task Console
58.1. Viewing Tasks
58.2. Managing Schedules
58.3. Managing Mass Instance Operations
59. Backup
59.1. Dashboard
59.2. Storages
59.3. Instance Binds
59.4. Backups
59.5. Backup Schedules
59.6. Configuring Backup Storage Parameters
60. Event Log
60.1. Pre-Configuring Logging of Audit Events
60.2. Viewing Event Log
60.3. Viewing Detailed Event Information
60.4. Downloading Event Log
60.5. Clearing Event Log
61. Query Plan Visualization
61.1. Creating a Query Plan
61.2. Visualizing a Query Plan
61.3. Editing a Query Plan
61.4. Sharing a Query Plan With Other Users
61.5. Deleting a Query Plan