common queries in postgres sql

1
2
3
4
5
6
7
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;

resize ubuntu logic volume

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
$sudo lvdisplay
LV Path /dev/ubuntu-vg/ubuntu-lv

**查看并记下LV的Path

$ sudo pvdisplay
PV Size <63.00 GiB / not usable 0

** 查看PV的实际大小

$ sudo lvextend -L 62G /dev/ubuntu-vg/ubuntu-lv

**根据前两步的LVPath和PV大小,扩容到(比PV最大略小1、2G才够分配)

$ sudo resize2fs /dev/ubuntu-vg/ubuntu-lv

**让OS识别新的PV