Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ru7d7-002fS0-DD for pgsql-admin@arkaria.postgresql.org; Tue, 09 Apr 2024 09:19:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ru7d6-002B8w-Ep for pgsql-admin@arkaria.postgresql.org; Tue, 09 Apr 2024 09:19:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ru7d5-002B8f-MG for pgsql-admin@lists.postgresql.org; Tue, 09 Apr 2024 09:19:00 +0000 Received: from sonic304-21.consmr.mail.ir2.yahoo.com ([77.238.179.146]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ru7d1-001yb9-T2 for pgsql-admin@lists.postgresql.org; Tue, 09 Apr 2024 09:18:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.de; s=s2048; t=1712654330; bh=UdYWFCTr5J0ajbFcjuuPFjT7/7woaefzJMZk8n+kQRI=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=iHx1tiOKjphGJAKSrg5a/y2zfi0df9QvdAe7FWaY1uanCm6fx+FEMeRQEf3BuirXuXgXOCNTvW0hCgxUnDMSgJMJrWyWpApGFqyQrTzqMHVYITdRI7tUb7yFKciwcvCuEP+wnpSUi20351mK88Ll/g+e8wUvJQLjaTDfXWIJeWoMzQZmojlDTc7f1kzqq31ORfWlDTxVY2U9KcobAfGOWo52rSmd1FbiM0ISshXfymGyCkUpRFaThVCX4gFdVzgJc/xbvYabSfI3HPmVZL2oF26Z+gBU6xC7UgIyBI830tmG506QDt+aV2Xze5cywpyZvR/HtlPE99uYtOJ0zti5MA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1712654330; bh=h5HGMBSC2pWWlHg2bVDUinT3kNbl1+gzXv125XZewoZ=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=LjpDV6AwHaaoo4gPwZJcJ3buMiC/qiR65fUzoIHmEOB+ECgKPiy/p23sFFUqcXxDmMLQNEgWtRFB8ipi+rtcfmrhlnu77uyuQG1YRlpYBlzdjwXx9xE/O2Gh6I794jzOPawRRXcXebYcfsA2+DB/5XGM3eYJ2MI/KdxOEbISzms6FqyJGlXzaN2T/pc0BZWO3kgt5hMpcurv0dyWBlXY6qu4Ei2sMScUP6KQKP7StbdV85b3pRC1zkUNKxj0tfUnDeZthgqenhLTxAGGStmOVpZ7tWLWZDNwCgDs0I2YhFcfUS9EaW/QYy8Z6MPCz1kG3Bx3weQARGoXyYS6JQechA== X-YMail-OSG: auR3dI8VM1mgxWjVHyAkfBpV5WjDaY7bdZBIRsZRvXoYQ0EfiQnPgGntwkBKtCH dqJU_feS1jrxoqKM9tDkAG5A2h.xAWnnzNYn3xbDPWfv6azqMbBKnr_k1oFxOL9XMKYgAf1bYAAM N8k48KGRvRf5iuA1Tf5d2i3Yp9hLRJKOpb1n6vPuBX.2kXnoyGGsCQPcHFL8qViu9sGD.2hJCBfQ Gz0CaZ_bBr0_gZH.qinXnOuEq79iLwX4OszvSeAAXtPD1SfKa01YpIeujv8D587XxfZXB47hODYb ROA9ulqL8PhUsfGOwImktO1AQ6zSwD6EiZGjtnz1_bOLfq_QIsqIoOdbXk44Vzm_GS2mVP5rPIV2 4xYUVz4QvPkr21bHqbYtgFUv2oeqhSLzV2AbC71fs2PqC4q5q42RsqwPjnP3uEYkrfG4K3xUzG1J ncRK6kZ5JkCmOBn8HcBadjS2eirCbqnoWpPmYvEv.xXDYVVstxJh3XuPA9E0uuOlQ9F8QhHLq52_ QIXXnv2gaK0bENiFdGrk0MFeQ40QH7nF5v62pnAxc9G0muUX6lnXSvGuUc5qSgJgqmZqR.q_z6qR srFpzlFgM7E9s097zoF8fl1QH9Cg58OmuYqh4tIczBGNxH0vOUD3xLG9cYFnBtDv0BPYvGMDLhbR g.5bXCT2TrEc0W2d8BBTCoyiKxA9MeCwyaqURhqC2vCclmw2M_yrgRVFHnGjVxGAwoM5KuMbeHZ1 Clv1XYOkJ8OLM3xfpISmGN6vzWNASK.mobZHfZBn9C5FKi2utAVzf5yyUIcibjeHZM8iKJhWX3Cz 5hPzQPUKlZpn3ZkxmoTqjXh7rn5QzTqpAhEi.kCgy3HQIDaZXorimUge2WGjfXu14TqEoKHZKODQ 6cZKbbe5GCAgqh_OJyD3WAzthRAvy.HP.LoVz0crvSj0rE.MAd1sNj_P1yTT.08_xoP4ibX8_1j9 U3yUYiR4KhAnOSE0IP9fQALxr7RbT.c4dim45ZWoHDehWeJIrlcyuaD8rz.2AF59mX3x_ZLQ6Qy0 UUyN8D6Wa4OYEY4BKkHhCP3S5V7jwfJ8jQwFu0LSb2XzPBEbiTrtpYwYF2FwOYrqRBcEaQpeWFMt KBWJ6krwtu.fEHyqKv5neQnZ9aoVwXIsSyWgAGJ0jrFXVc3vOoKbUQ1XNmkd9QCjl7BMXXTVyUD5 STjShpHIunAlMllcvT_eGrpsn5TMZHsX.6O4Hv549ymKr6Ex6lpd7HicyCZBKTjCw2YxkILFs_t. qB_RngLCTlk9tlojAVTZ20UTMYnUdUbubV73LF9S_cIaPNluMWfvkqZv3F6uCSbhdwxxT9BqlxfT GRzJ41fhfk.G93DwJeHuSETEWkSwJDjUfBfa7bJLcpyMMZ4lx2q.Iit8nLo6F3HFmWQO04OLPXHT vaKIE40ukizheqX8_5oMhG5nUwXbNYHcMzVla32SQvxzrGP8c1F8TPYbgE7Kp6CKnfJvnM4nNR84 W_0hSsQValRtX_ur1ju6db12u8mUqy4K5q1Ql5.18VwzBmWehsAl577lRgZBuCaTzcRvJWp1RtAg 0M1IjoAsBJtsbmO_Y0uNzNycrhkTIObAk9MdpBQdMETiQ_4ppnKijAooUI36coEpz6oIpWIrZUS2 DNtlJPXuQarY5JGhDkGl57bGJWmfWY_EISmotewpNgeNkCKV_9ExcTczeHjb5VEphqHmHjXY0FOV F.x6Ai4W1ZLE5JfazfqcT121rj7mzjWt0hXwc.6WM74FtykBcCezafS0oX375eBubsYNgAdjjEw0 fosHvm3sOnKKGAiy0VP7oXjKxUSFsz1hMuf2C1iijJTOYbqShGpx2Om7t0wroBA9wcZkCNcki9QL HkPW7M1Hmw5XI7AHNUTd9S5QW5HPTkfvSJsSVdhrwHps_80DghUPvCct3M986PTpPg3i6XF.eA3B CbAyfGiezTiGSgY93seicyIuuN_2NyXt7JaNGiS08jVgX5LtI3Q2sNFWvCbDdCNhcZRW9BtKC2Yk P8mguwrQNNGKBaTUPPZhYweRGbma4uT9k4rXtxhQAro1y_BL42aSemywMHPFboEPuRHbh9sWU7Te QQCCdDzwa_4nuRCUCTkqrWrLPXpLDilQiy_zLXldaJ57yQbEk4irja1ltaec6MKp.tx3BPRIBqNl 3BGwjIDhzwjbvCMtZmxXZqkxZ0mF8aCz1rolGlnn8scQITaR.5YysNaohf3dFiW9sOVi5eDrC2GJ hzRPiJA05A1n8.bolu_0M8D77IzS4b33tuIosuA-- X-Sonic-MF: X-Sonic-ID: d3b7a072-a393-497b-9cae-1849cd99d394 Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.ir2.yahoo.com with HTTP; Tue, 9 Apr 2024 09:18:50 +0000 Date: Tue, 9 Apr 2024 09:18:47 +0000 (UTC) From: Wolfgang Wilhelm To: "pgsql-admin@lists.postgresql.org" , Holger Jakobs Message-ID: <732532928.10253521.1712654327518@mail.yahoo.com> In-Reply-To: References: <1131891051.9514344.1712572662608@mail.yahoo.com> Subject: Re: Dynamic views MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10253520_376679700.1712654327517" X-Mailer: WebService/1.1.22205 YMailNorrin Content-Length: 5999 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_10253520_376679700.1712654327517 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Holger, thank you for the correction. Kind regardsWolfgang Am Montag, 8. April 2024 um 13:57:51 MESZ hat Holger Jakobs Folgendes geschrieben: =20 =20 =20 =20 Am 08.04.24 um 12:37 schrieb Wolfgang Wilhelm: =20 =20 Hi Rajesh,=20 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 v= iew. No reset needed. pg_stat_database will have new information with new o= r deleted databases. So no reset required, too. More information can be taken from the docs. See https://www.postgresql.o= rg/docs/current/monitoring-stats.html=20 Regards Wolfgang =20 =20 Am Montag, 8. April 2024 um 09:01:12 MESZ hat Rajesh Kumar Folgendes geschrieben: =20 =20 Hi all,=20 How much time the stats are hold in dynamic stats views such as pg_stat_a= ctivity, pg_stat_database etc? =20 Is there a reset point? How to find the last reset time ? =20 =20 =20 pg_stat_activity shows the CURRENT activity ... =20 Deutsch: "aktuell"=C2=A0 is NOT the same as "actual" in English! Using "act= ual" instead of "current" may confuse other people. =20 =20 --=20 =20 Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 =20 =20 =20 ------=_Part_10253520_376679700.1712654327517 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Hi Holger,

thank you for the correction.

Kind regards
Wolfgang

Am Montag, 8. April 2024 um 13:57:51 MESZ hat Holger Jakobs <holger@jakobs.com> Folgendes geschrieben:



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 https://www.postgresql.org/docs/current/monitoring-stats.html

Regards
Wolfgang


Am Montag, 8. April 2024 um 09:01:12 MESZ hat Rajesh Kumar <rajeshkumar.dba09@gmail.com> 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

------=_Part_10253520_376679700.1712654327517--