Abstract: In urban transportation networks, the inefficiency of the road network is primarily caused by traffic bottlenecks. Freight bottleneck is a unique type of traffic bottleneck that exclusively involves the analysis of truck freight mobility. This research uses Geotab telematics data to detect and analyze long-term freight transportation bottlenecks at large-scale. This presentation includes an overview of the definition and detection of freight transportation bottleneck based on a database-parallel implementation of connected components algorithm and the ranking metrics for the utility function.