top of page
Волнистый абстрактный фон

PostgreSQL monitor: dashboard

The main tool for managing and monitoring the operation of the cluster  PostgreSQL

Double click on "MONITOR" or "PARAMETER" to run

​

PostgreSQL monitor is a comprehensive screen with information about the operation of the PostgreSQL database

Allows not only to monitor the performance of the cluster, but also to make changes to the database configuration

​​

dashboard

​

Basic information on the load on the database. Data is updated 1 time per second

  • server session  - information on sessions (total, active, idle)

  • Transaction per second  - information on transactions (active, fixing data, rolling back)

  • Tuples In  - data on operations that change data (insert, update, delete)

  • Tuples Out  - data on data extraction operations from the database (Number of rows returned by queries in this database; Number of rows returned by queries in this database)

  • Block I/O  - number of blocks read from disk or found in memory

​

To select the base for which to display statistics, use the drop-down list " Base statistics ".

Available: database name or ALL - total for all

​

Data collection is controlled via the "Running" switch

​

​

SELECT 'session_stats' AS chart_name, t.*
   FROM (SELECT  * from
      (SELECT 'Total'::text  "Name1", count(*)::int "COUNT1" FROM pg_stat_activity
      ) AS "1",
      (SELECT 'Active'::text "Name2", count(*)::int "COUNT2" FROM pg_stat_activity WHERE state = 'active'  
      ) "2", 
      (SELECT 'Idle'::text   "Name3", count(*)::int "COUNT3" FROM pg_stat_activity WHERE state = 'idle'
      ) "3"
   ) t
   UNION ALL
   SELECT 'tps_stats' AS chart_name, t.* 
   FROM (SELECT * from
      (SELECT 'Transactions'::text "Name1", (sum(xact_commit) + sum(xact_rollback))::int "COUNT1" FROM pg_stat_database
      ) "1",
      (SELECT 'Commits'::text "Name2", sum(xact_commit)::int "COUNT2"  FROM pg_stat_database
      ) "2",
      (SELECT 'Rollbacks'::text "Name3", sum(xact_rollback)::int "COUNT3" FROM pg_stat_database 
      ) "3"
   ) t
   UNION ALL
   SELECT 'ti_stats' AS chart_name, t.*
   FROM (SELECT * from
      (SELECT 'Inserts'::text "Name1", sum(tup_inserted)::int "COUNT1" FROM pg_stat_database
      ) "1",
      (SELECT 'Updates'::text "Name2", sum(tup_updated)::int "COUNT2" FROM pg_stat_database
      ) "2",
      (SELECT 'Deletes'::text "Name3", sum(tup_deleted)::int "COUNT3" FROM pg_stat_database 
      ) "3"
   ) t
   UNION ALL
   SELECT 'to_stats' AS chart_name, t.*
   FROM (SELECT * from
      (SELECT 'Fetched'::text "Name1", sum(tup_fetched)::int "COUNT1" FROM pg_stat_database
      ) "1",
      (SELECT 'Returned'::text "Name2", sum(tup_returned)::int "COUNT2" FROM pg_stat_database 
      ) "2",
      (SELECT ''::text "Name3", 0::int "COUNT3") "3"
   ) t
   UNION ALL
   SELECT 'bio_stats' AS chart_name, t.*
   FROM (SELECT * from
      (SELECT 'Reads'::text "Name1", sum(blks_read)::int "COUNT1" FROM pg_stat_database 
      )"1",
      (SELECT 'Hits'::text "Name2", sum(blks_hit)::int "COUNT2" FROM pg_stat_database
      ) "2",
      (SELECT ''::text "Name3", 0::int "COUNT3") "3"
   ) t

bottom of page