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
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
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
