PGCon2011 - Add 4 Video (2015.09.18)

PGCon 2011
The PostgreSQL Conference

Robert Haas
Day Tutorials - 1 - 2011-05-17
Room DMS 1120
Start time 09:00
Duration 03:00
ID 305
Event type Workshop
Track DBA
Language used for presentation English

Using The PostgreSQL System Catalogs

Database Introspection with PostgreSQL

The PostgreSQL system catalogs store metadata about SQL objects such as tables, columns, functions, schemas, and more. This talk will explore the organization and structure of the system catalogs and explain how you can use these catalogs to manage and tune your database.

We'll cover applications such as (1) getting a list of all tables that have no indices, (2) determining table and database sizes on disk, and (3) monitoring table, session, and background writer activity, as well as the internal structure of the catalogs and how they're used by the database system.