Part V. Using PPEM

Table of Contents

31. Logging in to the Web Application
32. Web Application Interface
33. System Configuration
33.1. Viewing PPEM Summary Information
33.2. Configuring PPEM Repository Database
33.3. Agents
33.4. Tags
34. User Management
34.1. Users
34.2. User Groups
34.3. User Roles and Privileges
35. Instances
35.1. Creating an Instance
35.2. Viewing Instances
35.3. Restarting an Instance
35.4. Checking the Consistency of an Instance Data Directory
35.5. Stopping and Starting an Instance
35.6. Creating a Backup
35.7. Applying and Removing a Configuration Preset From an Instance
35.8. Editing an Instance
35.9. Selecting a Repository Instance
35.10. Deleting an Instance
36. Clusters
36.1. Creating a Cluster
36.2. Viewing Clusters
36.3. Editing a Cluster
36.4. Deleting a Cluster
36.5. Managing Nodes of BiHA Clusters
36.6. Migration of BiHA Clusters
37. Configuration Presets
37.1. Creating a Configuration Preset
37.2. Viewing Configuration Presets
37.3. Applying a Configuration Preset
37.4. Editing a Configuration Preset
37.5. Deleting a Configuration Preset
38. Tablespaces
38.1. Creating a Tablespace
38.2. Viewing Tablespaces
38.3. Renaming a Tablespace
38.4. Deleting a Tablespace
39. Databases
39.1. Creating a Database
39.2. Viewing Databases
39.3. Running the psql Terminal
39.4. Collecting the Planner Statistics for a Database
39.5. Editing a Statistics Collecting Schedule for a Database
39.6. Reindexing a Database
39.7. Editing a Database Reindexing Schedule
39.8. Vacuuming a Database
39.9. Editing a Database Vacuuming Schedule
39.10. Renaming a Database
39.11. Deleting a Database
40. Schemas
40.1. Creating a Schema
40.2. Viewing Schemas
40.3. Editing a Schema
40.4. Deleting a Schema
41. Tables
41.1. Creating a Table
41.2. Viewing Tables
41.3. Collecting the Planner Statistics for a Table
41.4. Editing a Statistics Collecting Schedule for a Table
41.5. Reindexing a Table
41.6. Editing a Table Reindexing Schedule
41.7. Vacuuming a Table
41.8. Editing a Table Vacuuming Schedule
41.9. Viewing Table Constraints
41.10. Viewing Table Storage Layers
41.11. Editing a Table
41.12. Viewing Table Columns
41.13. Editing a Table Column
41.14. Deleting a Table Column
41.15. Deleting a Table
41.16. Table Storage Parameters
42. Indexes
42.1. Creating an Index
42.2. Viewing Indexes
42.3. Reindexing an Index
42.4. Editing an Index
42.5. Deleting an Index
43. Functions
43.1. Creating a Function
43.2. Viewing Functions
43.3. Editing a Function
43.4. Deleting a Function
44. Sequences
44.1. Creating a Sequence
44.2. Viewing Sequences
44.3. Editing a Sequence
44.4. Deleting a Sequence
45. Control Center
46. Metrics
46.1. Viewing Main Metrics
46.2. Creating an SQL Metric
46.3. Viewing SQL Metrics
46.4. Editing an SQL Metric
46.5. Deleting an SQL Metric
47. Alerts
47.1. Pre-Configuring Alerts
47.2. Creating an Alert
47.3. Viewing Alerts
47.4. Viewing Detailed Alert Information
47.5. Disabling and Enabling Alerts
47.6. Editing an Alert
47.7. Editing Alert Recipients
47.8. Clearing Alert History
47.9. Deleting an Alert
48. Activity
48.1. User Sessions
48.2. Wait Event Statistics
48.3. Vacuum Processes
48.4. Statistics Collection Processes
48.5. Clustering Processes
48.6. Reindexing or Index Creation Processes
48.7. Base Backup Processes
48.8. Copying Processes
49. Backend Diagnostics
49.1. Configuring Backend Diagnostics
49.2. Downloading a Diagnostic File
49.3. Deleting a Diagnostic File
50. CPU Usage Reports
50.1. Viewing a CPU Usage Report
50.2. Configuring the Retention Period for CPU Usage Reports
50.3. Downloading a CPU Usage Report
51. SQL Statistics
52. Active Session History
52.1. Managing Active Session Profiling
52.2. Viewing Total Wait Event Time
53. Repository Maintenance
53.1. Creating a Housekeeping Rule
53.2. Viewing the Repository Summary
53.3. Viewing Housekeeping Rules
53.4. Viewing Detailed Housekeeping Rule Information
53.5. Running a Housekeeping Rule
53.6. Editing a Housekeeping Rule
53.7. Deleting a Housekeeping Rule
54. Instance Parameters
54.1. Viewing Instance Parameters
54.2. Editing Instance Parameters
55. Extensions
55.1. Installing Extensions
55.2. Viewing Extensions
55.3. Editing an Extension
55.4. Deleting an Extension
56. Profiler
56.1. Profiler Servers
56.2. Samples
56.3. Viewing Profiler Graphs
56.4. Sampling Schedules
56.5. Reports
57. Authentication
57.1. Viewing Authentication Rules
57.2. Editing Authentication Rules
58. Instance Roles
58.1. Creating an Instance Role
58.2. Viewing Instance Roles
58.3. Editing an Instance Role
58.4. Deleting an Instance Role
59. Message Log
60. Task Console
60.1. Viewing Tasks
60.2. Managing Schedules
60.3. Managing Mass Instance Operations
61. Backup
61.1. Dashboard
61.2. Storages
61.3. Instance Binds
61.4. Backups
61.5. Backup Schedules
61.6. Configuring Backup Storage Parameters
62. Event Log
62.1. Pre-Configuring Logging of Audit Events
62.2. Viewing Event Log
62.3. Viewing Detailed Event Information
62.4. Downloading Event Log
62.5. Clearing Event Log
63. Query Plan Visualization
63.1. Creating a Query Plan
63.2. Visualizing a Query Plan
63.3. Editing a Query Plan
63.4. Sharing a Query Plan With Other Users
63.5. Deleting a Query Plan