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.