Timing problem wtih pg_stat_activity

From: "Donald Fraser" <postgres(at)kiwi-fraser(dot)net>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Timing problem wtih pg_stat_activity
Date: 2007-10-10 17:22:38
Message-ID: 000501c80b62$2b777a10$2064a8c0@LISTINGS12
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Please ignore my previous question - I should have read the documents first!

The answer is here:
"When using the statistics to monitor current activity, it is important to
realize that the information does not update instantaneously. Each
individual server process transmits new block and row access counts to the
collector just before going idle; so a query or transaction still in
progress does not affect the displayed totals. Also, the collector itself
emits a new report at most once per PGSTAT_STAT_INTERVAL milliseconds (500
unless altered while building the server). So the displayed information lags
behind actual activity. However, current-query information collected by
stats_command_string is always up-to-date."

Regards
Donald Fraser

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-10-10 17:39:35 Re: PG 8.1.4 not clearing pg_clog
Previous Message Donald Fraser 2007-10-10 17:12:37 Timing problem wtih pg_stat_activity