koji

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

Closed: Fixed
Reopen Issue

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
...

PR #2334

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

Commit 2f4688d5 fixes this issue

Commit 6d41344d fixes this issue

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/2333

Please continue any further discussion there.
Metadata
None

bug easyfix no_qe

None
None
Normal
None
Related Pull Requests
Static archive. pagure.io was sunset in 2026; this is a read-only snapshot.
Red Hat Logo

Fedora is sponsored by Red Hat. Learn more about the relationship between Red Hat and Fedora »

© Red Hat, Inc. and others.