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 1sm71C-003KqV-C4 for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 07:35: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 1sm71A-005JuS-S0 for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 07:35:01 +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 1sm71A-005JuK-EP for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 07:35:00 +0000 Received: from mail-oo1-xc30.google.com ([2607:f8b0:4864:20::c30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sm718-000FVN-U2 for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 07:35:00 +0000 Received: by mail-oo1-xc30.google.com with SMTP id 006d021491bc7-5df9542f3d8so308531eaf.0 for ; Thu, 05 Sep 2024 00:34:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725521697; x=1726126497; 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=9gy7tbnPEuMY43pnTiHv/FQdy6h1+1zBqcOS4XgYFAM=; b=jXDWAmigxRh5z9T6UOcqNK/27dxrfda27y6pD7dZVNZYNxC+v8buuh8DccDI5950qm JgfHjB3StLoCAe9FBEP4+J+K21DXuBHIZwsKyCO6pEaY68xU4iA8tuxt30KlqHGx0dEK fwaQ3Q1cE5UiAX/67Gqf1Tovk4rtA4alHwLTRKHTWrf1iHpy1AR6S4DseD8WVh8UdiXe vBWdo6ZZ/tv/Busurv7fE5tHMunvBInxjbd/APnC3iQJMnVRx1QiJ7bOqoRTA/0myt3R /IaWpGxXa4FC1FnTMhhfR//HnVbogZEC+NvmXEYHWKjcSz5OB5sm22WlKl5Op8AqkwYS Cl1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725521697; x=1726126497; 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=9gy7tbnPEuMY43pnTiHv/FQdy6h1+1zBqcOS4XgYFAM=; b=Jlkgy06rK7axc1DukrUqTRJdLnRlJzSyOxGnEVOjf9o9TELyV5RYaCqMxY+M6wQ+CI xixoJFwnMbR8eRoYveY04d4dvjZgdWCD1LpnP+YlSNWsmUeTBuG5HOFmrlfku21pXKgW iIV7gP1AA+UkXpVhpIdWfHKu6aagnRz+altStW5VNg5hkwdKcjxh9t1VbfPjz7wV0e45 RPE7DYv0Ca18MDPRgwamZtR8hZZLI65dUZqFz6Yk9BtEQjjBSFuBOznizii2qkqFnWyt lR+LiO+C1eI4RB/rhVriGkDFtOyFl9RhXGHeJqzryczZqRk3DpgNTj5E0gCtptzE7fsn PrIg== X-Gm-Message-State: AOJu0YzQe04qqt8eucLy4fim7qP8l0rO+8S52tAEVvL+gRH6hTIyNa5z PT25DKCYiwYXf7ski55FjaLzaag6q6e48PilxIhjaZBxAulg1oKWQ9RK0O2Xf4EpYNNly3j8Jw/ SuqXViG2y3VVH0hqnpCC7sPjcVi3mh9QO X-Google-Smtp-Source: AGHT+IEkYZXO+ic9UfX9FVI1gpabZjPS3BV2vZ4Vk8oWwEZeH/GO2cicyRBFOSBUctNnxlGb3ZRkzF6o3MZ7K6/SIsg= X-Received: by 2002:a05:6870:9687:b0:277:e5a5:3362 with SMTP id 586e51a60fabf-2781a807f14mr9841015fac.30.1725521697465; Thu, 05 Sep 2024 00:34:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sathish Reddy Date: Thu, 5 Sep 2024 13:04:45 +0530 Message-ID: Subject: Re: Postgres database size monitoring To: Muhammad Usman Khan Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000d46dd306215a531a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d46dd306215a531a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Sure we can..we are planning to write script for same is it possible...help us.. On Thu, Sep 5, 2024, 1:03=E2=80=AFPM Muhammad Usman Khan wrote: > 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 .. genar= ate >> report to compare size all databases.. >> Any one have idea on these help us ..we are using RDS postgres. >> >> >> >> Thanks >> Sathishreddy >> > --000000000000d46dd306215a531a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Sure we can..we are planning to write script for same is it = possible...help us..


On Thu= , Sep 5, 2024, 1:03=E2=80=AFPM Muhammad Usman Khan <usman.k@bitnine.net> wrote:
Hi,
You can use the combination of A= mazon CloudWatch Events and a cron job to accomplish=C2=A0this task.

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



Thanks=C2=A0
Sathishreddy=C2=A0
--000000000000d46dd306215a531a--