> 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
