How to get CPU ans Memory usage of timescale database in a table

How can I get the CPU and Memory usage of the timescale database in a table?
I dont know if it is possible by just using an postgresql extension. Maybe I need a programm which collects these informations for me or even write my own programm/script.
I hope someone can help me with this.

Welcome to our forum!

When you say Timescale database do you mean the instance (node stats), the database usage, or query CPU stats?

Are you running self-hosted or Timescale Cloud?

-James

Thanks for your reply. I mean the instance of the timescaledb but i would also like to know how I could query the CPU stats. My timescaledb is self-hosted.