Postgres Pro
Downloads
Home   >   mailing lists

Who mades the inserts? - Mailing list pgsql-general

From Durumdara
Subject Who mades the inserts?
Date
Msg-id CAEcMXhn8aBkfvf=A=bHDES-eQUN1Ats4TEEpi7xbRwOpLdNugQ@mail.gmail.com
Whole thread Raw
Responses Re: Who mades the inserts?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: Who mades the inserts?  (Justin <zzzzz.graf@gmail.com>)
List pgsql-general
Tree view
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?


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

pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: strange locks on PG 11 with Golang programs
Next
From: "Sterpu Victor"
Date:
Subject: Query to retrieve the index columns when a function is used.