- 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.
推薦閱讀
- Oracle SOA Governance 11g Implementation
- 面向STEM的mBlock智能機器人創新課程
- 中文版Photoshop CS5數碼照片處理完全自學一本通
- PostgreSQL 11 Server Side Programming Quick Start Guide
- 3D Printing with RepRap Cookbook
- 空間機器人遙操作系統及控制
- 影視后期制作(Avid Media Composer 5.0)
- 數據庫原理與應用技術學習指導
- Windows內核原理與實現
- Windows 7寶典
- Ceph:Designing and Implementing Scalable Storage Systems
- 傳感器與物聯網技術
- Kubernetes for Developers
- 傳感器與新聞
- Web璀璨:Silverlight應用技術完全指南