开发者社区 问答 正文

postgresql auto_explain 与log打印时间不一致

__15175345973039

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

`

展开
收起
绛云 2018-02-02 11:12:15 2269 分享
分享
版权
举报
1 条回答
写回答
取消 提交回答
  • 一个热爱科技,热爱生活的阳光男孩

    时间匹配吗

    2019-07-17 21:57:28 举报
    赞同 评论

    评论

    全部评论 (0)

    登录后可评论
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等

登录插画

登录以查看您的控制台资源

管理云资源
状态一览
快捷访问