Monitor db activity
select * from pg_stat_activity
Get database size
select datname as db, pg_size_size(pg_database_size(datname)) as size from pg_database order by pg_database_size(datname) desc;
Start Cloud SQL proxy with workload id:
cloud_sql_proxy -ip_address_type=PRIVATE -instances=CLOUDSQL_INSTANCE_NAME -enable_iam_login &
Log into PSQL
psql -h 127.0.0.1 -U WORKLOAD_ID DATABASE
Run a sql file
psql -h 127.0.0.1 -U WORKLOAD_ID DATABASE -a -f SQLFILE.sql
or after logging into psql:
\i /PATH/SQLFILE.sql