Missing / Orphan Indexes?
pg_indexes.tablename only contains the table name, not the schema name. The schema name is available in the column schemaname.

So you need to use

select * 
from pg_indexes 
where tablename ='asignacion'
  and schemaname = 'distribucion';