Timing problem wtih pg_stat_activity - Mailing list pgsql-admin

From Donald Fraser
Subject Timing problem wtih pg_stat_activity
Date
Msg-id 001801c80b60$ca464d30$2064a8c0@LISTINGS12
Whole thread Raw
List pgsql-admin
PostgreSQL 8.1.9, Linux Redhat ES 4
 
I am experiencing a timing issue with the following query:
SELECT count(procpid) FROM pg_stat_activity WHERE usename='someuser'
 
If I execute the above query by the client who is user "someuser" and it is executed immediately after connecting I am getting two different results depending on the speed of the connection. If I connect to the database on a local area network of 100Mb/s and immediately execute the statement, I see the result of 0. If I connect to the same database over a slow connection, for example 115kb/s and immediately execute the statement, I see the result of 1.
 
Is this normal behaviour?
 
Regards
Donald Fraser

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG 8.1.4 not clearing pg_clog
Next
From: Simon Riggs
Date:
Subject: Re: Using rsync for base backups for PITR