Sort (cost=88.67..88.68 rows=1 width=61) |
Sort Key: created_at DESC |
-> Bitmap Heap Scan on tbl_clients (cost=4.72..88.66 rows=1 width=61) |
Recheck Cond: (sales_rep = 1001) |
Filter: ((NOT deleted) AND (((name)::text ~~* '%北京极通世纪信息技术有限公司(过单)%'::text) OR (pinyin_shortcut ~~* '%北京极通世纪信息技术有限公司(过单)%'::text))) |
-> Bitmap Index Scan on tbl_clients_sales_rep_idx (cost=0.00..4.72 rows=59 width=0) |
Index Cond: (sales_rep = 1001) |