Commitf828654

committed

Add log_line_prefix option 'n' for Unix epoch.

Prints time as Unix epoch with milliseconds.Tomas Vondra, reviewed by Fabien Coelho.

1 parent37239ef commitf828654Copy full SHA for f828654

File tree

+20

-0

lines changed

+20

-0

lines changed

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -4629,6 +4629,11 @@ local0.* /var/log/postgresql`
`4629`	`4629`	`<entry>Time stamp with milliseconds</entry>`
`4630`	`4630`	`<entry>no</entry>`
`4631`	`4631`	`</row>`
	`4632`	`+ <row>`
	`4633`	`+ <entry><literal>%n</literal></entry>`
	`4634`	`+ <entry>Time stamp with milliseconds (as a Unix epoch)</entry>`
	`4635`	`+ <entry>no</entry>`
	`4636`	`+ </row>`
`4632`	`4637`	`<row>`
`4633`	`4638`	`<entry><literal>%i</literal></entry>`
`4634`	`4639`	`<entry>Command tag: type of session's current command</entry>`

Lines changed: 14 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2438,6 +2438,20 @@ log_line_prefix(StringInfo buf, ErrorData *edata)`
`2438`	`2438`	`appendStringInfoString(buf,strfbuf);`
`2439`	`2439`	`}`
`2440`	`2440`	`break;`
	`2441`	`+case'n':`
	`2442`	`+{`
	`2443`	`+structtimevaltv;`
	`2444`	`+charstrfbuf[128];`
	`2445`	`+`
	`2446`	`+gettimeofday(&tv,NULL);`
	`2447`	`+sprintf(strfbuf,"%ld.%03d",tv.tv_sec, (int)(tv.tv_usec /1000));`
	`2448`	`+`
	`2449`	`+if (padding!=0)`
	`2450`	`+appendStringInfo(buf,"%*s",padding,strfbuf);`
	`2451`	`+else`
	`2452`	`+appendStringInfoString(buf,strfbuf);`
	`2453`	`+}`
	`2454`	`+break;`
`2441`	`2455`	`case's':`
`2442`	`2456`	`if (formatted_start_time[0]=='\0')`
`2443`	`2457`	`setup_formatted_start_time();`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -425,6 +425,7 @@`
`425`	`425`	`# %p = process ID`
`426`	`426`	`# %t = timestamp without milliseconds`
`427`	`427`	`# %m = timestamp with milliseconds`
	`428`	`+# %n = timestamp with milliseconds (as a Unix epoch)`
`428`	`429`	`# %i = command tag`
`429`	`430`	`# %e = SQL state`
`430`	`431`	`# %c = session ID`

Comments

(0)