nested queries vs. pg_stat_activity - Mailing list pgsql-hackers

From legrand legrand
Subject nested queries vs. pg_stat_activity
Date
Msg-id AM6PR0102MB3157EC9857150EF68C65BC7C90440@AM6PR0102MB3157.eurprd01.prod.exchangelabs.com
Whole thread Raw
Responses Re: nested queries vs. pg_stat_activity
List pgsql-hackers
Hello,

An other solution is to expose nested queryid, and to join it with pg_stat_statements.
Actual development trying to add queryid to pg_stat_activity isn't helpfull, because it is only exposing top level one.
Extension pg_stat_sql_plans (github) propose a function called pg_backend_queryid(pid),
that gives the expected queryid (that is stored in shared memory for each backend) ...

Regards
PAscal

pgsql-hackers by date:

Previous
From: Shawn Debnath
Date:
Subject: Re: pendingOps table is not cleared with fsync=off
Next
From: Anastasia Lubennikova
Date:
Subject: Re: [BUG] Error in BRIN summarization