Commit99cfd5e

committed

doc: Session identifiers truncate, not round, the backend start time.

Joel Jacobson

1 parent1c645da commit99cfd5eCopy full SHA for 99cfd5e

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4707,7 +4707,7 @@ local0.* /var/log/postgresql`
`4707`	`4707`	`of printing those items. For example, to generate the session`
`4708`	`4708`	`identifier from <literal>pg_stat_activity</>, use this query:`
`4709`	`4709`	`<programlisting>`
`4710`		`-SELECT to_hex(EXTRACT(EPOCH FROM backend_start)::integer) \|\| '.' \|\|`
	`4710`	`+SELECT to_hex(trunc(EXTRACT(EPOCH FROM backend_start))::integer) \|\| '.' \|\|`
`4711`	`4711`	`to_hex(pid)`
`4712`	`4712`	`FROM pg_stat_activity;`
`4713`	`4713`	`</programlisting>`

Comments

(0)