> On Jan 19, 2021, at 6:33 AM, Jayadevan M <maymala.jayadevan@xxxxxxxxx> wrote: > > > > 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? Yes, pg_stat_activity has a query column that could be searched with the regular string matching tools, including regex if necessary. pg_stat_activity also has some other useful columns that, like query_start which can tell you how long the query has been running. Cheers Philip
