pg_stat_statements has duplicate entries for the same query & queryId

Hi Folks! Let me know if there's a better mailing list to ask this in. I have a statistics collector that collects data from various postgres statistics tables, pg_stat_statements being one of them. This is done on an entire fleet of Postgres databases. From the collected data we record the timest

Clarification on REVOKE ALL ON FUNCTION – Are there any privileges apart from EXECUTE?

Hi Postgres Community, I had a quick question regarding function-level privileges in PostgreSQL. We know that REVOKE EXECUTE ON FUNCTION ... removes the ability to call the function. But when we do: REVOKE ALL ON FUNCTION my_func(args) FROM some_role; does this revoke anything other than EXECUTE?

Re: Clarification on REVOKE ALL ON FUNCTION – Are there any privileges apart from EXECUTE?

On 5/18/25 12:17, Ayush Vatsa wrote: Hi Postgres Community, I had a quick question regarding function-level privileges in PostgreSQL. We know that |REVOKE EXECUTE ON FUNCTION ...| removes the ability to call the function. But when we do: REVOKE ALL ON FUNCTION my_func(args) FROM some_role; doe

Re: pg_stat_statements has duplicate entries for the same query & queryId

On 5/18/25 12:20, Jevon Cowell wrote: Hi Folks! Let me know if there's a better mailing list to ask this in. I have a statistics collector that collects data from various postgres statistics tables, pg_stat_statements being one of them. This is done on an entire fleet of Postgres databases. Fr