This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing few important system or statistics views which we can use for monitoring the PostgreSQL Server.
We should monitor the different statistics of the server which help us for improving the overall database performance.
Below are few important views:
Return the running queries/connections information:
|
1 |
select * from pg_stat_activity |
Return the SSL information for each connection:
|
1 |
select * from pg_stat_ssl |
Check the database statistics:
|
1 |
select * from pg_stat_database |
Check the table statistics:
|
1 |
select * from pg_stat_all_tables |
Check the system table statistics:
|
1 |
select * from pg_stat_sys_tables |
Check the index statistics:
|
1 |
select * from pg_stat_all_indexes |
Check the user functions statistics:
|
1 |
select * from pg_stat_user_functions |
