Postgres Pro
Downloads
Home   >   mailing lists

Re: How to check if a materialised view is being updated? - Mailing list pgsql-general

From Jayadevan M
Subject Re: How to check if a materialised view is being updated?
Date
Msg-id CAFS1N4gygbXHDy1q23p_jZohFC_qVbxf-0_JC_JmkFSb=5pGqA@mail.gmail.com
Whole thread Raw
In response to How to check if a materialised view is being updated?  (Myklebust, Bjørn Magnar <Bjorn.Myklebust@skatteetaten.no>)
Responses 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>)
List pgsql-general
Tree view


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 by date:

Previous
From: Thiemo Kellner
Date:
Subject: Re: How to check if a materialised view is being updated?
Next
From: Myklebust, Bjørn Magnar
Date:
Subject: Re: How to check if a materialised view is being updated?