# 92x faster queries: How Open Electricity uses ClickHouse to track Australia's energy transition in real time

DevFeed: [92x faster queries: How Open Electricity uses ClickHouse to track Australia's energy transition in real time](<https://devfeed.tech/articles/92x-faster-queries-how-open-electricity-uses-clickhouse-to-track-australia-s-energy-transition-in-real-time-5467.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/openelectricity-australia-energy-transition>)

Author: ClickHouse

Published: 2026-06-17T12:06:29Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [data](<https://devfeed.tech/topics/data.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>)

Tags: [australia](<https://devfeed.tech/tags/australia.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cost](<https://devfeed.tech/tags/cost.md>), [data](<https://devfeed.tech/tags/data.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [open](<https://devfeed.tech/tags/open.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [speed](<https://devfeed.tech/tags/speed.md>)

## AI overview

Open Electricity uses ClickHouse to serve live Australian energy data through an open platform and public API. Migrating about one billion records from Postgres and TimescaleDB produced a 92x query speed improvement while requiring substantially less hardware and cost.

## Source excerpt

Open Electricity migrated ~1 billion rows of Australian energy data from Postgres and TimescaleDB to ClickHouse, achieving 92x faster queries on a fraction of the hardware.