From: Laurenz Albe <laurenz.albe@cybertec.at>
To: satish v <vuyyuru.satish59@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Know bloat percentage after auto vacuum
Date: Mon, 01 Nov 2021 05:35:14 +0100
Message-ID: <b2fc8e664c475c0c08a12874ebeafaa3fa5e252e.camel@cybertec.at> (raw)
In-Reply-To: <CAPG-CvVyZEY6tjsEKJXZBW69pmWpaMrbf7TbnM3yQqBCU3tUow@mail.gmail.com>
References: <CAPG-CvVyZEY6tjsEKJXZBW69pmWpaMrbf7TbnM3yQqBCU3tUow@mail.gmail.com>
On Sat, 2021-10-30 at 21:33 +0530, satish v wrote:
> We have the table with 2 months data (approx 450GB). We deleted 17 days of data and auto vacuum
> performed on the table.new insertions are utilizing that space,we want to perform the vacuum full
> and reclaim the space at os level but don't know how much free (unused) space available.how can we get the details.
CREATE EXTENSION pgstattuple;
SELECT tuple_percent, dead_tuple_percent, free_percent
FROM pgstattuple('table_name');
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, vuyyuru.satish59@gmail.com
Subject: Re: Know bloat percentage after auto vacuum
In-Reply-To: <b2fc8e664c475c0c08a12874ebeafaa3fa5e252e.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox