| Sort (cost=86.25..86.32 rows=27 width=61) |
| Sort Key: created_at DESC |
| -> Bitmap Heap Scan on tbl_clients (cost=4.70..85.61 rows=27 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.69 rows=55 width=0) |
| Index Cond: (sales_rep = 1001) |