GP - Database List

Generating the report on the list of database
SELECT
 d.oid AS "Database OID",
 d.datname AS "Database Name", 
 r.rolname AS "Database Owner",
 pg_catalog.pg_encoding_to_char(d.encoding) AS "Database Encoding",
 d.datallowconn AS "Connections Allowed",
 d.datconnlimit AS "Connection Limit",
 pg_size_pretty(pg_database_size(d.datname)) AS "Database Size"
FROM
 pg_catalog.pg_database d , 
 pg_catalog.pg_roles r
WHERE
 d.datdba=r.oid
ORDER BY 2 ;
NOTE: This SQL can ran from any Database

Comments

Popular posts from this blog

GP - Kerberos errors and resolutions

How to set Optimizer at database level in greenplum

GP - SQL Joins