diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/privileges.out /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/privileges.out --- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/privileges.out 2025-03-05 13:34:15.174994076 +0000 +++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/privileges.out 2025-03-05 13:40:50.908468432 +0000 @@ -1,41 +1,3 @@ --- --- Only superusers and roles with privileges of the pg_read_all_stats role --- are allowed to see the SQL text and queryid of queries executed by --- other users. Other users can see the statistics. --- -SET pg_stat_statements.track_utility = FALSE; -CREATE ROLE regress_stats_superuser SUPERUSER; -CREATE ROLE regress_stats_user1; -CREATE ROLE regress_stats_user2; -GRANT pg_read_all_stats TO regress_stats_user2; -SET ROLE regress_stats_superuser; -SELECT pg_stat_statements_reset() IS NOT NULL AS t; - t ---- - t -(1 row) - -SELECT 1 AS "ONE"; - ONE ------ - 1 -(1 row) - -SET ROLE regress_stats_user1; -SELECT 1+1 AS "TWO"; - TWO ------ - 2 -(1 row) - --- --- A superuser can read all columns of queries executed by others, --- including query text and queryid. --- -SET ROLE regress_stats_superuser; -SELECT r.rolname, ss.queryid <> 0 AS queryid_bool, ss.query, ss.calls, ss.rows - FROM pg_stat_statements ss JOIN pg_roles r ON ss.userid = r.oid - ORDER BY r.rolname, ss.query COLLATE "C", ss.calls, ss.rows; rolname | queryid_bool | query | calls | rows -------------------------+--------------+----------------------------------------------------+-------+------ regress_stats_superuser | t | SELECT $1 AS "ONE" | 1 | 1 @@ -69,17 +31,13 @@ SELECT r.rolname, ss.queryid <> 0 AS queryid_bool, ss.query, ss.calls, ss.rows FROM pg_stat_statements ss JOIN pg_roles r ON ss.userid = r.oid ORDER BY r.rolname, ss.query COLLATE "C", ss.calls, ss.rows; - rolname | queryid_bool | query | calls | rows --------------------------+--------------+---------------------------------------------------------------------------------+-------+------ - regress_stats_superuser | t | SELECT $1 AS "ONE" | 1 | 1 - regress_stats_superuser | t | SELECT pg_stat_statements_reset() IS NOT NULL AS t | 1 | 1 - regress_stats_superuser | t | SELECT r.rolname, ss.queryid <> $1 AS queryid_bool, ss.query, ss.calls, ss.rows+| 1 | 3 - | | FROM pg_stat_statements ss JOIN pg_roles r ON ss.userid = r.oid +| | - | | ORDER BY r.rolname, ss.query COLLATE "C", ss.calls, ss.rows | | - regress_stats_user1 | t | SELECT $1+$2 AS "TWO" | 1 | 1 - regress_stats_user1 | t | SELECT r.rolname, ss.queryid <> $1 AS queryid_bool, ss.query, ss.calls, ss.rows+| 1 | 4 - | | FROM pg_stat_statements ss JOIN pg_roles r ON ss.userid = r.oid +| | - | | ORDER BY r.rolname, ss.query COLLATE "C", ss.calls, ss.rows | | + rolname | queryid_bool | query | calls | rows +-------------------------+--------------+--------------------------+-------+------ + regress_stats_superuser | | | 1 | 1 + regress_stats_superuser | | | 1 | 1 + regress_stats_superuser | | | 1 | 3 + regress_stats_user1 | | | 1 | 1 + regress_stats_user1 | | | 1 | 4 (5 rows) -- diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/cleanup.out /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/cleanup.out --- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/cleanup.out 2025-03-05 13:34:15.174994076 +0000 +++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/cleanup.out 2025-03-05 13:40:51.156472219 +0000 @@ -1 +0,0 @@ -DROP EXTENSION pg_stat_statements;