perfSONAR User Q&A and Other Discussion

[Valentin Vidic <>]

On Sun, May 12, 2019 at 11:55:23AM +0000, Muhammad Tayyab wrote:
> I'm not able to connect with  Postgres database, would you please
> assist me how I can grab the output from the PS node.

Try if this works:

# sudo -u postgres psql -c 'SELECT * FROM pg_stat_activity'

You can also check table sizes with:

# sudo -u postgres psql pscheduler -c "SELECT *, pg_size_pretty(total_bytes) 
AS total
    , pg_size_pretty(index_bytes) AS INDEX
    , pg_size_pretty(toast_bytes) AS toast
    , pg_size_pretty(table_bytes) AS TABLE
  FROM (
  SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes 
FROM (
      SELECT c.oid,nspname AS table_schema, relname AS TABLE_NAME
              , c.reltuples AS row_estimate
              , pg_total_relation_size(c.oid) AS total_bytes
              , pg_indexes_size(c.oid) AS index_bytes
              , pg_total_relation_size(reltoastrelid) AS toast_bytes
          FROM pg_class c
          LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
          WHERE relkind = 'r'
  ) a
) a;"

> I have attached disk utilization logs.

Yes, the disks seem to be 100% utilized mostly with reads.
Can you say what kind of a disk is /dev/sda?

-- 
Valentin Vidic
Computer Systems Engineer - Expert
Department of Computer Infrastructure and Services
Croatian Academic and Research Network - CARNET
Josipa Marohnica 5, HR-10000 Zagreb, Croatia
tel: +385 1 6661 714, fax. +385 1 6661 635
gsm: +385 91 2480 919
www.CARNet.hr