Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?
От | Julien Rouhaud |
---|---|
Тема | Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? |
Дата | |
Msg-id | 20210408041758.amzavdu5rmvv6low@nol обсуждение исходный текст |
Ответ на | Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? |
Список | pgsql-hackers |
On Wed, Apr 07, 2021 at 02:12:11PM -0400, Bruce Momjian wrote: > > Patch applied. I am ready to adjust this with any improvements people > might have. Thank you for all the good feedback we got on this, and I > know many users have waited a long time for this feature. Thanks a lot Bruce and everyone! I hope that the users who waited a long time for this will find everything they need. Just to validate that this patchset also allows user to use pg_stat_statements, any additional third-party module and the new added infrastructure with the queryid algorithm of their choice, I created a POC extension ([1]) which works as expected. Basically: SHOW shared_preload_libraries; shared_preload_libraries -------------------------- pg_stat_statements, pg_queryid (1 row) SET pg_queryid.use_object_names TO on; SET pg_queryid.ignore_schema TO on; CREATE SCHEMA ns1; CREATE TABLE ns1.tbl1(id integer); CREATE SCHEMA ns2; CREATE TABLE ns2.tbl1(id integer); SET search_path TO ns1; SELECT COUNT(*) FROM tbl1; SET search_path TO ns2; SELECT COUNT(*) FROM tbl1; SELECT queryid, query, calls FROM public.pg_stat_statements WHERE query LIKE '%tbl%'; queryid | query | calls ---------------------+---------------------------+------- 4629593225724429059 | SELECT count(*) from tbl1 | 2 (1 row) So whether that's a good idea to do that or not, users now have a choice. [1]: https://github.com/rjuju/pg_queryid
В списке pgsql-hackers по дате отправления: