PostgreSQL 12新增了pg_stat_progress_cluster,用以統(tǒng)計database的活動進(jìn)度,加強了數(shù)據(jù)庫的易用性.

創(chuàng)新互聯(lián)主要從事網(wǎng)站設(shè)計、成都網(wǎng)站制作、網(wǎng)頁設(shè)計、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務(wù)。立足成都服務(wù)思禮,10年網(wǎng)站建設(shè)經(jīng)驗,價格優(yōu)惠、服務(wù)專業(yè),歡迎來電咨詢建站服務(wù):18982081108

PG11

[xdb@localhost testdb]$ psql -p 5433 -d testdb
psql (11.2)
Type "help" for help.
testdb=# select * FROM pg_stat_progress_cluster;
ERROR:  relation "pg_stat_progress_cluster" does not exist
LINE 1: select * FROM pg_stat_progress_cluster;
                      ^
testdb=#

PG 11沒有該relation.

PG12

[pg12@localhost ~]$ psql -d testdb
psql (12beta1)
Type "help" for help.
testdb=# vacuum full;
VACUUM
testdb=# 
testdb=# drop table t_status;
;
vacuum full;DROP TABLE
testdb=# create table t_status(id int,c1 varchar(200),c2 varchar(200),c3 varchar(200));
CREATE TABLE
testdb=# 
testdb=# insert into t_status select x,'c1'||x,'c2'||x,'c3'||x from generate_series(1,1000000) as x;
INSERT 0 1000000
testdb=# 
testdb=# update t_status set c1 = lpad(c1,200,'*'),c2=lpad(c2,200,'*');
UPDATE 1000000
testdb=# 
testdb=# vacuum full;

查詢pg_stat_progress_cluster監(jiān)控

testdb=# select pid,datname,relid::regclass,command,phase,heap_blks_scanned,heap_tuples_scanned FROM pg_stat_progress_cluster;
  pid  | datname | relid |   command   |       phase       | heap_blks_scanned | heap_tuples_scanned 
-------+---------+-------+-------------+-------------------+-------------------+---------------------
 10805 | testdb  | t1    | VACUUM FULL | seq scanning heap |              2989 |              552780
(1 row)

參考資料
Postgres 12 highlight - More progress reporting