Configuring SQL Profiler
Permissions for SQL profiler
To access the SQL profiler tool on PEM, there are two prerequisites:
- The user logged in to the PEM GUI must either be a superuser or a member of group
pem_comp_sqlprofilerwithin the PEM server database. For more information, see pem groups. - The user configured for the database server in the server tree (
Username), must be a superuser on the database server that the trace is being run on (monitored server).
Parameters
The following parameters in postgresql.conf control the SQL Profiler extension behavior.
| Parameter | Description | Default | Reload or restart |
|---|---|---|---|
sql_profiler.enabled | Enable or disable SQL Profiler for this session. | true | No need to restart or reload, can be set by anyone at any time. |
sql_profiler.use_array_for_paramas | Enable or disable to load the prepared parameters in 'params' (OIDVECTOR) column. | false | No need to restart or reload, can be set by anyone at any time. |
sql_profiler.explain_format | EXPLAIN format to be used in the trace. | EXPLAIN_FORMAT_TEXT | No need to restart or reload, can be set by anyone at any time. |
- On this page
- Permissions for SQL profiler
- Parameters
Could this page be better? Report a problem or suggest an addition!