Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1okcei-0003Js-J8 for pgsql-novice@arkaria.postgresql.org; Tue, 18 Oct 2022 02:48:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1okceh-00074q-6r for pgsql-novice@arkaria.postgresql.org; Tue, 18 Oct 2022 02:48:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1okceg-00074h-QR for pgsql-novice@lists.postgresql.org; Tue, 18 Oct 2022 02:48:34 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1okced-0001C2-Qd for pgsql-novice@lists.postgresql.org; Tue, 18 Oct 2022 02:48:34 +0000 Received: by mail-wm1-x335.google.com with SMTP id v130-20020a1cac88000000b003bcde03bd44so14049003wme.5 for ; Mon, 17 Oct 2022 19:48:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=/yPPQbdvBU+t+tIkoXLautMjMVmARiPJef0ItppBU70=; b=2jr3FYnJUZMr7u6Vc+J7qsyKfy8YhMBxizv+gmPUorHmBDpkUx8CkvCGu3Hg4f9toJ CQOyrrmHEHdS2czgeEumbHOHAADE4QDRtwM0eh5FT22jV+Ceyo7we4fGsk5Y+9OcsRaI MSOgYdiji1LOdr2xCzDoRNmLjSURQytknxkog33L2zm045MvnoK+mXfh/d7z7xOhfYXU 6lNKimvtgnzHut0Lwknopws3AdbI7TSR4aBWBlgTu+7Wmm1q5fF5SzjXTqDTnJCt8Qf/ wfh2ndvIhu8DMWCmZyyYITdFpuVmj8th7F0YxQTfbvcrp4DD6WGUU67WNqplSh+C+thH T9tA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=/yPPQbdvBU+t+tIkoXLautMjMVmARiPJef0ItppBU70=; b=AIDYs91VTiLFLhh5CqzETUxEXOss4yxl53gkO6ft04kCrUkrpdJB+2sHQgVl8GO741 LMchVkUDdv0ZFs3L8xTukAFucGXqaeVl53EggAVQzBrZ+qV/PaMSPAcUgT5rQlh5tJj0 jzR+EVnGyHLUp8YYcVrDl4RhOW6HxAeHTtkuAE65pxgG6ZwEz8l/VdL6pB2yNxXMbaLk /9NjLZeXqAs/3GLDeB6VE9CUg3kYJhbs+Nae5KC8PkwHCM9cq+gJrDytpIERLfeuTuOh AUxbycBDPoVa5jaVIAQHJjKPFK/25TF2uSdhexpravlqppSkt5nyoLd/fDHU218dXalo u7qw== X-Gm-Message-State: ACrzQf2NhJSOX7753EDNEKyFXDSUuGMoMBR8J6L6YoHOGhsJenREQ58L 4dVJ7HATZiE2W2pBe2aXLX2Udw== X-Google-Smtp-Source: AMsMyM6xjAGPV2LOMWSBq7+MNbwU5Y+cAd7Y8DJ5cp9rliHqgDVcnCh2CkCCrVRvf9L9aoEYWUiwgg== X-Received: by 2002:a05:600c:1c08:b0:3c6:e398:64e0 with SMTP id j8-20020a05600c1c0800b003c6e39864e0mr339164wms.2.1666061309497; Mon, 17 Oct 2022 19:48:29 -0700 (PDT) Received: from localhost.localdomain (62-46-248-232.adsl.highway.telekom.at. [62.46.248.232]) by smtp.gmail.com with ESMTPSA id l9-20020a05600c47c900b003c3a1d8c8e6sm11426772wmo.19.2022.10.17.19.48.29 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 17 Oct 2022 19:48:29 -0700 (PDT) Message-ID: Subject: Re: Allocated size of DB? From: Laurenz Albe To: Ron Watkins , pgsql-novice@lists.postgresql.org Date: Tue, 18 Oct 2022 04:48:28 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2022-10-17 at 09:48 -0700, Ron Watkins wrote: > I have a request to supply business owner with both the available size of DB as well > as the used size of the DB. I have been able to locate the used size, but I don't see > any way to query the available size (used + unused space). How can I find that in PSQL? The available size would be the size of the file system that contains the data directory. You cannot query that size from the database; you have to ask the operating system. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com