Track the current command of each session.
At a glance
| Property | Value |
|---|---|
| Parameter | track_activities |
| Category | Statistics |
| Default | on |
| Value type | boolean / enum / numeric |
| Change scope | Superuser / reload |
What it does
Enables collection of information about the currently executing command of each session, shown in pg_stat_activity.
How to apply a change
Can be changed at runtime by a superuser for the current session, or globally via reload.
Inspect the current value and source with SHOW track_activities; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'track_activities';.
Tuning guidance
Keep on — disabling it blinds pg_stat_activity and most monitoring.