is there a way that we could find which procpid or connection that has created a particular temporary schema (pg_temp_*) ?.
In one of our db a temporary schema (pg_temp_48) was using more than 200GB of disk space and how to find the connection which has created the temp schema, ?