SELECT r.rolname, d.datname, rs.setconfig
FROM pg_db_role_setting rs
LEFT JOIN pg_roles r ON r.oid = rs.setrole
LEFT JOIN pg_database d ON d.oid = rs.setdatabase
adililhan
adililhan
/ psql_useful_stat_queries.sql
Created
May 14, 2021 12:45
— forked from anvk/psql_useful_stat_queries.sql
List of some useful Stat Queries for PSQL
This file contains 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
| --- 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 |
adililhan
/ postgresql.queries.md
Created
May 14, 2021 12:37
adililhan
/ PostgreSQL_Note.md
Created
May 14, 2021 12:13
— forked from hanksudo/PostgreSQL_Note.md
PostgreSQL Note
adililhan
/ awesome-php.md
Created
September 20, 2012 07:47
— forked from sineld/awesome-php.md
Awesome PHP Libraries
A list of amazingly awesome PHP libraries that you should be using:
- Composer/Packagist - A package and dependency manager.
- Symfony2 - A framework comprised of individual components.
- Zend Framework 2 - Another framework of individual components.
- Symfony2 Components - The components that make Symfony2.
- [Laravel] (https://github.com/laravel/laravel) - A PHP Framework
- [Yii] (https://github.com/yiisoft/yii) - A PHP Framework