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
`
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。