pg_stat_activity (currently executing queries):
select procpid, datname, rpad(current_query, 80) query, waiting, to_char(query_start, 'MM-DD-YY HH24:MI:SS') query_start, client_addr, client_port from pg_stat_activity order by query_start;
pg_user (all database users):
select * from pg_user;
pg_database (all databases and their sizes):
select datname, pg_size_pretty(pg_database_size(datname)) from pg_database order by pg_database_size(datname) desc;
pg_tables (all tables and their sizes, with/without indexes):
select tablename, pg_size_pretty(pg_relation_size(schemaname||'.'||tablename)) as size, pg_size_pretty(pg_total_relation_size(schemaname||'.'||tablename)) as total_size from pg_tables where schemaname = 'MY_SCHEMA_NAME';
pg_namespace (all schemas):
select * from pg_namespace order by 1;
-
-
Save madelfio/2520766 to your computer and use it in GitHub Desktop.
Useful Postgres Admin Queries
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment