Re: [PROPOSAL] extend the object names to the qualified names in pg_stat_statements

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergei Agalakov <sergei(dot)agalakov(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PROPOSAL] extend the object names to the qualified names in pg_stat_statements
Date: 2018-11-28 21:34:26
Message-ID: 15933.1543440866@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sergei Agalakov <sergei(dot)agalakov(at)gmail(dot)com> writes:
> It would help to analyze performance issues if pg_stat_statements would
> extend the object names to the qualified names.

What pg_stat_statements puts out is the original query text. As was
already pointed out to you, changing that text is likely to break
use-cases in which people are trying to match entries to actual
queries or log entries. This would also entail rather significant
overhead to find out schema names and interpolate them into the text.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-11-28 21:41:36 Re: Python versions (was Re: RHEL 8.0 build)
Previous Message Peter Eisentraut 2018-11-28 21:20:44 Re: Python versions (was Re: RHEL 8.0 build)