diff options
| author | Jeff Davis <jdavis@postgresql.org> | 2015-09-07 13:46:31 -0700 |
|---|---|---|
| committer | Jeff Davis <jdavis@postgresql.org> | 2015-09-07 13:46:31 -0700 |
| commit | f828654e1097bdbb40fedebd9ac1ea045b183e15 (patch) | |
| tree | 3a2ab2496b3aac2c5c9f98b96ca50b106a2d4223 /src | |
| parent | 37239ef8c9fa72e0f73a307cc413a03a743878d3 (diff) | |
| download | postgresql-f828654e1097bdbb40fedebd9ac1ea045b183e15.tar.gz postgresql-f828654e1097bdbb40fedebd9ac1ea045b183e15.zip | |
Add log_line_prefix option 'n' for Unix epoch.
Prints time as Unix epoch with milliseconds.
Tomas Vondra, reviewed by Fabien Coelho.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/error/elog.c | 14 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 1 |
2 files changed, 15 insertions, 0 deletions
diff --git a/src/backend/utils/error/elog.c b/src/backend/utils/error/elog.c index 088c714821b..9114c55b66b 100644 --- a/src/backend/utils/error/elog.c +++ b/src/backend/utils/error/elog.c @@ -2438,6 +2438,20 @@ log_line_prefix(StringInfo buf, ErrorData *edata) appendStringInfoString(buf, strfbuf); } break; + case 'n': + { + struct timeval tv; + char strfbuf[128]; + + gettimeofday(&tv, NULL); + sprintf(strfbuf, "%ld.%03d", tv.tv_sec, (int)(tv.tv_usec / 1000)); + + if (padding != 0) + appendStringInfo(buf, "%*s", padding, strfbuf); + else + appendStringInfoString(buf, strfbuf); + } + break; case 's': if (formatted_start_time[0] == '\0') setup_formatted_start_time(); diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 695a88fe7d1..c33e5856197 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -425,6 +425,7 @@ # %p = process ID # %t = timestamp without milliseconds # %m = timestamp with milliseconds + # %n = timestamp with milliseconds (as a Unix epoch) # %i = command tag # %e = SQL state # %c = session ID |