This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script to check a Fillfactor value, for tables or indexes of PostgreSQL Database Server.
I have already published importance of Fillfactor in PostgreSQL.
When we are working with the large database system, and we set Fillfactor value of multiple objects, sometimes it is required to check the value of current Fillfactor for those objects.
I prepared one script with “reloptions” column in which you can find “{fillfactor=value}” if it is assigned then only otherwise it is NULL.
1 2 3 4 5 6 7 8 |
SELECT pc.relname AS ObjectName ,pc.reloptions AS ObjectOptions FROM pg_class AS pc INNER JOIN pg_namespace AS pns ON pns.oid = pc.relnamespace WHERE pns.nspname = 'public' AND pc.relname = 'Table_Name'; |