Thanks for the v7.
Please check the comment below.
-Table name in the vacuum progress
+ snprintf(progress_message[0], PROGRESS_MESSAGE_LENGTH, "%s.%s",
schemaname,relname);
In the vacuum progress, column table_name is showing first 30 characters of
table name.
postgres=# create table test_vacuum_progress_in_postgresql(c1 int,c2 text);
postgres=# select * from pg_stat_vacuum_progress ;
-[ RECORD 1 ]-------+------------------------------
pid | 12284
table_name | public.test_vacuum_progress_i
phase | Scanning Heap
total_heap_pages | 41667
scanned_heap_pages | 25185
percent_complete | 60
total_index_pages | 0
scanned_index_pages | 0
index_scan_count | 0
-----
Regards,
Vinayak,
--
View this message in context: http://postgresql.nabble.com/PROPOSAL-VACUUM-Progress-Checker-tp5855849p5875614.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.