Re: query_id: jumble names of temp tables for better pg_stat_statement UX
| От | Christoph Berg |
|---|---|
| Тема | Re: query_id: jumble names of temp tables for better pg_stat_statement UX |
| Дата | |
| Msg-id | Z-F9L8nGd72E8d2G@msg.df7cb.de обсуждение исходный текст |
| Ответ на | Re: query_id: jumble names of temp tables for better pg_stat_statement UX (Michael Paquier <michael@paquier.xyz>) |
| Ответы |
Re: query_id: jumble names of temp tables for better pg_stat_statement UX
|
| Список | pgsql-hackers |
Re: Michael Paquier > So your idea to use the relation name in eref while skipping the > column list looks kind of promising. Per se the attached. Thoughts? Makes sense to me, thanks for digging into it. > +++ b/src/backend/nodes/queryjumblefuncs.c > @@ -33,6 +33,7 @@ > #include "postgres.h" > > #include "access/transam.h" > +#include "catalog/namespace.h" No longer needed. > +++ b/contrib/pg_stat_statements/sql/select.sql > +SET search_path = 'pgss_schema_1'; > +SELECT count(*) FROM tab_search_same; > +SELECT a, b FROM tab_search_same; > +SELECT count(*) FROM tab_search_diff_1; > +SELECT count(*) FROM tab_search_diff_2; > +SELECT a FROM tab_search_diff_2; > +SET search_path = 'pgss_schema_1'; Should this be pgss_schema_2 ? Christoph
В списке pgsql-hackers по дате отправления: