How to fetch slower queries in postgresql logs (from RDS)

commands.txt

You well get query that greater than 5000ms with the next line that as often query parameter if you use prepared statements. This commande requires ripgrep.
rg --pcre2 '[6-9][0-9][0-9][0-9]\.[0-9][0-9][0-9] ms.*' -A=1

Get queries that timeout, exclude the one with a COUNT but with a filter on `rented_at`
rg --pcre2 'STATEMENT:  SELECT(?:(?!COUNT).)*rented_at >'