Horton

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

Yun Li <liyunjuanyong@gmail.com>

View thread View on postgr.es
From: Yun Li <liyunjuanyong@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2019-03-15T21:54:19Z
Lists: pgsql-hackers 
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

Commits

  1. Clarify description of pg_stat_statements columns

  2. Fix wording in description of pg_stat_statements.toplevel

  3. Mention that toplevel is part of pg_stat_statements key.

  4. adjust query id feature to use pg_stat_activity.query_id

  5. Update copyright for 2021

  6. Take the statistics collector out of the loop for monitoring backends'