Unix Log Analysis Pipeline — Top 5 Requested URLs

Unix Log Analysis Pipeline — Top 5 Requested URLs A data-flow diagram generated by Archify. 01 / Source 02 / Extract 03 / External Sort 04 / Count 05 / Rank & Report access.log · NGINX log lines · 01 / Source access.log NGINX log lines awk {print $7} · extract URL field · 02 / Extract awk {print $7} extract URL field sort · group duplicate URLs · 03 / External Sort sort group duplicate URLs uniq -c · count per URL · 04 / Count uniq -c count per URL sort -r -n · rank by request count · 05 / Rank & Report sort -r -n rank by request count head -n 5 · top-5 report · 05 / Rank & Report head -n 5 top-5 report log lines e.g. GET /css/typography.css 200 URL stream sorted URLs spills to disk, merges sorted segments counted pairs ranked pairs top 5 kept, rest discarded Legend primary data data store