9 SQL Profiling and Analysis

Table of Contents Previous Next


9 SQL Profiling and Analysis

1.
Edit the postgresql.conf file; you must include the SQL Profiler library in the shared_preload_libraries configuration parameter.
2.
Create the functions used by SQL Profiler in your database. The SQL Profiler installation program places a SQL script (named sql-profiler.sql) in the share/postgresql/contrib subdirectory of the main PostgreSQL installation directory on Linux systems. On Windows systems, this script is located in the share subdirectory. You must invoke this script on the maintenance database specified when registering the server with PEM.

9 SQL Profiling and Analysis

Table of Contents Previous Next