How to see which tables are accessed in postgreSQL?

Internally, PostgreSQL has a subsystem (Known as Statistics Collector in>>) responsible for monitoring all activities that are performed by the server.

This monitoring information is made available through a few tens % system%. "

A% of% called VIEWS contains real-time information about all running processes, including queries that are currently running.

For example, to query the activity in the database named VIEW :

SELECT * FROM pg_stat_activity WHERE datname = 'foobar'; 

Another alternative is to use a log analyzer to collect statistics from log files generated by Postgres.

The pg_stat_activity makes this work very well, generating reports in foobar format.