
Sort  (cost=680.29..680.35 rows=26 width=1661) (actual time=3.875..3.968 rows=567 loops=1)
  Sort Key: service_date
  Sort Method: quicksort  Memory: 370kB
  Buffers: shared hit=561
  ->  Bitmap Heap Scan on sljy_order_product orderprodu0_  (cost=12.29..679.68 rows=26 width=1661) (actual time=0.315..2.431 rows=567 loops=1)
    Recheck Cond: ((company_id = '86568'::bigint) AND ((service_date)::text >= '20180201'::text) AND ((service_date)::text <= '20180228'::text))
    Filter: (((destination_code)::text = 'JGK'::text) AND ((order_state)::text <> ALL ('{0,1,2,3}'::text[])))
    Rows Removed by Filter: 35
    Heap Blocks: exact=553
    Buffers: shared hit=561
    ->  Bitmap Index Scan on sljy_order_product_index1  (cost=0.00..12.29 rows=229 width=0) (actual time=0.246..0.246 rows=987 loops=1)
          Index Cond: ((company_id = '86568'::bigint) AND ((service_date)::text >= '20180201'::text) AND ((service_date)::text <= '20180228'::text))
          Buffers: shared hit=8",,,,,,,,,""
`
auto_explain 配置
session_preload_libraries = 'auto_explain'
auto_explain.log_min_duration = 100
auto_explain.log_analyze = true
auto_explain.log_buffers = true
`
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。