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 1rsdSf-008HOJ-Dd for pgsql-admin@arkaria.postgresql.org; Fri, 05 Apr 2024 06:54:05 +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 1rsdSd-004phz-9P for pgsql-admin@arkaria.postgresql.org; Fri, 05 Apr 2024 06:54:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rsdSc-004phr-SV for pgsql-admin@lists.postgresql.org; Fri, 05 Apr 2024 06:54:02 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rsdSa-000k5p-Cz for pgsql-admin@lists.postgresql.org; Fri, 05 Apr 2024 06:54:02 +0000 Received: by mail-lf1-x12f.google.com with SMTP id 2adb3069b0e04-516c547fb4eso2510008e87.0 for ; Thu, 04 Apr 2024 23:54:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1712300039; x=1712904839; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=/h2+VXfrld7TcYgoHigViUKw7diKjrXC4zBAUP3DdWY=; b=ELrpBBJHuOjyjC/GG/t4+QYPk2jhKFnLx7xTUqpnuLQmHxThGjjkEjC7CP6XmjUQHF gf+NEGtxelnmFlrQXiuVfTWVoe5xD+nvhQIv3wKshi3XDkhWmuqarn2layEg+xhvfmez ABEuXm5N9X/4EAf9uohRcaZ5yttzmTBP68Ww+4m/NzCnwD7t/iqakVHOjqY8w99Omj/5 /LL4u8XjCdC2s9+HP+M7rOO0CbnIoF1Yf8eWOk9YzbQ8usL4L/NqVKc0/kaq/ocNKcki OtIzJBOdHe/OHy+4mPQC+EQd1Jes+zUhxta+gxcuJlvJwjjjhovawkvnIzRHxx3walGU sLPA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712300039; x=1712904839; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=/h2+VXfrld7TcYgoHigViUKw7diKjrXC4zBAUP3DdWY=; b=QxXT6QnGhbmwuEX7+wVxkQV22qRaVdKoEUmbiNqa9vwinkq4Gf5UTG6SkulBCwgrWf 5eO5esLsPywASFJYIcho77o3Yq2wqH9Vah0TFqo3RK5kk8zNeQKLRbSkpvdeQkIZuHpt OXMav2sMDDQxGZ0RIoDdGhfkqy0OCo9mi4pAjvFATjEPneuULOOgwnZxQacGz04a6rWm 0kSr7kg4npADUTVFwb9Sc5NESHF1a+3f6H9aw0QegeJB9dW2AZXrmzCWfc0L+FQm4gTn vKTxyseXY1W2vibgF3vbRHQsSNqmRMoa25cW5E+Qzldr/LfAWLG5nQftIHiJkPDeaFdV NYbA== X-Gm-Message-State: AOJu0YzW2kDNcAFBAns/rrA52jtXpnDNPmeQBqIRTLNg4pfcYU0vn92T 7j0r9we3U/rc2/3rcR+SdEdeke/8Mbx7UIH9REyYYz4L/NhaiB26DzhAu7+ldbnBHeZCJJq++IL izLAFV0V+LOMoCxEZq+ZAFoB19PWLeomshoM= X-Google-Smtp-Source: AGHT+IECTbqOMjZMKg+wKOvkch/JkC7YquaEB3wr0CNDqWS/pj/wGSkeX2oPWaQrbK9pEo3sVtnf57RX1Y7NWOizpAg= X-Received: by 2002:ac2:46e9:0:b0:516:bfd7:de92 with SMTP id q9-20020ac246e9000000b00516bfd7de92mr388182lfo.43.1712300038626; Thu, 04 Apr 2024 23:53:58 -0700 (PDT) MIME-Version: 1.0 From: jaya kumar Date: Fri, 5 Apr 2024 12:23:46 +0530 Message-ID: Subject: Table DML status check per day To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000008d24a9061553eb30" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008d24a9061553eb30 Content-Type: text/plain; charset="UTF-8" Hi Team, Application team requesting data like a particular day each table how many inserts, update and delete activity are happening? Without enabling the Audit parameter?Hope we will enable the Audit parameter. Huge entry will be written in a log file. Is it possible to check the status and provide to the end user these details? Thanks & Regards, Jayakumar.S +91-9840864439. --0000000000008d24a9061553eb30 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi Team,

=C2=A0

Application team requesting data like a particular day each ta= ble=C2=A0 how many inserts, update and delete activity are happening?
<= br>Without enabling the Audit parameter?Hope we will enable the Audit param= eter. Huge entry will be written in a log file.

=C2=A0=C2=A0

Is it possible to check the status and provide to the end=C2= =A0user these details?=C2=A0



Thanks & Regards,
Jayakumar.S
+91-= 9840864439.
--0000000000008d24a9061553eb30--