Semab Tariq wants to see which indexes are in use:
Indexes exist to speed up data access. They allow PostgreSQL to avoid full table scans, significantly reducing query execution time for read-heavy workloads.
From real production experience, we have observed that well-designed, targeted indexes can improve query performance by 5× or more, especially on large transactional tables.
However, indexes are not free.
The reasons for why are very similar to what we have in SQL Server. The way to track utilization is a bit different, however.