Tuesday, June 12, 2018

[google-cloud-sql-discuss] Re: Without superuser, how can I terminate rogue sessions?

True, the PostgreSQL user does not have the SUPERUSER attribute. You can show connections and threads to see the processes that are running on your database. Example:

select * from pg_stat_activity;

If you meant long-lived unused connections for rogue sessions, the connections with a GCE instance time out after 10 minutes of inactivity by default. 


select * from pg_stat_activity;

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/b96cdc3e-9108-4f73-82ab-9cf3e756b0ca%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment