↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

track_activities

Enables the collection of information on the currently executing command of each session, along with its identifier and the time when that command began execution. This parameter is on by default. Note that even when enabled, this information is only visible to superusers, roles with privileges of the pg_read_all_stats role and the user owning the sessions being reported on (including sessions belonging to a role they have the privileges of), so it should not represent a security risk. Only superusers and users with the appropriate SET privilege can change this setting.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
on
category
Statistics / Cumulative Query and Index Statistics
context
superuser
documented
true
enumvals
Unknown
extra desc
Enables the collection of information on the currently executing command of each session, along with the time at which that command began execution.
lang
en
max val
Unknown
metadata version
18
min val
Unknown
name
track_activities
short desc
Collects information about executing commands.
source
pg-settings-source-snapshot
unit
Unknown
vartype
bool

Definition PG 18

Enables the collection of information on the currently executing command of each session, along with its identifier and the time when that command began execution. This parameter is on by default. Note that even when enabled, this information is only visible to superusers, roles with privileges of the pg_read_all_stats role and the user owning the sessions being reported on (including sessions belonging to a role they have the privileges of), so it should not represent a security risk. Only superusers and users with the appropriate SET privilege can change this setting.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:3bc2fec03c72403d129ab29efb2a1817611d254dff9a25c146f25cf5a3badbab

Text language: en · wiki-repair-20261023:3bc2fec03c72403d129ab29efb2a1817611d254dff9a25c146f25cf5a3badbab