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.
          • 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 ...
          • 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 ...
          • Changing the size of the SQL Server Express transaction log

            Question: How do I increase my SQL Server Express transaction log  size? This article provides steps to change the size of the SQL Server Express transaction log. You may want to change the log size to, for example, restrict its growth.   Solution:  ...