Community and Support

            How to find Database & PolledData table & data size

            Queries to check database size and polleddata table size:

            Please connect the database and execute the below queries to get the results.

            SELECT pg_size_pretty(pg_database_size('<databasename>'));
            SELECT pg_size_pretty(pg_total_relation_size('polleddata'));
            SELECT pg_size_pretty(pg_relation_size('polleddata'));

            Please copy the database name from /OpManager/conf/database_params.conf file and paste it in the query and execute it.
            Updated: 03 Jan 2016 11:43 PM
            Helpful?  
            Help us to make this article better
            0 0