Who mades the inserts?

Поиск
Список
Период
Сортировка
От Durumdara
Тема Who mades the inserts?
Дата
Msg-id CAEcMXhn8aBkfvf=A=bHDES-eQUN1Ats4TEEpi7xbRwOpLdNugQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Who mades the inserts?
Re: Who mades the inserts?
Список 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?


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 по дате отправления:

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: strange locks on PG 11 with Golang programs
Следующее
От: "Sterpu Victor"
Дата:
Сообщение: Query to retrieve the index columns when a function is used.