Is there way we can get the table size and DB size growth from last one month day-wise?
We are able to give the current size of DB and table size.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
If you have a base backup from more than a month ago, and all the archived WAL files, then you can spin up a new server and do PITR ending at each day, and take the sizes at each day. You will need to set
recovery_target_time and perhaps
recovery_target_timeline. You will probably also want to use
recovery_target_action (depending on what version you have) so that you can resume PITR from where you left off for the next day, rather than having to restart from scratch each day.
This is a rather heavy-handed way to do things. Going forward, you should just schedule a job to take the sizes each day and store them someplace, either inside the database or outside.