Issue #2333: hub: unused index sessions_active_and_recent - koji

koji

#2333 hub: unused index sessions_active_and_recent

Closed: Fixed 3 years ago by tkopecek. Opened 3 years ago by tkopecek.

As condition is negative, index is never used.

select 
    indexrelid::regclass as index, relid::regclass as table 
from 
    pg_stat_user_indexes 
    JOIN pg_index USING (indexrelid) 
where 
    idx_scan = 0 and indisunique is false;
             index             |          table           
-------------------------------+--------------------------
...
 sessions_active_and_recent    | sessions
...

tkopecek commented 3 years ago

PR #2334

Metadata Update from @tkopecek:
- Custom field Size adjusted to None

3 years ago

tkopecek commented 3 years ago

Commit 2f4688d fixes this issue

tkopecek commented 3 years ago

Commit 6d41344 fixes this issue

Metadata

Assignee

None

Tags

Blocking

None

Depending on

None

Priority

Low

Milestone

1.22

Size

None

Related Pull Requests

#2334 Merged 3 years ago

koji

Source Code

Documentation

#2333 hub: unused index sessions_active_and_recent Closed: Fixed 3 years ago by tkopecek. Opened 3 years ago by tkopecek.

Metadata

bug easyfix no_qe

Related Pull Requests

#2333 hub: unused index sessions_active_and_recent

Closed: Fixed 3 years ago by tkopecek. Opened 3 years ago by tkopecek.