May 2018
Intermediate to advanced
576 pages
30h 25m
English
Please spend a few minutes reading the PostgreSQL documentation, which contains more detailed information about pg_stat_activity, available at http://www.postgresql.org/docs/current/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW.
You can find answers to many administration-related questions by analyzing the pg_stat_activity view. One common example is outlined in the next recipe.