why I can't see the *_now tables in pgadmIII and using \dt command while I could retrieve the data from *_now tables?

posted Oct 27, 2012, 3:58 PM by Sachchida Ojha
The now and tail data are stored as text files on the master file system, and accessed by Command Center database (gpperfmon) via external tables.  This is why you couldn't see the *_now tables shown in pgadmIII or using \dt command while you could retrieve the data from *_now tables.
 
The history tables are regular database tables stored within the Command Center database so we  you can see those tables.
Comments