Skip to content

Instantly share code, notes, and snippets.

View semoac's full-sized avatar

Sergio Morales semoac

  • Cornershop
  • Chile
View GitHub Profile
@semoac
semoac / psql_useful_stat_queries.sql
Created November 5, 2019 19:40 — forked from anvk/psql_useful_stat_queries.sql
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

Keybase proof

I hereby claim:

  • I am semoac on github.
  • I am semoac (https://keybase.io/semoac) on keybase.
  • I have a public key whose fingerprint is 73B2 9EF0 DECD BB7C 6410 F90E D58E BB25 8D25 8A01

To claim this, I am signing this object: