PostgreSQL: insufficient privilege

You would have to run the query as a root-user to see all the queries. This is usually the postgres user.

On certain managed postgresql services (AWS), access to the root-user is restricted, and it is not possible to see queries executed by that user by design.

In general, the more privileges your user has, the more queries you can see in pg_stat_activity