common queries in postgres sql

select version();

select date_trunc('second',current_timestamp - pg_postmaster_start_time()) as uptime;

select pg_size_pretty(pg_database_size(current_database()));

select datname, usezname, state, query from pg_stat_activity;