# Kibana 8.12 transform process is too slow

**URL:** <https://discuss.elastic.co/t/kibana-8-12-transform-process-is-too-slow/360007>\
**Category:** Elasticsearch\
**Created:** [May 22, 2024, 3:06pm UTC](https://discuss.elastic.co/t/kibana-8-12-transform-process-is-too-slow/360007 "2024-05-22T15:06:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![RobertC1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/robertc1/32/98051_2.png) [@RobertC1](https://discuss.elastic.co/u/RobertC1)\
**Post date:** [May 22, 2024, 3:06pm UTC](https://discuss.elastic.co/t/kibana-8-12-transform-process-is-too-slow/360007/1 "2024-05-22T15:06:56Z")

</div>

Every hour text files ar ingested to update the index. I have the following code of a process that transforms the data to seconds.

```auto
  "version": "10.0.0",
  "create_time": 1714766696988,
  "source": {
    "index": [
      "trx_hours_new"
    ],
    "query": {
      "bool": {
        "must": [
          {
            "range": {
              "@timestamp": {
                "gte": "now-6h"
              }
            }
          }
        ]
      }
    }
  },
  "dest": {
    "index": "trx_hours_history_segundos_sp"
  },
  "frequency": "20m",
  "sync": {
    "time": {
      "field": "@timestamp",
      "delay": "60s"
    }
  },
  "pivot": {
    "group_by": {
      "@timestamp": {
        "date_histogram": {
          "field": "@timestamp",
          "calendar_interval": "1s",
          "missing_bucket": true
        }
      },
      "nodo": {
        "terms": {
          "field": "nodo"
        }
      },
      "sp": {
        "terms": {
          "field": "sp"
        }
      }
    },
    "aggregations": {
      "segundo_prom": {
        "avg": {
          "field": "tiempo"
        }
      },
      "cant_trn_seg": {
        "value_count": {
          "field": "trn"
        }
      }
    }
  },
  "description": "trx_hours_hist_seg_sp",
  "settings": {
    "max_page_search_size": 19000
  }
}

```

1 hour of data could has 1.2 millions of documents and can take more than 1 hours to execute.  
Any advice ?  
Thanks in advance.