grep "Dauer:" /path/to/postgres.log | sort -nr -k 5 | head -100 | less

maybe you must replace "Dauer" with the correct spelling in your logging language (i´ve done this on a german system).
also make sure, that the duration (the value in ms) column is the 5th one in your log file.

show longest queries in postgres log

Bash