Part V. Using PPEM

Important

Read Chapter 9 before you begin.

Table of Contents

39. Logging in to the Web Application
40. Web Application Interface
41. System Configuration
41.1. Viewing PPEM Summary Information
41.2. Configuring PPEM Repository Database
41.3. Agents
41.4. Tags
42. User Management
42.1. Users
42.2. User Account
42.3. User Groups
42.4. User Roles and Privileges
43. Instances
43.1. Creating an Instance
43.2. Viewing Instances
43.3. Viewing and Customizing an Instance Overview
43.4. Restarting an Instance
43.5. Checking the Consistency of an Instance Data Directory
43.6. Stopping and Starting an Instance
43.7. Creating a Backup
43.8. Applying and Removing a Configuration Preset From an Instance
43.9. Editing an Instance
43.10. Selecting a Repository Instance
43.11. Configuring Metrics and Log Collection for an Instance
43.12. Deleting an Instance
44. Clusters
44.1. Resolving Network Names of Cluster Nodes
44.2. Creating a Cluster
44.3. Viewing Clusters
44.4. Viewing Cluster Composition
44.5. Editing a Cluster
44.6. Deleting a Cluster
44.7. Managing Nodes
44.8. Viewing Cluster Events
44.9. Migration of BiHA Clusters with Minimal Downtime
44.10. Configuring Metrics and Log Collection for Cluster Nodes
45. Configuration Presets
45.1. Creating a Configuration Preset
45.2. Viewing Configuration Presets
45.3. Applying a Configuration Preset
45.4. Editing a Configuration Preset
45.5. Deleting a Configuration Preset
46. Tablespaces
46.1. Creating a Tablespace
46.2. Viewing Tablespaces
46.3. Renaming a Tablespace
46.4. Deleting a Tablespace
47. Databases
47.1. Creating a Database
47.2. Viewing Databases
47.3. Running the psql Terminal
47.4. Collecting the Planner Statistics for a Database
47.5. Editing a Statistics Collecting Schedule for a Database
47.6. Reindexing a Database
47.7. Editing a Database Reindexing Schedule
47.8. Vacuuming a Database
47.9. Editing a Database Vacuuming Schedule
47.10. Renaming a Database
47.11. Deleting a Database
48. Schemas
48.1. Creating a Schema
48.2. Viewing Schemas
48.3. Editing a Schema
48.4. Deleting a Schema
49. Tables
49.1. Creating a Table
49.2. Viewing Tables
49.3. Collecting the Planner Statistics for a Table
49.4. Editing a Statistics Collecting Schedule for a Table
49.5. Reindexing a Table
49.6. Editing a Table Reindexing Schedule
49.7. Vacuuming a Table
49.8. Editing a Table Vacuuming Schedule
49.9. Viewing Table Constraints
49.10. Viewing Table Storage Layers
49.11. Editing a Table
49.12. Viewing Table Columns
49.13. Editing a Table Column
49.14. Deleting a Table Column
49.15. Deleting a Table
49.16. Table Storage Parameters
50. Indexes
50.1. Creating an Index
50.2. Viewing Indexes
50.3. Reindexing an Index
50.4. Editing an Index
50.5. Deleting an Index
51. Functions
51.1. Creating a Function
51.2. Viewing Functions
51.3. Editing a Function
51.4. Deleting a Function
52. Sequences
52.1. Creating a Sequence
52.2. Viewing Sequences
52.3. Editing a Sequence
52.4. Deleting a Sequence
53. Control Center
54. Metrics
54.1. Viewing Main Metrics
54.2. Creating an SQL Metric
54.3. Viewing SQL Metrics
54.4. Editing an SQL Metric
54.5. Deleting an SQL Metric
55. Alerts
55.1. Pre-Configuring Alerts
55.2. Creating an Alert
55.3. Viewing Alerts
55.4. Viewing Detailed Alert Information
55.5. Disabling and Enabling Alerts
55.6. Editing an Alert
55.7. Editing Alert Recipients
55.8. Clearing Alert History
55.9. Deleting an Alert
56. Issues and Recommendations
56.1. Viewing Issues and Recommendations
56.2. Running a Check
56.3. Configuring Check Coverage
56.4. Viewing Metrics with Issues
56.5. Viewing Issue Detailed Information
56.6. Viewing Instance Check Parameters
56.7. Viewing Metrics
56.8. Viewing Metric Description
56.9. Configuring Metric Analysis
57. Activity
57.1. User Sessions
57.2. Wait Event Statistics
57.3. Vacuum Processes
57.4. Statistics Collection Processes
57.5. Clustering Processes
57.6. Reindexing or Index Creation Processes
57.7. Base Backup Processes
57.8. Copying Processes
58. Backend Diagnostics
58.1. Configuring Backend Diagnostics
58.2. Downloading a Diagnostic File
58.3. Deleting a Diagnostic File
59. CPU Usage Reports
59.1. Viewing a CPU Usage Report
59.2. Viewing a Detailed Hourly CPU Usage Report
59.3. Configuring the Retention Period for CPU Usage Reports
59.4. Downloading a CPU Usage Report
60. SQL Statistics
61. Active Session History
61.1. Managing Active Session Profiling
61.2. Viewing Active Session History
61.3. Managing Active Session History Storages
62. Repository Maintenance
62.1. Creating a Housekeeping Rule
62.2. Viewing the Repository Summary
62.3. Viewing Housekeeping Rules
62.4. Viewing Detailed Housekeeping Rule Information
62.5. Running a Housekeeping Rule
62.6. Truncating Tables Manually
62.7. Editing a Housekeeping Rule
62.8. Deleting a Housekeeping Rule
63. Instance Parameters
63.1. Viewing Instance Parameters
63.2. Editing Instance Parameters
64. Cluster Parameters
64.1. Viewing Cluster Parameters
64.2. Editing Cluster Parameters
65. Extensions
65.1. Installing Extensions
65.2. Viewing Extensions
65.3. Editing an Extension
65.4. Deleting an Extension
66. Profiler
66.1. Profiler Servers
66.2. Snapshots
66.3. Viewing Profiler Graphs
66.4. Snapshot Schedules
66.5. Reports
67. Authentication
67.1. Viewing Authentication Rules
67.2. Editing Authentication Rules
68. Instance Roles
68.1. Creating an Instance Role
68.2. Viewing Instance Roles
68.3. Editing an Instance Role
68.4. Deleting an Instance Role
69. Message Log
70. Task Console
70.1. Viewing Tasks
70.2. Managing Schedules
70.3. Managing Mass Instance Operations
71. Backup
71.1. Dashboard
71.2. Storages
71.3. Instance Binds
71.4. Backups
71.5. Backup Schedules
71.6. Configuring Backup Storage Parameters
72. Event Log
72.1. Pre-Configuring Logging of Audit Events
72.2. Viewing Event Log
72.3. Viewing Detailed Event Information
72.4. Downloading Event Log
72.5. Clearing Event Log
73. Query Plan Visualization
73.1. Creating a Query Plan
73.2. Visualizing a Query Plan
73.3. Editing a Query Plan
73.4. Sharing a Query Plan With Other Users
73.5. Deleting a Query Plan
74. Adaptive Query Optimization (AQO)
74.1. Installing aqo
74.2. Disabling and Enabling aqo
74.3. Managing aqo Databases
74.4. Configuring aqo Parameters
74.5. Cleaning aqo Storage
74.6. Viewing aqo Views
74.7. Uninstalling aqo
75. Interacting with Ask Postgres
75.1. Configuring the Chat
75.2. Using the Chat
FAQ