[openstreetmap/openstreetmap-website] Why are some diff uploads slow? (#1710)
Darafei Praliaskouski
notifications at github.com
Fri Dec 22 10:45:52 UTC 2017
Can we get a slowlog published?
```
shared_preload_libraries = 'auto_explain'
auto_explain.log_min_duration = '100ms'
auto_explain.log_nested_statements = on
auto_explain.log_analyze = on
```
It also seems we can have transactions up to 1M seconds, or 12 days:
https://munin.openstreetmap.org/openstreetmap/karm.openstreetmap/postgres_querylength_openstreetmap_9_5_main.html
It can also be a reading transaction, say, a forgotten open psql on terminal.
`statement_timeout` and `idle_in_transaction_session_timeout` can help limit it, so it becomes application error traceable in application logs.
To get distribution of queries and keep sanity reading endless postgres logfiles: https://github.com/dalibo/pgbadger
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/1710#issuecomment-353572883
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20171222/cffd772a/attachment.html>
More information about the rails-dev
mailing list