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 1sm6za-003Kh6-9Q for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 07:33:22 +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 1sm6zY-005G4a-Re for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 07:33:21 +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 1sm6zY-005G3j-Az for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 07:33:20 +0000 Received: from mail-pj1-x1031.google.com ([2607:f8b0:4864:20::1031]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sm6zV-000Eyq-B0 for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 07:33:19 +0000 Received: by mail-pj1-x1031.google.com with SMTP id 98e67ed59e1d1-2d87a1f0791so309266a91.2 for ; Thu, 05 Sep 2024 00:33:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bitnine-net.20230601.gappssmtp.com; s=20230601; t=1725521596; x=1726126396; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=LozHqWVO1Lm3SJMxTQg02hay4I3c80q4OAHMqWmq+m8=; b=YDF+qZ0yv8WvBDR+zX6ibAosXkHU6i1SqKKf8+F4EJGsUIxY5CFEbBJp9t9SJ/cxiD J4QTrImOoINJ+TnT4yEBkRmzb4U9XEPHS8LhDqsDJBsjons6M0uvv7yw15SUeqNf++XU 9Oxyj7O9PqM92ZGAw3vJjw9WLllqX9gzvhPctJhd92ZTwbwGFWTB0Bc6lzfex/HTkMvu zx81VuibQU4pLomAW7jieOIZvoSYlHShOSStzdmI7j47q4fpFKt0B45InrU3FuvlS+eJ RXteGRFeFyfnixcGMs0h1+ZRbiqPvpUK0wluWpkGnTlJDcr8aMl2zeB4QCccJiOQwrTj mXCw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725521596; x=1726126396; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=LozHqWVO1Lm3SJMxTQg02hay4I3c80q4OAHMqWmq+m8=; b=NDGD6Pe4tHcSCi7jd7t2mWGFOwswJ5/vCOZHobWsuWtuuFJxA8vKktmShi2WGzVB9s 0wO2Gr+Y17JKgX2O7DjcHKnZs12/vB/8ISD/MBHx/cX3AbmFj6pjSSTQ5FFjWEB0KVuF 6bDLWkZkil+RuhPrvnprcEy7uDUGaA4w6D32aFQbPRwZ5CT0E+6loEka9vexShGypq56 ucIS6FL6nhKvpVIJaU6pBzPPU61ixGHycEDVYi08XRCAvROzIQGYzwjXolYX4mfSSd4L eus6DkpTvIXxwsQC3l7HdXx0G8BB6bbbjaABfyS0TmX7NGJgwXJqmSVXWjZSlyZCRiuq hDjw== X-Gm-Message-State: AOJu0YypRRgtOJnyv8/sWu/1QRhw2r59bbVFMdjtsRx+2HcxquLPZTk9 RkZHYWGwlA58UPx/92PfHy+2pb+TPBBFTYhQB6nKdGHuotSGs/RRskYMW35PhJMXp7I6ek4jeDT 55l+23FXheNQQqzieOlf97RGQRr6dPm59KHHqDA== X-Google-Smtp-Source: AGHT+IG/XMia+J545g9htWJLQZbzNNHPCveECzrG6m0+uQzIOLZ6NYHhYurPvhs5C+ZPjVMjv3zMJfsw+d6haV4GOSU= X-Received: by 2002:a17:90a:8d0e:b0:2cf:2ab6:a157 with SMTP id 98e67ed59e1d1-2d89728ba16mr14933678a91.12.1725521595770; Thu, 05 Sep 2024 00:33:15 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Muhammad Usman Khan Date: Thu, 5 Sep 2024 12:33:04 +0500 Message-ID: Subject: Re: Postgres database size monitoring To: Sathish Reddy Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000c4c97b06215a4dbe" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c4c97b06215a4dbe Content-Type: text/plain; charset="UTF-8" Hi, You can use the combination of Amazon CloudWatch Events and a cron job to accomplish this task. On Thu, 5 Sept 2024 at 12:30, Sathish Reddy < sathishreddy.postgresql@gmail.com> wrote: > Hi > We are planning to genarate weekly report for database size growth as > like in month 4 weeks on 1st week second week 3rd week 4th week .. genarate > report to compare size all databases.. > Any one have idea on these help us ..we are using RDS postgres. > > > > Thanks > Sathishreddy > --000000000000c4c97b06215a4dbe Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,
You can use the combination of Amazon CloudWatch Ev= ents and a cron job to accomplish=C2=A0this task.

On Thu, 5 Sept 2024 = at 12:30, Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:
Hi=C2=A0
=C2=A0 We are planning to genarate weekly report for database siz= e growth as like in month 4 weeks on 1st week second week 3rd week 4th week= .. genarate report to compare size all databases..
= =C2=A0 =C2=A0Any one have idea on these help us ..we are using RDS=C2=A0 po= stgres.



Thanks=C2=A0
Sathishreddy=C2=A0
--000000000000c4c97b06215a4dbe--