Re: Dynamic views

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Am 08.04.24 um 12:37 schrieb Wolfgang Wilhelm:
Hi Rajesh,

pg_stat_activity shows the actual activity - what is running as DB tasks on the system. When the process finishes then it will disappear from that view. No reset needed. pg_stat_database will have new information with new or deleted databases. So no reset required, too.
More information can be taken from the docs. See


Am Montag, 8. April 2024 um 09:01:12 MESZ hat Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx> Folgendes geschrieben:

Hi all,

How much time the stats are hold in dynamic stats views such as pg_stat_activity, pg_stat_database etc?

Is there a reset point? How to find the last reset time ?

pg_stat_activity shows the CURRENT activity ...

Deutsch: "aktuell"  is NOT the same as "actual" in English! Using "actual" instead of "current" may confuse other people.


Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux