1. Home
  2. Optional Special User Functions
  3. Optional Special User Functions: PostgreSQL Server Statistics

Optional Special User Functions: PostgreSQL Server Statistics

PostgreSQL Server Statistics

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.

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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.

Updated on May 27, 2020

Was this article helpful?

Related Articles

Leave a Comment