Re: Skip temporary table schema name from explain-verbose output.
От | Greg Stark |
---|---|
Тема | Re: Skip temporary table schema name from explain-verbose output. |
Дата | |
Msg-id | CAM-w4HMOmgDv05JRkEqAFMQ88OF0pT2DfXPoi-ggTNKegis=mw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Skip temporary table schema name from explain-verbose output. (Amul Sul <sulamul@gmail.com>) |
Ответы |
Re: Skip temporary table schema name from explain-verbose output.
|
Список | pgsql-hackers |
> On Tue, Apr 27, 2021 at 7:08 PM Bharath Rupireddy > <bharath.rupireddyforpostgres@gmail > Make sense, we would lose the ability to differentiate temporary > tables from the auto_explain logs. There's no useful differentiation that can be done with the temp schema name. They're assigned on connection start randomly from the pool of temp schemas. The names you find in the log won't be useful and as new connections are made the same schema names will be reused for different connections. I would say it makes sense to remove them -- except perhaps it makes it harder to parse explain output. If explain verbose always includes the schema then it's easier for a parser to make sense of the explain plan output without having to be prepared to sometimes see a schema and sometimes not. That's probably a pretty hypothetical concern however since all the explain plan parsers that actually exist are prepared to deal with non-verbose plans anyways. And we have actual machine-readable formats too anyways. -- greg
В списке pgsql-hackers по дате отправления: