Chapter 53. Profiler

Table of Contents

53.1. Profiler Servers
53.1.1. Creating a Profiler Server
53.1.2. Viewing Profiler Servers
53.1.3. Editing a Profiler Server
53.1.4. Deleting a Profiler Server
53.2. Samples
53.2.1. Taking a sample
53.2.2. Viewing Samples
53.3. Viewing Profiler Graphs
53.4. Sampling Schedules
53.4.1. Creating a Sampling Schedule
53.4.2. Viewing Sampling Schedules
53.4.3. Editing a Sampling Schedule
53.4.4. Executing a Sampling Schedule
53.4.5. Activating and Deactivating a Sampling Schedule
53.4.6. Deleting a Sampling Schedule
53.5. Reports
53.5.1. Building a Report
53.5.2. Building a Report Using a Profiler Graph
53.5.3. Viewing All Built Reports
53.5.4. Viewing and Downloading a Report
53.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.