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 1rtmOi-00HOpa-Q4 for pgsql-admin@arkaria.postgresql.org; Mon, 08 Apr 2024 10:38:45 +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 1rtmOh-004c9G-Kt for pgsql-admin@arkaria.postgresql.org; Mon, 08 Apr 2024 10:38:43 +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 1rtmOg-004c94-R5 for pgsql-admin@lists.postgresql.org; Mon, 08 Apr 2024 10:38:43 +0000 Received: from sonic310-57.consmr.mail.ir2.yahoo.com ([77.238.177.30]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rtmOd-001oDM-MY for pgsql-admin@lists.postgresql.org; Mon, 08 Apr 2024 10:38:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.de; s=s2048; t=1712572716; bh=tACcSxqgTkWyixzTJimwJZ0MeCkOZD+uspm0rcbo1tk=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=WJ/4rJCx+cPwrzYJkBy0K4/bcIaMl66TdBlWaCNf+/YdVauC9XlS1a0dw5gIGjyCYUJ4SQkMmtR034zOUklFnFIMJF/hWYYZb7z1gsNsv7X+iYKR/q2xiZ8BjCb0uesPTKC2GBeDTvxdRSnl7cawRLoOIRZoy9b5lZfBsUjostmoaknzbEfwuevhf7uJvDUr0mq3LvOmlSrlU5L4Zu5//2TNH1Sd2GZ6QsChnbvL8jeD3njCgymv8DLN3Ks9U7jYBRxsoSP61Q/LhM1ydNzCAfyg5L+c9d6up6PQsQVULn8LOWIFJnmkvSh2i+BvYBNmAy8eCWJ79YTvRz1w2h/Z6A== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1712572716; bh=/BuX0/8gsS8C11qmfc88N8/n8e5EseOPN/xyYqkL6GB=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=CBxTwFKa8+6cnc6CQULGhjuXU+gZxH5dLeywGKv0DlB0uwJiZu1BNgJAKmWC+a1S3B00BKjOlqjaoNNZRus+i3tkwiOQ551pGcnf41xd82dvrDQYD0uwUVxd5GoZN0ro88tntKuk7bykIN4K5HCyawgPS9fnSiFj0dU7Lks3ej+xmXlSp5cCRW9hNgFF+oJGPlBrEMP/95NZHb2ZJR3PKY0QMMs46SQORf8qvUzVL+EL3bU4tJcnCeeziUgTJLkSsOUT6sPiIE48a3Ot7JzaGD0dlf1lYNMsSLzf5F9ib535N4qSTda45XMz4hyWP2h+i6bk4kRecHiD6Udwew1gsw== X-YMail-OSG: nAEsCMwVM1kVi3bxuBOOuTO8iJHIpiQTHkQTBjQ_F2CYuw76DFjK1NcthEVrk1h fZ4ndAK9dj991l4kwJjmCKwlmIKFJAM9w2NWXwiTWE6Dm4AfCGUS4w9kY8Sfx0uMlB9r9E3rtRqY QPpHAywKXhXnwH_iql2igbyqkX10EeqMUuF.s84oNyPPklYb3OsGcSdC4xmpWNGVBvD4xOFa6epW CAgZegIvCM7bpbr6ieB6rt6kLnbotOO8p8oA2a3o38E7L_pY4rBRBmxBN0ZRlzjOTw.S0o5R2VMU 4PzqEXUqLh8kIUWO9Bo0RBtq7h87vFXoC1K5uqhiA0VPE1UviprmaRt5OoQ4I.SxtjU8shfSiU0t VtLDKZEzVLJ6i0yY36KxHZsSdTgSoLtyGSaBdsV3W_ZeNP4taJ0bVgLrJE4_7mCK22AX3BZCKWCQ R8xTggCkO2h16NDubWMOgU7wuYvY.rdJLMGPFGOH722ei2_2IRbAxL7tPS_ufdRp19i71tQcETgZ hziqKfn53fXi4OrrZHdx7IEJBLpsB.njPfHttexPQyZLWp5kuA8vgEPvT2kpR8hp38MMRUGqkLpZ neBef__6mjShzid4Xox9BI2nPSAyqtBJLRWEzPLgQL5JZz0oE3cDNzhtlrksjh_UPzFg6Dj.jwso Ysz.4BmTODpRh0D_0XWy3u_f3LKKyt8yxa4wfUL2IdmqGa1CReyiAWIR8.10xwjTuiSluPpZ6ery TlZMj_7a0Yfqfl.qQh8n26UlMAVO7YuEzTTuwBxVR70ZaRyxuT.rDOZvL_MODrGFmORbdu35UDQ7 Bor3MqnfaZPq9AH.HlSo.TQin2HiE94Bszgg7WMsB1pcn3kXFVDd8SpsNSfKWxhPua_yEk5OdWiF FPeK0Pb0RrLuxBBI8J0_RW8on.5PVBERq06rpKO0ufx_nWp18UWfENIwV1201ynNQT1L8Ho6X2HT ml9g5ZH2iOIW3bCVPJ2DDrgGONDpRpk4BPvk_1GtQvCQMUuFQd3j651ojq_wxWy_o9OFy6KeNDe4 98zWvN6ZqntquJGtTmt1l52G6L3MpuZjSWjK7koslXDEbYZWUZfDYEgPCffroTcdMVQHDT6AZtY1 BHRQZLCe3xl__z0xTXVbbKyTyasCS.sR_8NR._fS_P_7GEfQ_L1ZUjKCfOjoNNBo.K9JtwmXZ16H vwlhaNOv35RsWBdMzIN7ZntYHmNzESv_UTDtskEyJXkDbS0tiqomh4CXfzH1EgsncQV91SdAWjYs 11hFoo.tLsM99eyMu..yXIfbmnNal6IIA.L1dErqD5nuegfR0ooG6HYCcSv8gsW.gRUU_6rGVr0w pMjaGhYohkKDQj583BQGxQcmwyrJVShWkrMuDIeQWL.I8HET7A35wNYPrLZ7Uj30yxmJ_a9b8g7f 0A2ZKnmXUpTEWTYtj7Hf57qZ.dPn6vgQdtVv3azydX3c6HDaClzr0Tx3IGVYoQnpX6Rhtgwh634Y qh4gS.hNHXLy..PsZxyyjeFmNRhHfpn_PnFlOr7j.NG2ai38A8S5s4WZd8_xtZ2PMQWFjISpuXlb bmzA99rUFXDxCgLRNaEQv5dv.gQPfG.vumob89Cps8FFwxFXlOqOGDDefYQMbMh9Ry0HKtArsPwp RSMiWevQkdmKr17O3gVo2O9Jv6GADlaJ5HsM0U2L_zqg_wBJ.49maZDKyOem6xokKC5mePgpDV8O FeNvVssTebQS37g8ziAycm15wB6ac5Uk48sfPFqe63xENhL0Fvbt5ciIbNrHQACaDTEVmdpgkXvk 7pBur7Pa5iYWrkKiYCaY5lfO53bQeHBypBL7Uws_netzBq.X7_tJLRUPHaDriFp8qzuDG2BUO4qF uQiRHnRmMWFXRg_QsxgHBnfQ.ykAik1ihdRqD8R9DlKIR9kax68m3mEtHGbZtO3vwEXZxJw4Ro.5 Ki2a38AWk6NU6M51ks5fqrbmpSrk0.l7qYprZwSyB9b9zfJcTX_XcO3OeHrrdaV2m1p.Hi68t3a1 IQTszumNfU.M5qZi91_36jMZqoVAkM15huK2hGbpkng1C0b3iurhP5YKQCZMO5Tq82Xm7Q1CIKFo J8bUTCcsV2qqo.n5OW_Fn2a88zM1IvQ62uEdaMEHYOVVbpoLa2hMCDiw43Oe4a3VgI8oa9mctVmb iqzQ_EsazHjVtTZpW5iydjB18rnDZloeDr0Fx8.ZXJZqUoDGwOCWbnfGL6pxo16wcejAoYOxcg_2 f4o6X1VgrPrV2aJ9f9gyrL5BhWoZ6g5SOOE6M.KlJMSadK3uhY3ISruGaytA.ll46HYkCm8lzAw8 wikmRPxWZLs1FQA-- X-Sonic-MF: X-Sonic-ID: ea106112-c822-4193-8a0a-8501efc2b588 Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.ir2.yahoo.com with HTTP; Mon, 8 Apr 2024 10:38:36 +0000 Date: Mon, 8 Apr 2024 10:37:42 +0000 (UTC) From: Wolfgang Wilhelm To: Pgsql-admin , Rajesh Kumar Message-ID: <1131891051.9514344.1712572662608@mail.yahoo.com> In-Reply-To: References: Subject: Re: Dynamic views MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9514343_2070997474.1712572662607" X-Mailer: WebService/1.1.22205 YMailNorrin Content-Length: 2883 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_9514343_2070997474.1712572662607 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit 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 RegardsWolfgang Am Montag, 8. April 2024 um 09:01:12 MESZ hat Rajesh Kumar 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 ? ------=_Part_9514343_2070997474.1712572662607 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
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 ?
------=_Part_9514343_2070997474.1712572662607--