DBA Hub

📋Steps in this guide1/1

Monitor vacuum operation

postgres# select * from pg_stat_progress_vacuum; -[ RECORD 1 ]------+-------------------- pid                | 12540 datid              | 21192 datname            | b2cnsmst relid              | 22402 phase              | cleaning up indexes heap_blks_total.   | 624176 heap_blks_scanned  | 624176 heap_blks_vacuumed | 624176 index_vacuum_count | 0 max_dead_tuples    | 178956970 num_dead_tuples    |

postgresql configurationintermediate
by PostgreSQL
14 views
1

Monitor vacuum operation

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
postgres#
select * from pg_stat_progress_vacuum;
-[ RECORD 1 ]------+--------------------
pid                | 12540
datid              | 21192
datname            | b2cnsmst
relid              | 22402
phase              | cleaning up indexes
heap_blks_total.   | 624176
heap_blks_scanned  | 624176
heap_blks_vacuumed | 624176
index_vacuum_count | 0
max_dead_tuples    | 178956970
num_dead_tuples    | 0

Comments (0)

Please to add comments

No comments yet. Be the first to comment!