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.

Video Zone
OpManager Customer Videos
Altaleb Alshenqiti - Ministry of National Guard - Health Affairs
  •  IT Admin from "Royal flying doctor service", Australia
     Jonathan ManageEngine Customer
  •  Michael - Network & Tech, ManageEngine Customer
     Altaleb Alshenqiti - Ministry of National Guard - Health Affairs
  •  David Tremont, Associate Directory of Infrastructure,USA
     Todd Haverstock Administrative Director
  •  Donald Stewart, IT Manager from Crest Industries
     John Rosser, MIS Manager - Yale Chase Equipment & Services
 Pricing  Get Quote