开发者社区> 问答> 正文

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 2148 0
1 条回答
写回答
取消 提交回答
  • 一个热爱科技,热爱生活的阳光男孩

    时间匹配吗

    2019-07-17 21:57:28
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
PostgresChina2018_赖思超_PostgreSQL10_hash索引的WAL日志修改版final 立即下载
Kubernetes下日志实时采集、存储与计算实践 立即下载
日志数据采集与分析对接 立即下载