Indicate which index is CLUSTER index
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
Currently when looking at table structure we cannot tell which index is the cluster index (or that clustering is as such being done). It would be comprehensive to show which index, if any, is the cluster index. I have to revert to psql with "\\d _table_" to find this out which is inconvenient.
Use case: more so now that RDS supports pg_repack, it becomes very valuable to setup table clustering, and among the DBs I manage, I like to quickly see that all tables are being clustered, and properly so.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start from Postico's table structure view and compare its displayed information with what psql's "\\d _table_" reports. The work is done when the view clearly indicates which index, if any, is the table's cluster index, including when clustering is not configured.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100