Re: pg_stat_activity

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: pg_stat_activity
Дата
Msg-id CAKFQuwYx=uBJ+=Vn_WuQ81HX0mFrXMLg36xN9vHFohH+U2uYAQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_stat_activity  (Pavan Teja <pavan.postgresdba@gmail.com>)
Ответы Re: pg_stat_activity  (Rui DeSousa <rui.desousa@icloud.com>)
Re: pg_stat_activity  (pavan95 <pavan.postgresdba@gmail.com>)
Список pgsql-admin
On Mon, Jun 11, 2018 at 10:07 AM, Pavan Teja <pavan.postgresdba@gmail.com> wrote:
You can use LIKE  operator for getting updates and deletes and inserts like 

​I was pondering whether answering "show me everything that isn't (match non-select statements) would be more easily achievable...and in fact it is but...
" Select * from pg_stat_activity where query like '%UPDATE%' or '%update%' "

The same in case of updates and deletes.

That would depend on how acceptable false positives are...​generally speaking pattern matching the input string doesn't work reliably.

  You can also configure table level audit with the help of triggers to capture DML's 

​How?

David J.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Pavan Teja
Дата:
Сообщение: Re: pg_stat_activity
Следующее
От: Rui DeSousa
Дата:
Сообщение: Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix