Part V. Using PPEM

Table of Contents

33. Logging in to the Web Application
34. Web Application Interface
35. System Configuration
35.1. Viewing PPEM Summary Information
35.2. Configuring PPEM Repository Database
35.3. Agents
35.4. Tags
36. User Management
36.1. Users
36.2. User Groups
36.3. User Roles and Privileges
37. Instances
37.1. Creating an Instance
37.2. Viewing Instances
37.3. Restarting an Instance
37.4. Checking the Consistency of an Instance Data Directory
37.5. Stopping and Starting an Instance
37.6. Creating a Backup
37.7. Applying and Removing a Configuration Preset From an Instance
37.8. Editing an Instance
37.9. Selecting a Repository Instance
37.10. Deleting an Instance
38. Clusters
38.1. Creating a Cluster
38.2. Viewing Clusters
38.3. Editing a Cluster
38.4. Deleting a Cluster
38.5. Managing Nodes of BiHA Clusters
38.6. Migration of BiHA Clusters
39. Configuration Presets
39.1. Creating a Configuration Preset
39.2. Viewing Configuration Presets
39.3. Applying a Configuration Preset
39.4. Editing a Configuration Preset
39.5. Deleting a Configuration Preset
40. Tablespaces
40.1. Creating a Tablespace
40.2. Viewing Tablespaces
40.3. Renaming a Tablespace
40.4. Deleting a Tablespace
41. Databases
41.1. Creating a Database
41.2. Viewing Databases
41.3. Running the psql Terminal
41.4. Collecting the Planner Statistics for a Database
41.5. Editing a Statistics Collecting Schedule for a Database
41.6. Reindexing a Database
41.7. Editing a Database Reindexing Schedule
41.8. Vacuuming a Database
41.9. Editing a Database Vacuuming Schedule
41.10. Renaming a Database
41.11. Deleting a Database
42. Schemas
42.1. Creating a Schema
42.2. Viewing Schemas
42.3. Editing a Schema
42.4. Deleting a Schema
43. Tables
43.1. Creating a Table
43.2. Viewing Tables
43.3. Collecting the Planner Statistics for a Table
43.4. Editing a Statistics Collecting Schedule for a Table
43.5. Reindexing a Table
43.6. Editing a Table Reindexing Schedule
43.7. Vacuuming a Table
43.8. Editing a Table Vacuuming Schedule
43.9. Viewing Table Constraints
43.10. Viewing Table Storage Layers
43.11. Editing a Table
43.12. Viewing Table Columns
43.13. Editing a Table Column
43.14. Deleting a Table Column
43.15. Deleting a Table
43.16. Table Storage Parameters
44. Indexes
44.1. Creating an Index
44.2. Viewing Indexes
44.3. Reindexing an Index
44.4. Editing an Index
44.5. Deleting an Index
45. Functions
45.1. Creating a Function
45.2. Viewing Functions
45.3. Editing a Function
45.4. Deleting a Function
46. Sequences
46.1. Creating a Sequence
46.2. Viewing Sequences
46.3. Editing a Sequence
46.4. Deleting a Sequence
47. Control Center
48. Metrics
48.1. Viewing Main Metrics
48.2. Creating an SQL Metric
48.3. Viewing SQL Metrics
48.4. Editing an SQL Metric
48.5. Deleting an SQL Metric
49. Alerts
49.1. Pre-Configuring Alerts
49.2. Creating an Alert
49.3. Viewing Alerts
49.4. Viewing Detailed Alert Information
49.5. Disabling and Enabling Alerts
49.6. Editing an Alert
49.7. Editing Alert Recipients
49.8. Clearing Alert History
49.9. Deleting an Alert
50. Activity
50.1. User Sessions
50.2. Wait Event Statistics
50.3. Vacuum Processes
50.4. Statistics Collection Processes
50.5. Clustering Processes
50.6. Reindexing or Index Creation Processes
50.7. Base Backup Processes
50.8. Copying Processes
51. Backend Diagnostics
51.1. Configuring Backend Diagnostics
51.2. Downloading a Diagnostic File
51.3. Deleting a Diagnostic File
52. CPU Usage Reports
52.1. Viewing a CPU Usage Report
52.2. Configuring the Retention Period for CPU Usage Reports
52.3. Downloading a CPU Usage Report
53. SQL Statistics
54. Active Session History
54.1. Managing Active Session Profiling
54.2. Viewing Total Wait Event Time
55. Repository Maintenance
55.1. Creating a Housekeeping Rule
55.2. Viewing the Repository Summary
55.3. Viewing Housekeeping Rules
55.4. Viewing Detailed Housekeeping Rule Information
55.5. Running a Housekeeping Rule
55.6. Editing a Housekeeping Rule
55.7. Deleting a Housekeeping Rule
56. Instance Parameters
56.1. Viewing Instance Parameters
56.2. Editing Instance Parameters
57. Extensions
57.1. Installing Extensions
57.2. Viewing Extensions
57.3. Editing an Extension
57.4. Deleting an Extension
58. Profiler
58.1. Profiler Servers
58.2. Samples
58.3. Viewing Profiler Graphs
58.4. Sampling Schedules
58.5. Reports
59. Authentication
59.1. Viewing Authentication Rules
59.2. Editing Authentication Rules
60. Instance Roles
60.1. Creating an Instance Role
60.2. Viewing Instance Roles
60.3. Editing an Instance Role
60.4. Deleting an Instance Role
61. Message Log
62. Task Console
62.1. Viewing Tasks
62.2. Managing Schedules
62.3. Managing Mass Instance Operations
63. Backup
63.1. Dashboard
63.2. Storages
63.3. Instance Binds
63.4. Backups
63.5. Backup Schedules
63.6. Configuring Backup Storage Parameters
64. Event Log
64.1. Pre-Configuring Logging of Audit Events
64.2. Viewing Event Log
64.3. Viewing Detailed Event Information
64.4. Downloading Event Log
64.5. Clearing Event Log
65. Query Plan Visualization
65.1. Creating a Query Plan
65.2. Visualizing a Query Plan
65.3. Editing a Query Plan
65.4. Sharing a Query Plan With Other Users
65.5. Deleting a Query Plan