QUERY PLAN
Append (cost=0.00..154.60 rows=155 width=120)
-> Seq Scan on tbl_clients (cost=0.00..120.19 rows=81 width=121)
Filter: ((NOT deleted) AND (((name)::text ~~* '%bjh%'::text) OR (pinyin_shortcut ~~* '%bjh%'::text)))
-> Seq Scan on tbl_suppliers (cost=0.00..32.86 rows=74 width=119)
Filter: (((name)::text ~~* '%bjh%'::text) OR (pinyin_shortcut ~~* '%bjh%'::text))