Skip to content

Instantly share code, notes, and snippets.

View maxiko's full-sized avatar

Maxim Ignatenko maxiko

View GitHub Profile
@anvk
anvk / psql_useful_stat_queries.sql
Last active June 1, 2025 16:17
List of some useful Stat Queries for PSQL
--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192
-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.
------------
-- Basics --
------------
-- Get indexes of tables
@Cubixmeister
Cubixmeister / README.md
Created August 16, 2016 18:23
Simple Sentry docker-compose.yml
  1. Download docker-compose.yml to dir named sentry
  2. Change SENTRY_SECRET_KEY to random 32 char string
  3. Run docker-compose up -d
  4. Run docker exec -it sentry_sentry_1 sentry upgrade to setup database and create admin user
  5. Run docker exec -it pip install sentry-slack if you want slack plugin, it can be done later
  6. Run docker restart sentry_sentry_1
  7. Sentry is now running on public port 9000
@quidryan
quidryan / build.gradle
Last active February 14, 2024 22:22
Code to use ssh-agent when using JGit. Running in Gradle with the gradle-git plugin.
buildscript {
repositories {
mavenCentral()
}
dependencies {
classpath 'org.ajoberstar:gradle-git:0.5.0' // not used in this example, but it's what brings in JGit
classpath 'com.jcraft:jsch.agentproxy.jsch:0.0.5'
classpath 'com.jcraft:jsch.agentproxy.usocket-jna:0.0.5'
classpath 'com.jcraft:jsch.agentproxy.sshagent:0.0.5'
}