pg_stat_activity

From: Cédric BUSCHINI <cbuschini(at)carax(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_stat_activity
Date: 2006-02-02 15:56:38
Message-ID: 43E22BB6.4030701@carax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

question in 2 times :

1 - "select * from pg_stat_activity ;" gives me serverals lines but all
lines have <command string not enable> in current_query
I have set "stats_command_string" to true...

2 - I wanna to log users activity : connections, disconnection,
queries, ... I assume there is a good way to do that .....

Thanks a lot

cédric

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mcelroy, tim 2006-02-02 15:58:52 Postmaster errors
Previous Message Dario Brignardello 2006-02-02 13:07:15 Re: is there any missing ??