Chapter 57. Profiler

Table of Contents

57.1. Profiler Servers
57.1.1. Creating a Profiler Server
57.1.2. Viewing Profiler Servers
57.1.3. Editing a Profiler Server
57.1.4. Deleting a Profiler Server
57.2. Samples
57.2.1. Taking a sample
57.2.2. Viewing Samples
57.3. Viewing Profiler Graphs
57.4. Sampling Schedules
57.4.1. Creating a Sampling Schedule
57.4.2. Viewing Sampling Schedules
57.4.3. Editing a Sampling Schedule
57.4.4. Executing a Sampling Schedule
57.4.5. Activating and Deactivating a Sampling Schedule
57.4.6. Deleting a Sampling Schedule
57.5. Reports
57.5.1. Building a Report
57.5.2. Building a Report Using a Profiler Graph
57.5.3. Viewing All Built Reports
57.5.4. Viewing and Downloading a Report
57.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.