Message-ID: <7a6f0623-7028-bc1c-1d43-bf685f98513f@jakobs.com>
Date: Fri, 5 Apr 2024 19:12:01 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.12.0
Subject: Re: Table DML status check per day
To: pgsql-admin@lists.postgresql.org
References: 
 <CACd4L3vjfmqtuT0fGiNRiUNVyvwDpy1W1-RfBEPZGH6GOWL_LA@mail.gmail.com>
 <CAAo1mbm9nW8_qyfw2d_Qoe6G+gJYa-yqLet1bYwLt40a-jfDZw@mail.gmail.com>
 <CACd4L3tYyT1riWZsCmtFg5qQh88C_Un8WMp8eG_8irnfangwLQ@mail.gmail.com>
Content-Language: de-DE
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: 
 <CACd4L3tYyT1riWZsCmtFg5qQh88C_Un8WMp8eG_8irnfangwLQ@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------No4VsQdj7FnVcCoRSbiYAz8E"
Archived-At: 
 <https://www.postgresql.org/message-id/7a6f0623-7028-bc1c-1d43-bf685f98513f%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------No4VsQdj7FnVcCoRSbiYAz8E
Content-Type: multipart/mixed; boundary="------------zo0UoU6ywWRUW8XvUsRMoFg9";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <7a6f0623-7028-bc1c-1d43-bf685f98513f@jakobs.com>
Subject: Re: Table DML status check per day
References: <CACd4L3vjfmqtuT0fGiNRiUNVyvwDpy1W1-RfBEPZGH6GOWL_LA@mail.gmail.com>
 <CAAo1mbm9nW8_qyfw2d_Qoe6G+gJYa-yqLet1bYwLt40a-jfDZw@mail.gmail.com>
 <CACd4L3tYyT1riWZsCmtFg5qQh88C_Un8WMp8eG_8irnfangwLQ@mail.gmail.com>
In-Reply-To: <CACd4L3tYyT1riWZsCmtFg5qQh88C_Un8WMp8eG_8irnfangwLQ@mail.gmail.com>

--------------zo0UoU6ywWRUW8XvUsRMoFg9
Content-Type: multipart/alternative;
 boundary="------------GQYyy1390tfrEUohUz0Ncc3u"

--------------GQYyy1390tfrEUohUz0Ncc3u
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QW0gMDUuMDQuMjQgdW0gMTg6Mjkgc2NocmllYiBqYXlhIGt1bWFyOg0KPiBIaSBTYW1lZCwN
Cj4NCj4gVGhhbmtzIGZvciB5b3VyIHVwZGF0ZS4gRGFpbHkgb3Igd2Vla2x5IGRhdGFiYXNl
IGdyb3d0aMKgY2hlZWvCoHNvcHRpb24gDQo+IGFyZSBhdmFpbGFibGU/DQo+DQo+IE9uIEZy
aSwgQXByIDUsIDIwMjQgYXQgMzoyNuKAr1BNIFNhbWVkIFlJTERJUklNIDxzYW1lZEByZWRk
b2MubmV0PiB3cm90ZToNCj4NCj4gICAgIEhpIEpheWEsDQo+DQo+ICAgICBZb3UgY2FuIHVz
ZSBwZ19zdGF0X2FsbF90YWJsZXMgdmlldyBmb3IgdGhhdC4gQnV0LCBpdCBwcm92aWRlcw0K
PiAgICAgY3VtdWxhdGl2ZSBzdGF0aXN0aWNzLiBTbywgeW91IG5lZWQgdG8gdGFrZSBzbmFw
c2hvdCBvZiB0aGUgdmlldw0KPiAgICAgZXZlcnlkYXkuIFRoZW4sIHlvdSBjYW4gY3JlYXRl
IGRhaWx5IGJyZWFrZG93biBvZg0KPiAgICAgaW5zZXJ0L2RlbGV0ZS91cGRhdGUgb3BlcmF0
aW9ucyBvbiB0YWJsZXMgb3V0IG9mIHNuYXBzaG90cy4NCj4NCj4gICAgIGh0dHBzOi8vd3d3
LnBvc3RncmVzcWwub3JnL2RvY3MvMTYvbW9uaXRvcmluZy1zdGF0cy5odG1sI01PTklUT1JJ
TkctUEctU1RBVC1BTEwtVEFCTEVTLVZJRVcNCj4NCj4gICAgIEJlc3QgcmVnYXJkcy4NCj4g
ICAgIFNhbWVkIFlJTERJUklNDQo+DQo+ICAgICBPbiBGcmksIDUgQXByIDIwMjQsIDA5OjU0
IGpheWEga3VtYXIsIDxrdW1hcmRiYTI3QGdtYWlsLmNvbT4gd3JvdGU6DQo+DQo+ICAgICAg
ICAgSGkgVGVhbSwNCj4NCj4gICAgICAgICBBcHBsaWNhdGlvbiB0ZWFtIHJlcXVlc3Rpbmcg
ZGF0YSBsaWtlIGEgcGFydGljdWxhciBkYXkgZWFjaA0KPiAgICAgICAgIHRhYmxlwqAgaG93
IG1hbnkgaW5zZXJ0cywgdXBkYXRlIGFuZCBkZWxldGUgYWN0aXZpdHkgYXJlDQo+ICAgICAg
ICAgaGFwcGVuaW5nPw0KPg0KPiAgICAgICAgIFdpdGhvdXQgZW5hYmxpbmcgdGhlIEF1ZGl0
IHBhcmFtZXRlcj9Ib3BlIHdlIHdpbGwgZW5hYmxlIHRoZQ0KPiAgICAgICAgIEF1ZGl0IHBh
cmFtZXRlci4gSHVnZSBlbnRyeSB3aWxsIGJlIHdyaXR0ZW4gaW4gYSBsb2cgZmlsZS4NCj4N
Cj4gICAgICAgICBJcyBpdCBwb3NzaWJsZSB0byBjaGVjayB0aGUgc3RhdHVzIGFuZCBwcm92
aWRlIHRvIHRoZSBlbmTCoHVzZXINCj4gICAgICAgICB0aGVzZSBkZXRhaWxzPw0KPg0KPg0K
Pg0KPiAgICAgICAgIFRoYW5rcyAmIFJlZ2FyZHMsDQo+ICAgICAgICAgSmF5YWt1bWFyLlMN
Cj4gICAgICAgICArOTEtOTg0MDg2NDQzOS4NCj4NCj4NCj4NCj4gLS0gDQo+IFRoYW5rcyAm
IFJlZ2FyZHMsDQo+IEpheWFrdW1hci5TDQo+ICs5MS05ODQwODY0NDM5Lg0KDQoNCk9idmlv
dXNseSBub3QsIHRoZSBzdGF0aXN0aWNzIGFyZSAtIGFzIG1lbnRpb25lZCBlYXJsaWVyIC0g
Y3VtdWxhdGl2ZS4NCg0KU28geW91IGhhdmUgdG8gZG8gdGhlIG1hdGggeW91cnNlbGYuIENv
bXB1dGUgdGhlIGRpZmZlcmVuY2UgYmV0d2VlbiANCnllc3RlcmRheSdzIGFuZCB0b2RheSdz
IG51bWJlcnMuDQoNCg0KLS0gDQoNCkhvbGdlciBKYWtvYnMsIEJlcmdpc2NoIEdsYWRiYWNo
LCBUZWwuICs0OS0xNzgtOTc1OTAxMg0KDQo=
--------------GQYyy1390tfrEUohUz0Ncc3u
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">Am 05.04.24 um 18:29 schrieb jaya
      kumar:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CACd4L3tYyT1riWZsCmtFg5qQh88C_Un8WMp8eG_8irnfangwLQ@mail.gmai=
l.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">Hi=C2=A0
        <span style=3D"color:rgb(0,0,0)">Samed,</span>
        <div><span style=3D"color:rgb(0,0,0)"><br>
          </span></div>
        <div><span style=3D"color:rgb(0,0,0)">Thanks for your update.
            Daily or weekly database growth=C2=A0cheek=C2=A0soption are a=
vailable?</span></div>
      </div>
      <br>
      <div class=3D"gmail_quote">
        <div dir=3D"ltr" class=3D"gmail_attr">On Fri, Apr 5, 2024 at 3:26=
=E2=80=AFPM
          Samed YILDIRIM &lt;<a href=3D"mailto:samed@reddoc.net"
            moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext">same=
d@reddoc.net</a>&gt;
          wrote:<br>
        </div>
        <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px
          0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=

          <div dir=3D"auto">
            <div>
              <div>Hi Jaya,</div>
              <div dir=3D"auto"><br>
              </div>
              <div dir=3D"auto">You can use pg_stat_all_tables view for
                that. But, it provides cumulative statistics. So, you
                need to take snapshot of the view everyday. Then, you
                can create daily breakdown of insert/delete/update
                operations on tables out of snapshots.</div>
              <div dir=3D"auto"><br>
              </div>
              <div dir=3D"auto"><a
href=3D"https://www.postgresql.org/docs/16/monitoring-stats.html#MONITORI=
NG-PG-STAT-ALL-TABLES-VIEW"
                  target=3D"_blank" moz-do-not-send=3D"true"
                  class=3D"moz-txt-link-freetext">https://www.postgresql.=
org/docs/16/monitoring-stats.html#MONITORING-PG-STAT-ALL-TABLES-VIEW</a><=
br>
              </div>
              <div dir=3D"auto"><br>
              </div>
              <div>Best regards.<br>
                Samed YILDIRIM</div>
              <br>
              <div class=3D"gmail_quote">
                <div dir=3D"ltr" class=3D"gmail_attr">On Fri, 5 Apr 2024,=

                  09:54 jaya kumar, &lt;<a
                    href=3D"mailto:kumardba27@gmail.com" target=3D"_blank=
"
                    moz-do-not-send=3D"true" class=3D"moz-txt-link-freete=
xt">kumardba27@gmail.com</a>&gt;
                  wrote:<br>
                </div>
                <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=

                  0px 0.8ex;border-left:1px solid
                  rgb(204,204,204);padding-left:1ex">
                  <div dir=3D"ltr">
                    <p class=3D"MsoNormal"
                      style=3D"margin:0cm;font-size:11pt;font-family:Apto=
s,sans-serif">Hi
                      Team,</p>
                    <p class=3D"MsoNormal"
                      style=3D"margin:0cm;font-size:11pt;font-family:Apto=
s,sans-serif">=C2=A0</p>
                    <p class=3D"MsoNormal"
                      style=3D"margin:0cm;font-size:11pt;font-family:Apto=
s,sans-serif">Application
                      team requesting data like a particular day each
                      table=C2=A0 how many inserts, update and delete
                      activity are happening? <br>
                      <br>
                      Without enabling the Audit parameter?Hope we will
                      enable the Audit parameter. Huge entry will be
                      written in a log file.</p>
                    <p class=3D"MsoNormal"
                      style=3D"margin:0cm;font-size:11pt;font-family:Apto=
s,sans-serif">=C2=A0<span
                        style=3D"font-size:11pt">=C2=A0</span></p>
                    <p class=3D"MsoNormal"
                      style=3D"margin:0cm;font-size:11pt;font-family:Apto=
s,sans-serif">Is
                      it possible to check the status and provide to the
                      end=C2=A0user these details?=C2=A0</p>
                    <div><br>
                    </div>
                    <br>
                    <div dir=3D"ltr" class=3D"gmail_signature">
                      <div dir=3D"ltr">
                        <div>
                          <div dir=3D"ltr">
                            <div>Thanks &amp; Regards,<br>
                            </div>
                            Jayakumar.S<br>
                            +91-9840864439.<br>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </blockquote>
              </div>
            </div>
          </div>
        </blockquote>
      </div>
      <br clear=3D"all">
      <div><br>
      </div>
      <span class=3D"gmail_signature_prefix">-- </span><br>
      <div dir=3D"ltr" class=3D"gmail_signature">
        <div dir=3D"ltr">
          <div>
            <div dir=3D"ltr">
              <div>Thanks &amp; Regards,<br>
              </div>
              Jayakumar.S<br>
              +91-9840864439.<br>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <p><br>
    </p>
    <p>Obviously not, the statistics are - as mentioned earlier -
      cumulative.</p>
    <p>So you have to do the math yourself. Compute the difference
      between yesterday's and today's numbers.</p>
    <p><br>
    </p>
    <div class=3D"moz-signature">-- <br>
      <p>Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</p>
    </div>
  </body>
</html>

--------------GQYyy1390tfrEUohUz0Ncc3u--

--------------zo0UoU6ywWRUW8XvUsRMoFg9--

--------------No4VsQdj7FnVcCoRSbiYAz8E
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZhAw4QUDAAAAAAAKCRCKV5yTsxlhusHw
AKDWwoavjjl8MS2Xa3HcVJ5kydu7PACgvCdgZSl9d0AoZmrD7wlIcqAav4I=
=OLCN
-----END PGP SIGNATURE-----

--------------No4VsQdj7FnVcCoRSbiYAz8E--