adililhan

--- 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

Exploitation

Database information

Schema settings

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

PostgreSQL Note

Commands

https://www.postgresql.org/docs/9.5/static/reference-client.html

Show work memory

SHOW work_mem;

adililhan

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