Re: [PROPOSAL] extend the object names to the qualified names inpg_stat_statements - Mailing list pgsql-hackers

From legrand legrand
Subject Re: [PROPOSAL] extend the object names to the qualified names inpg_stat_statements
Date
Msg-id 1543483408140-0.post@n3.nabble.com
Whole thread Raw
In response to Re: [PROPOSAL] extend the object names to the qualified names inpg_stat_statements  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Alvaro Herrera-9 wrote
> On 2018-Nov-28, Tom Lane wrote:
> 
>> This would also entail rather significant overhead to find out schema
>> names and interpolate them into the text.
> 
> True.  I was thinking that the qualified-names version of the query
> would be obtained via ruleutils or some similar mechanism to deparse
> from the parsed query tree (not from the original query text), where
> only pg_catalog is considered visible.  This would be enabled using a
> GUC that defaults to off.

maybe that explain on "table with many columns" suffers from the same 
problem, see:

https://www.postgresql.org/message-id/1537816948278-0.post%40n3.nabble.com

https://www.postgresql.org/message-id/20180924195048.7dhnjvq5ggwjtiwi@alap3.anarazel.de

regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html


pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [PATCH] Change "checkpoint starting" message to use "wal"
Next
From: "Iwata, Aya"
Date:
Subject: RE: libpq debug log