Shulou(Shulou.com)06/01 Report--

PostgreSQL 12 adds pg_stat_progress_cluster to count the progress of database activities and enhance the ease of use of the database.

PG11

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

PG 11 does not have the relation.

PG12

[pg12@localhost ~] $psql-d testdbpsql (12beta1) Type "help" for help.testdb=# vacuum full;VACUUMtestdb=# testdb=# drop table tasking statusleading full;DROP TABLEtestdb=# create table t_status (id int,c1 varchar), c2 varchar (200), c3 varchar (200); CREATE TABLEtestdb=# testdb=# insert into t_status select x varchar c1' | | x from generate_series C2'| | x from generate_series (1m 1 000000) as x INSERT 0 1000000testdb=# testdb=# update t_status set C1 = lpad (c1Magne200 dagger'), c2=lpad (c2pd200); UPDATE 1000000testdb=# testdb=# vacuum full

Query pg_stat_progress_cluster monitoring

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)

references

Postgres 12 highlight-More progress reporting

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.