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 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 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 ...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 ...Data Collection Manager