How to find Database and Polled Data table data size?

Queries to check the database size and polled data table size:

Please connect the database and execute the below queries to get the results.

SELECT pg_size_pretty(pg_database_size(''));
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.

For MSSQL you can use SQL Server Management Studio(SSMS) - DB Properties/Object Explorer Details for DB Size/Table size & Reports -> Standard Reports -> Disk Usage By Table.

 
 Pricing  Get Quote