CentOS help


LOG_QUERY_TIME_THRESHOLD

The LOG_QUERY_TIME_THRESHOLD variable enables you to log database requests at INFO level if they run longer than a given period.

By default, database requests are logged at DEBUG level. Configuring a value for LOG_QUERY_TIME_THRESHOLD causes requests that run for a period greater than that value to be logged at the INFO level, which makes them show up in vamessages.log.

Set the value to zero to log all database queries at INFO.

Values

Integer (in milliseconds)

Default

1000

Related actions
Change the logging level on your site
Change the location of a log file
Raise the logging visibility of selected database requests
Related reference information
DATABASE_HOST
DATABASE_NAME
DATABASE_PASSWORD
DATABASE_TYPE
DATABASE_USERNAME
PGSQL_LOG_DIR
LOG_DIR
More information
Log level basics