Re: [PROPOSAL] VACUUM Progress Checker.

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.

In response to

Responses

Browse pgsql-hackers by date

  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