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 ...Log Analysis
Every action in OpManager leaves a trace(s) in the log files. There are two logs folder in OpManager. One under the OpManager directory and the other under OpManager tomcat folder. The logs folder under the OpManager directory contains various logs ...