Re: TODO item: adding VERBOSE option to CLUSTER [with patch]

On Fri, Oct 10, 2008 at 10:23 AM, Heikki Linnakangas <
heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:

> Kevin Grittner wrote:
>
>> "Jim Cox" <shakahshakah(at)gmail(dot)com> wrote:
>>>>>
>>>> if present an INFO message is generated which displays
>>> the schema.tblname just before actual clustering is kicked off (see
>>>
>> example
>>
>>> below).
>>>
>>
>>
>>> postgres=# CLUSTER VERBOSE ;
>>> INFO: clustering "public.my_b"
>>> INFO: clustering "public.my_c"
>>> INFO: clustering "public.my_a"
>>> CLUSTER
>>>
>> Would it make sense to display the pg_total_relation_size before and
>> after?
>>
>
> Assuming you run CLUSTER as a replacement for VACUUM FULL, yes. More
> interesting would be a metric of "clusteredness", I think.
>

Something more like the following?

postgres=# CLUSTER VERBOSE ;
INFO: clustering "public.my_b"
INFO: complete, 0 rows scanned, 0 rows now live
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: clustering "public.my_c"
INFO: complete, 20 rows scanned, 10 rows now live
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: clustering "public.my_a"
INFO: complete, 10 rows scanned, 10 rows now live
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
CLUSTER