PostgreSQL 監控、分析與統計工具

原始工具：

1. https://wiki.postgresql.org/wiki/9.1%E7%AC%AC%E4%BA%8C%E5%8D%81%E4%B8%83%E7%AB%A0
2. http://twpug.net/docs/postgresql-doc-8.0-zh_TW/monitoring-stats.html
3. pghero -- https://github.com/ankane/pghero
4. pgFouine -- http://pgfouine.projects.pgfoundry.org/

商用工具：

1. https://docs.citusdata.com/en/v5.1/installation/production_rhel.html
2. https://www.compose.com/articles/loading-google-analytics-data-to-postgresql-using-python/
3. http://chuansong.me/n/615176
4. http://www.it610.com/article/2662277.htm
5. http://itindex.net/detail/47304-postgres-%E6%95%B0%E6%8D%AE%E5%BA%93-%E5%88%86%E6%9E%90

問題與討論

1. 索引問題：http://stackoverflow.com/questions/3318727/postgresql-index-usage-analysis