Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?

2019-03-18 Thread Yun Li
Thanks a lot for really good points!! I did not expected I will get this many points of view. :P I have identical experience with Robert when other extension calculate the id different as PGSS, PGSS will overwritten that id when it is on. But Tom got a point that if we centralize the logic that pg

Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?

2019-03-15 Thread Yun Li
Hey pg developers, Do you think if we can add queryId into the pg_stat_get_activity function and ultimatly expose it in the view? It would be easier to track "similar" query's performance over time easier. Thanks a lot! Yun