Marek Kadek KadekM
KadekM
/ .scalafmt.conf
Last active
October 6, 2024 15:42
— forked from kubukoz/.scalafmt.conf
How to disable significant indentation in Scala
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| runner.dialect = scala3 | |
| runner.dialectOverride.allowSignificantIndentation = false | |
| runner.dialectOverride.allowQuietSyntax = false |
KadekM
/ pg_index_cache_hit_rate.sql
Created
March 7, 2017 19:37
— forked from mattsoldo/pg_index_cache_hit_rate.sql
Postgres Index Hit Rate and Cache Hit Rate
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Index hit rate | |
| WITH idx_hit_rate as ( | |
| SELECT | |
| relname as table_name, | |
| n_live_tup, | |
| round(100.0 * idx_scan / (seq_scan + idx_scan),2) as idx_hit_rate | |
| FROM pg_stat_user_tables | |
| ORDER BY n_live_tup DESC | |
| ), |