QUERY PLAN
Append (cost=0.00..167.18 rows=1413 width=120)
-> Seq Scan on tbl_clients (cost=0.00..120.19 rows=935 width=121)
Filter: ((NOT deleted) AND (((name)::text ~~* '%北京%'::text) OR (pinyin_shortcut ~~* '%北京%'::text)))
-> Seq Scan on tbl_suppliers (cost=0.00..32.86 rows=478 width=119)
Filter: (((name)::text ~~* '%北京%'::text) OR (pinyin_shortcut ~~* '%北京%'::text))