We are always asked by a client or our manager about how fragmented a table, an index, a schema or whole database is in PostgreSQL database. The following code will answer this question with the following information reported for a schema.
Toal 7415.00 MB, Free 1918.87 MB, Fragmentation 25.88 Percent
Please do NOT run the code during busy or peak hours, ideally run the code in after hours or off-peak hours.
Subscribe to get access
Read more of this content when you subscribe today.
2 thoughts on “Code to Report Table Index Schema or Database Fragmentation in PostgreSQL”