I would like to get avg number of inserts hourly and also avgg number of transactions running in database
We have performace_schema enabled but need confirmation of other possible ways to get , may triggers or using timestamp columns in tables ( not all tables have them)
Please configure Percona monitoring and management, that is the best tool out there to give you exact information.
I do have pmm2 configured and running, other than QPS, is there a way to get more granular details like , updates in a day
Yes, you’d have to create a new graph for that and write the appropriate PromQL query to do that. Look at other graph formulas in PMM for examples. There are a couple in InnoDB Details that do 24hr summaries of different data points.