Re: [GENERAL] live and dead tuples are zero on slave running on tmpfs

2015-08-19 Thread Haribabu Kommi
On Thu, Aug 20, 2015 at 12:55 AM, Karthik Viswanathan wrote: > Hello, > > I have a master slave (read replica) setup running pg 9.4.4. I'm > trying to find the dead tuples out both the master and slave > > Here's what it looks like on master: > > # select relname ,n_live_tup ,n_dead_tup from pg_st

[GENERAL] live and dead tuples are zero on slave running on tmpfs

2015-08-19 Thread Karthik Viswanathan
Hello, I have a master slave (read replica) setup running pg 9.4.4. I'm trying to find the dead tuples out both the master and slave Here's what it looks like on master: # select relname ,n_live_tup ,n_dead_tup from pg_stat_user_tables; relname | n_live_tup | n_dead_tup ---