Mem / Swap / Load etc. not displaying about pg_activity HOT 10 CLOSED

You should run pg_activity with 'postgres' user privileges (or 'root').

from pg_activity.

I have tried both postgres and root with the same results. At any rate that shouldn't matter since ordinary users can see memory usage and load stats through uptime, top, etc.

I noticed the following query in Data.pg_is_local(self,):
SELECT inet_server_addr() AS inet_server_addr, inet_client_addr() AS inet_client_addr

When pg_activity is connected over a unix domain socket, both of those functions return null, which psycopg2 translates to None, and str(None) is 'None' rather than '' so the length test returns false. Strangely though, if I use -h localhost, both functions return '127.0.0.1', so the equality test should return true, but I still don't get memory and load stats.

I was able to get them to show up by completely commenting out all the "am I local" tests...

from pg_activity.

Thanks for these informations.

What psutil version you have ? I've just discovered that the new psutil versions > 2.0 bring a new API and I can reproduce this behaviour with a 2.1.1.

from pg_activity.

my psutil is 2.1.0

from pg_activity.

Just commited a fixe : f00fc2a
It works for me with psutil 2 and older versions.

Could you try it ?

Thank you,

from pg_activity.

That fixed it, thank you!

from pg_activity.

Seems to be broken again in pg_activity 1.0.2 (from PyPI), tried with psutil 2.1.3 (current) and 2.1.0, psycopg2 2.5.4 if that matters

from pg_activity.

It's not broken again, it's just that the latest release at PyPI, i.e. the 1.0.2 you mentioned, dates from 2013-06 and the fix was committed 2014-05. The current git master works just fine.

from pg_activity.

Hi,

Latest version (1.2.0) has been pushed on pypi.

Thanks,

from pg_activity.

Thanks, this makes it easier to keep my servers updated

from pg_activity.