Skip to content

Instantly share code, notes, and snippets.

@malkab

malkab/postgresql_general_management_recipes.sql

Last active December 22, 2020 09:38
Show Gist options
  • Save malkab/3028a6947a8aeec7a1924ca6f20d2a74 to your computer and use it in GitHub Desktop.
Save malkab/3028a6947a8aeec7a1924ca6f20d2a74 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL - General Management Recipes
Raw
postgresql_general_management_recipes.sql
/**
Check number of connections to the DB.
*/
SELECT count(distinct(numbackends)) FROM pg_stat_database;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment