Keiko Oda

pg:blocking query is old

1

I believe that the query of `pg:blocking` came from following page (looking at https://github.com/heroku/heroku-pg-extras/issues/80): https://wiki.postgresql.org/wiki/Lock_Monitoring However, the query definitely changed. Looking at Japanese version of that page, the query is...

pg:locks doesn't consider about locks other than EXCLUSIVE

1

We should at least add `ACCESS EXCLUSIVE`, and potentially adding other locks as well. https://github.com/heroku/heroku-pg-extras/blob/07cda801f3368676afd54b6fee8b2874f3487701/commands/locks.js#L32

With this PR, we collect lock information and add it to the compact activity snapshot. To collect lock information, we use `pg_blocking_pids()`. This function is introduced PG9.6, so the lock...

Closes https://github.com/pganalyze/collector/issues/328 I admit that I don't have much knowledge around here so maybe I'm saying something pretty off, though at least publishing the chart worked (currently publishing as a...

Allow collector to run in verbose log mode with Docker

1

Please correct me if I'm doing something useless, though I always find it difficult to run with the debug log mode with a Docker setup. Maybe I can run `docker...

feat: Support prepend SQL comment for PG instrumentation

14

Currently, `extract_operation` method is simply extracting the first word before the space as an operation (as commented, this was borrowed from opentelemetry-js-contrib's pg instrument). This works okay for most of...

Improve the example payload from Netlify for creating a new instance

2

https://github.com/netlify/addons#payload-from-netlify-1 this example payload from Netlify is the following: ``` { // Unique ID generated by Netlify uuid: '2e65dd70-523d-48d8-8826-a93229d7ec01', account: '5902622bcf321c7359e97e52', config: { site_url: 'https://calling-site-from-netlify.netlify.com', jwt: { secret: 'xyz-netlify-secret' },...

Fetcher throws incorrect error with zero-config_vars attachments

3

During the provisioning, there is a timing that there's an attachment but there's not config_vars. Under that condition, https://github.com/heroku/heroku-pg/blob/master/lib/fetcher.js#L61 will throw the error https://github.com/heroku/heroku-pg/blob/master/lib/util.js#L12 . This is especially bad for...

how to repro: 1. run `heroku pg:backups:restore b001 DATABASE_URL -a myapp -c myapp` 2. it says this log message: https://github.com/heroku/heroku-pg/blob/master/commands/backups/restore.js#L62-L66 3. do `Ctrl+C` 4. the canceling to see the progress...

There was a Windows user who used the "wrong" single quote and ended up seeing an unhelpful error message. ``` heroku pg:backups:restore ’https://some-s3-url/of-dump-file.dump’ DATABASE -a appname ▸ Backup ’https://some-s3-url/of-dump-file.dump’ not...