PostgreSQL: Script to find total Live Tuples and Dead Tuples (Row) of a Table

This is one of the very important post for all PostgreSQL Database Professionals. In this post, I am sharing a small, but very powerful script to know about the Live Tuples (Rows) and Dead Tuples (Rows) of the PostgreSQL Object like: Tables and Indexes. If you don’t know about the MVCC (Multi Version Concurrency Control), … Continue reading PostgreSQL: Script to find total Live Tuples and Dead Tuples (Row) of a Table