Part V. Using PPEM

Table of Contents

32. Logging in to the Web Application
33. Web Application Interface
34. System Configuration
34.1. Viewing PPEM Summary Information
34.2. Configuring PPEM Repository Database
34.3. Agents
34.4. Tags
35. User Management
35.1. Users
35.2. User Groups
35.3. User Roles and Privileges
36. Instances
36.1. Creating an Instance
36.2. Viewing Instances
36.3. Restarting an Instance
36.4. Checking the Consistency of an Instance Data Directory
36.5. Stopping and Starting an Instance
36.6. Creating a Backup
36.7. Applying and Removing a Configuration Preset From an Instance
36.8. Editing an Instance
36.9. Selecting a Repository Instance
36.10. Deleting an Instance
37. Clusters
37.1. Creating a Cluster
37.2. Viewing Clusters
37.3. Editing a Cluster
37.4. Deleting a Cluster
37.5. Managing Nodes of BiHA Clusters
37.6. Migration of BiHA Clusters
38. Configuration Presets
38.1. Creating a Configuration Preset
38.2. Viewing Configuration Presets
38.3. Applying a Configuration Preset
38.4. Editing a Configuration Preset
38.5. Deleting a Configuration Preset
39. Tablespaces
39.1. Creating a Tablespace
39.2. Viewing Tablespaces
39.3. Renaming a Tablespace
39.4. Deleting a Tablespace
40. Databases
40.1. Creating a Database
40.2. Viewing Databases
40.3. Running the psql Terminal
40.4. Collecting the Planner Statistics for a Database
40.5. Editing a Statistics Collecting Schedule for a Database
40.6. Reindexing a Database
40.7. Editing a Database Reindexing Schedule
40.8. Vacuuming a Database
40.9. Editing a Database Vacuuming Schedule
40.10. Renaming a Database
40.11. Deleting a Database
41. Schemas
41.1. Creating a Schema
41.2. Viewing Schemas
41.3. Editing a Schema
41.4. Deleting a Schema
42. Tables
42.1. Creating a Table
42.2. Viewing Tables
42.3. Collecting the Planner Statistics for a Table
42.4. Editing a Statistics Collecting Schedule for a Table
42.5. Reindexing a Table
42.6. Editing a Table Reindexing Schedule
42.7. Vacuuming a Table
42.8. Editing a Table Vacuuming Schedule
42.9. Viewing Table Constraints
42.10. Viewing Table Storage Layers
42.11. Editing a Table
42.12. Viewing Table Columns
42.13. Editing a Table Column
42.14. Deleting a Table Column
42.15. Deleting a Table
42.16. Table Storage Parameters
43. Indexes
43.1. Creating an Index
43.2. Viewing Indexes
43.3. Reindexing an Index
43.4. Editing an Index
43.5. Deleting an Index
44. Functions
44.1. Creating a Function
44.2. Viewing Functions
44.3. Editing a Function
44.4. Deleting a Function
45. Sequences
45.1. Creating a Sequence
45.2. Viewing Sequences
45.3. Editing a Sequence
45.4. Deleting a Sequence
46. Control Center
47. Metrics
47.1. Viewing Main Metrics
47.2. Creating an SQL Metric
47.3. Viewing SQL Metrics
47.4. Editing an SQL Metric
47.5. Deleting an SQL Metric
48. Alerts
48.1. Pre-Configuring Alerts
48.2. Creating an Alert
48.3. Viewing Alerts
48.4. Viewing Detailed Alert Information
48.5. Disabling and Enabling Alerts
48.6. Editing an Alert
48.7. Editing Alert Recipients
48.8. Clearing Alert History
48.9. Deleting an Alert
49. Activity
49.1. User Sessions
49.2. Wait Event Statistics
49.3. Vacuum Processes
49.4. Statistics Collection Processes
49.5. Clustering Processes
49.6. Reindexing or Index Creation Processes
49.7. Base Backup Processes
49.8. Copying Processes
50. Backend Diagnostics
50.1. Configuring Backend Diagnostics
50.2. Downloading a Diagnostic File
50.3. Deleting a Diagnostic File
51. CPU Usage Reports
51.1. Viewing a CPU Usage Report
51.2. Configuring the Retention Period for CPU Usage Reports
51.3. Downloading a CPU Usage Report
52. SQL Statistics
53. Active Session History
53.1. Managing Active Session Profiling
53.2. Viewing Total Wait Event Time
54. Repository Maintenance
54.1. Creating a Housekeeping Rule
54.2. Viewing the Repository Summary
54.3. Viewing Housekeeping Rules
54.4. Viewing Detailed Housekeeping Rule Information
54.5. Running a Housekeeping Rule
54.6. Editing a Housekeeping Rule
54.7. Deleting a Housekeeping Rule
55. Instance Parameters
55.1. Viewing Instance Parameters
55.2. Editing Instance Parameters
56. Extensions
56.1. Installing Extensions
56.2. Viewing Extensions
56.3. Editing an Extension
56.4. Deleting an Extension
57. Profiler
57.1. Profiler Servers
57.2. Samples
57.3. Viewing Profiler Graphs
57.4. Sampling Schedules
57.5. Reports
58. Authentication
58.1. Viewing Authentication Rules
58.2. Editing Authentication Rules
59. Instance Roles
59.1. Creating an Instance Role
59.2. Viewing Instance Roles
59.3. Editing an Instance Role
59.4. Deleting an Instance Role
60. Message Log
61. Task Console
61.1. Viewing Tasks
61.2. Managing Schedules
61.3. Managing Mass Instance Operations
62. Backup
62.1. Dashboard
62.2. Storages
62.3. Instance Binds
62.4. Backups
62.5. Backup Schedules
62.6. Configuring Backup Storage Parameters
63. Event Log
63.1. Pre-Configuring Logging of Audit Events
63.2. Viewing Event Log
63.3. Viewing Detailed Event Information
63.4. Downloading Event Log
63.5. Clearing Event Log
64. Query Plan Visualization
64.1. Creating a Query Plan
64.2. Visualizing a Query Plan
64.3. Editing a Query Plan
64.4. Sharing a Query Plan With Other Users
64.5. Deleting a Query Plan