QUERY PLAN
Append (cost=0.00..165.61 rows=1378 width=120)
-> Seq Scan on tbl_clients (cost=0.00..118.97 rows=912 width=121)
Filter: ((NOT deleted) AND (((name)::text ~~* '%bj%'::text) OR (pinyin_shortcut ~~* '%bj%'::text)))
-> Seq Scan on tbl_suppliers (cost=0.00..32.86 rows=466 width=119)
Filter: (((name)::text ~~* '%bj%'::text) OR (pinyin_shortcut ~~* '%bj%'::text))