S
S
Serg4452020-12-03 11:03:45
PostgreSQL
Serg445, 2020-12-03 11:03:45

How to see free space in a table in Postgres after going through an auto vacuum process?

Good afternoon!
Tell me if it is possible and how to see the amount of free space inside the postgres table after it is cleared by the autovacuum process.

There is a certain table, many insertions and deletions were made in it in a short period of time (there are more deletions). After that, the autovacuum process came and removed the dead tuples (dead tuples). There is a great desire to make Full vacuum, but before that we need to understand what we can get after that, whether the space occupied by the table will decrease and if so, by how much.
We use PG 12

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2020-12-03
@Serg445

pgstattuple + this query

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question