diff options
| author | Bruce Momjian <bruce@momjian.us> | 2013-05-04 13:23:04 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2013-05-04 13:23:04 -0400 |
| commit | 083d8fa79dbd693f48c1c195bf4f2af3d1e7dc67 (patch) | |
| tree | 51f441d18c53c0c0879df1ee3e81468308b2b8fa /doc/src | |
| parent | f87f214b7c09e20d954fae887809c41cc5ca68df (diff) | |
| download | postgresql-083d8fa79dbd693f48c1c195bf4f2af3d1e7dc67.tar.gz postgresql-083d8fa79dbd693f48c1c195bf4f2af3d1e7dc67.zip | |
docs: Improve log_line_prefix session_id query
Diffstat (limited to 'doc/src')
| -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> |