Commit083d8fa

committed

docs: Improve log_line_prefix session_id query

1 parentf87f214 commit083d8faCopy full SHA for 083d8fa

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4096,7 +4096,7 @@ local0.* /var/log/postgresql`
`4096`	`4096`	`identifier from <literal>pg_stat_activity</>, use this query:`
`4097`	`4097`	`<programlisting>`
`4098`	`4098`	`SELECT to_hex(EXTRACT(EPOCH FROM backend_start)::integer) \|\| '.' \|\|`
`4099`		`- regexp_replace('0000' \|\|to_hex(pid), '^0(.....)$', '\1')`
	`4099`	`+ regexp_replace('0000' \|\|'0133e3', '^0*(.{4,})$', '\1')`
`4100`	`4100`	`FROM pg_stat_activity;`
`4101`	`4101`	`</programlisting>`
`4102`	`4102`

Comments

(0)