Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1elu8X-0000Q1-Mf for pgsql-admin@arkaria.postgresql.org; Wed, 14 Feb 2018 10:18:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1elu8W-0006uZ-CT for pgsql-admin@arkaria.postgresql.org; Wed, 14 Feb 2018 10:18:00 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1elu8V-0006uP-P6 for pgsql-admin@lists.postgresql.org; Wed, 14 Feb 2018 10:17:59 +0000 Received: from n3.nabble.com ([162.255.23.22]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1elu8O-0005bu-PS for pgsql-admin@postgresql.org; Wed, 14 Feb 2018 10:17:58 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id E50A8B25EB27 for ; Wed, 14 Feb 2018 03:17:50 -0700 (MST) Date: Wed, 14 Feb 2018 03:17:50 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1518603470895-0.post@n3.nabble.com> Subject: Calculation of Database Size in postgres MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi all, In postgres for knowing the size of a database we generally use the system administration function "pg_database_size('database_name')". I am curious to know how does this calculate internally from the pages(free pages/fragmented pages/full pages) stored in the disk? Thanks in advance! Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html