Monthly Archives: August 2012

To compare Sequential and Index Scan on the table

select relname,seq_scan,seq_tup_read,idx_scan,idx_tup_fetch from pg_stat_user_tables;

Posted in PostgreSQL DBA Stuff | Leave a comment

To Print Postgresql Control Data

To Print Postgresql Control Data # /usr/pgsql-9.1/bin/pg_controldata /var/lib/pgsql/9.1/data pg_control version number: 903 Catalog version number: 201105231 Database system identifier: 5696805748991827949 Database cluster state: in production pg_control last modified: Wed 15 Aug 2012 01:40:35 PM PDT Latest checkpoint location: 77/B2CEB158 Prior … Continue reading

Posted in Uncategorized | Leave a comment