Re: How to check if a materialised view is being updated?

Поиск
Список
Период
Сортировка
От Jayadevan M
Тема Re: How to check if a materialised view is being updated?
Дата
Msg-id CAFS1N4gygbXHDy1q23p_jZohFC_qVbxf-0_JC_JmkFSb=5pGqA@mail.gmail.com
обсуждение исходный текст
Ответ на How to check if a materialised view is being updated?  (Myklebust, Bjørn Magnar <Bjorn.Myklebust@skatteetaten.no>)
Ответы Re: How to check if a materialised view is being updated?  (Philip Semanchuk <philip@americanefficient.com>)
Re: How to check if a materialised view is being updated?  (Myklebust, Bjørn Magnar <Bjorn.Myklebust@skatteetaten.no>)
Список pgsql-general
Дерево обсуждения


So I’m looking for a way to identify if the refresh process is finished or if it’s still running  - preferably without having to wait for timeout by querying a locked materialized view.  But by e.g. using the system tables or otherwise.

 

Can anybody suggest some pointers on how to do this?

 
Maybe pg_stat_activity will have the refresh query?

Regards,
Jayadevan

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

Предыдущее
От: Thiemo Kellner
Дата:
Сообщение: Re: How to check if a materialised view is being updated?
Следующее
От: Myklebust, Bjørn Magnar
Дата:
Сообщение: Re: How to check if a materialised view is being updated?