dashboard: show more details in catalog pages

[BugenZhao]

Although RisingWave is compatible with the Postgres wire protocol and system catalogs so a considerable number of external tools work to inspect and manage the system, we still have some custom resources like Source and Sink which cannot be natively supported. As a result, the catalog pages in dashboard play an important role for observability, especially for on-premises deployments.

Currently, there's a lack of detail information, such as...

• owner name additional to internal id
• database name
• schema name

Also, some custom resources are missing, like

• user-defined functions
• connection
• subscription: feat(dashboard): subscription is not displayed in kernel dashboard(catalog, streaming graph) #16469

[fuyufjh]

cc. @wangrunji0408 for the UDF parts

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄