官术网_书友最值得收藏!

Tracking vaccum progress

For many years, people have asked for a progress tracker for vacuum. Finally, PostgreSQL 9.6 makes this wish come true by introducing a new system view. Here is how it works:

postgres=# SELECT * FROM pg_stat_progress_vacuum ?

-[ RECORD 1 ]------+--------------

pid | 29546
datid | 67535
datname | test
relid | 16402
phase | scanning heap
heap_blks_total | 6827
heap_blks_scanned | 77
heap_blks_vacuumed | 0
index_vacuum_count | 0
max_dead_tuples | 154
num_dead_tuples | 0

PostgreSQL will provide detailed information about ongoing vacuum processes so that people can track the progress of this vital operation.

主站蜘蛛池模板: 乌拉特前旗| 富源县| 孟州市| 潍坊市| 临江市| 汽车| 辽宁省| 潞西市| 海丰县| 烟台市| 麟游县| 海盐县| 蓝田县| 柏乡县| 霍山县| 阿拉善左旗| 大石桥市| 灵川县| 宁海县| 荆门市| 墨竹工卡县| 乐清市| 姜堰市| 屯昌县| 宁化县| 黑河市| 崇仁县| 乌拉特后旗| 临颍县| 道真| 光泽县| 铁力市| 龙陵县| 垦利县| 青田县| 余干县| 高碑店市| 罗城| 达日县| 巨鹿县| 岢岚县|