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

  • Mastering PostgreSQL 9.6
  • Hans Jurgen Schonig
  • 121字
  • 2021-07-09 19:57:09

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.

主站蜘蛛池模板: 大港区| 临朐县| 元朗区| 肃宁县| 昭苏县| 镇雄县| 云阳县| 阳原县| 沈丘县| 攀枝花市| 墨玉县| 萝北县| 扶绥县| 离岛区| 江城| 钟祥市| 扬中市| 皋兰县| 吴江市| 于田县| 堆龙德庆县| 余姚市| 济阳县| 朝阳县| 邵阳县| 宁夏| 洪湖市| 龙游县| 西昌市| 鄂托克旗| 郑州市| 平阴县| 石棉县| 清涧县| 绵竹市| 甘肃省| 乌审旗| 波密县| 太保市| 西昌市| 大城县|