Skip to content

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

License

Notifications You must be signed in to change notification settings

matthewmcgarvey/lucky_pg_extras

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

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

Topics

Resources

License

Stars

Watchers

Forks