PostgreSQL Server Statistics
Reference Contents > Optional Special User Functions > PostgreSQL Server Statistics
For PostgreSQL users only. As an standard Custom Feature you can use this window to examine PostgreSQL Statistics. To add this to your User menu go to File — Preferences — User Settings, choose Custom Features, enter a Section title for the menu, or one that already exists, and add a Window Class of wOptPgServerStats. After saving the settings you will find it under the User menu on the main menu bar.
For a full explanation of what you are seeing Google “PostgreSQL Statistics” and you can navigate to the PostgreSQL Documentation. The column headings of the lists are the column names of the various postgres statistic views listed in the documentation.
Note that in PostgreSQL-speak _tup_ in a column name stands for tuple. A tuple can be thought of as a row of table data. Due to the MVCC system PostgreSQL uses there can be many versions of an actual row of data steming from multiple updates of the data.
|
Field |
Description |
|---|---|
|
Database |
The current database and drivers. It also provides an estimate of disk usage. |
|
Help |
Web address for PostgreSQL Documentation. You can select and copy to your browser. |
|
Button |
Action |
|---|---|
|
Refresh |
Refresh to the latest. |
|
pg_hba.conf |
Opens the pg_hba.conf file to control server connections. Opens the PostgreSQL pg_hba.conf File Edit window. |
The window has 6 tab panes.
Activity
Database
Tables
Indexes
Sequences
Locks
Activity
The pg_stat_activity view will have one row per server process, showing information related to the current activity of that process.
|
Field |
Description |
|---|---|
|
List |
SELECT * FROM pg_stat_activity |
|
Query text |
The query text of the selected activity. |
Database
The pg_stat_database view will contain one row for each database in the cluster, showing database-wide statistics. Uniquly with this list you can see the changes from one Refresh to another and the rate of change per minute, giving you a measure of server loading.
|
Field |
Description |
|---|---|
|
List |
SELECT * FROM pg_stat_database WHERE datname=?1 |
Tables
This is a combined list of pg_stat_user_tables and pg_statio_user_tables. The pg_stat_user_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about accesses to that specific table. The pg_statio_user_tables view will contain one row for each table, showing statistics about I/O on that specific table.
|
Field |
Description |
|---|---|
|
List |
SELECT * FROM pg_stat_user_tables and pg_statio_user_tables |
Indexes
This is a combined list of pg_stat_user_indexes and pg_statio_user_indexes. The pg_stat_user_indexes view will contain one row for each index in the current database, showing statistics about accesses to that specific index. pg_statio_user_indexes covers I/O statistics and comprises just idx_blks_read and idx_blks_hit.
|
Field |
Description |
|---|---|
|
List |
SELECT * FROM pg_stat_user_indexes and pg_statio_user_indexes |
Sequences
The pg_statio_all_sequences view will contain one row for each sequence in the current database, showing statistics about I/O on that specific sequence. A sequence is a auto-incrementing counter object within PostgreSQL. They are used in Caliach Vision to generate Row Sequence Numbers.
|
Field |
Description |
|---|---|
|
List |
SELECT * FROM pg_statio_sequences |
Locks
The view pg_locks provides access to information about the locks held by active processes within the database server. Documentaion on this can be found by Googleing PostgreSQL pg_locks.
|
Field |
Description |
|---|---|
|
List |
SELECT * FROM pg_locks |
| See also: – |
Compiled in Program Version 5.10. Help data last modified 21 Jun 2018 07:13:14.14. Class wOptPgServerStats last modified 21 Jun 2018 07:13:02.
Reference Contents > Optional Special User Functions > PostgreSQL Server Statistics
