Slow query log parser for Postgres
Total Avg Count Query
(min) (ms)
20 4381 283 SELECT DISTINCT "orders"."id" AS t0_r0, "orders"
7 3574 120 SELECT "visits".* FROM "visits" WHERE ("visits".
4 12621 20 SELECT DISTINCT "order_deliveries"."id" AS t0_r0Run:
gem install pghero_logsIt can take a few minutes to compile the query parser 🕑
Tell Postgres to log slow queries in postgresql.conf
log_min_duration_statement = 20 # ms
Analyze the logs
cat /usr/local/var/log/postgres.log | pghero_logsFirst, download the logs. Create an IAM user with the policy below
{
"Version": "2012-10-17",
"Statement": [
{
"Action": [
"rds:DescribeDBLogFiles",
"rds:DownloadDBLogFilePortion"
],
"Effect": "Allow",
"Resource": "*"
}
]
}And run
aws configure
pghero_logs download <instance-id>Once logs are downloaded, run
cat postgresql.log* | pghero_logsTo analyze with PgBadger, install
brew install pgbadgerAnd run
pgbadger --prefix "%t:%r:%u@%d:[%p]:" --outfile pgbadger.html postgresql.log*
open pgbadger.htmlThanks to RDS PgBadger for the prefix.
View the changelog
Everyone is encouraged to help improve this project. Here are a few ways you can help:
- Report bugs
- Fix bugs and submit pull requests
- Write, clarify, or fix documentation
- Suggest or add new features
To get started with development:
git clone https://github.com/ankane/pghero_logs.git
cd pghero_logs
bundle install