diff options
| author | Robert Haas <rhaas@postgresql.org> | 2015-06-04 17:57:39 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2015-06-04 17:57:39 -0400 |
| commit | 99cfd5e136e2a20c77021390a1378d18a24b7388 (patch) | |
| tree | dcb45860a49b64dd8a8ce9a483d6bb1362244caf /doc/src | |
| parent | 1c645da8ebb5532105481ad77bb1d9a671b1f086 (diff) | |
doc: Session identifiers truncate, not round, the backend start time.
Joel Jacobson
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 5549b7dce62..1da7dfbc5cd 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4707,7 +4707,7 @@ local0.* /var/log/postgresql of printing those items. For example, to generate the session identifier from <literal>pg_stat_activity</>, use this query: <programlisting> -SELECT to_hex(EXTRACT(EPOCH FROM backend_start)::integer) || '.' || +SELECT to_hex(trunc(EXTRACT(EPOCH FROM backend_start))::integer) || '.' || to_hex(pid) FROM pg_stat_activity; </programlisting> |