Chapter 54. Profiler

Table of Contents

54.1. Profiler Servers
54.1.1. Creating a Profiler Server
54.1.2. Viewing Profiler Servers
54.1.3. Editing a Profiler Server
54.1.4. Deleting a Profiler Server
54.2. Samples
54.2.1. Taking a sample
54.2.2. Viewing Samples
54.3. Viewing Profiler Graphs
54.4. Sampling Schedules
54.4.1. Creating a Sampling Schedule
54.4.2. Viewing Sampling Schedules
54.4.3. Editing a Sampling Schedule
54.4.4. Executing a Sampling Schedule
54.4.5. Activating and Deactivating a Sampling Schedule
54.4.6. Deleting a Sampling Schedule
54.5. Reports
54.5.1. Building a Report
54.5.2. Building a Report Using a Profiler Graph
54.5.3. Viewing All Built Reports
54.5.4. Viewing and Downloading a Report
54.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.