Append (cost=0.00..162.06 rows=1428 width=120) |
-> Seq Scan on tbl_clients (cost=0.00..116.59 rows=958 width=121) |
Filter: ((NOT deleted) AND (((name)::text ~~* '%北京%'::text) OR (pinyin_shortcut ~~* '%北京%'::text))) |
-> Seq Scan on tbl_suppliers (cost=0.00..31.18 rows=470 width=119) |
Filter: (((name)::text ~~* '%北京%'::text) OR (pinyin_shortcut ~~* '%北京%'::text)) |