From: | Durumdara <durumdara(at)gmail(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Who mades the inserts? |
Date: | 2020-03-09 12:52:51 |
Message-ID: | CAEcMXhn8aBkfvf=A=bHDES-eQUN1Ats4TEEpi7xbRwOpLdNugQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sterpu Victor | 2020-03-09 13:15:49 | Query to retrieve the index columns when a function is used. |
Previous Message | Julien Rouhaud | 2020-03-09 09:36:55 | Re: strange locks on PG 11 with Golang programs |