Skip to main content
Ctrl+K
Postgres Enterprise Manager 9.7.0 ドキュメント - Home
  • Introduction
    • Postgresの互換性
    • Release notes
      • Postgres Enterprise Manager 9.7.0 release notes
      • Postgres Enterprise Manager 9.6.0 release notes
      • Postgres Enterprise Manager 9.5.1 release notes
      • Postgres Enterprise Manager 9.5.0 release notes
      • Postgres Enterprise Manager 9.4.1 release notes
      • Postgres Enterprise Manager 9.4.0 release notes
      • Postgres Enterprise Manager 9.3.1 release notes
      • Postgres Enterprise Manager 9.3.0 release notes
      • Postgres Enterprise Manager 9.2.2 release notes
      • Postgres Enterprise Manager 9.2.1 release notes
      • Postgres Enterprise Manager 9.2.0 release notes
      • Postgres Enterprise Manager 9.1.1 release notes
      • Postgres Enterprise Manager 9.1.0 release notes
      • Postgres Enterprise Manager 9.0.0 release notes
    • Platform compatibility
    • Hardware requirements for installing the PEM server on Linux
  • Planning
    • Understanding Postgres Enterprise Manager components and architecture
    • Deployment considerations
      • Using Failover Manager for high availability
      • Connection pooling using PgBouncer
        • PEM server and agent connection management mechanism
        • Preparing the PEM database server
        • Configuring PgBouncer
        • Configuring the PEM agent
      • Authentication options
        • Configuring the PEM server to use Kerberos authentication
        • Configuring the PEM server to use Windows Active Directory domain services for Kerberos authentication (SSPI)
        • Configuring the PEM server to use two-factor authentication
      • Securing your deployment
        • Apache HTTPD security configurations
        • PEM application security configurations
      • Web server installation options
  • Installing and Upgrading
    • Installing Postgres Enterprise Manager server
      • Dependencies of the PEM Server and Agent on Linux
      • Installing Postgres Enterprise Manager server on Linux x86 (amd64)
        • Installing Postgres Enterprise Manager server on RHEL 9 or OL 9 x86_64
        • Installing Postgres Enterprise Manager server on RHEL 8 or OL 8 x86_64
        • Installing Postgres Enterprise Manager server on AlmaLinux 9 or Rocky
        • Installing Postgres Enterprise Manager server on AlmaLinux 8 or Rocky
        • Installing Postgres Enterprise Manager server on SLES 15 x86_64
        • Installing Postgres Enterprise Manager server on SLES 12 x86_64
        • Installing Postgres Enterprise Manager server on Ubuntu 22.04 x86_64
        • Installing Postgres Enterprise Manager server on Ubuntu 20.04 x86_64
        • Installing Postgres Enterprise Manager server on Debian 12 x86_64
        • Installing Postgres Enterprise Manager server on Debian 11 x86_64
      • Installing Postgres Enterprise Manager server on Linux IBM Power (ppc64le)
        • Installing Postgres Enterprise Manager server on RHEL 9 ppc64le
        • Installing Postgres Enterprise Manager server on RHEL 8 ppc64le
        • Installing Postgres Enterprise Manager server on SLES 15 ppc64le
        • Installing Postgres Enterprise Manager server on SLES 12 ppc64le
      • Installing Postgres Enterprise Manager server on Linux AArch64 (ARM64)
        • Installing Postgres Enterprise Manager server on Debian 12 arm64
      • Installing Postgres Enterprise Manager server on Windows
        • Installing the PEM server and PEM-HTTPD on separate hosts
        • Installing the PEM server and PEM-HTTPD on the same host
        • Installing the PEM server on an existing Postgres servers
      • Creating an EDB repository on an isolated network
      • Configuring the PEM server on Linux
    • Installing Postgres Enterprise Manager agent
      • Installing Postgres Enterprise Manager agent on Linux x86 (amd64)
        • Installing Postgres Enterprise Manager agent on RHEL 9 or OL 9 x86_64
        • Installing Postgres Enterprise Manager agent on RHEL 8 or OL 8 x86_64
        • Installing Postgres Enterprise Manager agent on AlmaLinux 9 or Rocky
        • Installing Postgres Enterprise Manager agent on AlmaLinux 8 or Rocky
        • Installing Postgres Enterprise Manager agent on SLES 15 x86_64
        • Installing Postgres Enterprise Manager agent on SLES 12 x86_64
        • Installing Postgres Enterprise Manager agent on Ubuntu 22.04 x86_64
        • Installing Postgres Enterprise Manager agent on Ubuntu 20.04 x86_64
        • Installing Postgres Enterprise Manager agent on Debian 12 x86_64
        • Installing Postgres Enterprise Manager agent on Debian 11 x86_64
      • Installing Postgres Enterprise Manager agent on Linux IBM Power (ppc64le)
        • Installing Postgres Enterprise Manager agent on RHEL 9 ppc64le
        • Installing Postgres Enterprise Manager agent on RHEL 8 ppc64le
        • Installing Postgres Enterprise Manager agent on SLES 15 ppc64le
        • Installing Postgres Enterprise Manager agent on SLES 12 ppc64le
      • Installing Postgres Enterprise Manager agent on Linux AArch64 (ARM64)
        • Installing Postgres Enterprise Manager agent on Debian 12 arm64
      • Installing Postgres Enterprise Manager agent on Windows
    • Upgrade and migration
      • Upgrading a PEM installation
        • Upgrading a PEM installation on a Linux host
        • Upgrading a PEM installation on a Windows host
        • Upgrading a PEM installation on high-availability mode using HTTPD
      • Upgrading the PEM backend Postgres database
      • Upgrading SQL Profiler
      • Upgrading Apache HTTPD server
      • Moving the PEM server
    • Uninstalling
      • Uninstalling Postgres Enterprise Manager components on Linux
      • Uninstalling Postgres Enterprise Manager components on Windows
    • Troubleshooting
  • Administering
    • Changing the default port
    • Registering a Postgres server
    • Registering a PEM agent
    • Managing a PEM server
    • Managing Postgres servers
    • Managing a PEM agent
      • Managing job notifications
      • Managing scheduled jobs
      • Modifying agent configuration
      • Reviewing or modifying agent properties
      • Setting agent privileges
    • Managing SSL certificates
      • Regenerating the server self-signed SSL certificates
      • Regenerating the agent self-signed SSL certificates
    • Managing configuration settings
    • Troubleshooting agent issues
  • Using
    • Accessing the web interface
    • Connecting and disconnecting a database server
    • Monitoring performance
      • Probes
      • Alerts
      • Notifications
      • Capacity Manager
      • Audit Manager
      • Log Manager
      • Charts
      • Dashboards
      • Remote monitoring
    • Monitoring Barman
    • Monitoring EDB Postgres Distributed
    • Monitoring Failover Manager
    • Monitoring Replication Server
    • Monitoring event history
    • Tuning performance
      • Tuning Wizard
      • Postgres Expert
      • Performance Diagnostic
    • Profiling workloads
      • Installing the SQL Profiler extension
      • Using SQL Profiler
      • Using the Index Advisor
    • Viewing system reports
    • PEM command line interface
    • PEM Rest API
  • Developing
    • Using the Query tool
    • Using the Schema Diff tool
    • Using the ERD tool
  • .rst

Tuning performance

Tuning performance#

次の機能は、パフォーマンスの調整に役立ちます。

  • Tuning Wizard

  • Postgres Expert

  • Performance Diagnostic

  • Tuning Wizard
  • Postgres Expert
    • Postgres Expertウィザードを使用する
    • Postgres Expertの推奨事項の確認
    • UIの詳細についてのアプリ内ヘルプへのアクセス
  • Performance Diagnostic
    • 前提条件
    • パフォーマンス診断ダッシュボードを使用する
      • パフォーマンス診断ダッシュボード
      • クエリー情報

前へ

Monitoring event history

次へ

Tuning Wizard

著者 EnterpriseDB Corporation.

© Copyright EnterpriseDB Corporation..