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

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: Myklebust, Bjørn Magnar <Bjorn(dot)Myklebust(at)skatteetaten(dot)no>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to check if a materialised view is being updated?
Date: 2021-01-19 11:33:33
Message-ID: CAFS1N4gygbXHDy1q23p_jZohFC_qVbxf-0_JC_JmkFSb=5pGqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Myklebust 2021-01-19 12:54:36 Re: How to check if a materialised view is being updated?
Previous Message Thiemo Kellner 2021-01-19 11:24:39 Re: How to check if a materialised view is being updated?