postgres finding child tables for particular table
The schema name of a table is not stored in the column table_name, it's stored in the column table_schema, so you need to change the condition:

and ccu.table_name in ('plugin') 


to 

and (ccu.table_schema, ccu.table_name) in (('a', 'plugin'))