[Postgres] Identifier les privilèges

SELECT *   FROM information_schema.role_table_grants  WHERE grantee = '<role_name>';

[Postgres] Identifier les attentes

This query allows you to identify the wait events on which query .

How to Find and Stop Running Queries on PostgreSQL

Find a query with his pid.