I'm using postgres server 9.4.
From pg_admin or psql tool, I can do SHOW ALL; this will give me the config of postgres server. For example shared_buffers is 8GB or effective_cache_size is 24GB
Recently the database has grown bigger and queries become slower.
I do aware that the query may need to be re-evaluated using explain.
Query optimization aside, how do I know the utilization status?
For example from this shared_buffer of 8GB or effective_cache_size of 24GB how much is being used, or any other config value - is it time to increase these config value?