Anthony theonlyway

Useful PostgreSQL Queries & Commands

All sizes in MB, change /1024/1024 to /1024/1024/1024 for GB.

Without system databases

select
datname as database,
(pg_database_size(datname)/1024/1024) as size

	<!DOCTYPE html>
	<html>
	<head>
	<!-- Fontawesome 5! Get it here: https://fontawesome.com/how-to-use/on-the-web/setup/hosting-font-awesome-yourself -->
	<link rel="stylesheet" href="css/all.min.css" />
	<style>
	body {
	background: rgba(0, 0, 0);
	color: #ffffff;
	font-size: 16px;

	AUTH0_ISSUER_BASE_URL='https://YOUR_AUTH0_DOMAIN.auth0.com'
	AUTH0_SCOPE='openid read:current_user create:current_user_metadata update:current_user_metadata'