Using System Catalogs to Investigate a PostgreSQL Server
Database Training Architect II
PostgreSQL is the world's most advanced open source database. It's stability, functionality, and extensibility make it a primary choice for an RDBMS solution. In this hands-on lab scenario you are the DBA for Awesome Company. You have built a PostgreSQL database backend to facilitate the development of a new web application. Now that it is being utilized by the development group, you need to gather some diagnostic information about the instance. Performing the tasks of this lab will help you become familiar with utilizing the system catalogs to gather information about your PostgreSQL installation. This includes finding and evaluating sessions that are generating load, listing the size of objects, and querying information about column types.