{"repo":"agis/pglockanalyze","free":true,"listed":false,"github":"https://github.com/agis/pglockanalyze","clone":"git clone https://github.com/agis/pglockanalyze.git","description":"See what PostgreSQL locks your migrations acquired","language":"Rust","stars":28,"topics":["database-lock","migrations","postgres","postgresql"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"pglockanalyze [![Build Status]][actions] [![Latest Version]][crates.io] [Build Status]: https://img.shields.io/github/actions/workflow/status/agis/pglockanalyze/ci.yml?branch=main [actions]: https://github.com/agis/pglockanalyze/actions?query=branch%3Amain [Latest Version]: https://img.shields.io/crates/v/pglockanalyze.svg [crates.io]: https://crates.io/crates/pglockanalyze See what locks your Postgres migrations will acquire—before you run them in production. To be used in CI and development environments; see pglockanalyze-action for integration with GitHub Actions. Status This software is in alpha stage - expect breaking changes between releases and a lot of rough edges. Rationale Understanding the locks your migrations will acquire is crucial to avoiding downtime in production traffic. Tools like the official Postgres docs and strong migrations are invaluable; however, reasoning your way through complex DDL statements is not always practical. pglockanalyze is meant to complement, not replace such tools, by executing your migrations against a test database (that you have to provision) and dynamically identifying the locks acquired at runtime. It then prints a report of the locks that were acquired. By default, pglockanalyze rolls back the transactions it analyzes, so you can safely run it against a test database without worrying about leaving it in and inconsistent state. If you want to commit the transactions, you can use the --commit option. Installation You can inst","default_branch":null,"files":null,"tree":[],"storefront":"/r/agis","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/agis/pglockanalyze/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}