lucky_pg_extras

Crystal/Lucky PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

Lucky PG Extras

Crystal port of Ruby PG Extras which is a Ruby port of Heroku PG Extras.

Installation

  1. Add the dependency to your shard.yml:

    dependencies:
      lucky_pg_extras:
        github: matthewmcgarvey/lucky_pg_extras
    
  2. Run shards install

  3. Require the shard in src/shards.cr

    require "lucky_pg_extras"
    
  4. Set up the configuration in config/lucky_pg_extras.cr

    LuckyPgExtras.configure do |settings|
      settings.database = AppDatabase
    end
    

Some of the queries (e.g., calls and outliers) require pg_stat_statements extension enabled.

Usage

Running lucky -h should now show the pg_extras commands that are available.

Development

TODO: Write development instructions here

Contributing

  1. Fork it (https://github.com/matthewmcgarvey/lucky_pg_extras/fork)
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create a new Pull Request

Contributors

Owner
github statistic
  • 0
  • 0
  • 0
  • 0
  • 8 months ago
  • September 30, 2020
License

MIT License

Links
Synced at

Sat, 19 Jun 2021 11:19:08 GMT