On Tue, Jan 21, 2025 at 9:48 AM <msalais(at)msym(dot)fr> wrote:
> Hi all,
>
>
>
> I have long commits on a production database. To know why this happens I
> organized a snapshot system on table pg_stat_activity.
>
> When I check the result I have this row in it:
>
>
>
> postgres=# select * from public.fdj_ms_slow_stmts where pid = 2285947 \gx
>
What is the full version()? What is the query used to populate this
snapshot table? Are the advisory locks being used as session-level locks
or transaction-level locks?
Cheers,
Jeff