Dear Members! We have more than 200 databases in a server. The PGAdmin's dashboard shows me 4500 inserts periodically.
I want to know which database(s) causes this. Do you know any query which can show me the inserts per databases? And I don't know it works as TPS query? So I need to make differents between measured values in two time point? Like here: https://dba.stackexchange.com/questions/35940/how-many-queries-per-second-is-my-postgres-executing select * from ( SELECT current_timestamp, datname, sum(xact_commit+xact_rollback) db FROM pg_stat_database group by current_timestamp, datname ) t order by db desc Thank you for any advance! Best regards DD
