Seoul bike ·
PostGIS
+ ClickHouse
Dashboard
Maps
Statistics
Pushdown
Log
About
connecting…
Range
1d
1w
1mo
3mo
6mo
1y
custom
Bucket
From (KST)
To (KST)
District
All districts
Hour (KST)
–
Days
All days
Weekdays
Weekends
Min trips / group
—
▶ Run query
Station demand — PostGIS
geometry · always local
Busiest districts
table
Trips per day
table
Trip length (minutes)
table
Hour of day
table
Weekday
Weekend
Postgres — the geometry side
Replication — ClickPipes / PeerDB
Generator — pg_cron
Pushdown — pg_clickhouse
PostGIS · always local
Run against
—
press Run to load
EXPLAIN ANALYZE
press Run to compare the two sides
Refresh
auto every 5s
click a row for its SQL, remote SQL and plan