Let "activity" command show all sessions except idle ones

NikolayS · agneum · commit 4f02d860b410 · 2023-09-20T01:19:38.000Z
diff --git a/pkg/bot/command/activity.go b/pkg/bot/command/activity.go
@@ -57,7 +57,7 @@ func (c *ActivityCmd) Execute() error {
   coalesce((clock_timestamp() - query_start)::text, '') as query_duration,
   coalesce((clock_timestamp() - state_change)::text, '') as state_changed_ago
 from pg_stat_activity 
-where state in ('active', 'idle in transaction', 'disabled') and pid <> pg_backend_pid();`, truncateLength)
+where state <> 'idle' and pid <> pg_backend_pid();`, truncateLength)
 
 	tableString := &strings.Builder{}
 	tableString.WriteString(ActivityCaption)
