diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-03-03 18:46:40 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-03-03 18:46:40 +0000 |
| commit | e52c4a6e26f2c5d37cefe42c39b6233d9c0fbe25 (patch) | |
| tree | ca2c1c39d9c0c4c2f0e04d1590d8c72e9101d46a /src/backend/utils | |
| parent | f52019cf80c2a639d0188e0f0cd5988e80367307 (diff) | |
| download | postgresql-e52c4a6e26f2c5d37cefe42c39b6233d9c0fbe25.tar.gz | |
Add GUC log_lock_waits to log long wait times.
Simon Riggs
Diffstat (limited to 'src/backend/utils')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 10 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 2 |
2 files changed, 10 insertions, 2 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 12d5ecf181..173e9903c5 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.377 2007/02/23 21:36:18 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.378 2007/03/03 18:46:40 momjian Exp $ * *-------------------------------------------------------------------- */ @@ -812,6 +812,14 @@ static struct config_bool ConfigureNamesBool[] = #endif { + {"log_lock_waits", PGC_SIGHUP, LOGGING_WHAT, + gettext_noop("Logs long lock wait events."), + NULL + }, + &log_lock_waits, + false, NULL, NULL + }, + { {"log_hostname", PGC_SIGHUP, LOGGING_WHAT, gettext_noop("Logs the host name in the connection logs."), gettext_noop("By default, connection logs only show the IP address " diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 77a86f0020..7ee8d417c0 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -340,7 +340,7 @@ # e.g. '<%u%%%d> ' #log_statement = 'none' # none, ddl, mod, all #log_hostname = off - +#log_lock_waits = off # Log lock waits longer than deadlock_timeout #log_temp_files = -1 # Log temporary files equal or larger # than the specified number of kilobytes. # -1 disables; 0 logs all temp files |