As per the documentation, To get the total size of all indexes attached to a table, you use the function. The pg_indexes_size() function accepts the OID or table name as the argument and returns the total disk space used by all indexes attached to that table.
We will use this funcion to get the index sizes of each table in the database.
select relname as table_name,
pg_size_pretty(pg_indexes_size(relid)) as index_size