From: | Vinayak <vinpokale(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [PROPOSAL] VACUUM Progress Checker. |
Date: | 2015-12-01 02:10:44 |
Message-ID: | 1448935844520-5875614.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kyotaro HORIGUCHI | 2015-12-01 02:11:01 | Re: Error with index on unlogged table |
Previous Message | Peter Geoghegan | 2015-12-01 01:21:40 | Re: Using quicksort for every external sort run |