Provide summary table for suggestions

[mkindahl]

Background

Right now, the tool emits a message for each object that matches a rule. The message is usually very elaborate, for example:

mats@fury:~/work/timescale/doctor$ timescale-doctor 
Table might benefit from being transformed to a hypertable.

    1. The table 'rides' has a column 'pickup_datetime' of timestamp type 'timestamp'
    2. The table 'rides' is not partitioned
    3. There are index scans done on 'rides'
    4. There are rows in 'rides'
    5. There are more than 10 pages allocated to 'rides'.

Problem

With a lot of tables under consideration, it can be difficult to get a good summary of the available tables and/or queries, what rules they match, and what the recommendation is.

Solution

Print a summary table with reference to the name of the rule. Something like this

Rule	Object	Description
hypertable_candidate	rides

The tool can then print the full recommendation using a option and a rule name to provide more information.

[RobAtticus]

Any consideration to adding this feature set to timescale-tune?

[RobAtticus]

Long ago when I had bigger ambitions for it, I thought about tuning hypertables/policies/etc

[mkindahl]

Any consideration to adding this feature set to timescale-tune?

That is an option, but not sure how easy it is to build something like this using timescaledb-tune.