| Sort (cost=95.85..95.92 rows=28 width=61) |
| Sort Key: created_at DESC |
| -> Bitmap Heap Scan on tbl_clients (cost=4.72..95.17 rows=28 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.71 rows=58 width=0) |
| Index Cond: (sales_rep = 1001) |