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
