diff options
| author | Bruce Momjian | 2013-05-04 17:23:04 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2013-05-04 17:23:04 +0000 |
| commit | 083d8fa79dbd693f48c1c195bf4f2af3d1e7dc67 (patch) | |
| tree | 51f441d18c53c0c0879df1ee3e81468308b2b8fa | |
| parent | f87f214b7c09e20d954fae887809c41cc5ca68df (diff) | |
docs: Improve log_line_prefix session_id query
| -rw-r--r-- | doc/src/sgml/config.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 8323bd6a89d..7b3e6179470 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4096,7 +4096,7 @@ local0.* /var/log/postgresql identifier from <literal>pg_stat_activity</>, use this query: <programlisting> SELECT to_hex(EXTRACT(EPOCH FROM backend_start)::integer) || '.' || - regexp_replace('0000' || to_hex(pid), '^0*(.*....)$', '\1') + regexp_replace('0000' || '0133e3', '^0*(.{4,})$', '\1') FROM pg_stat_activity; </programlisting> |