Re: Question about semantics of $ variables in json explain plans in 13

2023-12-08 Thread Tom Lane
Jerry Brenner writes: > Is there any documentation on the semantics of $ variables in json explain > plans for both InitPlans and SubPlans in 13? I don't think there's anything much in the user-facing docs, which is somewhat unfortunate because it's confusing: the notation is overloaded. $N could

Question about semantics of $ variables in json explain plans in 13

2023-12-08 Thread Jerry Brenner
Is there any documentation on the semantics of $ variables in json explain plans for both InitPlans and SubPlans in 13? I'm trying to understand the attached json file. - It looks like $0 represents the value from the outer query block when the correlated subquery is evaluated - It looks