- 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.
推薦閱讀
- Hands-On Graph Analytics with Neo4j
- 嵌入式系統應用
- AWS:Security Best Practices on AWS
- 影視后期制作(Avid Media Composer 5.0)
- Expert AWS Development
- Creo Parametric 1.0中文版從入門到精通
- 網站入侵與腳本攻防修煉
- 電腦日常使用與維護322問
- Mastering GitLab 12
- INSTANT Puppet 3 Starter
- 水晶石影視動畫精粹:After Effects & Nuke 影視后期合成
- 大數據:引爆新的價值點
- 設計模式
- 常用傳感器技術及應用(第2版)
- 網絡安全概論