FLIGHT//DB
5.74M rows of Russian airline data analyzed in PostgreSQL 16, migrated to BigQuery, visualized interactively. A deep dive into query optimization, indexing strategies, and data pipeline engineering.
POSTGRESQL 16BIGQUERYPYTHON ETLNEXT.JS
0
Total rows analyzed
0
Russian airports
0
Total revenue (RUB)
0.0%
Avg delay rate
0x
Mat view speedup
0
ETL migration (sec)
0
Flights arrived
0
Routes mapped
ROUTE MAP
104 airports, 532 routes on an interactive WebGL map
DELAY ANALYSIS
Heatmaps, worst routes, aircraft and time-of-day patterns
REVENUE
Pareto curves, fare class split, monthly trends
FLEET
Load factors, turnaround times, seat configurations
PG INTERNALS
EXPLAIN plans, index strategies, partitioning, VACUUM
ETL PIPELINE
PostgreSQL to BigQuery migration + performance comparison