Chapter 56. Profiler

Table of Contents

56.1. Profiler Servers
56.1.1. Creating a Profiler Server
56.1.2. Viewing Profiler Servers
56.1.3. Editing a Profiler Server
56.1.4. Deleting a Profiler Server
56.2. Samples
56.2.1. Taking a sample
56.2.2. Viewing Samples
56.3. Viewing Profiler Graphs
56.4. Sampling Schedules
56.4.1. Creating a Sampling Schedule
56.4.2. Viewing Sampling Schedules
56.4.3. Editing a Sampling Schedule
56.4.4. Executing a Sampling Schedule
56.4.5. Activating and Deactivating a Sampling Schedule
56.4.6. Deleting a Sampling Schedule
56.5. Reports
56.5.1. Building a Report
56.5.2. Building a Report Using a Profiler Graph
56.5.3. Viewing All Built Reports
56.5.4. Viewing and Downloading a Report
56.5.5. Deleting a Report

Profiler is an interface to the pgpro_pwr module. With profiler, you can build detailed reports on database performance. Reports are based on samples of database data and cover the specified periods of time.

To build a report, take at least two samples. The samples are placed in the directory of the profiler server. Before taking samples, prepare profiler servers and create them in the web application.

You can create schedules that allow taking samples automatically at the specified interval. Such schedules also allow taking a sample for the specified date and time.