Who mades the inserts?

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

Responses

Browse pgsql-general by date

  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