Dashboard customization (RM #3061)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3061
Originally created by Pavel Klimenko at 2018-01-26 08:41:08 UTC.

It will be cool to have opportunity to dashboard customization.
I mean:

• disable/enable some widgets (widget - Server Sessions | Transactions per second | Tuples in etc)
• add custom/user specify widgets
• add user role with access only to dashboard

What are you think about it?

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3061#note-1
Originally created by Akshay Joshi at 2018-05-18 10:47:23 UTC.

Need to work on design.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed		Ready

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3061#note-2
Originally created by Dave Page at 2018-05-18 10:51:12 UTC.

It doesn't make a huge amount of sense to allow serious customisation of the dashboards unless we also allow custom charts to be defined. This could be done quite easily - we just need to get a title and SQL query to execute from the user. Series names could be the column name, so a query like SELECT hits AS "Web Hits", errors AS "Errors" FROM weblogs; could be used.

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3061#note-3
Originally created by vikas gupta at 2020-09-21 11:58:17 UTC.

Dave Page wrote:

It doesn't make a huge amount of sense to allow serious customisation of the dashboards unless we also allow custom charts to be defined. This could be done quite easily - we just need to get a title and SQL query to execute from the user. Series names could be the column name, so a query like SELECT hits AS "Web Hits", errors AS "Errors" FROM weblogs; could be used.

Yes, I agree. If user queries can be customized to create own graphs, that would be really useful feature.

[akshay-joshi]

We are not planning to work on this in the future, so we are closing it.