How to find out tables that are frequently read/ write?

2019-02-06 Thread Jason W
Apologize first because I am not familiar with database. So I probably did not find the right doc before posting my question. I received a chart which is plotted by X - date, and Y - throughput (M/ sec). It shows that recently (after N Jan) the read/ write throughput was increased drastically.

Re: Revoke SQL doesn't take effect

2019-02-03 Thread Jason W
‐‐‐ Original Message ‐‐‐ On Tuesday, January 29, 2019 9:20 PM, Tim Cross wrote: > On Wed, 30 Jan 2019 at 07:49, Jason W wrote: > >> I have two postgresql accounts created by someone else who I do not know (So >> I do not know setting for those accounts and tables cre

Revoke SQL doesn't take effect

2019-01-29 Thread Jason W
I have two postgresql accounts created by someone else who I do not know (So I do not know setting for those accounts and tables created). One is read only account e.g. read_only_user (This can perform select operations only). The other is admin account e.g. admin_user (This can perform grant, r