How to find Database & PolledData table & data size

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.
        New to ADManager Plus?

          New to ADSelfService Plus?

            • Related Articles

            • Performance Data Archiving

              Which are the database tables to be queried for performance data? Here are the details that might help you extract reports by connecting to the database: 1. The resources polled for data collection are stored in the table polleddata, and each polled ...
            • Steps to Check the Data Collection Issue

              Steps to check the data collection issue :- Generate threadDump using any one of the following url http://opmanager:port/GenerateThreadDump.do http://opmanager:port/servlet/GenerateThreadDump Analyse the threaddump for any BLOCKED threads If there is ...
            • Where can I find my OpManager database information?

              Question: Where can I find my OpManager database  information? Solution:  OpManager database information is stored  in the file "database_params.conf"  under OpManager/conf folder. The database server name/IP , database name, database type   and user ...
            • Data Collection Manager

            • Database information in OpManager

              Question: Where can I find my OpManager database  information? Solution:  OpManager database information is stored  in the file "database_params.conf"  under OpManager/conf folder. The database server name/IP , database name, database type   and user ...