> > 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